Originally posted by Steven Edwards
View Post
Announcement
Collapse
No announcement yet.
Step 2 Connect to database help
Collapse
X
-
-
Thanks Steve,
I figured it out... I had the same problem as the previous post. I used the tip and it worked
Leave a comment:
-
Steve,
I've been trying and I have contacted my host so that isn't the problem. Now I'm guessing it's my config. I'm not really good at it. I know you're a very busy guy but if I sent my config to your PM. Can you please skim through it and see what I'm going wrong?
Thanks
Janie
Leave a comment:
-
Thanks. I've updated the troubleshooting page with a link to your post.
Leave a comment:
-
I wasn't receiving the exact same message as the OP, apparently.
I'll have a server acting as a webhead and another as the database server. I had the database server's FQDN as ['MasterServer']['servername'] and was receiving a database connection error from vBulletin that directed me to line 311 in includes/class_core.php.
Running the PHP above from the command line worked, so I tested it from the web (using lighttpd+APC) and received a database connection error. I then modified the PHP to attempt a connection to port 3306 on the database server directly and received error number 13, error string Permission denied. I then tried retrieving Google's homepage in PHP from the web and got the same error, which convinced me that something was preventing lighttpd from making outgoing connections.
A few searches later led me to SELinux being the culprit and offering the setselinux command in my previous post as a way to fix Apache. I couldn't find anything that mentioned a comparable command for lighttpd, so I ran the command and then ran the modified PHP script to see if it worked. It did, so I tested vBulletin and it worked, too. (I then came and made my crow comment.)
Does that help?
Steven
Leave a comment:
-
Interesting. Can you lease explain that some more? I don't see how it's applicable unless the database is on a different server. I'll be glad to update the troubleshooting page if you can provide the relevant info.
Leave a comment:
-
Simple solution: "setsebool -P httpd_can_network_connect true". (SELinux blocks outgoing connections from the web server by default, apparently.)
Steven
p.s., I'll take my crow baked, please.
Leave a comment:
-
Sorry Steve—no need to take me so seriously. I'm just trying to keep things lighthearted while I debug whatever the issue may be.
Leave a comment:
-
Originally posted by Steven Edwards View PostAll I'm saying is "hey, this may not be a server issue, so you guys may want to look into it."
(I do give you credit for categorically stating that it's a server issue, then effectively walking it back by saying it may be a previously unknown [vB] issue.)
Also I did I not say it was an unknown vB issue. The 'unknown' part has to do with the server. Sorry that was not clear.
Leave a comment:
-
All I'm saying is "hey, this may not be a server issue, so you guys may want to look into it."
(I do give you credit for categorically stating that it's a server issue, then effectively walking it back by saying it may be a previously unknown [vB] issue.)
Leave a comment:
-
There should be something in the server errors logs, yes. All I can state categorically is if the info in config.php is correct and the server is setup correctly, then this would work. Since you state the info is correct then this has to be a server issue. As I said it is also a previously unknown issue that has never come up before in the 8 years I have been doing this. If it was a known issue we would have updated that page.
Leave a comment:
-
Originally posted by Steve Machol View PostSince that age has all the known causes of this problem, then by definition this one is unknown and is certainly a server problem. If there is a new issue then this is something you will have to have your host investigate.
Once they have figured this out you can let us know and we can update that page is it really is a new problem.
Leave a comment:
-
Since that age has all the known causes of this problem, then by definition this one is unknown and is certainly a server problem. If there is a new issue then this is something you will have to have your host investigate.
Once they have figured this out you can let us know and we can update that page is it really is a new problem.
Leave a comment:
-
Originally posted by Steve Machol View PostThat links contains all the known causes of that error and in 8 years of doing this I have never seen it caused by anything else.
There may be a new error, then. I'm migrating my vBulletin setup to new servers and am receiving the same error.
Current setup: vB 3.8.3+MySQL on a single server.
New setup: vB 3.8.3 on one (slave) server [xxx-web.xxx.yyy], MySQL master on another [xxx-db.xxx.yyy].
SSH'd in to -web, I can connect to -db using the login info I placed in config.php. From vBulletin, however, I cannot.
Going a step further, I wrote this simple code to verify that PHP can connect:
Code:<? $server = ''; $port = 3306; $user = ''; $pass = ''; $link = mysql_connect("$server:$port", $user, $pass); if (!$link) { die('Could not connect: ' . mysql_error()); } ?>
Can you offer any suggestions?
Thanks,
Steven
Leave a comment:
-
That links contains all the known causes of that error and in 8 years of doing this I have never seen it caused by anything else. This itself is pretty clear:
Access denied for user 'XXXXl'@'localhost' (using password: NO)
I suggest contacting your host for further help with this. Clearly something is wrong. Perhaps there is an issue with the server.
Leave a comment:
widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
Leave a comment: