Cannt connect to database after install 0.91
-
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?
-
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.
-
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?
-
//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 -
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?
-
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');
-
there is no table named user, could you exactly explain how you get it to work?
thx!
-
The 'user' table is not in the 'i-doit' database but in the 'mysql' database. Try USE mysql before INSERT INTO user.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login