Warning: Failed to Connect in db_mysql.php on line 128

[Martin]

Setting up tables...

Setting up bb codes...
Warning: Failed to Connect in db_mysql.php on line 128


huh?

please help?

[Edited by Martin on 05-06-2000 at 11:35 PM]

[Martin]

just d/l'd the latest 1.1.1 (not the dev) to my server.

server:
Dual PIII 600
512Mb
WinNT 4.0
IIS 4.0

Proggies:
PHP 4.0 RC1 with Zend (as CGI)
mySQL 3.22.34 shareware for NT

that about covers everything, I guess

[Martin]

I dumped the DB and tried installing 1.1.0 and got stopeed at the exact same place with the exact same message.

any ideas?

[Martin]

okay, I upgraded to mySQL 3.23.14 and stil the same thing...

next step, I guess, is to try downgrading to PHP 3?

[Martin]

I downgraded to PHP 3.0.16 and going to step 3 I got:


Fatal error: Call to unsupported or undefined function mysql_pconnect() in db_mysql.php on line 29


does *anyone* have an idea that might help out here?

[vbsquare]

I know absolutly jack about mySQL and PHP but from what I might be able to remember from a previous post is that you need to change mySQL_pConnect() to mySQL_connect()

[John]

The failed to connect message appearing is not directly due to MySQL, but instead it is trying to send an email, and failing to connect to the SMTP server.

When an error like that occurs, and you do not have email set up on the server, view the source of that page. Embedded in the source will be the MySQL error. Post that, and then I will see if I can figure out what is wrong.

vbsquare is correct about that pconnect problem. Make sure that you have enabled MySQL support in the php.ini file.

Thanks,
John

[vbsquare]

My goodness! I actually got something correct with two things I know nothing about. Oh well, must be my day...

[Martin]

mysql error: Table '.\forum\bbcode' is read only
mysql error number: 1036

[Martin]

it seems that *all* my databases are "read only"

I follwed the install instructions and with a little help from Herb got it running. I didn't do anything out of the ordinary. Anyone have any ideas?

[John]

You must be running MySQL on NT - this is a file permissions problem I think. I have no experience of NT, but I'm going to make a guess that if you set the database files to be public writable then it should work. Find the directory that you installed MySQL into (ususally c:\mysql) and then find the data subdirectory. In this data dir, there will be a separate directory for each database. Find the one for the forums database, and change the properties for all the files in the directory to not read-only.

John

[Martin]

I installed mySQL 3.22.14 for NT (NT 4/SP6 running IIS 4.0) successfully but it set up all the tables in all the databases as "read only", so I thought I would try a fresh install. I uninstalled it thru the "add/remove" dialog and reinstalled, not so successfully.

When I tried to install the deamon,
mysqld --install
it wouldn't let me, so I thought the deamon might still be in memory so I did a
mysqld --remove
and rebooted.
When the server came back up I went back to the bin and tried again. Still no joy. Same error message.


a system error has occured

System Error 1067 has occured

the process has been terminated unexpectedly


Can anyone *please* tell me wtf is going on???

[Martin]

the my-example.cnf file that comes with mySQL for NT is corrupt.

I retyped it, by hand, correctly, and uploaded. Now forums are converting :)

I have run into 1 problem, though. It seems to have a helluva time with large forums. I have 1 that was 1.28 mb and it wouldn't take it.

I took it out of the folder and put it to the side to try later. I also moved the 2.47 mb one out of the line, too...