
Hi, I am installing OTRS 2.1.2. I am trying to enable Debug mode while connecting to the database. I have set in Config.pm $Self->{Debug} = 3; But it has no effects. What should be set ? Regards. Eric Boudrand

I am installing OTRS 2.1.2. I am trying to enable Debug mode while connecting to the database. I have set in Config.pm $Self->{Debug} = 3; But it has no effects. What should be set ?
You should be set to "5". Of course, you have to create logfile in filesystem, and configure Config.pm. -- Valkai Jozsef +36 70 36 28 147 valkaij@externet.hu jvalkai@gmail.com lat:N 47° lon:E 19°

I am installing OTRS 2.1.2. I am trying to enable Debug mode while connecting to the database. I have set in Config.pm $Self->{Debug} = 3; But it has no effects. What should be set ?
You should be set to "5". Of course, you have to create logfile in filesystem, and configure Config.pm.
It outputs debug information in apache logs not in otrs logs as I expected. I did not find logs from Kernel::System::DB::connect() function. I have an issue while connecting to the database server : installer.pl: DBI connect('database=;host=localhost;','root',...) failed: Can't connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2) at /opt/otrs/bin/cgi-bin/../../Kernel/Modules/Installer.pm line 200 MySQL server is running and I can do query with mysql client. I can also use phpMyAdmin. Regards. Eric

Hi Eric, I don't know if I am right (not much experience), but I think so.... Eric Boudrand schrieb:
I am installing OTRS 2.1.2. I am trying to enable Debug mode while connecting to the database. I have set in Config.pm $Self->{Debug} = 3; But it has no effects. What should be set ? You should be set to "5". Of course, you have to create logfile in filesystem, and configure Config.pm.
It outputs debug information in apache logs not in otrs logs as I expected. I did not find logs from Kernel::System::DB::connect() function.
I have an issue while connecting to the database server : installer.pl: DBI connect('database=;host=localhost;','root',...) failed: Can't connect to local MySQL server through socket ''/var/run/mysqld/mysqld.sock'' (2) at /opt/otrs/bin/cgi-bin/../../Kernel/Modules/Installer.pm line 200
OTRS tries to establish a socket connect. Use the IP-way instead, e.g. define the IP your MySQL-DB is waiting for connections, e.g. 127.0.0.1 or IP the server has on the network
MySQL server is running and I can do query with mysql client. I can also use phpMyAdmin.
Try to etablish a socket connection with mysql-client - I think it won't work.
Regards.
Eric
Bye, ALex

Hi Alexander,
OTRS tries to establish a socket connect. Use the IP-way instead, e.g. define the IP your MySQL-DB is waiting for connections, e.g. 127.0.0.1 or IP the server has on the network
MySQL server is running and I can do query with mysql client. I can also use phpMyAdmin.
Try to etablish a socket connection with mysql-client - I think it won't work.
Thanks for the advices. I will try them. But, I have problems with my hard disk. I will change it first. I still have a question with debug mode. How can I increase logs in the log file I have set with $Self->{'LogModule::LogFile'} ? Adding $Self->{'Debug'} = 5; does not output logs in this file. Regards. Eric

I still have a question with debug mode. How can I increase logs in the log file I have set with $Self->{'LogModule::LogFile'} ? Adding $Self->{'Debug'} = 5; does not output logs in this file.
Did you make log file manually n the filesystem? Did you change the ownership? :) -- Valkai Jozsef +36 70 36 28 147 valkaij@externet.hu jvalkai@gmail.com lat:N 47° lon:E 19°

Hi,
I still have a question with debug mode. How can I increase logs in the log file I have set with $Self->{'LogModule::LogFile'} ? Adding $Self->{'Debug'} = 5; does not output logs in this file.
Did you make log file manually n the filesystem? Did you change the ownership? :)
The log file is normally filled; but, with no debug logs inside. I can only find debug logs in apache log files. In DBI.pm, I have manually increased debug level by setting $Debug variable. Then the OTRS log file is correctly filled. Regards. Eric Boudrand
participants (3)
-
Alexander Scholler
-
Eric Boudrand
-
Jozsef Valkai