AW: [opencms-dev] Re: could not connect to database

[Frank Wunderlich]

Hi David,

it seems to me, that Opencms has no problem in connecting the database
(although the upper most exception handler thinks so too ;-).

Opencms obviously tries to insert a datarow into a table and MySql
complains that this datarow already exists (Duplicate entry 'Guests' for
key 2). Considering this message, I would guess, that it is the
"cms_groups"-table and the application tries to insert the usergroup
'Guests'. Unfortunatly it has done this work before...

I don't know why this problem occurs, but it seems that some
initalization during setup has failed and that the state of your system
is in some sense "corrupt". 

If you like "hacking": You could try to look at the "cms_groups"-table
and try to delete the probably already existing datarow (if i am right)
manually, before starting the app again. But no guaranty if the rest of
the system/database will work...

Good luck...
Frank.


> 
> Le Wed, Jul 09, 2003 at 09:52:14AM -0400, Rene Hinojosa ecrivait :
> > 
> > Have you looked at the priveleges table in mysql database? I've run 
> > into instances where my db connections were setup as 
> localhost and the 
> > webserver would try to connect as the machines ip address. If the 
> > priveleges are set not to allow the user to connect from an 
> ip other 
> > than localhost(127.0.0.1) then it will not work. Check the 
> mysql logs 
> > instead of the tomcat logs.
> 
> 	no, i haven't looked, but i'm going to check. But, if 
> the wizard can create table in the opencms database, i 
> doesn't understand how the "opencms application" can't 
> connect to this database....
> 
> 	thanks all to try to solve this problem,
> 
> 	David.
>