Previous Thread
Next Thread
Print Thread
Hop To
Page 2 of 2 1 2
#225246 04/02/2009 1: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,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:

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,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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...


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,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
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,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
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,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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...


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,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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.

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 3: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 2:02 PM.

Member since November 2004
Gold Member since Feb 2008
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
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 2:05 PM.

Member since November 2004
Gold Member since Feb 2008
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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.

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,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
UBB.threads Developer
UBB.threads Developer
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...


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,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
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,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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...


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,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
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,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
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,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
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,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
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,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
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,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
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,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
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?


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,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
Joined: Nov 2004
Posts: 198
L
Member
Member
L Offline
Joined: Nov 2004
Posts: 198
Giz: my UBB version is 7.4.1

Ruben: I just set it back to what it was. I had a backup of the config and just used that.

I really think this is a bug (in fact I'm sure it is.) The UBB should not do this defaulting unless the two names are guaranteed to be compatible. And EVEN if the two names were compatible, it still shouldn't have changed it. Fields shouldn't auto-magically change without explicit direction from the administrator.



Member since November 2004
Gold Member since Feb 2008
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Yeh, the UBB shouldn't be changing what the data for the dbuser when it's set to something else... Very odd...

If I get some time I'm going to go drudge through the script/template files and see if i can notice anything; though I have a feeling that Yarp™ may beat me to it by then lol...


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,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
Well UBB has nothing to do with MYsql as far as servername,User Name and password.
You enter that info in ubb so it can access the database.
It is like giving ubb a login to the database.
So ubb did not change the db login it was just wrong in the config file
Phpmyadim is a standalone db tool which again has nothing to do with UBB.
So when you selected the connection settings something must have corrupted the ubb config file. Especially if you restored the old config file and it is working again.
So something was changed in the config file due to whatever reason. It was probably so slight and unobtrusive you overlooked it checking for errors.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Ruben, he's saying that when he edited his config via the CP that it changed the mysql username to the name of his forum (if i get what he's saying correctly) vs keeping the username unaffected.


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,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
Yea I am not sure. Since you and I both advised him to check his db using phpmyadmin. My understanding was phpmyadmin forced him to change the login.
But even then how would a old config file still work?
If the db login changed.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
I think the login info was fine, the UBB changed his username in the config file, and thus it was being submitted wrong due to this odd behavior.

Luket, if I'm assuming this correct (as mentioned above) would you be willing to backup your config file, and go and just submit the db info page to see if it overwrites your mysql username again to narrow down if it is a bug with this area?


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,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
BTW Luket,
You say you are a gold member but you are using 7.4.1.
Maybe it is time to upgrade to 7.5.2


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
Originally Posted by Gizmo
I think the login info was fine, the UBB changed his username in the config file, and thus it was being submitted wrong due to this odd behavior.

Correct. it was fine until i went to the "Game-Master.Net » Control Panel » DB, Paths & URLs" of the control panel. At this point the CP CHANGED:
1. Database Username: my message board account name
2. Database Password: my message board account password

When I hit submit, it shoved this info into the config file whereby screwing me over for all future DB access. (since my message board user name is incompatable with the DB.)

Originally Posted by Gizmo
Luket, if I'm assuming this correct (as mentioned above) would you be willing to backup your config file, and go and just submit the db info page to see if it overwrites your mysql username again to narrow down if it is a bug with this area?

Done. I fix everything and went back to the "Game-Master.Net » Control Panel » DB, Paths & URLs" and noticed that in fact it auto filled in those two database fields (user and password) with my message board info.
I then hit Submit and verified that once again my config file was updated with the bad user name (and password)

The problem is very simple. The "Game-Master.Net » Control Panel » DB, Paths & URLs" section should NEVER change those fields unless explicitly asked to do so.


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 now we are getting somewhere for Rick to work on.
What Browser are you using to visit the control panel in UBB.
I did note a issue a while back with Firefox with password changes.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
HERE is my post on a issue with Firefox auto filling in password fields. Which may apply to this issue.
Most of this topic may not apply to the bug forum but the last few may.
But upgrading from 7.4.1 to 7.5.2 may also correct the issue.
If Rick addressed this for other areas in the software.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Yeh, from what you're saying it definitely sounds like an autofill utility is installed in your browser that's trying to "log in" to the page


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
What Browser are you using to visit the control panel in UBB.

Ah, good call man.

I use Google Chrome V 1.0.154.48
and it auto fills in the fields (causing the problem)

I then tried IE and it did not fill in the fields.


Member since November 2004
Gold Member since Feb 2008
Joined: Apr 2007
Posts: 3,940
Likes: 1
SD Offline
Former Developer
Former Developer
Joined: Apr 2007
Posts: 3,940
Likes: 1
if Chrome wasn't so 'smart' about the autofill of psws, i'd be using it more for ubbthreads sites frown

Joined: Dec 2003
Posts: 6,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
Verified problem with chrome.
Using ubb ver 7.5.2
If you are using the browsers stored login and password. When you open the db/paths section in the control panel.
It replaces the database user name and the database users password with the board login stored in the browser.

IE7 and Firefox 3 seem okay.

Is this fixorable for chrome users in a future release Rick?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Dec 2003
Posts: 6,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
Chrome also changes the verify email address and verify password fields. When you open mystuff>profile.

