If you are not registered or logged in, you may still use these forums but with limited features. Show recent topics
  [Search] Search   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [FAQ]  FAQ 
[Register] Register / 
[Login] Login 
AdvancedGuestbook on GoDaddy servers  XML
Forum Index » Support Forum
Author Message
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??
[WWW] aim icon
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
[WWW] [Yahoo!] aim icon [MSN]
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
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
[WWW] [Yahoo!] aim icon [MSN]
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
[WWW] aim icon
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
[WWW] [Yahoo!] aim icon [MSN]
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.
[WWW] aim icon
 
Forum Index » Support Forum
Go to:   
Based on the open source JForum