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

[Jessica Maas]

Ah... nevermind. I found the mistake... because of many other
test-configurations of other installations I mixed up the IPs... well it
works better if you use an IP with an actual server behind xD *head->desk*

But with this I could correct the user-rights at least over which I would
have stumbled just after that.

Thanks for your nice (and fast O_o") help anyway and I even if there are
still some days left I already wish you a merry christmas :)

2009/12/21 Jessica Maas <yukarichan87 at googlemail.com>

> 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/fb8f287c/attachment.htm>