Build new Debian Lenny Perfect Server about a month ago, using Falko's excellent guides, and everything has been great. I successfully migrated all of my clients and about 15 DB's over. However, I tried to add a new database for an existing client and while it appears in the ISPConfig interface, it's not actually being created. (not in /var/lib/mysql) It's not a limit problem- database successfully gets created inside the ISPConfig DB. I can create it via phpmyadmin and via cli, but if I do it there, it doesn't show up inside ISPConfig. Any ideas? Thanks, //Todd
Have you changed the mysql root password? If yes, dont forget to change it in the mysql_client.inc file in /usr/local/ispconfig/server/lib/ too.
No- haven't changed mysql root pwd. However- another strange thing is that I guess my provider rebooted my XEN VM, which is the one running ISPConfig and apache didn't start up. However, I've since started it manually, and for some reason, ISPConfig still thinks the service is stopped in the 'monitoring' area... Thanks, //Todd
Till, Just double-checked the mysql root pwd inside '/usr/local/ispconfig/server/lib/mysql_clientdb.conf' and it was correct... Thanks, //Todd
The mysql connection is made to localhost and the apache server is checked on localhost too, so if both have problems then you might have a wrong or no record for localhost in /etc/hosts for IP 127.0.0.1 or the lo intercface is not listening on IP 127.0.0.1
Hmmm- no. Machine resolves and gets a reply from localhost correctly: lo Link encap:Local Loopback inet addr:127.0.0.1 Mask:255.0.0.0 inet6 addr: ::1/128 Scope:Host UP LOOPBACK RUNNING MTU:16436 Metric:1 RX packets:237312 errors:0 dropped:0 overruns:0 frame:0 TX packets:237312 errors:0 dropped:0 overruns:0 carrier:0 collisions:0 txqueuelen:0 RX bytes:66139374 (63.0 MiB) TX bytes:66139374 (63.0 MiB) 127.0.0.1 localhost PING localhost (127.0.0.1) 56(84) bytes of data. 64 bytes from localhost (127.0.0.1): icmp_seq=1 ttl=64 time=0.028 ms 64 bytes from localhost (127.0.0.1): icmp_seq=2 ttl=64 time=0.050 ms 64 bytes from localhost (127.0.0.1): icmp_seq=3 ttl=64 time=0.051 ms Thanks Till, //Todd
Till, Also, switched System, Server Config, server, server logging to debug, and still seeing nothing in /var/log/ispconfig/ispconfig.log. Thanks, //Todd
Till, Found the problem. While investigating a postfix timeout error, my provider was poking around inside my VM and did an 'update-rc.d cron remove' because the VM was hanging upon reboot. The problem ended up being that the image they used to create my VM didn't include the XEN kernel. However, they didn't document that the removed cron from starting up in the rc scripts and somebody there 'remembered'. Now that we've added them back, we're all good... PHEW. Thanks to you and Falko for a VERY COOL tool, exceptional support and some of the best 'How To's' around! //Todd