Bad news again.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
It's not really a threads issue imo...


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,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
Originally Posted by Gizmo
It's not really a threads issue imo...
No it is not a ubb issue but we all know Rick trys as much as he can for cross browser compatibility.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Well, short of renaming every field in the UBB to be some unresolvable field to ensure nothing triggers an autofill field ever, I don't really see this as being too easy...


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,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
Never said it was easy. Just that Rick trys his best.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Well, the thing is, some fill in every field for say name, address, etc when you load a page; so you could end up with say every im service populating with "name" or "address" and all of that; it'd likely be problems on any 3rd party page... Just don't see why the UBB would have to update because of some random behavior that should be fixed in the users browser...


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,628
Likes: 85
Joined: Dec 2003
Posts: 6,628
Likes: 85
So what do you do, target a browser and tell everyone that your site only works on Firefox 2 but not 3. Or you could use IE7 but not 6.
Or if you use chrome you have to turn off a certain feature.

It is bad enough with the referrer issue with Norton,Etc.
And dealing with different settings for each internet security settings.

I know it is a big issue, but where do you draw the line?


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Well, if the issue effects more than one product, that's where i'd draw the line... i mean, making every field name obscure as to not "trip" would make dev even more difficult as you'd have to go in and have to actually look at what has to be updated instead of using logical names like "name" and "email" and "address", etc...


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,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
A valid "fix" would be if these browsers would create an html code to disable their autofill on any page it's specified; so they could make support for a prepriatary tag like:
Code
<meta name="autofill" content="disabled" />

Then we could just embed that anywhere we'd want it disabled, like every page of the CP... But that's up to them what prepriatry crap they want to shove in their product...


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,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
There is actually a thread on Google's Support Pages regarding the autofill in the Google Toolbar (give or take it's the same real behaviour as with the autofill in Crome); a lot of developers don't like the behaviour and are also seeking a tag to disable the autofill via a tag on a page as well.


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'd just rename all the special field names to ubb_name, ubb_email, and ubb_password and be done with it.


Member since November 2004
Gold Member since Feb 2008
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Sadly that wouldn't fix it in all cases; if you read the post I linked to above you'll see that anything containing "pass" can trigger the password, anything with "name" can trigger name...

Unless you went out of the way to name everything something totally out there (name: 8237980327441; pass: u2309ur023joijhoi, etc) you'll still get tagged by the autofill; and would make dev time a pain (both for rick, modders, etc)...

Again, this is really the browser/plugin creators problem, they need to make and follow a method of allowing site owners to disable their tool.


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 understand the "it's not our problem" mentality, but an unhappy UBB customer is an unhappy UBB customer.

If other message board software solves the problem, then UBB could lose market share, because in the end; a customer doesn't really care who's problem it is, they just want to to all work.

I too am a software developer. My software works on all versions of Windows, but I had to either (1) say 'too bad' to people running Windows NT, or (2) work around the shortcomings of NT.
I chose to do the extra work needed so that my customers had a good experience.

My customers--like your customers--HATE to hear "it's not my problem"; especially when we know that you CAN work around the problem, but CHOOSE not to on principal.

Even though you're not asking; I recommend you work around the problem and never utter the words "It's not our problem" again tongue

PS. Don't you guys have a #define mechanism?
Can you say something like:
#define EMAIL flabber_123
#define PASSWORD snarf_6969

such that the developer sees human readable names and the runtime environment sees some uninteresting field names?


Member since November 2004
Gold Member since Feb 2008
Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
I'm by no way a staff at infopop/groupee/whatever... I'm a user of the software just like you; i just understand how things work and all that fun jazz (hence why i'm a beta tester and a gold license holder).

My opinions are that of myself, not groupee/infopop.

By saying it's not the UBBs problem, i'm saying that the browser companies need to make it so that it's EASIER to work with their functionality; by specifying that post above i show that others are requesting the same thing FROM the company, which I'm assuming will be eventually worked on BY the manufacturer of the browser/plugin since they tend to have a decent track record with such things.

I'm not saying "it's not our problem" i'm saying it'll make maintenance more difficult, both for the product maintainer and 3rd party modders (and even board owners who just want to play with code every once and again).


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: Mar 2008
Posts: 327
D
Enthusiast
Enthusiast
D Offline
Joined: Mar 2008
Posts: 327
not to mention taking a step backwards from XHTML compliancy

Additionally, bending over backwards to support a Web browser's shortcomings only encourages the behavior to continue.

Joined: Jun 2006
Posts: 16,366
Likes: 126
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,366
Likes: 126
Originally Posted by DLWebmaestro
not to mention taking a step backwards from XHTML compliancy

Additionally, bending over backwards to support a Web browser's shortcomings only encourages the behavior to continue.
My point exactly


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!
Page 2 of 2 1 2

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Not allowing attachment over 2m
by ehill - 12/03/2024 3:16 PM
New Admin Here
by SenecaFlyer - 12/02/2024 4:14 PM
Post Counts zeroed out
by Baldeagle - 11/03/2024 3:05 PM
Who's Online Now
0 members (), 1,448 guests, and 60 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.1
(Snapshot build 20240918)