Previous Thread
Next Thread
Print Thread
Hop To
Page 1 of 2 1 2
#225246 04/02/2009 2:23 PM
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
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,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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:

Quote
'PERSISTENT_DB_CONNECTION' => '',


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
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
L
Member
Member
L Offline
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
D
Pooh-Bah
Pooh-Bah
D Offline
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,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
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,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
L
Member
Member
L Offline
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,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
L
Member
Member
L Offline
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
L
Member
Member
L Offline
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,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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 2:55 PM.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
Code
[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 4:38 PM. Reason: removed real name

Member since November 2004
Gold Member since Feb 2008
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
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 3:02 PM.

Member since November 2004
Gold Member since Feb 2008
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Well, that generally means that there is a problem with the username/password combination (Access Denied)


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
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 3:05 PM.

Member since November 2004
Gold Member since Feb 2008
Joined: Jun 2006
Posts: 16,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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 3:07 PM.

I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
help?


Member since November 2004
Gold Member since Feb 2008
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
L
Member
Member
L Offline
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
L
Member
Member
L Offline
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,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
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...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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 3:20 PM. Reason: Added comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
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.net

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: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
where do I find phpmyadmin?



Member since November 2004
Gold Member since Feb 2008
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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 3:26 PM. Reason: added comment

Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
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,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
L
Member
Member
L Offline
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,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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 3: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
L
Member
Member
L Offline
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,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
Curious on the craziness... Hope all is sorted soon...


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
L
Member
Member
L Offline
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,292
Likes: 116
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,292
Likes: 116
That's weird, never heard of that happening before; what version of the UBB are you on?


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,560
Likes: 78
Joined: Dec 2003
Posts: 6,560
Likes: 78
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
Page 1 of 2 1 2

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
spam issues
by ECNet - 03/19/2024 11:45 PM
Looking for a forum
by azr - 03/15/2024 11:26 PM
Editing Links in Post
by Outdoorking - 03/15/2024 9:31 AM
Question on barkrowler and the like
by Mors - 02/29/2024 6:51 PM
Member Permissions Help
by domspeak - 02/27/2024 6:31 PM
Who's Online Now
2 members (Gizmo, Nightcrawler), 553 guests, and 186 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20230217)