Community

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

    Cannt connect to database after install 0.91

    Operating
    3
    8
    3280
    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.
    • D
      dobby last edited by

      I have installed 0.91 on a sles10.

      Now my problem. After installing i-doit, i see the entry username and password in config.inc.php. but with these credentials, i cannot connect to the database: Here the error:

      isys_exception_database : Query error: 'SHOW TABLES LIKE 'isys_registry';': (Extended Information: NULL)

      If I change the username to my mysql root and the password to the rootpassword it connects to the database and i see the login screen. The problem then is, that i cant login with admin/admin an other thing is, that infront of the username i-doit writes:
      LC__LOGIN__USERNAME:
      LC__LOGIN__PASSWORD;

      any hints howto fix this problem?

      1 Reply Last reply Reply Quote 0
      • D
        dobby last edited by

        Habe das Problem gelöst.

        Bei der Installation auf einem SLES wird kein i-doit account in der DB erstellt. Dies muss von hand getan werden. Zudem braucht man suf dem tmp im i-doit verzeichniss auch schreibrechte. Dann funzt es einwandfrei.

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

          Für die Schreibrechte gibt es auch extra ein Skript, welches man ausführen kann. Das liegt mit im root und heisst 'idoit-rights.sh'.

          Erscheinen irgendwelche Fehlermeldungen zu dem Problem, dass der i-doit User nicht installiert wird?

          MfG,
          Niclas Potthast

          1 Reply Last reply Reply Quote 0
          • E
            elcarni last edited by

            //EDIT
            sorry, i forgot i was in the english forum…
            well my question was: in which database table can i create new users?

            in welche tabelle erstellt man neue konten?
            hab dasselbe problem, weiß aber nicht wo ich ein konto erstellen kann

            1 Reply Last reply Reply Quote 0
            • E
              elcarni last edited by

              found it

              http://doc.i-doit.org/wiki/FAQ#How_do_I_create_new_users_using_my_database.3F

              now i have created a new username and made the relation to the group table as shown in the faq, but i still cannot log in successfully

              any suggestions?

              1 Reply Last reply Reply Quote 0
              • D
                dobby last edited by

                You don't have a user in your mysql db.

                Connect to mysql

                INSERT INTO user (host, user, password, select_priv, insert_priv, update_priv) VALUES ('localhost', 'i-doit' PASSWORD('mypass'), 'Y', 'Y', 'Y');

                1 Reply Last reply Reply Quote 0
                • E
                  elcarni last edited by

                  there is no table named user, could you exactly explain how you get it to work?

                  thx!

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

                    The 'user' table is not in the 'i-doit' database but in the 'mysql' database. Try USE mysql before INSERT INTO user.

                    MfG,
                    Niclas Potthast

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