Hi Danie, On Wed, Aug 03, 2005 at 02:32:08PM +0200, Danie Theron wrote:
Ok finally got the Config.pm file setup (correctly I hope:P) , getting the following error when trying to connect to the interface:
Error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' ([..]
Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time: Wed Aug 3 14:23:59 2005
Message: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13)
Traceback (11236): Module: Kernel::System::DB::new (v1.44) Line: 168 Module: Kernel::System::Web::InterfaceAgent::Run (v1.7) Line: 150 Module: ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler (v) Line: 48 Module: (eval) (v1.80) Line: 202 Module: ModPerl::RegistryCooker::run (v1.80) Line: 202 Module: ModPerl::RegistryCooker::default_handler (v1.80) Line: 168 Module: ModPerl::Registry::handler (v1.99) Line: 30
The traceback is totally unfamiliar ground for me , so any help would be appreciated.
You can connect to a mysql server either via a socket (a special file in your file system) or TCP/IP (like a connection via a network). If OTRS and the mysql DB are installed on the same machine and a connection via a mysql socket is possible, you should use this type of connection, because its faster than TCP/IP. OK, first of all, check if the connection is working at all. Execute the following command: mysql -p hot -u otrs -h localhost You should be able to log in to your mysql server, if ervery thing works fine.
# DatabaseDSN # (The database DSN for MySQL ==> more: "man DBD::mysql") $Self->{DatabaseDSN} = "DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";
Thats the connection string for your database. TWith this setting you connect via TCP/IP to your mysql server. See http://portal.otrs.de/otrs/public.pl?Action=&FAQID=38 if you like to connect through a socket. But first of all you have to check, which kind of connection your mysql server accepts. Regards, Christian -- ((otrs)) :: OTRS GmbH :: Norsk-Data-Str. 1 :: 61352 Bad Homburg http://www.otrs.de/ :: Manage your communication!