|
10-27-2003, 07:51 PM | #1 |
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 |
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 |
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 |
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 |
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 |
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 |
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 |
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.
|
Thread Tools | |
|
|
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 |