Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Pages: 1
#1 2008-06-03 23:03:36
- SebastianS
- Member
- From: Australia
- Registered: 2007-10-05
- Posts: 46
Database Unavailable
One of my subdomains gives the message “database unavailable”, all the other domains on the server work fine, so theoretically it’s a TXP problem.
Is there a way of:-
A. Accessing it or
B. retrieving the data through phpMyAdmin.
To my knowledge no changes have been made to the site or hosting passwords.
The data on the site is not that important to me but it would be nice to know what to do if it happens to one that is.
Offline
#2 2008-06-03 23:24:34
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,306
Re: Database Unavailable
The SQL server is down at the moment. A and B won’t work for now. Just wait a while and retry.
As a precaution for your important data you can install and regularly use rss_admin_db_manager for txp installs. Mary wrote an article for the faq where a modification for rss_admin_db_manager is included in order to make it work with 4.0.6 (at the very bottom).
Last edited by uli (2008-06-03 23:47:58)
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#3 2008-06-03 23:42:36
- SebastianS
- Member
- From: Australia
- Registered: 2007-10-05
- Posts: 46
Re: Database Unavailable
Thank you for your reply.
I have been unable to access my site for over 12 hours, the hosting company quickly replied suggesting is was a CMS problem because all my other domains work.
I have rss_admin_db_manager on my “importart” domain which I use.
Am I correct in thinking because the data bases are stored on the same server and all other sites work it is a TXP problem rather than server problem?
Offline
#4 2008-06-04 00:27:37
- uli
- Moderator
- From: Cologne
- Registered: 2006-08-15
- Posts: 4,306
Re: Database Unavailable
No, this is an ISP problem. And I’m pretty sure you can’t set the access permissions of your database.
In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links
Offline
#5 2008-06-04 01:13:28
- SebastianS
- Member
- From: Australia
- Registered: 2007-10-05
- Posts: 46
Re: Database Unavailable
Looking at the problem from a different perspective:-
I can get into phpmyadmin and do a keyword seach and bring up article titles of what it appears google bot or people have opened. Is there anyway of finding the articles in the phpmyadmin, probably not but I am asking?
Where is the text stored, perhaps a naive question.
Last edited by SebastianS (2008-06-04 01:19:14)
Offline
Re: Database Unavailable
View the source of the database unavailable page – you should see the MySQL error message as an HTML comment. Post it here :).
Offline
#7 2008-06-04 02:14:36
- SebastianS
- Member
- From: Australia
- Registered: 2007-10-05
- Posts: 46
Re: Database Unavailable
<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN”
“http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd”>
<html xmlns=“http://www.w3.org/1999/xhtml” xml:lang=“en” lang=“en”>
<head>
<meta http-equiv=“content-type” content=“text/html; charset=utf-8” />
<title>Untitled</title>
</head>
<body>
<p align=“center” style=“margin-top:4em”>Database unavailable.</p>
<!— Access denied for user ‘stmawes’@‘localhost’ (using password: YES) —>
</body>
</html>
Offline
#8 2008-06-04 02:55:30
- SebastianS
- Member
- From: Australia
- Registered: 2007-10-05
- Posts: 46
Re: Database Unavailable
Thank you both for your help, I think it is a password issue.
It was a password Issue.
Last edited by SebastianS (2008-06-04 03:04:07)
Offline
Re: Database Unavailable
I hope the following warning will be helpful to others that follow. This applies if you have more than one textpattern install using the same database.
If you use the same user name to access multiple installs it must have the same password. This may seem obvious, but if you go through the installation procedure step by step it can be missed. When the SQL database setup prompts for the user name and password you can give it an existing name but a different password. Rather than issue a warning, the password is instead overwritten. Instantly all your old textpattern installs that used that user name will die a horrible death with “Database Unavailable” replacing every page on the site.
It just took me four hours to debug this.
robin
Offline
Re: Database Unavailable
- the username/password to access the database: should be identical if all installs are in the same database (using different table prefixes)
- the username/password for logging into Textpattern on the admin side: you are free to choose different ones for each install, since these are stored in separate tables.
Offline
Re: Database Unavailable
ruud wrote:
You’re confusing two things:
- the username/password to access the database: should be identical if all installs are in the same database (using different table prefixes)
- the username/password for logging into Textpattern on the admin side: you are free to choose different ones for each install, since these are stored in separate tables.
Actually I was only writing about the first item. So, no, I was not confusing these two things.
I had initially assumed that a user password was unique per database, which it is not. However the interface should definitely not let a password change happen silently. This compounds a bad assumption with a mistake.
Not a textpattern issue, but one that might come up when installing textpattern, so worth a mention here I thought.
robin
Offline
Re: Database Unavailable
Textpattern doesn’t change or create the username/password for a database. It only uses an existing username/password combination that was previously created by either webhost or the website admin.
Offline
Pages: 1