Hello, I have just installed the script (mainly as a test) on my new hosting provider. Previously I had my own server but alas the return of that is resting on financial probabilities. Anyhow when I tap in the url I get the following:
Cannot establish a database connection. MySQL returns the error . (It's possible that the web host's database is currently down, if so this is a temporary error and will go away when the database is accessible again.) WSN Links 5.0.45
Unfortunately this is always what appears. The installation went perfectly but that's the screen immediately after and is always showing. My hosting provider tells me that the links are correct and whilst I told them that there seemed to be 'no permissions' (showing in red) in phpMyadmin they said it was fine and anyhow I'm unable to change stuff in there. I can see 34 tables have been made and the Mysql version is 5.0.22 / php 5.2.9 and the hosting server is through Plesk. Their tech keep asking me if the script is looking for a particular version of php and I'm quickly starting to think they are none too hot on things. Some help/comments?
That PHP/MySQL version combo is exactly what I'd recommend and use, no problem.
I don't see how the installation process could ever complete when a page itself can't, since they use the same code. If the installation had died with an error this could make some kind of logical sense, but it doesn't.
Test your mysql info in servertest.php and see if it gives any suggestions. If it works in servertest.php, double check config.php to be sure that's the info in there.
Output buffering - pass PHP version 5.2.9 - pass Remote URL functions - pass Apache mode with FTP extension - pass Linux - pass GD bundled (2.0.34 compatible) - pass Maximum Execution Time (800 seconds) - pass Allowed Memory (256M) - pass
Congratulations, this server meets all the recommendations for running WSN Links.
MySQL version 5.0.51b-community-nt-log - pass
Access to the database was established. Everything is good.
........... The upload paths in config.php have trailing slashes - is that okay (see below)? config.php is correct because I copied the data from there to the servertest.php screen
The trailing slash on your $dirurl value is bad, though completely unrelated. Only $uploadpath is supposed to have the trailing slash. The fact that the $dirurl could have the slash suggests that you may have been doing custom editing rather than using the script's installation process -- which automatically remove trailing slashes -- and that would be the real problem. Please use autosetup.php or setup.php, there are no other supported installation methods and manual file editing is certainly a bad way to do it.
Paul wrote: The trailing slash on your $dirurl value is bad, though completely unrelated. Only $uploadpath is supposed to have the trailing slash. The fact that the $dirurl could have the slash suggests that you may have been doing custom editing rather than using the script's installation process -- which automatically remove trailing slashes -- and that would be the real problem. Please use autosetup.php or setup.php, there are no other supported installation methods and manual file editing is certainly a bad way to do it.
Paul - I never touched the config.php file. The installation was 100% through the autosetup.php and if I'd done anything I would have said it - that's why it was a question rather than a statement.
So the solution to the 'cannot connect to database' is? Re-run autosetup.php maybe?
If you're not going to let me see your website URL and the actual content of config.php, then the only thing I can suggest is re-running autosetup.php.
Paul wrote: If you're not going to let me see your website URL and the actual content of config.php, then the only thing I can suggest is re-running autosetup.php.
Fixing autosetup to trim the / properly.
Well Paul actually I thought - Delete the installation and start again. Just waiting for a reply from the hosting company (and I will let you know) as I could not delete the .js files and see they are 'owned by Apache'. Once that's done I'll do a reinstall. Michael
0/5
1
2
3
4
5
Sorry, you don't have permission to post posts. Log in, or register if you haven't yet.
Comments on Cannot Connect to Database
Member
Usergroup: Customer
Joined: Apr 18, 2004
Location: London, UK
Total Topics: 9
Total Comments: 16
Hello,
I have just installed the script (mainly as a test) on my new hosting provider. Previously I had my own server but alas the return of that is resting on financial probabilities.
Anyhow when I tap in the url I get the following:
Cannot establish a database connection.
MySQL returns the error . (It's possible that the web host's database is currently down, if so this is a temporary error and will go away when the database is accessible again.)
WSN Links 5.0.45
Unfortunately this is always what appears. The installation went perfectly but that's the screen immediately after and is always showing. My hosting provider tells me that the links are correct and whilst I told them that there seemed to be 'no permissions' (showing in red) in phpMyadmin they said it was fine and anyhow I'm unable to change stuff in there. I can see 34 tables have been made and the Mysql version is 5.0.22 / php 5.2.9 and the hosting server is through Plesk. Their tech keep asking me if the script is looking for a particular version of php and I'm quickly starting to think they are none too hot on things.
Some help/comments?
Michael
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
That PHP/MySQL version combo is exactly what I'd recommend and use, no problem.
I don't see how the installation process could ever complete when a page itself can't, since they use the same code. If the installation had died with an error this could make some kind of logical sense, but it doesn't.
Test your mysql info in servertest.php and see if it gives any suggestions. If it works in servertest.php, double check config.php to be sure that's the info in there.
Note that installation service is free: scripts.webmastersite.net/w...ustom=yes&TID=installation
Member
Usergroup: Customer
Joined: Apr 18, 2004
Location: London, UK
Total Topics: 9
Total Comments: 16
results:
Output buffering - pass
PHP version 5.2.9 - pass
Remote URL functions - pass
Apache mode with FTP extension - pass
Linux - pass
GD bundled (2.0.34 compatible) - pass
Maximum Execution Time (800 seconds) - pass
Allowed Memory (256M) - pass
Congratulations, this server meets all the recommendations for running WSN Links.
MySQL version 5.0.51b-community-nt-log - pass
Access to the database was established. Everything is good.
...........
The upload paths in config.php have trailing slashes - is that okay (see below)?
config.php is correct because I copied the data from there to the servertest.php screen
$dirurl = 'http://xxxxxxx.org/Links/';
$uploadpath = '/var/www/vhosts/xxxxxxx.org/httpdocs/Links/attachments/';
$rejectspiderlevel = '';
$rejectguestlevel = '';
$ftphost = '';
$ftpuser = '';
$ftppass = '';
$ftpdir = '';
...........
Michael
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
The trailing slash on your $dirurl value is bad, though completely unrelated. Only $uploadpath is supposed to have the trailing slash. The fact that the $dirurl could have the slash suggests that you may have been doing custom editing rather than using the script's installation process -- which automatically remove trailing slashes -- and that would be the real problem. Please use autosetup.php or setup.php, there are no other supported installation methods and manual file editing is certainly a bad way to do it.
Member
Usergroup: Customer
Joined: Apr 18, 2004
Location: London, UK
Total Topics: 9
Total Comments: 16
The trailing slash on your $dirurl value is bad, though completely unrelated. Only $uploadpath is supposed to have the trailing slash. The fact that the $dirurl could have the slash suggests that you may have been doing custom editing rather than using the script's installation process -- which automatically remove trailing slashes -- and that would be the real problem. Please use autosetup.php or setup.php, there are no other supported installation methods and manual file editing is certainly a bad way to do it.
Paul - I never touched the config.php file. The installation was 100% through the autosetup.php and if I'd done anything I would have said it - that's why it was a question rather than a statement.
So the solution to the 'cannot connect to database' is? Re-run autosetup.php maybe?
developer
Usergroup: Administrator
Joined: Dec 20, 2001
Location: Diamond Springs, California
Total Topics: 61
Total Comments: 7868
If you're not going to let me see your website URL and the actual content of config.php, then the only thing I can suggest is re-running autosetup.php.
Fixing autosetup to trim the / properly.
Member
Usergroup: Customer
Joined: Apr 18, 2004
Location: London, UK
Total Topics: 9
Total Comments: 16
If you're not going to let me see your website URL and the actual content of config.php, then the only thing I can suggest is re-running autosetup.php.
Fixing autosetup to trim the / properly.
Well Paul actually I thought - Delete the installation and start again. Just waiting for a reply from the hosting company (and I will let you know) as I could not delete the .js files and see they are 'owned by Apache'. Once that's done I'll do a reinstall.
Michael