HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   MySQL connection problem (http://www.howtoforge.com/forums/showthread.php?t=746)

cartdev 3rd October 2005 18:57

MySQL connection problem
 
I had problems with MySQL I think because I used some unusual carachters in my root password. Now I've changed the pass both in MySQL and in the /home/admispconfig/ispconfig/lib/config.inc.php. I can login to the MySQL monitor within the ispconfigdb at the command line, but when I attempt to access the web page, I get the login screen but it says "ERROR 101: wrong username or password." when I use admin and admin. It appears that ispconfig is not even hitting the database or if it is, that the admin:admin record is missing.

Also, it is a pain to go through the install so many times. Can you save it at anypoint to start over? Just not having to type the cert stuff would be helpful.

falko 3rd October 2005 19:10

I guess that at least the admin user record is missing, if not the whole ISPConfig database. Do you have a phpMyAdmin where you can check that?

Quote:

Also, it is a pain to go through the install so many times. Can you save it at anypoint to start over? Just not having to type the cert stuff would be helpful.
No, you have to run the whole installation again. Delete the directories /home/admispconfig and /root/ispconfig before and also the ISPConfig database if there is one...

cartdev 3rd October 2005 19:40

Thanks for the help. Know that I have succeeded in getting this up on another box, but it took some fiddling. Now I'm trying to make an exact recipe for putting this on several boxes.

On a whim, I reinstalled things again, despite the fact that the last install completed. This time, I got this error:

HTML Code:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /root/ispconfig/scripts/lib/config.inc.php on line 47
No results found!FreshClam is already running!
ISPConfig system is now up and running!
Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.

I get the exact same login problem on the website, i.e. "ERROR 101: wrong username or password."

Oh, I just checked the ispconfig database and it doesn't have any tables. WHat can I do to build this db properly?

Bob

falko 3rd October 2005 19:57

Quote:

Originally Posted by cartdev
Oh, I just checked the ispconfig database and it doesn't have any tables. WHat can I do to build this db properly?

Delete the current ISPConfig installation and install again.

cartdev 3rd October 2005 19:59

I just did delete the install and both directores /root/isp... and /home/admin...
and the above is what I reported. A db was created, but without tables. Reinstalling yet again, won't change anything. How can I create the tables?

mysql> select * from isp_server;
ERROR 1146 (42S02): Table 'ispconfigdb.isp_server' doesn't exist

falko 3rd October 2005 20:10

Quote:

Originally Posted by cartdev
I just did delete the install and both directores /root/isp... and /home/admin...
and the above is what I reported. A db was created, but without tables. Reinstalling yet again, won't change anything. How can I create the tables?

mysql> select * from isp_server;
ERROR 1146 (42S02): Table 'ispconfigdb.isp_server' doesn't exist

You can only create them using the installer because some entries are created on-the-fly.
Before you install ISPConfig please delete the whole ispconfig database, not only the tables in it!

cartdev 3rd October 2005 20:40

Dropping the empty ispconfig db prior to reinstall did the trick. Thank you!

cartdev 3rd October 2005 21:50

Wierd. I stopped for lunch, returned and the session expired. WHen I tried to log back in, I get the "ERROR 101: wrong username or password." The database has tables. I restarted ISPConfig and that didn't help. What's up with this? Any clues?

By the way, there is an admin record in the table sys_users.

falko 3rd October 2005 23:17

Quote:

Originally Posted by cartdev
Wierd. I stopped for lunch, returned and the session expired. WHen I tried to log back in, I get the "ERROR 101: wrong username or password." The database has tables. I restarted ISPConfig and that didn't help. What's up with this? Any clues?

By the way, there is an admin record in the table sys_users.

Maybe a typo?

zer0_g666 17th November 2005 15:42

Quote:

Originally Posted by cartdev
Dropping the empty ispconfig db prior to reinstall did the trick. Thank you!


Ive had the same problem .... ive tried dropping the database and then creating a new one prior to install and still getting the same problem, can any one suggest anything that might help ? :/


All times are GMT +2. The time now is 12:00.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.