Table 'otrs.users' doesn't exist

[pmn]

Hi,

I was able to install otrs 4 on opensuse 12.1 and at the final step 4 was given a password for the root@localhost. (fresh installation)
But cannot log in to the index.pl with the root@localhost with the given password.

when i see the otrs log file it says

[Kernel::System::User::UserSearch][660] Table 'otrs.users' doesn't exist, SQL: 'SELECT id, login FROM users WHERE (login) LIKE ? AND valid_id IN (1)'

I even tried changing the password using /opt/otrs/bin/otrs.SetPassword.pl root@localhost <newpassword>

for this also it throws the above error,

what could be the issue , any insight appreciated

Thank you

[pab]

Hi,

Have you looked into the database? Does otrs.users exist?
What does the web servers log say?

[pmn]

Hi ,

when i run perl /opt/otrs/bin/otrs.CheckDB.pl i get

Trying to connect to database
DSN : DBI:mysql:database=otrs;host=127.0.0.1
DatabaseUser: root

[Fri Jun 12 10:12:59 2015] otrs.CheckDB.pl: DBD::mysql::st execute failed: Table 'otrs.valid' doesn't exist at /opt/otrs/Kernel/System/DB.pm line 629.
ERROR: OTRS-otrs.CheckDB.pl-08 Perl: 5.14.2 OS: linux Time: Fri Jun 12 10:12:59 2015

Message: Table 'otrs.valid' doesn't exist, SQL: 'SELECT * FROM valid'

Traceback (10229):
Module: /opt/otrs/bin/otrs.CheckDB.pl Line: 53

[Fri Jun 12 10:12:59 2015] otrs.CheckDB.pl: DBD::mysql::st fetchrow_array failed: fetch() without execute() at /opt/otrs/Kernel/System/DB.pm line 696.
Connection successful, but no initial inserts are found!

Also i cannot see the otrs datase tables when i use show tables in my sql console .

[root]

What does this command shows?

Code: Select all

mysql -e "SHOW TABLES;" -u otrs -pDATABASEPASSWORD otrs

[pmn]

hi

i deleted the /otrs folder under mysql and ran the installer again and was able to log with root@localhost
Now i cannot run the cron jobs as i cannot login with otrs user with the password provided in the interface.

otrs error log says "No UserID found for 'otrs"

But i can see the otrs user and password in Config.pm

when i run Select * from otrs.user in mysql console i only see the record for root@localhost

do i need to manually add otrs user to otrs.user database ? I thought the user is automatically added when running the web interface

if so what is the syntax

Thanks

[root]

I strongly recommend to study the mysql manual. If your table where create a InnoDB tables and you don't have set innodb_file_per_table in server config your data is still in the InnoDB data file. Next time just use a 'DROP database orts' to delete the database.

[pmn]

Thanks for the reply

I did drop database otrs ; but did not move innodb files when running the installer again.
Is there any fix at this stage to add the otrs user to the user table ?

[jojo]

the user otrs is a database user, not a OTRS user. Please don't mix up these two.

[pmn]

Is there anything i can do to add this otrs database user to the users table in order to run the cron jobs and move forward.

[jojo]

you don't need a database user otrs to run cron jobs as this is done by a unix user.
Please follow the installatiin guidelines and consult your linux and database admins for support.