prosper can't select database

[momchil9]

I ditched beyond hosting and tried to install prosper on a VPS.

Installed lamp
Installed vsftpd
setup database and user
put database usr and pwd on 202-config.php
uploaded prosper

and when I got to the VPS' IP - BAM

yes, I made sure that my user has priviliges for the database
yes. I made sure everything is spelled correctly.

 

[BlogHue]

Did you enter the Database name? From your post above it seems you entered only the database user and password?

If you enter the name prosper shows the name on that screen.

 

[momchil9]

yes. I did enter the db name

 

[momchil9]

If it helps I got this msg too

"Warning: include_once(/var/www/202-config.php): failed to open stream: Permission denied in /var/www/202-config/connect.php on line 27 Warning: include_once(): Failed opening '/var/www/202-config.php' for inclusion (include_path='.:/usr/share/php:/usr/share/pear') in /var/www/202-config/connect.php on line 27"

I tried googling it, but I just fail to see to which user I have to give permission to the /www directory... I have only root on the VPS...

 

[BlogHue]

Can you check whether a successful connection is being made otherwise. Let's ensure that this is not a Prosper specific problem.

Save the following in a file called test.php and then run it.

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

Replace ”db_host”, ”db_username”, ”db_password” with the real credentials.

 

[momchil9]

root@localhost:/var/www# ./test.php
-bash: ./test.php: Permission denied

I use root for everything, except uploading. For that I use another user.

 

[BlogHue]

root@localhost:/var/www# ./test.php
-bash: ./test.php: Permission denied

I use root for everything, except uploading. For that I use another user.

Umm... once the upload is done - you run it in a browser.

Upload it in your www and then call it http://VPS-IP/test.php

 

[momchil9]

lawl, my bad

I just have been doing this for a very long time and kind of burned out.

The website encountered an error while retrieving http://199.180.197.97/test.php. It may be down for maintenance or configured incorrectly.
Here are some suggestions:
Reload this webpage later.
HTTP Error 500 (Internal Server Error): An unexpected condition was encountered while the server was attempting to fulfill the request.

 

[BlogHue]

Your VPS is not configured correctly.

Since had it been just a MySQL issue, the script should've spouted - "Could not connect"

Is this a Managed VPS? If so, you may contact your host and they should be able to help you out.

 

[momchil9]

What might be configured incorrectly?

 

[BlogHue]

Let's try something else -

Run the following and post or PM me the output.

rpm -qa '*php5*'

Also check /var/log/apache2/error.log for the errors it outputs.

 

[momchil9]

I solved it finally.

It seems that root did not have permissions for the database, no matter how strange that sounds.

 

[BlogHue]

I solved it finally.

It seems that root did not have permissions for the database, no matter how strange that sounds.

Glad you did it! Cheers.

Now go make some monies!