can't load due to "." in my server path

can't load due to "." in my server path

Posted by: chunky
Posted on: 2007-10-07 10:08:00

I am trying to install EZ-IPN Subscription Manager. I am using a sub-domain so my host name looks like this.sub.domain.com
The dots "." in my server path is causing problems in the setup script writting the correct path to the files. Does anyone know a way around this...or even know what i am talking about ? Thanks
This sub domain is just a dev site and i will be loading to my main site in a couple of months, but i anticipate the same problem since the host name will be this.domain.com

ChunkyEdited by chunky on 10/07/07 10:09 AM (server time).

Re: can't load due to "." in my server path

Posted by: Serg
Posted on: 2007-10-07 11:33:00

if you go to your domain manager: https://panel.dreamhost.com/index.cgi?tree=domain.manage&

you can just set up a directory without dots in it if you edit the hosting for the specific sub domain

Re: can't load due to "." in my server path

Posted by: chunky
Posted on: 2007-10-07 14:09:00

ok. but, what about the local hostname...any suggestions there?

thanks...most appreciated.

Chunky

Re: can't load due to "." in my server path

Posted by: monkeyboy7706
Posted on: 2007-10-07 14:34:00

I take it it doesn't like the /home/.something/username bit. The only thing I can suggest is ensuring you leave out the .something bit when you put in the path. Its not actually essential.

Re: can't load due to "." in my server path

Posted by: rlparker
Posted on: 2007-10-07 18:14:00

As monkeyboy7706 pointed out, the ".something" that is part of the path "above" you user is not necessary. I'd only add to that by saying that not only is it not necessary, but it really *should not* be used in paths included in a script, as that "dataglob" is subject to change by DreamHost.

If you *do* include it, and it works (as it will with many scripts), you could be surprised when the script suddenly quits working because DreamHost changes it on you. wink

--rlparker

Re: can't load due to "." in my server path

Posted by: chunky
Posted on: 2007-10-08 05:01:00

I changed the server path using the CP. I changed the path from dev.neighborhoodschools.net to devneighborhoodschoolsnet

my db name is membership
localhost is membership.dev.neighborhoodschools.net (am i supposed to change this to...i don't know how)

i reran script and this is the error message...

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'membershipdevneighborhoodschoolsnet' (1) in /home/.fay/chunky/devneighborhoodschoolsnet/members/config.php on line 3

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /home/.fay/chunky/devneighborhoodschoolsnet/members/config.php on line 4

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/.fay/chunky/devneighborhoodschoolsnet/members/config.php on line 5

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.fay/chunky/devneighborhoodschoolsnet/members/config.php on line 5

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.fay/chunky/devneighborhoodschoolsnet/members/config.php on line 6

Warning: mysql_query() [function.mysql-query]: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) in /home/.fay/chunky/devneighborhoodschoolsnet/members/config.php on line 11

Warning: mysql_query() [function.mysql-query]: A link to the server could not be established in /home/.fay/chunky/devneighborhoodschoolsnet/members/config.php on line 11


ChunkyEdited by chunky on 10/08/07 05:02 AM (server time).

Re: can't load due to "." in my server path

Posted by: patricktan
Posted on: 2007-10-08 05:49:00

Please remove your real hostname and database name immediately first.

In reply to:

localhost is membership.dev.neighborhoodschools.net (am i supposed to change this to...i don't know how)


No you are not supposed to change that. This hostname must be same as the one you created in DH panel. Unfortunately your script can't read the dot. I don't think you can change the MySQL hostname. It must be something like xxx.domain.com

If I were you, I would look into the script and tried to modified the script to recognize dot.

Re: can't load due to "." in my server path

Posted by: rlparker
Posted on: 2007-10-08 06:41:00

In reply to:

I changed the server path using the CP. I changed the path from dev.neighborhoodschools.net to devneighborhoodschoolsnet


Well, that would get rid of the "dots", but I don't really think that would solve then problem, and shouldn't be necessary. If the script really can't handle "." in a path, then I'd get in contact with the script author and get that addressed. wink

In reply to:

my db name is membership
localhost is membership.dev.neighborhoodschools.net (am i supposed to change this to...i don't know how)


As Patricktan pointed out, you probably shouldn't publish that information. That said, you should not need to change your host name - it is in commonly acceptable form as it is.

In reply to:

i reran script and this is the error message...

Warning: mysql_connect() [function.mysql-connect]: Unknown MySQL server host 'membershipdevneighborhoodschoolsnet' (1) in /home/.fay/chunky/devneighborhoodschoolsnet/members/config.php on line 3 ... (etc)


That obviously made it worse; when yousay you "reran the script" did you "re-install it", or rerun the *install* script, or just rerun the main script itself? If you changed the path, and the host info, you would need to either reinstall the script or change the appropriate configuration files.

If it were me, I'd "clear everything out" and start over.

--rlparker

Re: can't load due to "." in my server path

Posted by: chunky
Posted on: 2007-10-08 07:16:00

well the software came with a number of files...including a php setup script...the files are placed in the main web dir. once you upload the files, you point your browser to the php script and then you fill out some info such as db name, localhost and then you submit.



Chunky

Re: can't load due to "." in my server path

Posted by: rlparker
Posted on: 2007-10-08 07:24:00

I see. That sounds like an install routine. Possibly the script checks for the presence of a valid config file and, if it finds it it runs the script, but if it doesn't, it goes into an install routine. This is a pretty common way of doing this.

Maybe if you review the instructions carefully you will find that if you delete (or rename) whatever file the application is using as the configuration file (to store that data you have to enter - db, hostname, etc.), when you run the script the install routine will run again?

--rlparker

Re: can't load due to "." in my server path

Posted by: chunky
Posted on: 2007-10-08 09:18:00

yes, if i delete the db. if i don't it say table already exists...thank you for your input and suggestions...i am going to work on it tonight...

Chunky

Re: can't load due to "." in my server path

Posted by: rlparker
Posted on: 2007-10-08 15:04:00

You are welcome, and Good Luck tonight! smile

--rlparker