Unable to connect to database : Check the connection script.

Wayne McBryde · 10-27-2003, 07:51 PM

Trying to install on a Cobalt RAQ4 server, Linux 2.2, PHP 4.1.2-3, MySQL 3.23.54-1, phpMyAdmin 2.2.6.

I managed to install the database and tables using the manual install outlined in the instructions. When I enter domain.com/phpdig/index.php I get “Unable to connect to database : Check the connection script”.

Using phpMyAdmin, I can verify the database and tables are there.

Using Shell, I can enter “SHOW DATABASES” and the database is there. “SHOW TABLES” verifies the tables are there. I do this using the same user id / P/W that is setup in phpdig files “connect.php” and “config.php”.

Please help! I would really like to get this working.

Thanks

Charter · 10-28-2003, 08:08 PM

Hi. Did you add a prefix to the tables?

Wayne McBryde · 10-29-2003, 06:24 AM

no prefix. the files are in a folder called "phpdig" in the root of the web.

Other thoughts:
1, I uploaded the files with Microsoft FrontPage. Could this be a problem? I am planning to retry the install using wsftp later today. I will post the results of this approach.

2, I need to be able to index 1000 to 2000 web sites. Will this be a problem?

Thanks

k1k · 11-02-2003, 04:02 PM

I have exacly the same problem. After trying to install, i can't go back to instll.php- no connection to database-

is perhaps the open_basedir in the server configuration the point of problem ?

Wayne McBryde · 11-03-2003, 06:49 AM

More info here:
http://phpdig.net/showthread.php?s=&threadid=190

jive · 11-03-2003, 08:26 PM

linux file permissions are called chmod. I was getting the same error and I fixed it by chmoding my connect.php file and the includes folder to 777. Works like a charm now. Perhaps the phpdig guys should mention these permissions in the documentation section.

druesome · 11-04-2003, 10:03 AM

In all fairness, it does say in the documentation:

...set the file permissions to writable on the following directories, for the suid Apache server is running :

[PHPDIG_DIR]/text_content
[PHPDIG_DIR]/include
[PHPDIG_DIR]/admin/temp

-----------

Setting a file or folder to writable means to CHMOD it to 777. But I think it would be a better idea to mention the CHMOD 777 in the document to prevent anyone from overlooking it.

CHMOD 777 will allow you to 'write' into the connect.php script the required information to connect to your database. If it is not 'writable', then basically your install script will fail, and no information will help you connect to your SQL database.

k1k · 11-04-2003, 12:08 PM

i solved this problem by upload the files to the root directory. the installation works fine.

10-27-2003, 07:51 PM	#1
Wayne McBryde Orange Mole Join Date: Oct 2003 Location: NC, USA Posts: 34	Unable to connect to database : Check the connection script. Trying to install on a Cobalt RAQ4 server, Linux 2.2, PHP 4.1.2-3, MySQL 3.23.54-1, phpMyAdmin 2.2.6. I managed to install the database and tables using the manual install outlined in the instructions. When I enter domain.com/phpdig/index.php I get “Unable to connect to database : Check the connection script”. Using phpMyAdmin, I can verify the database and tables are there. Using Shell, I can enter “SHOW DATABASES” and the database is there. “SHOW TABLES” verifies the tables are there. I do this using the same user id / P/W that is setup in phpdig files “connect.php” and “config.php”. Please help! I would really like to get this working. Thanks __________________ Wayne Mcbryde http://LakeNormansWeb.com We search all of Lake Norman!

10-28-2003, 08:08 PM	#2
Charter Head Mole Join Date: May 2003 Posts: 2,539	Hi. Did you add a prefix to the tables? __________________ Responses are offered on a voluntary if/as time is available basis, no guarantees. Double posting or bumping threads will not get your question answered any faster. No support via PM or email, responses not guaranteed. Thank you for your comprehension.

10-29-2003, 06:24 AM	#3
Wayne McBryde Orange Mole Join Date: Oct 2003 Location: NC, USA Posts: 34	no prefix. the files are in a folder called "phpdig" in the root of the web. Other thoughts: 1, I uploaded the files with Microsoft FrontPage. Could this be a problem? I am planning to retry the install using wsftp later today. I will post the results of this approach. 2, I need to be able to index 1000 to 2000 web sites. Will this be a problem? Thanks __________________ Wayne Mcbryde http://LakeNormansWeb.com We search all of Lake Norman!

11-02-2003, 04:02 PM	#4
k1k Green Mole Join Date: Oct 2003 Posts: 2	this is not a singel problem I have exacly the same problem. After trying to install, i can't go back to instll.php- no connection to database- is perhaps the open_basedir in the server configuration the point of problem ?

11-03-2003, 06:49 AM	#5
Wayne McBryde Orange Mole Join Date: Oct 2003 Location: NC, USA Posts: 34	More info here: http://phpdig.net/showthread.php?s=&threadid=190 __________________ Wayne Mcbryde http://LakeNormansWeb.com We search all of Lake Norman!

11-03-2003, 08:26 PM	#6
jive Green Mole Join Date: Oct 2003 Posts: 8	linux file permissions are called chmod. I was getting the same error and I fixed it by chmoding my connect.php file and the includes folder to 777. Works like a charm now. Perhaps the phpdig guys should mention these permissions in the documentation section.

11-04-2003, 10:03 AM	#7
druesome Orange Mole Join Date: Oct 2003 Posts: 30	In all fairness, it does say in the documentation: ...set the file permissions to writable on the following directories, for the suid Apache server is running : [PHPDIG_DIR]/text_content [PHPDIG_DIR]/include [PHPDIG_DIR]/admin/temp ----------- Setting a file or folder to writable means to CHMOD it to 777. But I think it would be a better idea to mention the CHMOD 777 in the document to prevent anyone from overlooking it. CHMOD 777 will allow you to 'write' into the connect.php script the required information to connect to your database. If it is not 'writable', then basically your install script will fail, and no information will help you connect to your SQL database.

11-04-2003, 12:08 PM	#8
k1k Green Mole Join Date: Oct 2003 Posts: 2	problem-can't connect to database i solved this problem by upload the files to the root directory. the installation works fine.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Can't connect to Database	liquidice	Script Installation	16	01-17-2005 12:17 AM
Unable to connect to database : Check the connection script.	marb	Troubleshooting	5	04-12-2004 03:35 AM
Unable to connect to database : Check the connection script.	Nosmada	Troubleshooting	2	02-27-2004 09:15 AM
Check box from spider.php	adtphpDig	External Binaries	3	02-05-2004 12:00 PM
Updated to 1.8.0 - unable to connect to database	rafarspd	Script Installation	2	01-22-2004 04:39 AM