[opencms-dev] OpenCms does not work on SUSE Linux with MySQL

Tue Nov 22 13:44:57 CET 2005

Neil,

I had the same problem yesterday and resolved it by disabling SElinux. (I am running Fedora Core 4).

Assuming that your mysql, and tomcat processes have started check for other things that could be interfering with the connection between the two. In FC4, SElinux acts as protection for MySQL and prohibits the connections to the mysqld (even for localhost).

You must change SElinux configuration options to allow connections to the mysqld
. I temporarily disabled my SElinux by making changes to the 'config' file in 
the /etc/selinux directory. 

I changed following line:
SELINUX = enforcing
to read....
SELINUX = disabled

So my config file is as follows:

# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
#       enforcing - SELinux security policy is enforced.
#       permissive - SELinux prints warnings instead of enforcing.
#       disabled - SELinux is fully disabled.
SELINUX=disabled
# SELINUXTYPE= type of policy in use. Possible values are:
#       targeted - Only targeted network daemons are protected.
#       strict - Full SELinux protection.
SELINUXTYPE=targeted

Please note that this disables SElinux and you will need to change specific 
mysql settings for SElinux when you change it back to 'enforcing' mode. But at 
least this is a temporary fix for the install of OpenCMS.

The settings may be different on SUSE linux.

Mike

