Christian Schoepplein wrote:
Hi Danie,
On Thu, Aug 04, 2005 at 10:31:01AM +0200, Danie Theron wrote:
Christian Schoepplein wrote:
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.
I checked to see if I actually have mysql.sock on my system , and it
seems I didn't start mysqld as 'root' , restarted as 'root' and there it
was (mysql.sock) although not in the same location as stated in the
Config.pm (it was in /var/lib/mysql/mysql.sock) , so changed it
accordingly.But....
OK, first of all, check if the connection is working at all. Execute the
following command:
mysql -p hot -u otrs -h localhost
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 3.23.58
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql>
OK so it looks like I can connect to my MySQL
Yes.
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};";
So I followed the FAQ (below) and added the (edited to correspond to my
mysql.sock) line :
$Self->{DatabaseDSN}="DBI:mysql:otrs;hostname=localhost;mysql_socket=/var/lib/mysqld/mysqld.sock";
I then restart otrs (/etc/init.d/otrs restart :
Checking database connect... DBI
connect('otrs;hostname=localhost;mysql_socket=/var/lib/mysqld/mysqld.sock','otrs',...)
failed: Can't connect to local MySQL server through socket
'/var/lib/mysqld/mysqld.sock' (2) at /opt/otrs/Kernel/System/DB.pm line 191
ERROR: OTRS-CheckDB-10 Perl: 5.8.5 OS: linux Time: Thu Aug 4 10:26:47 2005
Message: Can't connect to local MySQL server through socket
'/var/lib/mysqld/mysqld.sock' (2)
Traceback (13914):
Module: Kernel::System::DB::new (v1.44) Line: 168
Module: /opt/otrs/bin/CheckDB.pl (v1.12) Line: 47
I am quite baffled (and frustrated) by this , so any help would be
hugely appreciated.
Please try the following:
1. Open the file Kernel/Config.pm and change
$Self->{'SecureMode'} = 1;
to
$Self->{'SecureMode'} = 0;
2. Delete your otrs database manualy. Type on a linux shell:
mysql -p -u root -h localhost
If you are loged in, execute the following SQL statement (only if
your otrs database is new and not yet used!!!!).
DROP DATABASE otrs;
You should see a message abuot the deleted database.
3. Call the web installer:
http://your.otrs.host/otrs/installer.pl
OK , everything went fine , untill I called the install script from my
web interface :
Warning: Kernel/Config.pm isn't writable!
Comment: If you want to use the installer, set the Kernel/Config.pm
writable for the werserver user! Can't open /opt/otrs/Kernel/Config.pm:
Permission denied
check my permissions:
-rwxrwxr-x 1 apache apache 4671 Aug 4 10:26 Config.pm
-rw-rw-r-- 1 apache apache 3918 Aug 1 14:06 Config.pm.dist
drwxrwxr-x 11 apache apache 4096 Aug 3 11:54 cpan-lib
-rw-r--r-- 1 root root 0 Aug 3 16:45 {DatabaseDSN}
drwxrwxr-x 2 apache apache 4096 Aug 3 11:54 Language
-rw-rw-r-- 1 apache apache 12247 Aug 1 14:06 Language.pm
drwxrwxr-x 2 apache apache 4096 Aug 3 11:54 Modules
drwxrwxr-x 3 apache apache 4096 Aug 3 11:54 Output
drwxrwxr-x 18 apache apache 4096 Aug 3 11:54 System
Once again I am stunned..... :(
Sorry if I sound like a newbie , but as you can see everything seems ok
, yet it is not...
TIA
4. Follow the steps in the installer.
Normaly the installer configures the database correctly... If there are
problems with mysql for example, the installation woud not finish.
Best regards,
Christian
------------------------------------------------------------------------
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
--
Regards ,
@-----------------------------@
| Danie Theron |
| Network Administrator |
| Verpakt Management Services |
| email : [EMAIL PROTECTED] |
| tel : +2711 6020117 |
@-----------------------------@
If you dislike change, you're going to dislike being irrelevant even more.
Only two things are infinite, the universe and human stupidity, and I'm
not sure about the former.
"Time is an illusion. Lunchtime double so." (Douglas Adams.)
------------------------------------------------------------------------------------------------------------------------------------------
The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. Any review, retransmission, dissemination or other use of, or
taking of any action in reliance upon, this information by persons or
entities other than the intended recipient is prohibited. If you
received this in error, please contact the sender and delete the
material from any computer.
------------------------------------------------------------------------------------------------------------------------------------------
_______________________________________________
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
Support oder Consulting für Ihr OTRS System?
=> http://www.otrs.de/
