Znuny Open Source Ticketsystem

crythias wrote:This means the otrs database Creds are invalid for MySQL connection.

What is your advice in this case ?

Hi, can you insert the database .sql scripts manually? it is described in /opt/otrs/README.database Florian I've followed the instructions in /opt/otrs/README.database file. Run below commands by login as mysql root user: mysql> mysql -u root -p -e 'create database otrs charset utf8' -> mysql -u ro...

RStraub wrote:otrs3 is the user and db that I created (pw is 123456).

The Config.pm doesn't seem to be misconfigured. I'm sorry but debugging will become really hard without mysql access.

I've removed these user accounts now and re-attempted. But again error.

RStraub wrote:Same here, cannot login.

Could you post your Config.pm please (esp. the part about the database connection)?

And black out your password

Config.pm uploaded to below url. Please check it.

http://198.27.105.229/Config.pm.txt

Can anyone try the install ? This is a test VPS, so it won't be a problem.

http://198.27.105.229/otrs/installer.pl

MySQL User: root
Password: 123456

I tried to install again, with a new database name. Everything is completed with out errors, still user not found.

jojo wrote:you should have a error in the installer or if you are installing manually you left out a part

Hi Jojo, actually I skipped the email configuration part (plz see the below image) in that installation process. Other steps were successful.

When I run the command, it says:

root@cloud1:~# service otrs stop
otrs: unrecognized service
root@cloud1:~#

I've reattempted the installation again today.

All steps were successful and I thoroughly watched it. Got the login url, username and password in the installation final page. But login landed with error

Don't know whats wrong.

Here is the output of 'users' table:

mysql> SELECT * FROM users;
Empty set (0.01 sec)

mysql>

I am using index.tpl only for login.

Yes, finised the installation steps and finally I got the login url, username and password. Please see the screenshot of the final page at

In otrs db, 91 tables found total.

The table 'customer_user' shows as:

mysql> SELECT * FROM customer_user;
Empty set (0.00 sec)

mysql>

Do you want me to check any other table ?

Giulio Soleni, Thanks for your update. I tried the steps you mentionedm but I am still getting login error. In your Step 1 you told, '$Self->{SecureMode} = '0';' not found in Config.pm file, I added that line into the file and then cleaned the mysql db and used the installer.pl file and installed ag...

Yes, its a fresh installation.

I've followed the instructions from tutorial and done it.

I have installed OTRS on my ubuntu 12.10 server and it doesn't allow me to login. I am getting following error in error log: The error > Message: No UserID found for 'root@localhost'! mysql> select * from users; Empty set (0.00 sec) mysql> No users in table. Detailed error log at http://198.27.105.2...