HostOnNet Blog

OTRS check if DB connections are ok


Can check if DB connections are setup properly.

root@cloud1:/opt/otrs# /opt/otrs/bin/
Trying to connect to database
DSN: DBI:mysql:database=otrs;host=
DatabaseUser: otrs

Connection successful, but no initial inserts are found!

On the installation, we have an error

but no initial inserts are found!

This is because user table is empty.

root@cloud1:/opt/otrs# mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 380
Server version: 5.5.37-0ubuntu0.12.10.1 (Ubuntu)</code>

Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> select * from otrs.users;
Empty set (0.00 sec)


Posted in Installation