#11 Cannot connect to the DB

[Anonymous]

Hi
I have installed locanda on tomcat6 under linux.

After trying to create the first user http://190.2.34.134:8080/locanda/createAccount.action throws a problem connecting to mysql.

I can try it locally from the shell prompt and i can log perfectly fine with the user,pass i have defined in: /var/lib/tomcat6/webapps/locanda/META-INF/context.xml

For some reason the error I get on the browser says that it is still trying to log as "root@localhost" to mysql when in fact i have changed it (and restarted tomcat) in context.xml to "locandauser" (Mysql user created and working it just fine when testing with mysql client)

What is it wrong? Why the data base connector is failing and still using the old username i tried hours ago and not getting the actual context.xml

thanks

[Anonymous]

anybody following this thread?

[Anonymous]

It looks like it is using "root" as default mysql user when I have created a new one and it was configured in context.xml. What's wrong ?

[LabOpenSource]

Hi,

that's very strange. Context.xml is the only point where you set the db credentials. Since you restarted tomcat, I can only think about something in the browser cache, though unlikely.
However, the new 0.4 release uses an embedded H2 database that should prevent users to have such db problems!

Thanks,
the Locanda team