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

[Frank Pertack]

Hi Jessica,

sounds as if your mysql user is not configured correctly.
You have to add the opencms user with the appropriated IP of your OpenCms
Server.
Otherwise only your local DB-Server has access to your db.

Regards

Frank



-----opencms-dev-bounces at opencms.org schrieb: -----


An: 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:32PM
Betreff: [opencms-dev] installation of openCMS with database on external
server

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

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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://webmail.opencms.org/pipermail/opencms-dev/attachments/20091221/6b9546a2/attachment.htm>