#1  
Old 15th November 2007, 19:46
rabrol rabrol is offline
Junior Member
 
Join Date: Sep 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default Did I kill Joomla?

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
Reply With Quote
Sponsored Links
  #2  
Old 15th November 2007, 20:07
rabrol rabrol is offline
Junior Member
 
Join Date: Sep 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #3  
Old 16th November 2007, 10:30
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 36,804
Thanks: 840
Thanked 5,614 Times in 4,425 Posts
Default

Quote:
I notice in var/web/web5 (the joomla directory) there is a file called joomla.sql which I assume is my database.
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/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #4  
Old 16th November 2007, 17:57
rabrol rabrol is offline
Junior Member
 
Join Date: Sep 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till
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
Reply With Quote
  #5  
Old 16th November 2007, 18:39
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
Default

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
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #6  
Old 18th November 2007, 18:49
rabrol rabrol is offline
Junior Member
 
Join Date: Sep 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
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
Reply With Quote
  #7  
Old 18th November 2007, 21:46
rabrol rabrol is offline
Junior Member
 
Join Date: Sep 2006
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Quote:
Originally Posted by rabrol
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
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fedora core 4 Joomla! issues The General Installation/Configuration 8 12th April 2007 13:18
ubuntu ispconfig joomla .htaccess steve1084 General 8 6th January 2007 16:55
Joomla & MySql config and chmod permissions normdouglas Installation/Configuration 6 27th December 2006 13:39
Joomla images doesn't show off ! gabrix Server Operation 7 2nd November 2006 19:01
Joomla & ISPconfig ikaros General 7 3rd October 2006 13:16


All times are GMT +2. The time now is 09:37.


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