Hi all. I recently did a number of upgrades. 1. I upgraded the base Ubuntu install. 2. I upgraded ISPConfig to latest stable version. 3. I opened up Port 80 (had been 800 during testing) Then I set up some new domains, transferred a bunch of stuff and smiled as the testing server became production. Then last night I tried to access a Joomla test site I have been working on. It was unavailable. I can connect to the site itself, but then Joomla takes forever to load a page that says it is offline. The title at the top of the page is correct, but it says "Could not connect to the database server". It had been working fine prior to the upgrades (which included a MySQL upgrade at apt-get upgrade level I think). I restarted (as in rebooted) the server, but it made no difference. Joomla is still offline. I logged in to PHPmyadmin. There I can select databases to view, but the only options are information_schema, ispconfigdb or mysql. There is no mention of Joomla anywhere. I don't know what to do next? Rob
I notice in var/web/web5 (the joomla directory) there is a file called joomla.sql which I assume is my database. Why is it not showing in phpmyadmin? Can I import it or something? Rob
I dont think that this file contains your database. It is the mysql dump that is used by the joomla installer to install the databases for new joomla versions. Please post the output of: ls -la /var/lib/mysql/
xxxxxxx@WebServer:~$ ls -la /var/lib/mysql/ total 20540 drwxr-xr-x 4 mysql mysql 4096 2007-11-14 17:33 . drwxr-xr-x 26 root root 4096 2007-11-12 22:32 .. -rw-r--r-- 1 mysql mysql 0 2007-11-12 22:32 debian-5.0.flag -rw-rw---- 1 mysql mysql 10485760 2007-11-14 17:33 ibdata1 -rw-rw---- 1 mysql mysql 5242880 2007-11-14 17:33 ib_logfile0 -rw-rw---- 1 mysql mysql 5242880 2007-05-03 15:37 ib_logfile1 drwx------ 2 mysql mysql 4096 2007-11-13 09:46 ispconfigdb drwxr-xr-x 2 mysql mysql 4096 2007-11-14 17:05 mysql lrwxrwxrwx 1 mysql root 27 2007-05-04 16:23 mysql.sock -> /var/run/mysqld/mysqld.sock -rw------- 1 mysql mysql 4 2007-05-03 15:37 mysql_upgrade.info The upgrade.info file just contains the version number 5.0 It looks as if the Joomla database is absent. But I don't know why - do upgrades (OS level or ISPConfig) typically mess with mysql databases? Actually I may have done a stupid thing. When I tried to access Joomla and it couldn't connect to the database, I happened to have ISPConfig open in another browser tab. I checked to see if MySQL access was granted for the domain (it was). Then (perhaps foolishly) I unchecked the box, saved, and rechecked the box, thinking I could maybe kick start mysql if that is where the problem lay. Could that be why it is missing? If so, would it be backed up anywhere? Rob
Did you create a database for that web site in ISPConfig (you can do that on the Options tab)? After you've created it, you can import the .sql file like this: http://www.howtoforge.com/faq/6_4_en.html
Thanks for that Falko! Now I've just got to find the config file that tells Joomla where to look for the db! Rob
Well the config file was easy to find, and she is now up and running nicely again. Its just a shame by backup of the database is 3 month old. Robin
