Database Won't Install
Posted 24 August 2004 - 09:00 PM
When I try to install rvadmin I get the following error:
Updating rvskin database...
DBI connect('rvadmin_news:localhost','rvadmin_public',...) failed: Access denied for user: 'rvadmin_public@localhost' (Using password: YES) at /root/rvadmin/real_auto_rvskin.pl line 38
Database connection failed, You need to create it manually using database information below:
This is a new server and I can't see what the issue is as it works on all my other boxes.
Can anyone help?
Posted 24 August 2004 - 09:25 PM
1. Do you have configure this server to use remote MySQL?
You can check in https://SERVER_IP:20...remotemysqlhost
2. Go to WHm / MySQL / phpMyAdmin, and select 'mysql' database in the database list.
Click SQL query and place this in the textarea box.
SELECT * FROM db WHERE user like 'rvadmin_%'
Delete all records. And run installer again.
If none of which is work, please email me root password, and IP. I will take a look.
Posted 24 August 2004 - 09:34 PM
Second issue: There is no such file.
Please advise if this helps.
Posted 05 October 2004 - 04:52 PM
After I have checked the installation process for several hours, finally I found the cause.
Before you try to re-install rvskin, try to uninstall it by following the instruction:
After that, you have to remove rvskin related entries on your mysql database:
"rvadmin_news" database, "rvadmin" in the "user" table of "mysql", some records held by rvadmin_news in the "db" table of "mysql".
If you are not familier with mysql console, just use phpmyadmin from your WHM. If you get access denied message when you open phpmyadmin, check the file /root/.my.cnf.
It will be something like this:
If you see any quotation(") just remove them, and it will be:
after saving the file, open phpmyadmin again. You will be able to access your database.
I am happy with rvskin and thank you for the great product. If I am missing something please correct it.
Posted 05 October 2004 - 07:02 PM
I think I will create uninstall script to clean all db stuffs.
Posted 20 October 2004 - 07:08 AM
Posted 21 October 2004 - 04:50 AM
Try my book on the subject (available in both electronic and print versions):
cPanel: User's Guide and Tutorial
Web Host Manager Administration Guide
Posted 17 November 2005 - 11:29 AM
Any other ideas?
Posted 17 November 2005 - 02:06 PM