Author |
Message |
03/07/2005 22:37:19
|
Jellocat
Newbie
Joined: 03/07/2005 22:29:43
Messages: 3
Location: Atlanta
Offline
|
I'm having a MAJOR problem getting this to work. I am a newbie, completely, when it comes to PHP and SQL stuff, so please pardon me if I'm not doing things correctly.
I've read through the forum and d/led the install manual. I u/led all files to the server via FTP. I typed in the appropriate path for install, got the install screen and from there nothing seems to work.
I contacted GoDaddy to find out what they have. There is SQL and PHP on their servers, host name is: mysql47.secureserver.net (though I'm not sure if the tech guy I spoke with understood what I was asking for). I changed the necessary things in the config file to match the host name, etc. and nothing worked.
So I went back and used what the manual instructed: test for db name, localhost, root and got this:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/m/i/r/miraculous/html/guestbook/install.php on line 242
Cannot connect to database
MySQL Error : Cannot connect to database
Error Number: 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Date : Sun, July 3, 2005 13:34:26
IP : 24.92.149.3
Browser : Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7. Gecko/20050511 Firefox/1.0.4 (ax)
Referer : http://www.miraculoushands.com/guestbook/install.php
PHP Version : 4.3.11
OS : Linux
Server : Apache/1.3.31 (Unix) mod_tsunami/2.0 FrontPage/5.0.2.2634 mod_ssl/2.8.19 OpenSSL/0.9.7a
Server Name : www.miraculoushands.com
Now, through GoDaddy you can set up a DB and use their Open Manager to set up everything but I haven't a clue as to what I'm doing with SQL so I left it as is. I honestly don't know how to make this work. Any ideas??
|
|
03/07/2005 22:51:55
|
JTD
Graduate
Joined: 08/05/2004 21:52:50
Messages: 529
Location: Arkansas
Offline
|
This is what your config.php should look like. Plus you also have to create a database first.
|
LINK-> Use Lazarus Guestbook |
|
04/07/2005 01:56:12
|
Anonymous
|
How do you create the database first? When I use Go Daddy's system and then use the database name for the guestbook it gives me, pretty much, the same error.
It didn't work. I've tried every combination. For the configuration of (the proper names are in the original, but for security's sake in this msg I left it as username and my password):
$GB_DB["dbName"] = "guests";
$GB_DB["host"] = "localhost";
$GB_DB["user"] = "username";
$GB_DB["pass"] = "my password";
For this configuration I got this msg:
Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/content/m/i/r/miraculous/html/guestbook/install.php on line 242
Cannot connect to database
MySQL Error : Cannot connect to database
Error Number: 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Date : Sun, July 3, 2005 16:50:39
IP : 24.92.149.3
Browser : Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7. Gecko/20050511 Firefox/1.0.4 (ax)
Referer : http://www.miraculoushands.com/guestbook/install.php
PHP Version : 4.3.11
OS : Linux
Server : Apache/1.3.31 (Unix) mod_tsunami/2.0 FrontPage/5.0.2.2634 mod_ssl/2.8.19 OpenSSL/0.9.7a
Server Name : www.miraculoushands.com
|
|
04/07/2005 02:08:16
|
JTD
Graduate
Joined: 08/05/2004 21:52:50
Messages: 529
Location: Arkansas
Offline
|
If you have cpanel with godaddy you do it in there. It should look something like this.
|
LINK-> Use Lazarus Guestbook |
|
04/07/2005 02:09:17
|
Jellocat
Newbie
Joined: 03/07/2005 22:29:43
Messages: 3
Location: Atlanta
Offline
|
When I use the following configuration I get this error response. I set up the database "miraculous" through Go Daddy's database set up thing which consists of:
Create New Database
Credits Available: 9 MySQL 0 MS SQL
MySQL Database: miraculous
UserName: ""
Password: ""
Confirm Password: ""
Each database I create lies on different servers. The first one has the host name of: mysql47.secureserver.net, the second has mysql55.secureserver.net. Do I use these servers instead of "localhost"?
Also, after the database is created, there's a link to the Open Manager to set up the database. It begins with setting up the tables:
Create new table on database miraculous :
Name :
Fields :
But I thought the guestbook program, itself, set up these parameters. I'm not a database person so I don't know what to do with this stuff.
I still get the following error after running the guestbook install program when I name the database in $GB_DB["dbName"] with what I set up in Go Daddy:
Cannot create new database: miraculous
--------------------------------------------------------------------------------
MySQL Error : Cannot create new database: miraculous
Error Number: 1007 Can't create database 'miraculous'. Database exists
Date : Sun, July 3, 2005 17:02:50
IP : 24.92.149.3
Browser : Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)
Referer : http://www.miraculoushands.com/guestbook/install.php
PHP Version : 4.3.11
OS : Linux
Server : Apache/1.3.31 (Unix) mod_tsunami/2.0 FrontPage/5.0.2.2634 mod_ssl/2.8.19 OpenSSL/0.9.7a
Server Name : www.miraculoushands.com
|
|
04/07/2005 02:11:12
|
JTD
Graduate
Joined: 08/05/2004 21:52:50
Messages: 529
Location: Arkansas
Offline
|
You might want to ask godaddy. Most servers just use localhost.
|
LINK-> Use Lazarus Guestbook |
|
04/07/2005 02:30:27
|
Jellocat
Newbie
Joined: 03/07/2005 22:29:43
Messages: 3
Location: Atlanta
Offline
|
None of this is working. Thanks for your help. I need to find something else. Either Go Daddy is a lousy service to use with php/mysql, or the program is searching for something that doesn't exist.
|
|
|