Community

    • Register
    • Login
    • Search
    • Categories
    • Recent
    • Popular
    • Users
    • Search

    MySQL problem

    Operating
    3
    5
    2677
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • R
      Ricardas last edited by

      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…

      1 Reply Last reply Reply Quote 0
      • N
        npotthast last edited by

        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?

        MfG,
        Niclas Potthast

        1 Reply Last reply Reply Quote 0
        • ds
          ds last edited by

          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

          1 Reply Last reply Reply Quote 0
          • R
            Ricardas last edited by

            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 🙂

            1 Reply Last reply Reply Quote 0
            • R
              Ricardas last edited by

              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 😕

              1 Reply Last reply Reply Quote 0
              • First post
                Last post