[opencms-dev] Antwort: Re: installation of openCMS with database on external server

[Jessica Maas]

Yes, I did.

Mh I saw something else that could be wrong. In the error message is a line
saying:
"java.sql.SQLException: Access denied for user 'root'@'APPSERVER1' (using
password: YES) at"...

Why is it using appserver1 and not dbserver1 (to which the IP belongs)?
Maybe that is the problem?

2009/12/21 Frank Pertack <fpertack at vater-gruppe.de>

> Did you restart the db-server after the change?
>
> Regards
>
> Frank
>
>
>
>
>
> -----opencms-dev-bounces at opencms.org schrieb: -----
>
>
> An: The OpenCms mailing list <opencms-dev at opencms.org>
> Von: Jessica Maas <yukarichan87 at googlemail.com>
> Gesendet von: opencms-dev-bounces at opencms.org
> Datum: 21.12.2009 02:49PM
> Betreff: Re: [opencms-dev] installation of openCMS with database on
> external server
>
> Hi Russell,
>
> thanks for the fast answer first.
>
> Hm, maybe this was one problem but seems not the only one. I'm using root
> for installation and as the opencms-user (since it's only a
> test-installation at the moment - later I will create special users for
> opencms). I changed it from local usage to every host to see if anything
> changes, but I still get the same error :(
>
> Jessica
>
>
> 2009/12/21 Russell Stather < russell.stather at mac.com >
>
> My guess would be that you need to add permissions to the schema to the
> user at the host you are accessing the database from. The default when you
> create the schema on mysql is to allow access from local host, which is not
> the case for you, so use mysql admin to add the appropriate access
> Russell
>
> On Monday, December 21, 2009, at 01:32PM, "Jessica Maas" <
> yukarichan87 at googlemail.com
> > wrote:
> >
> >_______________________________________________
> >This mail is sent to you from the opencms-dev mailing list
> >To change your list options, or to unsubscribe from the list, please visit
> >
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
> >
>
> Hi everyone,
>
> I tried to install OpenCMS and when I do everything local it works without
> any problems. But if I try to install the database on another server I can
> not get a connection to it:
> "    *  Your database is down, or
>
>    * Your database is not accessible with the given connection
>    parameters."
>
> I've got several servers:
> application-server 1  --> 192.168.0.10 <-- this is where I currently try to
> install OpenCMS
> application-server 2  --> 192.168.0.20
> running as windows-loadbalancing-cluster with the virtual IP 192.168.0.1
>
> database-server   1  --> 192.168.0.30 <-- this is where the database should
> go to
> database-server   2  --> 192.168.0.40
> running as windows-loadbalancing-cluster with the virtual IP 192.168.0.2
>
> Later OpenCMS will be running on both application-servers and the database
> will be copied to both database-servers, but for testing I wanted to
> simplify it.
> It doesn't work if I try the following connection-string: jdbc:mysql://
> 192.168.0.2:3306/
> and it doesn't work either if I try the direct address to the db-server:
> jdbc:mysql:// 192.168.0.40:3306/
>
> I hope someone can help me out with this problem, because I've got no more
> ideas what to try.
>
> Thanks in advance,
> Jessica
>
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
> Frank Pertack
>
>
> Vater Solution GmbH
> Liebigstraße 26
> 24145 Kiel
>
> Telefon: +49 431 20084-210
> Telefax: +49 431 20084-222
> Mobil: +49 151 16353519
> mailto: fpertack at vater-gruppe.de
> http://www.vater-gruppe.de
>
>
>
> Amtsgericht Kiel, HRB 6403
> Geschäftsführer:
> Klaus-Hinrich Vater
> Michael Wiese
> -----
> Diese Email enthält ggfs. vertrauliche und/oder rechtlich geschützte
> Informationen. Wenn Sie nicht der richtige Adressat sind oder diese Email
> irrtümlich erhalten haben, informieren Sie bitte sofort den Absender und
> vernichten Sie diese Email. Das unerlaubte Kopieren sowie die unbefugte
> Weitergabe dieser Email sind nicht gestattet.
>
>
> _______________________________________________
> This mail is sent to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://lists.opencms.org/mailman/listinfo/opencms-dev
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20091221/a696e8b6/attachment.htm>