[opencms-dev] Could not connect to the database. Is the database up and running?

[Jörg Herbst]

Hi,

usally this error occures, if you're database isn't available. You 
should try to connect to you're opencms database via the command line 
from the same maschine OpenCms is running. Make sure the database 
OpenCms exists and the tables are not empty.
If you can connect via command line, check you're properties, maybe 
you're now running mysql on a different port than configured via the 
setup or you've got some kind of firewall between you're cms server and 
the database. You should also check if you've configured the right 
hostname, I had some problems with localhost, so use a qualified 
hostname if you can.

Greetings
Joerg

> Hello, im having a problem starting opencms:
>  
> Windows XP SP 1
> Tomcat 4.1.18-LE-jdk14
> MySQL 4.0.16-nt
> JDK 1.4.1_04
>  
>  
> [09.01.2004 16:59:56] <opencms_init> .
> [09.01.2004 16:59:56] <opencms_init> .
> [09.01.2004 16:59:56] <opencms_init> .
> [09.01.2004 16:59:56] <opencms_init> .
> [09.01.2004 16:59:56] <opencms_init> . OpenCms version 5.0.1 Kaitain
> [09.01.2004 16:59:56] <opencms_init> .
> [09.01.2004 16:59:56] <opencms_init> . Copyright (c) 2002-2004 Alkacon 
> Software
> [09.01.2004 16:59:56] <opencms_init> . Copyright (c) 2000-2002 The 
> OpenCms Group
> [09.01.2004 16:59:56] <opencms_init> . OpenCms comes with ABSOLUTELY 
> NO WARRANTY
> [09.01.2004 16:59:56] <opencms_init> . This is free software, and you 
> are welcome to
> [09.01.2004 16:59:56] <opencms_init> . redistribute it under certain 
> conditions.
> [09.01.2004 16:59:56] <opencms_init> . Please see the GNU Lesser 
> General Public Licence for
> [09.01.2004 16:59:56] <opencms_init> . further details.
> [09.01.2004 16:59:56] <opencms_init> .
> [09.01.2004 16:59:56] <opencms_init> .                      
> ...............................................................
> [09.01.2004 16:59:56] <opencms_init> . Startup time         : Fri Jan 
> 09 16:59:56 GMT-03:00 2004
> [09.01.2004 16:59:56] <opencms_init> . Servlet container    : Apache 
> Tomcat/4.1.18-LE-jdk14
> [09.01.2004 16:59:56] <opencms_init> . OpenCms version      : 5.0.1 
> Kaitain
> [09.01.2004 16:59:56] <opencms_init> . OpenCms base path    : 
> C:\developedapps\tomcatdev\bin\..\webapps\opencms\WEB-INF\
> [09.01.2004 16:59:56] <opencms_init> . OpenCms property file: 
> C:\developedapps\tomcatdev\bin\..\webapps\opencms\WEB-INF\config/opencms.properties
> [09.01.2004 16:59:56] <opencms_init> . OpenCms logfile      : 
> C:\developedapps\tomcatdev\bin\..\webapps\opencms\WEB-INF\logs/opencms.log
> [09.01.2004 16:59:56] <opencms_init> . OpenCms encoding     : ISO-8859-1
> [09.01.2004 16:59:56] <opencms_init> . System file.encoding : ISO-8859-1
> [09.01.2004 16:59:56] <opencms_init> . Encoding set to      : ISO-8859-1
> [09.01.2004 16:59:57] <opencms_init> . Ethernet address used: 
> d9:85:c5:29:d1:65
> [09.01.2004 16:59:57] <opencms_init> . Java VM in use       : Java 
> HotSpot(TM) Client VM 1.4.1_04-b01 mixed mode Sun Microsystems Inc.
> [09.01.2004 16:59:57] <opencms_init> . Operating sytem      : Windows 
> XP 5.1 x86
> [09.01.2004 16:59:57] <opencms_init> . Resource broker used : mysql
> [09.01.2004 16:59:57] <opencms_init> . Resource broker class: 
> com.opencms.file.mySql.CmsResourceBroker
> [09.01.2004 16:59:57] <opencms_init> . Resource broker init : phase 1 
> ok - starting
> [09.01.2004 16:59:57] <opencms_init> . Resource broker init : phase 2 
> ok - initializing database
> [09.01.2004 16:59:57] <opencms_init> . Resource broker init : phase 3 
> ok - creating db access module
> [09.01.2004 16:59:57] <opencms_init> . Database access init : ok
> [09.01.2004 16:59:57] <opencms_init> . Database offline pool: 
> jdbc:opencmspool:mysql
> [09.01.2004 16:59:57] <opencms_init> . Database online pool : 
> jdbc:opencmspool:mysqlonline
> [09.01.2004 16:59:57] <opencms_init> . Database backup pool : 
> jdbc:opencmspool:mysqlbackup
> [09.01.2004 16:59:57] <opencms_init> . Digest configured    : MD5
> [09.01.2004 16:59:57] <opencms_init> . Digest file encoding : UTF-8
> [09.01.2004 16:59:57] <opencms_init> . Using digest encoding: MD5 from 
> SUN version 1.2
> [09.01.2004 16:59:57] <opencms_pool> [com.opencms.dbpool.CmsPool] 
> mysql: creating new connection. Current Amount is:0
> [09.01.2004 16:59:57] <opencms_init> . Database fill default: yes
> [09.01.2004 16:59:57] <opencms_pool> [com.opencms.dbpool.CmsPool] 
> mysql: creating new connection. Current Amount is:0
> [09.01.2004 16:59:57] <opencms_critical> [CmsRbManager] Critical error 
> while loading resourcebroker
> [09.01.2004 16:59:57] <opencms_critical> . Critical init error/3: 
> com.opencms.core.CmsException: Critical error while loading resourcebroker
> [09.01.2004 16:59:57] <opencms_critical> OpenCms initialization error!
>  
> Could not connect to the database. Is the database up and running?
>  
>
> BEST REGARDS FROM ARGENTINA