Pleade help! I need to hire a Vanilla expert.

Elysa

Hi - My forum is down after being hacked last night. I have exhausted all resources to get it running again (including restoring all files from fresh 2.0.18.8 download). At the same time, I am trying move my site to GoDaddy (as we are having to move our domain) and I cannot get the forum to see my database there. If there is someone who can help me, I would greatly appreciate it. We are a national software company and happy to pay for services. Here are the forum links to my sites: www.expsoft.com/forum and the new site www.explorer-systems.com/forum. Please...if any Vanilla expert can spare some time to help us get running, I would greatly appreciate it. Thank you, Elysa

hgtonight

I just PMed you. I may be able to help.

Elysa

Hi - ok, Great! Sorry stepped away from my desk. My number is 707-279-2332.

vrijvlinder

so the one which is not working is this one

www.expsoft.com/forum

To reconnect to your database, write down the db id number then find it in your mysql php admin and change the password of that db. After changing the password make sure you write it into the config.php . Assuming all your files are complete, this should reconnect your db to vanilla forum.

vrijvlinder

You can also test to see if you can even connect to the database by making a test using this like below.

1.First, Make sure, MySql is running. Open PhpMyAdmin and connect the database.

2.Check User has sufficient permission to connect database.

For this, Create a test page testconnection.php, put following code and run it.

<?php
    $link = mysql_connect('localhost', 'root', 'password');
    if (!$link) {
    die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';
    mysql_close($link);
    ?>

3.If you fail to connect ,change the password as I said before. Make sure User has permissions and the user name and password are correct and match in the config.php. Make sure config.php has permissions of user owner and that it is writeable.

Linc

VanillaForums.com does emergency migrations if you want to get onto our managed hosting service. Email sales@vanillaforums.com.

Elysa

Hi Lincoln - Thanks, I will think about that.

Elysa

vrijvlinder - I tried changing the db password and updating config file, that did not do it. I am trying to figure out how to run the .php file you sent now.

vrijvlinder

make sure your changes were saved in the config.php. If they were not then something is wrong with permissions , both user and chmod. If the changes did remain after saving then make sure the credentials are correct. Check to see if this is not commented if it is uncomment or copy this into your config.php to possibly show more info on the error.

$Configuration['Garden']['Errors']['MasterView']= 'deverror.master.php'; // Used at installation time and you should use it too view when debugging

Elysa

ok I guess I don't understand. What should go in place of 'localhost' and 'root'. Is one of those supposed to be the path to my db and one the db name?

vrijvlinder

no that is only a test page to see if it can connect to db, that code is the testing code , if it can't connect when you go to the page yourforum/testconnection.php it will give the error Could not connect if it connects it will say Connected successfully that is all it does it tests the connection with the database .

You can also try connecting manually from phpmyadmin just go to the database and click connect.

Elysa

Ok, I uploaded the file above exactly as typed. Here is my address I used to run it http://www.expsoft.com/forum/testconnection.php

Here is the answer Could not connect: Access denied for user 'root'@'localhost' (using password: YES)

HOWEVER I can connect to the db via phpmyadmin

vrijvlinder

so you can connect but it still does not connect... I think it's permissions and ownership problem. Or even that you may need to specify a port or socket, what version of php is your server using .?

here is more info that may help troubleshoot

http://dev.mysql.com/doc/refman/5.1/en/access-denied.html

Elysa

Can I hire you to help me?

vrijvlinder

You don't have to hire me I will look into it and give you my results as to what I found for free. You can pm me the login info to your server where the trouble install is and I will gladly look it over and try to help you resolve the issue. I will not touch any files or edit anything without first telling you what I found.

I would contact the current host and see if they have a clue as to what is happening first. Please back up all files and database so at least you know that is safe. I will pm my telephone number to you so you have a way of contacting me .

Tama

If you've moved hosts, some don't allow you to connect to mysql databases outside of the shared plan you have hosted with them.