Hi

As far as I know this error is not related to mysql.Syslog is a standard for forwarding log messages in to an internet protocol comuter system (guyes please correct me if I am wrong).Hope you will get the some hint for your problem  on the link http://wiki.bestpractical.com/view/NoConnectionToSyslog


Regards
Sourabh Sarwate


On Thu, Feb 11, 2010 at 4:34 PM, Deniz Rende <deniz.rende@gmail.com> wrote:
Does anybody know if the errors above are mysql related or is there something else going on?

Did anybody successfully install the latest otrs on solaris 10 zone before? If so what database did you use? 

Anybody out there have any idea what's going on with the error?

no connection to syslog available
- unix dgram connect: Socket operation on non-socket at ../..//Kernel/System/Log/SysLog.pm line 63



On Wed, Feb 10, 2010 at 6:08 PM, Deniz Rende <deniz.rende@gmail.com> wrote:
Hi Leonardo,

I do have Config.pm files in the following locations:

/opt/otrs/Kernel/Config.pm.dist
/opt/otrs/Kernel/Config.pm
/opt/otrs/Kernel/System/Config.pm
/opt/otrs/Kernel/Modules/AdminSysConfig.pm

I also have syslog enabled in the zone:

root@zotrs# svcs -a | grep system-log
online         14:38:47 svc:/system/system-log:default

I commented out
$Self->{'LogModule'} = 'Kernel::System::Log::SysLog';
in /opt/otrs/Kernel/Config.pm and restarted the server instance, but I did not have any luck.

I am not sure what I am missing here..


On Wed, Feb 10, 2010 at 3:56 PM, Leonardo Certuche <leonardo.certuche@itcon-ltda.com> wrote:
Hi,

Just shooting in the dark here:

Syslog is not the only option to store OTRS logs, at the point you reached, I guess you already have a Config.pm file, have you checked it? mine looks like this and I'm using syslog, I guess if you don't have syslog enabled on your box, you could get rid of the second line and then run again installer.pl to see what happens

   $Self->{'LogModule::LogFile'} = '/tmp/otrs.log';
   $Self->{'LogModule'} = 'Kernel::System::Log::SysLog';

Hope it helps,

Leonardo Certuche


On Wed, Feb 10, 2010 at 4:11 PM, Deniz Rende <deniz.rende@gmail.com> wrote:
Hi Folks,

I installed otrs on a Solaris 10 x86 zone with ActivePerl 5.10 solaris pkg. The installation went smoothly and I was able to set up mysql database through gui. At the end of the 4'th step, when I try to go to the link provided, I face with the following error:

Software error:

no connection to syslog available
- unix dgram connect: Socket operation on non-socket at ../..//Kernel/System/Log/SysLog.pm line 63

For help, please send mail to this site's webmaster, giving this error message and the time and date of the error.



I did some search on the list but I could not find an answer to solve the problem.

I am using Sun Java Web Server 7.0 and I have the following warnings from the error logs:

10/Feb/2010:15:01:53 warning for host 192.168.1.100 trying to GET /otrs/index.pl, /opt/otrs/bin/cgi-bin/index.pl reports: CORE4385: stderr: [Wed Feb 10 15:01:53 2010] index.pl: DBD::mysql::db do failed: Unknown system variable 'NAMES' at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 427.
10/Feb/2010:15:01:53 warning for host 192.168.1.100 trying to GET /otrs/index.pl, /opt/otrs/bin/cgi-bin/index.pl reports: CORE4385: stderr: [Wed Feb 10 15:01:53 2010] index.pl: no connection to syslog available
10/Feb/2010:15:01:53 warning for host 192.168.1.100 trying to GET /otrs/index.pl, /opt/otrs/bin/cgi-bin/index.pl reports: CORE4385: stderr: [Wed Feb 10 15:01:53 2010] index.pl: - unix dgram connect: Socket operation on non-socket at ../..//Kernel/System/Log/SysLog.pm line 63


Here is what I am using

root@zotrs# cat /etc/release
                       Solaris 10 10/09 s10x_u8wos_08a X86
                        .....       
root@zotrs# perl -v

This is perl, v5.10.1 built for x86-solaris-thread-multi
(with 2 registered patches, see perl -V for more detail)
....

OTRS 2.4.7 Source Downloaded from otrs.org

Modules:
 o CGI............................ok (v3.45)
   o Date::Pcalc....................ok (v1.2)
   o Date::Format...................ok (v2.24)
   o DBI............................ok (v1.607)
   o DBD::mysql.....................ok (v4.013)
   o Digest::MD5....................ok (v2.39)
   o Crypt::PasswdMD5...............ok (v1.3)
   o LWP::UserAgent.................ok (v5.829)
   o Encode::HanExtra...............Not installed! (Optional - Required to handl                                                                             e mails with several Chinese character sets.)
   o IO::Scalar.....................ok (v2.110)
   o IO::Wrap.......................ok (v2.110)
   o MIME::Base64...................ok (v3.08)
   o Mail::Internet.................ok (v2.04)
   o MIME::Tools....................ok (v5.427)
   o Net::DNS.......................ok (v0.66)
   o Net::POP3......................ok (v2.29)
   o Mail::POP3Client...............ok (v2.18 )
      o IO::Socket::SSL.............ok (v1.31)
   o Net::IMAP::Simple..............ok (v1.17)
      o Net::IMAP::Simple::SSL......ok (v1.3)
   o Net::SMTP......................ok (v2.31)
      o Authen::SASL................ok (v2.12)
      o Net::SMTP::SSL..............ok (v1.01)
   o Net::LDAP......................Not installed! (Optional - Required for directory authentication.)
   o GD.............................ok (v2.44)
      o GD::Text....................ok (v0.86)
      o GD::Graph...................ok (v1.44)
      o GD::Graph::lines............ok (v1.15)
      o GD::Text::Align.............ok (v1.18)
   o PDF::API2......................ok (v0.73)
      o Compress::Zlib..............ok (v2.02)
   o SOAP::Lite.....................ok (v0.710.10)
   o XML::Parser....................ok (v2.36)


What seems to be the problem? Any ideas?

Please let me know if I need to supply any other information.

Thanks.


--
Deniz Rende
E-mail: deniz.rende@gmail.com
Phone: +1 (224) 789-UNIX (8649)
Mobile: +1 (816) 213-2139
Web: http://www.deniz-rende.com/blog


---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/


---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/



--
Deniz Rende
E-mail: deniz.rende@gmail.com
Phone: +1 (224) 789-UNIX (8649)
Mobile: +1 (816) 213-2139
Web: http://www.deniz-rende.com/blog




--
Deniz Rende
E-mail: deniz.rende@gmail.com
Phone: +1 (224) 789-UNIX (8649)
Mobile: +1 (816) 213-2139
Web: http://www.deniz-rende.com/blog


---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/