Error at connect to Mysql database

oliverbasa · February 2, 2005, 12:13am

Hi,

I'm using Wampserver and tried to install the newest Mysource Matrix.

I'm getting the following error messages:

My setting:

database location: localhost

user: root

passw: *****

after that I set the database name that i created before in Phpmyadmin.

at this point i got error message.

Sorry for the bad english, please HELP me!

Marc_Mcintyre · February 2, 2005, 12:16am

Matrix currently does not support PHP 5. You might want to try using the latest 4.x.x build. We also suggest using PostgreSQL instead of mysql as later versions of Matrix will not work with mysql.

oliverbasa · February 2, 2005, 12:20am

Thanks for your fast answer!

oliverbasa · February 2, 2005, 8:58pm

Hi there,

I still have problem with the installation.

When the installer trying to create the tables of the database, I got the following error message:

[quote]MySource Error

DB Error: connect failed[/quote]

I'm using XAMPP 1.4.11 (Apache 2.0 server with Php 4.3.1 and Mysql 4.1.8)

Please help me what I did wrong.

oliverbasa · February 2, 2005, 9:37pm

I created a new user and password for the Mysql, and now I have a new kind of error message:

[quote]MySource Error

DB Error: no database selected

ROLLBACK [nativecode=2006 ** MySQL server has gone away]

MYSQL TABLE TYPE SET[/quote]

Help please!

oliverbasa · February 4, 2005, 12:30am

Any idea?

Marcus_Nyeholt · February 4, 2005, 2:24am

What version of matrix are you installing? 3.3.1 beta requires Postgresql, and won't install on MySQL

oliverbasa · February 4, 2005, 12:58pm

I'm using the 3.2.1 version.

Marcus_Nyeholt · February 6, 2005, 9:44pm

What happens if you have a simple PHP script that does mysql_connect(‘host’, ‘user’,‘pass’) ? That error appears to be due to a timeout of some sort, but I’m not sure what would cause it.

http://sunsite.mff.cuni.cz/MIRRORS/ftp.mysql.com/doc/en/Gone_away.html

Luke_Wright · February 6, 2005, 9:52pm

Before people point it out, the PHP version in XAMPP would be 4.3.10 (I checked), so there would be no PHP versioning problems there.

Basically that "server has gone away" error says that MySQL is closing the connection before the queries are being sent from PHP - it could well be as much a problem in the MySQL configuration; I'm not sure where though.

Edit: Jinx. Try Marcus' test out though, and let us know.