---- wang neil <neil.wangnan at gmail.com> wrote: 
> and did your copy mysql connector to $TOMCAT_HOME/command/lib? check it!
> 
> On 11/21/05, Christof Dallermassl <ce-christof.dallermassl at bearingpoint.com>
> wrote:
> >
> > Hi!
> >
> > I just had the same problem 5 minutes ago:
> >
> > I had to change the order in /etc/hosts, so localhost is before
> > localhost.localdomain:
> >
> > 127.0.0.1 <http://127.0.0.1> localhost localhost.localdomain opencms
> >
> > as otherwise mysql won't let you connect.
> >
> > try
> > telnet localhost 3306
> > if that works, the jdbc in opencms setup will work as well!
> >
> > regards
> > Christof
> >
> > > Hello,
> > >
> > > I assume you try to create the databases on localhost. Initially we had
> > > the same problem using that constellation. We worked around it by giving
> > > the database ip address instead of the hostname in the connection string
> > > (e.g. 127.0.0.1 <http://127.0.0.1> instead of localhost.).
> > >
> > > Regards
> > >
> > > Felix
> > >
> > > ________________________________
> > >
> > > From: opencms-dev-bounces at opencms.org
> > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Michael, Nick N
> > > Sent: Friday, November 18, 2005 10:24 AM
> > > To: 'The OpenCms mailing list'
> > > Subject: RE: [opencms-dev] OpenCms does not work on SUSE Linux with
> > > MySQL
> > >
> > >
> > > Hi
> > >
> > > I get the following errors running the OpenCms Deployment Wizard
> > >
> > > Database Could not be created!
> > > Error connecting to database using: "jdbc:mysql://localhost:3306/".
> > >
> > > Tables could not be created!
> > > Error connecting to database using:
> > > "jdbc:mysql://localhost:3306/opencms".
> > >
> > > I am using the following versions of applications:
> > > ===================================
> > > j2sdk1.4.2_04/
> > > jakarta-tomcat-4.1.31
> > > mysql 4.1.10a-3.3
> > >
> > > ________________________________
> > >
> > > From: opencms-dev-bounces at opencms.org
> > > [mailto:opencms-dev-bounces at opencms.org] On Behalf Of Hari
> > > Sent: Tuesday, November 15, 2005 10:08
> > > To: The OpenCms mailing list
> > > Subject: RE: [opencms-dev] OpenCms does not work on SUSE Linux with
> > > MySQL
> > >
> > >
> > >
> > > Hi,
> > >
> > >
> > >
> > > We have Opencms 6.0 installed and working fine for the last 3 months on
> > > Suse Linux using MySQL 4.1 and Tomcat 5.0
> > >
> > >
> > >
> > > Can you specify what exactly are the errors you get? During
> > > installation instead of localhost:3306 try 127.0.0.1:8080<http://127.0.0.1:8080>
> > >
> > >
> > >
> > > Cheers
> > >
> > > Hari
> > >
> > >
> > >
> > > ________________________________
> > >
> > > From: Michael, Nick N [mailto:Nick.Michael at standardbank.co.za]
> > > Sent: 15 November 2005 04:59
> > > To: 'The OpenCms mailing list'
> > > Subject: [opencms-dev] OpenCms does not work on SUSE Linux with MySQL
> > >
> > >
> > >
> > > Hi there
> > > It seems that OpenCms does not work on SUSE Linux with MySQL
> > >
> > > I doubt if anyone ever got it to work
> > >
> > > You cant run the installation wizard as you get JDBC errors
> > >
> > > Regards
> > > Nico
> > >
> > > ________________________________________________________________________
> > > __________________________________________________________
> > >
> > > Standard Bank Disclaimer and Confidentiality Note
> > >
> > > This e-mail, its attachments and any rights attaching hereto are, unless
> > > the context clearly indicates otherwise, the property of Standard Bank
> > > Group Limited and/or its subsidiaries ("the Group"). It is confidential,
> > > private and intended for the addressee only.
> > >
> > > Should you not be the addressee and receive this e-mail by mistake,
> > > kindly notify the sender, and delete this e-mail, immediately and do not
> > > disclose or use same in any manner whatsoever. Views and opinions
> > > expressed in this e-mail are those of the sender unless clearly stated
> > > as those of the Group. The Group accepts no liability whatsoever for any
> > > loss or damages whatsoever and howsoever incurred, or suffered,
> > > resulting, or arising, from the use of this email or its attachments.
> > >
> > > The Group does not warrant the integrity of this e-mail nor that it is
> > > free of errors, viruses, interception or interference. Licensed
> > > divisions of the Standard Bank Group are authorised financial services
> > > providers in terms of the Financial Advisory and Intermediary Services
> > > Act, No 37 of 2002 (FAIS).
> > >
> > > For information about the Standard Bank Group Limited visit our website
> > > http://www.standardbank.co.za
> > >
> > > ________________________________________________________________________
> > > __________________________________________________________
> > >
> > > ________________________________________________________________________
> > > __________________________________________________________
> > > Standard Bank Disclaimer and Confidentiality Note
> > >
> > > This e-mail, its attachments and any rights attaching hereto are, unless
> > > the context clearly indicates otherwise, the property of Standard Bank
> > > Group Limited and/or its subsidiaries ("the Group"). It is confidential,
> > > private and intended for the addressee only.
> > >
> > > Should you not be the addressee and receive this e-mail by mistake,
> > > kindly notify the sender, and delete this e-mail, immediately and do not
> > > disclose or use same in any manner whatsoever. Views and opinions
> > > expressed in this e-mail are those of the sender unless clearly stated
> > > as those of the Group. The Group accepts no liability whatsoever for any
> > > loss or damages whatsoever and howsoever incurred, or suffered,
> > > resulting, or arising, from the use of this email or its attachments.
> > >
> > > The Group does not warrant the integrity of this e-mail nor that it is
> > > free of errors, viruses, interception or interference. Licensed
> > > divisions of the Standard Bank Group are authorised financial services
> > > providers in terms of the Financial Advisory and Intermediary Services
> > > Act, No 37 of 2002 (FAIS).
> > >
> > > For information about the Standard Bank Group Limited visit our website
> > > http://www.standardbank.co.za <http://www.standardbank.co.za>
> > >
> > > ________________________________________________________________________
> > > __________________________________________________________
> >
> >
> > _______________________________________________
> > This mail is send to you from the opencms-dev mailing list
> > To change your list options, or to unsubscribe from the list, please visit
> > http://mail.opencms.org/mailman/listinfo/opencms-dev
> >