Host only allows access through localhost

[littlefish]

I can't seem to get the installation to work with my new host.  I get to step three, but apparently my host has blocked port 3306.  I emailed them but they stated that they only allow connections to db through localhost.  So.....how I am supposed to complete the installation?  Help.

Thanks,
Kayla

[littlefish]

Tried that...no go. 

[Ted]

Try using 127.0.0.1 as the hostname.

[littlefish]

That doesn't work either.  My host says that they only allow access through localhost.  My problem apparently lies with the Database Host Port, but this is the only CMS that I have used that asks for that upon installation.  Any other ideas? 

[Ted]

Ok, here's the interesting part.  I just traced a bunch of code.  Apparently port isn't used in any of the connect statements and isn't saved in config.php.  I guess it must've been taken out a LONG time ago and never got removed from the installer.

So, I don't think the port thing is your issue.  It should be connecting like any other php app.

[amygdela]

and to add to that, your serverlocation (localhost) has absolutely nothing to do with your portnumber. Hosts and ports are 2 different things. What are your errors when installing? Please be as clear as possible, thanks!

[littlefish]

That is interesting.  Yes, I did create a database and enter all of the correct information in the installation screen.

I get:
Could not connect to database. Verify that username and password are correct, and that the user has access to the given database.

Here is what I entered:

Database Type: MySQL (3 and 4.0)
Database Host Address: localhost
Database Port: 3306
Database Name: meleshen_name
Database User: meleshen_user
Database Password: *******
Table Prefix: cms_
Create Tables: Checked

[littlefish]

Actually it is a vdeck account and the database is set up exactly as it should be.  I have set up many databases and installed many MySQL / PHP -based applications, but this is the only one I have had troube with.  I guess I will just have to find a new CMS. 

[ChrisC]

I might have a fix for this, but I can't tell you why it's happening.  Here's what I did...

When the CMSMS setup kept reporting "Could not connect to the database." I tried this PHP code:



The line that connects as root worked fine, but the line connecting as cms_user printed this error:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

So, I Googled that phrase and found a recommendation that I do this from the mysql prompt:

mysql> SET PASSWORD FOR cms_user@localhost = OLD_PASSWORD('*****');

Did that, clicked Continue on the CMSMS setup page and had a sight up in a blink.  I think it would be handy if the installer would report the actual mySQL error string, but I don't really know the root cause of the problem -- I just Google.  This might be somehow related to using phpMyAdmin to create the database....

Cheers,

CJC

[Ted]

Yeah, that's related to using the mysql driver (not mysqli) with mysql 4.1.  Though, I could've sworn that it gave a better error than the standard "can't connect" message in that case.

[Ted]

That's correct.  It's a flaw in the php/mysql combinartion.  We try to handle it as best as we can, but it doesn't always work without some kind of intervention.

[littlefish]

Whew.  I tried to follow the last few posts, but must admit that they are over my head.  So, is there any hope for me to get this installed with my current host provider?  I really hope so because they are a major hosting company and I often resell packages to my clients.  I would love to use the CMS on client sites as well!

[Joff]

Probably not the problem you're experiencing, but it might be worth a try anyway...

I had a similar "can't connect to db" problem yesterday and found this worked (last post): http://forum.cmsmadesimple.org/index.ph ... 810.0.html