Restoring or installing vBulletin OSX Yosemite

[marcopolo]

Anyone here have experience and successfully restored a vB system (that was previously hosted) or installed from fresh onto OSX Yosemite?

I'm having a few issues, php, MySQL and apache seem fine but the installer fails after licence input reporting:-

Due to the following errors, the install/upgrade can not continue:•The database has failed to connect because you do not have permission to connect to the server. Please confirm the values entered in the includes/config.phpfile
•Error description: mysqli_real_connect(): (HY000/2002): php_network_getaddresses: getaddrinfo failed: nodename nor servname provided, or not known /Users/mark/Sites/test/includes/class_core.php on line 1358
I have checked both mysql via workbench and phpmyadmin and I have a blank DB that allows user root all privileges

I have checked config.php and all the relevant connection credentials are correct,

$config['Database']['dbname'] = ‘test’;

$config['MasterServer']['username'] = ‘root’;
$config['MasterServer']['password'] = ‘password’;

I'm stuck!

Thanks

[HM666]

Look close to the top and find this:

$config['Database']['dbtype'] = '';

Make sure you have the correct database type there. If its currently 'mysql' try 'mysqli', save and upload again. I don't know if this is your problem or not.

Also its never a good idea to have your database as test/root/password and stuff like that even if its a test server. Never use root in your vBulletin config. This may open you to potential problems.

[marcopolo]

Thanks, I then get a parse error. Btw, this is my own home iMac, not a hosted one so security is not an issue.

[HM666]

Originally Posted by marcopolo

Thanks, I then get a parse error. Btw, this is my own home iMac, not a hosted one so security is not an issue.

I realize its a home server that still does not matter, you can still get hacked and still have a security problem from using unsafe logins & passwords. Can you post the parse error you get? Cannot help without knowing the error you get.

[marcopolo]

I appreciate your comments on security, be assured I know what I'm doing on that front.

I've now scrapped the MAC route and configured my 2008r2 server. tested a vb new install and it's fine but the attempt to get the restore of my original forum is still an issue.

Created a new DB based on config.php DB name, accessed mysqldumper and restored the last DB to it and it went through fine. Attempted to launch the forum directly on the server and get Database error (I used all the original vB files that were created from the hosted cpanel full backup)

[ozzy47]

Need to know what the error was.

[marcopolo]

Ok, changed config.php dtype from mysql to mysqli and same in message in browser, which is simply:-

Database error followed by 'The database has encountered a problem'

Nothing reported in mysql logs or server event logs

[kh99]

Did you check $config['MasterServer']['servername'] and $config['MasterServer']['port']? The message in the first post kind of sounds like it's failing looking up the servername.

[marcopolo]

Originally Posted by kh99

Did you check $config['MasterServer']['servername'] and $config['MasterServer']['port']? The message in the first post kind of sounds like it's failing looking up the servername.

They are set the same as my test vb forum which is working fine in a sub folder

--------------- Added [DATE]1422033874[/DATE] at [TIME]1422033874[/TIME] ---------------

Ok, this is bizzare, now when I launch http://localhost/vbulletin it's loading my old hosts website holding page

--------------- Added [DATE]1422034745[/DATE] at [TIME]1422034745[/TIME] ---------------

We're sorted, not sure what went on but we're up and URL settings sorted!