MySQL connection problem

[cartdev]

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]

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?

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]

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:

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]

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]

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]

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]

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

[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.

[falko]

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]

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 ? :/

[till]

The ISPConfig installer creates a database itself. Dont create the database manually! If the database exists, the installer will fail.

[zer0_g666]

Ah, that fixed that problem ... after installing it to wards the end it says

'no such file in: /etc/apache2/vhost.d/*.conf'

and when i create sites and try them in my browser they dnt work ... :(

[till]

Did you get an error when you execute:

httpd -t

[zer0_g666]

nope ... i got sytax ok ...

*sigh*

looks like im gonna have to re-install it ... again ....

[till]

No... We have a few more options to figure out whats wrong :)

Please have a look in the ISPConfig logfile:

/home/admispconfig/ispconfig/ispconfig.log

any errors?

[zer0_g666]

Ok ..

There seems to be alot of info in there so i took the last WARN msg which says there is an error in the sytax of httpd ...

11.2005 - 17:14:07 => WARN - /root/ispconfig/scripts/lib/config.lib.php, Line 2337: WARNING: could not httpd -t &> /dev/null
17.11.2005 - 17:14:07 => WARN - /root/ispconfig/scripts/lib/config.lib.php, Line 2343: httpd syntax seems to contain errors, reloading with old configuration

if u have vnc u can login and help fix if that would be easier ... just pm me

[falko]

Ah, that fixed that problem ... after installing it to wards the end it says

'no such file in: /etc/apache2/vhost.d/*.conf'

Don't worry about that warning. Nothing serious.

17.11.2005 - 17:14:07 => WARN - /root/ispconfig/scripts/lib/config.lib.php, Line 2343: httpd syntax seems to contain errors, reloading with old configuration

That means that ISPConfig tried to write a new vhost configuration, but your Apache doesn't support all the features of that new web site (e.g. PHP, CGI, ...), maybe because some modules are missing. ISPConfig detects that and reverts the configuration back to the last working state so that your Apache can start. But this explains why you cannot see any of the sites you created in ISPConfig.
Make sure Apache loads all the needed modules.

[zer0_g666]

Amazing, its working!!! yey ....

I installed a few apache2-mod's and bingo

Thankyou