GoDaddy installation - Login problem

[anachreon]

Hiya ppl,

Ok, I've uploaded phpwcms to the ftp area of the domain (hosted on GoDaddy) and ran through the setup.
I created the database with the sql script via phpMyAdmin on the GoDaddy phpMyAdmin panel.

Problem: When attempting to login to phpwcms it says it can't connect to server 'mysqlX.secureserver.net'. Ok, so maybe it's because I didn't set a table name, so I run setup again and give it a name, but it will not go through. I add the name, assuming it's the same as the user name in the conf file and it says it can't connect to the table.

In phpMyAdmin I can't see where to give the table a name (noob alert!
Is this a GoDaddy 'feature' or am I missing something?

Haylp!

Cheers,

Luis.

[pSouper]

it's a host thing.
your host will tell you what your sql details are or let you set the table up yourself.

[anachreon]

Well, I get the details from the panel, the sql is hosted at 'mysqlX.secureserver.net', and that's in the conf file.

Got the user and p/w all setup too.

What's going on?!

Cheers,

Luis.

[pSouper]

does the error mention password =YES or password =NO ?
do you use a password?

[Jan212]

maybe your db server doesn't allow remote access?

[anachreon]

It doesn't mention anything to do with passwords, they're in the cong file anyhow.

As for the remote db: I'm assuming it does because of phpMyAdmin. Actually, thinking about that, I noticed an 'internal' ip range in the browser bar when using phpMyAdmin form the panel link from within the GoDaddy login (10.0.0.something). So maybe it doesn't. Weird.

Anyone using a GoDaddy account with phpwcms?

From the looks of it, and checking out many others, phpwcms looks like the best free option out there, and it would be enough to get me to switch host if it doesn't work out with GoDaddy.

He does mention a support charge to install phpwcms: Anyone use this? It looks very reasonable, but I'm concerned that the host might not cut it.
Plus, if it contributes in any way to his efforts I am more inclined to pursue this option.

Cheers,

Luis.

[GreenNuggs]

anachreon, I'm using a remotely hosted site as well through eHostPros.com. What I had to do was create the database called phpwcms and created a new user called phpwcms with a specific password, then I assigned that user to be the superuser of that database. (Note: they do NOT have to be that name, nor do they have to be the same name, but I did so for simplicity sake)

Do you use cPanelX? cPanelX is basically a control panel for my hosting plan. It has everything from premade scripts to a file manager to a database manager.

The thing about my hosting company however is that I have to prepend onto BOTH the database name and the user name a "xxxxxxxx_" The xxxxxxxx_ is comprised of the first 6 digits of my site name through them and the last 2 digits is the numbered server I'm hosting through them.

I'm not sure thats what you have to do, but basically I had to make sure the database exists first as well as have a superuser setup for that database before installing PHPWCMS. And I don't believe you can do that through PHPMYADMIN because that only allows you to administer databases, not create them, I think?

Oh, one thing I just thought of, you are saying that your SQL servername is 'mysqlX.secureserver.net' ? Are you sure its not just 'localhost' ?

[anachreon]

Tried it with localhost, can't find the database...

It'll be a pain to have to remove phpwcms, recreate the database, and upload it all again and run through the setup, again.

It hadn't worked on RC1, then I went off on a tangent, came back and RC2 was out. I suppose I could leave it for now and see what happens when the full release comes out, although I'm sorely tempted to move the host, or perhaps test it with the 'remote' mysql server being at home.

Cheers,

Luis.

[DrubusCulubus]

Is your MySQL DB running on another machine? If that's the case try in de config.inc.php to set the login timeout to 1800000 instead of 1800.

It can be that the clocks are not synchronized. It worked for me. Goodluck!

[anachreon]

Sounds like a good idea: But I can't find any reference to a login timeout in that conf file, no mention of 1800 either.

I'm 'running' RC2 if that makes any difference.

Cheers,

Luis.

[DrubusCulubus]

arround line 33:
$phpwcms["max_time"] = 1800000000; //logout after max_time/60 seconds

Goodluck Luis!

[anachreon]

Well, I've added that in, but it still says:

Error while trying to connect to table ""

This is via domain/login.php

I've added phpwcs_user as the table in the cong file, and it still complains. Which should it be connecting to?

Cheers,

Luis.

[DrubusCulubus]

You did not edited the default.in.php manually? If you did, it happens... (I did in the beginning ... ) Upload a 'fresh' un-edited version of your default.inc.php.

Regards

[anachreon]

I can't find the default.in.php file anywhere in the install! Or am I missing something else here?

Ok, this is getting weird.

Seeing as you ppl are still urging me on with suggestions I'm going to keep on at this for a little longer, then I'll consider paying the guy to do it.

Cheers,

Luis.