|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
In the DB Configuration section I checked
Use Persistent Connections [x]
And now my boards are inaccessible.
Please help.
PS. my boards are now generating the message:
UBB Message
We encountered a problem. The reason reported was
Database error only visible to forum administrators
Please click back to return to the previous page.
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
You need to turn it off. Probably your host does not allow it. Edit your includes/config.inc.php file. Search for PERSISTENT_DB_CONNECTION and set it to: 'PERSISTENT_DB_CONNECTION' => '',
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
I made the change, but getting same results
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
I'm restarting my server .. maybe it was holding some persistent
state
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Jan 2004
Posts: 2,474 Likes: 3
Pooh-Bah
|
|
Pooh-Bah
Joined: Jan 2004
Posts: 2,474 Likes: 3 |
What vesion are you running?
I've seen this intermittently myself and only since I upgraded to 7.5.x
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
Do you have SQL Error Logging enabled? We really need to see what the message is...
As for persistent connections; never enable them on a shared host or vps; it can bring your server to its knees...
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
yes, but how would I get to it is I can't get into the boards?
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Well look in the config.inc.php file to find where the error logs are stored and you can ftp to them.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
damn, I restart the server and it's still giving me the error.
Ruben, I made the change to 'PERSISTENT_DB_CONNECTION' => '',
Driv, MySql is 4.1.12
Giz, how do I get to the logs?
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
I just told you.
The file is named ######_mysql.log. The pound is a date number.
You also may need to use your server control panel to expire all of your connection sessions.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
Well crap.
'SQL_LOG_PATH' => 'C:Inetpubvhostsgame-master.netlogs',
'ADMIN_LOG_PATH' => 'C:\\Inetpub\\vhosts\\game-master.net\\logs',
As you can see, the SQL_LOG_PATH looks like sh*t. Looks like someone messed up the processing of '\' characters.
'ADMIN_LOG_PATH' looks good tho.
How about I set the 'SQL_LOG_PATH' to the same value as 'ADMIN_LOG_PATH'???
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
There are no *_mysql.log files. I suspect because the 'SQL_LOG_PATH' seems corrupt.
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
Well, you have to enable error logging; check your config.inc.php file lines:
'LOG_SQL_ERRORS' => '1', (would be 1 for enabled, 0 for disabled)
'SQL_LOG_PATH' => '/home/undergroundnews/forum/logs/sql/', (would be the full path from your server root, directory should be chmodded 777)
Then you need to visit the board to have the error print to the log file. Then you need to open the log file and read the error...
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
When setting a path on a windows server, you cannot use \'s you must use two \'s like in the admin log path.
So it'd be:
C:\\Inetpub\\vhosts\\game-master.net\\logs
Last edited by Gizmo; 04/02/2009 1:55 PM.
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
[ERROR][Thu, Apr 02 2009 10:57:12 -0800] [] [72.30.79.94] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:57:16 -0800] [] [12.107.176.254] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:57:20 -0800] [] [66.249.66.11] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:57:21 -0800] [] [66.249.66.11] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:57:34 -0800] [] [66.249.66.11] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:57:38 -0800] [] [66.249.66.11] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:57:43 -0800] [] [72.30.79.94] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:57:55 -0800] [] [66.249.66.11] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:58:00 -0800] [] [38.99.44.105] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:58:06 -0800] [] [66.249.66.11] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:58:07 -0800] [] [66.249.66.11] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:58:09 -0800] [] [67.94.233.110] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:58:13 -0800] [] [67.94.233.110] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
[ERROR][Thu, Apr 02 2009 10:58:13 -0800] [] [66.249.66.11] Script: - Line: Unable to connect to the database! - Access denied for user 'XXX'@'YYY' (using password: YES)
Last edited by luket; 04/02/2009 3:38 PM. Reason: removed real name
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
Okay, I set the correct path .. results are above.
That's a brand new log file. i'm 'adam ant', and that's me trying to connect.
Last edited by luket; 04/02/2009 2:02 PM.
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
Well, that generally means that there is a problem with the username/password combination (Access Denied)
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
I've been logging fine since year 2000.
This started happening immediately after I checked PERSISTENT_DB_CONNECTION
I have since (based on Ruben input) edited the config file, but the error remains.
Last edited by luket; 04/02/2009 2:05 PM.
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
I'm just saying what the error SAYS is going wrong based on the error message you posted... The MySQL server is responding that there is a problem with the user/password combination by responding access denied...
You could try connecting to the db from say phpmyadmin using the user/pass in question to ensure it is correct...
You would also want to make sure the user/pass/host all exist correctly in the config file.
Last edited by Gizmo; 04/02/2009 2:07 PM.
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Also when the board is working and you enable logging you are required to click on the test link. It will create a test file called test.file. I believe at least some of the features that require a path look for that file when the feature is used so if it is missing the feature will not work.
Not sure about error logs though.
Also you could enable the debug in mysql.inc.php as a last resort to view errors.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
I would advise against enabling debug in mysql.inc.php as the error logs will show the same info and won't be visible to users...
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
I agree Giz it was a suggestion if he could not get to the error logs.
I guess Luket start with directly loging in with say phpmyadimn verify your Mysql login then double check the login in config.inc.php.
Pretty much what Gizmo just suggested.
Something may be hosed on the file still. Or caps key is on or off by mistake?
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
Ruben, I got logging working by manually changing that path. The log now appears, but the information is minimal. Gizmo says it looks like a bad password / user .. but I know that's not the case since I've been logging in fine for many years.
My hunch is that by Setting PERSISTENT_DB_CONNECTION ON I changed something in the database making subsequent logins fail.
Could that be? IF so, how the hell do I recover?
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
it's not a login issue as I I have my browser log me in.
Keep in mind this happen immediately after I checked PERSISTENT_DB_CONNECTION. The VERY NEXT PAGE would not display
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
I was thinking that there could have been some network congestion when he wrote the config file at one point and something could be hosed; hence asking to validate the data in the config file...
Though it seems complete enough to attempt a login with a user/pass of some sort, hence asking to check the u/p set in the ubb against phpmyadmin or another mysql tool to ensure it's allowing login from this combination.
It's possible if you have some sort of limits setup with the sql username to thwart abuse that the username got suspended in the system for going over quota; the persistent mysql crap takes a lot of resources and can hit a db in ways you don't want; hence why it's not recommended to use unless you understand what you're doing 110% (I wouldn't even bother with it).
I think we should nuke the option from the CP completely, and require users to manually turn it on in the config file should they understand how to use it and want to use the feature without accidental hosing their server lol... It'd be like classic's hidden ticks in the lib files way back when...
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Okay but did you double check the login in the ubb config file.(config.inc.php) It stores user name and password for the db.
All that stuff is the top few lines.
Make sure it is not corrupted.
Giz added the above while I was typing. Are you able to access phpmyadmin and login using your browser not ubb?
Last edited by Ruben; 04/02/2009 2:20 PM. Reason: Added comment
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
Yes, the config file looks good. The lines at the top are fine. Nobody can get at my boards. www.game-master.netUBB Message
We encountered a problem. The reason reported was
Database error only visible to forum administrators
Please click back to return to the previous page.
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
where do I find phpmyadmin?
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Okay are you able to access mysql using say phpmyadmin?
so you can view the tables.
Do you have another tool besides ubb to access your mysql tables? Use that.
Last edited by Ruben; 04/02/2009 2:26 PM. Reason: added comment
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
not sure where to find phpmyadmin .. not in my path, and I did a disk search and come up empty handed.
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
It would be in your server control panel like cpanel,Plesk,Helm Bla Bla
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
Aha! found in Plesk.. ty...
Okay, I see my databases, and the one for my message boards.
When I click it I see all of the tables .. I was never asked to log in tho.
Now what?
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Okay before you got to the database would be a section to add users with password for the database.
There should be a user assigned to the ubb database with a password.
You might have to retype the password since it usually will not show the password.
Whatever it is that should be identical to the config.inc.php file.
Database name,User name and user password.
If they don't match then ubb can't login to the database and that is the error you are getting.
Oh don't forget to double check the database server name.
Here is all the items in your config file to double check.
'DATABASE_SERVER' => 'your db server',
'DATABASE_USER' => 'your db user ',
'DATABASE_PASSWORD' => 'your db password',
'DATABASE_NAME' => 'your db name',
'TABLE_PREFIX' => 'your db prefix name(usually ubbt_)',
Last edited by Ruben; 04/02/2009 2:42 PM. Reason: added config fileds
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
WOW .. I think I may have found it...
Please stay tuned...
Looks like shear craziness.
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
Curious on the craziness... Hope all is sorted soon...
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Looks like post count spam to me! He He
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
|
Joined: Nov 2004
Posts: 198
Member
|
|
Member
Joined: Nov 2004
Posts: 198 |
OMG.. fixxored.
First of all .. thanks to all of you guys .. we did it!
Now for the craziness.
When I looked at those first few lines in the config file the LOOKED fine .. they had my MESSAGE BOARD admin name and MESSAGE BOARD Password.
Turns out when you go to that Database Configuration screen it WIPES OUT YOUR CURRENT NAME AND SUBSTITUTES YOU MESSAGE BOARD NAME AND PASSWORD!!
This is terrible since:
1. I didn’t want to change the db admin
2. Legal Message board names are NOT necessarily legal database names
It’s #2 that bit me. My name on the message board is “adam ant”, but spaces are not allowed for the database and so the catastrophic failure.
If I may make a suggestion; please do not change the current database admin and password when entering that screen.
Member since November 2004
Gold Member since Feb 2008
|
|
|
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126
|
|
Joined: Jun 2006
Posts: 16,366 Likes: 126 |
That's weird, never heard of that happening before; what version of the UBB are you on?
|
|
|
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85
|
|
Joined: Dec 2003
Posts: 6,628 Likes: 85 |
Yea I was going to tell you usually user names in mysql don't allow spaces so the default is underscore.
But for me anyway I can still use whatever username I want for the db. If you want to play try adding a second user and see if you can use what you are used to.
Blue Man Group
There is no such thing as stupid questions. Just stupid answers
|
|
|
|
0 members (),
1,448
guests, and
60
robots. |
|
Key:
Admin,
Global Mod,
Mod
|
|
|
|
