MySQL problem

Ricardas

Hi, I am from some Lithuanian process consulting company (ITIL and ISO-9001 consultations), we see I-Doit as really good product which can be offered to our customers. But… We can't install it.

Every time I try to install (tried several versions of I-Doit, including SVN version downloaded today) I get an error:

bash-3.2# mysql -u demo_idoit -pdemo_idoit demo_idoit_mandator < ./idoit_v0.9.1_data.sql
ERROR 2013 (HY000) at line 9158: Lost connection to MySQL server during query

All the things go well with system db, but data db can not be imported.

System we use is as follows:
OpenBSD 4.0-stable
mysql Ver 14.12 Distrib 5.0.33, for unknown-openbsd4.1 (i386) using readline 4.3

Of course, I tried web install but it fails too. The worst thing is that MySQL server hangs after that and must be restarted…

npotthast

Does the import of mysql dumps work with other users? Did you check the user table for internal and external access on the mysql server?
What exactly does fail with the web install?

ds

Have you enabled InnoDB in your mysql config?

locate my.cnf
vi /etc/path.to/my.cnf

uncomment "#skip-innodb"
to
skip-innodb

otherwise you can take a look at your mysql timeout settings:
http://bugs.mysql.com/bug.php?id=1370

Ricardas

InnoDB is enabled, actually, all the databases use InnoDB by default. Tables are created by that user too, but when I tried to create them as root, nothing changes.

But I'll check that bug with MySQL timeout - it seems to me that problem is more likely in MySQL, simply I-DoIT somehow enables that

Thank you for your suggestions, I'll try and inform you about success

Ricardas

Seems that I was unable to find where the problem is located. But on the Ubuntu system with MySQL configured almost in the same way all works OK