Portal Home > Knowledgebase > Articles Database > Problem with vBulletin 3.6.4 after migration to new host
Problem with vBulletin 3.6.4 after migration to new host
| Posted by VentureMaker, 08-22-2007, 05:07 AM |
| Hello, WHT!
I'm asking for assistance
I have just migrated vBulletin 3.6.4 to new host. Everything was done following migration docs, all files were moved, DB was moved, etc.
I have edited includes/config.php and corrected DB name, DB user, DB server, and so on.
The forum is up, but... When I try to login, I see the following message:
--- --- ---
Database error in vBulletin 3.6.4:
mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'oldusername'@'localhost' (using password: YES)
[something]/forum/includes/class_core.php on line 273
MySQL Error :
Error Number : 0
Date : Wednesday, August 22nd 2007 @ 04:55:00 AM
Script : [something]/forum/login.php?do=login
Referrer : [something]/forum/
IP Address : [something]
Username : [something]
Classname : vB_Database
--- --- ---
I have replaced some info with [something]
You see, that this error message tells me that vB tries to connect to DB using oldusername, not the new one I have set in includes/config.php
How can this be? Where else except includes/config.php does vB store mysql connection settings?
|
| Posted by kayz, 08-22-2007, 05:44 AM |
| Double check your config file and enter the new database name and password that you have created with your new host.
Also, if you are having problems, upload the tools.php file from the do_not_upload folder. Remember to delete it afterwards.
|
| Posted by VentureMaker, 08-22-2007, 05:58 AM |
| kayz, I have checked includes/config.php
It has all correct values for new host. DB user is also set to correct.
But the error message I have posted still tells me that vB tries to connect with OLD (incorrect) DB user.
So, if includes/config.php has NEW (correct) DB user there - it must be that vB stores DB connection settings not only in includes/config.php
Because regardless of the DB user specified in includes/config.php it STILL tries to connect with OLD username. At least, this tells me so:
mysql_pconnect() [function.mysql-pconnect]: Access denied for user 'oldusername'@'localhost' (using password: YES)
[something]/forum/includes/class_core.php on line 273
You see, that erros message shows oldusername, though includes/config.php has newusername specified.
I'm confused.
P.S. I don't have install package of vB, so I don't have tools.php
I'm just migrating it from one hoster to another, and I don't own license and install pack.
|
| Posted by Barti1987, 08-22-2007, 08:02 AM |
| Nope, the database information is wrong.
Another note: stop stealing.
Peace,
|
| Posted by VentureMaker, 08-22-2007, 08:11 AM |
| azizny, unfortunately you aren't at least informative in your post
Point 1. This copy of vB is legal, but I'm not the owner of license. I'm just doing contract (paid) work for the owner.
Point 2. What do you mean by 'Nope, the database information is wrong.'?
|
| Posted by Mxhub, 08-22-2007, 08:12 AM |
| It seem you are not using correct mysql username or password to login to your mysql database.
You better double check.
|
| Posted by VentureMaker, 08-22-2007, 08:14 AM |
| Guys, I have checked several times.
The file includes/config.php has everything OK. That's why I'm lost - I cannot imagine where vB still takes old DB username from.
|
| Posted by dollar, 08-22-2007, 08:15 AM |
| Are you sure that when you go to yourforum.com/forum or what have you, that you are actually going to the new host? Double check the IPs with a ping to make sure it's going to the right place. You updated your DNS right?
|
| Posted by Mxhub, 08-22-2007, 08:17 AM |
| do a traceroute to your site. Make sure it resolve to your new host.
|
| Posted by VentureMaker, 08-22-2007, 08:20 AM |
| My new host has CPanel. I have added an addon domain name, but haven't changed DNS records yet.
So, if you know CPanel, you know that this domain is accessible only via subdomain smth.myhost.com until DNS records are changed. So, I'm working using subdomain only.
Note: I have several other things there: Joomla, PHPAds, PHPCoin but none of these ever gave me this kind of error.
|
| Posted by dollar, 08-22-2007, 08:22 AM |
| None the less, won't hurt to ping or trace to subdomain.yourhost.com and check to make sure that the right IP is being accessed.
If you're 100% sure on the config file being edited correctly, and it's showing you that it's attempting to access the wrong information, the only thing that would make sense is for your machine to be accessing your install at your old host.
|
| Posted by VentureMaker, 08-22-2007, 08:23 AM |
| Also, I don't see any connection with possible DNS problems.
vB just tries to use user aaa while in includes/config.php there's user bbb
|
| Posted by VentureMaker, 08-22-2007, 08:25 AM |
| Both - main domain and subdomain - are responding to the same correct IP
|
| Posted by dollar, 08-22-2007, 08:31 AM |
| If it's going to the right IP then the only thing I could imagine is that somehow you've overlooked something in the file. Maybe you didn't actually save it, updated the SlaveServer section instead of the main database section, saved it with the wrong name, etc..
If you have shell access to the account you could log in and give something like:
grep -R "dbusername" *
a try.
|
| Posted by VentureMaker, 08-22-2007, 08:35 AM |
| OK, I see
I wanted to make sure that vB does not save DB connection settings in some other place than config.php in includes folder
|
| Posted by dollar, 08-22-2007, 08:38 AM |
| Only place I know of =/
|
| Posted by SoftWareRevue, 08-22-2007, 08:40 AM |
| What do you have in admincp > vBulletin Options > vBulletin Options > Site Name / URL / Contact Details > Forum URL? Do you have the new smth.myhost.com?
|
| Posted by VentureMaker, 08-22-2007, 08:58 AM |
| Seems I have found what's wrong here.
I have launched phpmyadmin and did a search of 'oldusername' value.
And in vb_connectors table there exists oldusername 'hardcoded'
Have a look:
SELECT *
FROM `dbname`.`vb_connectors`
WHERE `id` LIKE '%oldusername%'
OR `title` LIKE CONVERT( _utf8 '%oldusername%'
USING latin1 )
COLLATE latin1_german1_ci
OR `module` LIKE CONVERT( _utf8 '%oldusername%'
USING latin1 )
COLLATE latin1_german1_ci
OR `url` LIKE CONVERT( _utf8 '%oldusername%'
USING latin1 )
COLLATE latin1_german1_ci
OR `vb_useradd` LIKE '%oldusername%'
OR `app_useradd` LIKE '%oldusername%'
OR `params` LIKE CONVERT( _utf8 '%oldusername%'
USING latin1 )
COLLATE latin1_german1_ci
OR `published` LIKE '%oldusername%'
LIMIT 0 , 30
Well, quite interesting what does the above thing do... Can anyone tell me?
|
| Posted by VentureMaker, 08-22-2007, 09:08 AM |
| Looks like monkey-style programming or someone's BIG bug
Anyway, I have corrected the values, now everything works OK.
Thanks everyone for your help
|
| Posted by dollar, 08-23-2007, 12:12 AM |
| Odd that yours does that. In my install there isn't even a connectors table.
|
| Posted by Annex, 08-23-2007, 02:03 AM |
| shouldn't be using 3.6.4 theres an inline mod SQL injection exploit as well as a few image related Xss exploits.
|
| Posted by VentureMaker, 08-23-2007, 03:30 AM |
| dollar, I don't know
I didn't do that install, I have just migrated the forum from one host to another. Perhaps, there was some modification done on vB, and as far as I can see - it was done in a very strange way. Anyway, now this works, so everything is OK.
Annex, thanks for that. I'll do the upgrade in next few days.
|
Add to Favourites 
Print this Article
Also Read
Shared Hosting
Shared Hosting
