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

[Frank Pertack]

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