Yes, I did.<br><br>Mh I saw something else that could be wrong. In the error message is a line saying:<br>"java.sql.SQLException: Access denied for user 'root'@'APPSERVER1' (using password: YES) at"...<br>
<br>Why is it using appserver1 and not dbserver1 (to which the IP belongs)? Maybe that is the problem?<br><br><div class="gmail_quote">2009/12/21 Frank Pertack <span dir="ltr"><<a href="mailto:fpertack@vater-gruppe.de">fpertack@vater-gruppe.de</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>
<p><tt>Did you restart the db-server after the change?<br>
</tt></p><div class="im"><br>
<tt>Regards<br>
</tt><br>
<tt>Frank<br>
</tt><br>
<br>
<br>
<br>
<br>
<tt>-----<a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a> schrieb: -----<br>
</tt><br>
<br>
</div><tt>An: The OpenCms mailing list <<a href="mailto:opencms-dev@opencms.org" target="_blank">opencms-dev@opencms.org</a>><br>
</tt><div class="im"><tt>Von: Jessica Maas <<a href="mailto:yukarichan87@googlemail.com" target="_blank">yukarichan87@googlemail.com</a>><br>
</tt><tt>Gesendet von: <a href="mailto:opencms-dev-bounces@opencms.org" target="_blank">opencms-dev-bounces@opencms.org</a><br>
</tt></div><tt>Datum: 21.12.2009 02:49PM<br>
</tt><tt>Betreff: Re: [opencms-dev] installation of openCMS with database on external server<br>
</tt><div><div></div><div class="h5"><br>
<tt>Hi Russell,<br>
</tt><br>
<tt>thanks for the fast answer first.<br>
</tt><br>
<tt>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 :(<br>
</tt><br>
<tt>Jessica<br>
</tt><br>
<br>
<tt>2009/12/21 Russell Stather < <a href="mailto:russell.stather@mac.com" target="_blank">russell.stather@mac.com</a> ><br>
</tt><br>
<tt>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<br>
</tt><tt>Russell<br>
</tt><br>
<tt>On Monday, December 21, 2009, at 01:32PM, "Jessica Maas" <<br>
</tt><tt><a href="mailto:yukarichan87@googlemail.com" target="_blank">yukarichan87@googlemail.com</a><br>
</tt><tt>> wrote:<br>
</tt><tt>><br>
</tt><tt>>_______________________________________________<br>
</tt><tt>>This mail is sent to you from the opencms-dev mailing list<br>
</tt><tt>>To change your list options, or to unsubscribe from the list, please visit<br>
</tt><tt>><br>
</tt><tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
</tt><br>
<tt>><br>
</tt><br>
<tt>Hi everyone,<br>
</tt><br>
<tt>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:<br>
</tt><tt>" * Your database is down, or</tt>
<ul><tt>* Your database is not accessible with the given connection parameters."<br>
</tt></ul>
<tt>I've got several servers:<br>
</tt><tt>application-server 1 --> 192.168.0.10 <-- this is where I currently try to install OpenCMS<br>
</tt><tt>application-server 2 --> 192.168.0.20<br>
</tt><tt>running as windows-loadbalancing-cluster with the virtual IP 192.168.0.1<br>
</tt><br>
<tt>database-server 1 --> 192.168.0.30 <-- this is where the database should go to<br>
</tt><tt>database-server 2 --> 192.168.0.40<br>
</tt><tt>running as windows-loadbalancing-cluster with the virtual IP 192.168.0.2<br>
</tt><br>
<tt>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.<br>
</tt><tt>It doesn't work if I try the following connection-string: jdbc:mysql:// <a href="http://192.168.0.2:3306/" target="_blank">192.168.0.2:3306/</a><br>
</tt><tt>and it doesn't work either if I try the direct address to the db-server: jdbc:mysql:// <a href="http://192.168.0.40:3306/" target="_blank">192.168.0.40:3306/</a><br>
</tt><br>
<tt>I hope someone can help me out with this problem, because I've got no more ideas what to try.<br>
</tt><br>
<tt>Thanks in advance,<br>
</tt><tt>Jessica<br>
</tt><br>
<br>
<br>
<br>
<tt>_______________________________________________<br>
</tt><tt>This mail is sent to you from the opencms-dev mailing list<br>
</tt><tt>To change your list options, or to unsubscribe from the list, please visit<br>
</tt><tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br>
</tt><br>
<br>
<br>
<tt>_______________________________________________<br>
</tt><tt>This mail is sent to you from the opencms-dev mailing list<br>
</tt><tt>To change your list options, or to unsubscribe from the list, please visit<br>
</tt><tt><a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a></tt><br>
<br></div></div><div class="im">
Frank Pertack<br>
<br>
<br>
Vater Solution GmbH<br>
Liebigstraße 26<br>
24145 Kiel<br>
<br>
Telefon: +49 431 20084-210<br>
Telefax: +49 431 20084-222<br>
Mobil: +49 151 16353519<br>
mailto: <a href="mailto:fpertack@vater-gruppe.de" target="_blank">fpertack@vater-gruppe.de</a><br>
<a href="http://www.vater-gruppe.de" target="_blank">http://www.vater-gruppe.de</a><br>
<br>
<br>
<br>
Amtsgericht Kiel, HRB 6403 <br>
Geschäftsführer:<br>
Klaus-Hinrich Vater<br>
Michael Wiese<br>
-----<br>
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.<br>
<font face="Arial" size="2"> </font></div></div><br><br>
_______________________________________________<br>
This mail is sent to you from the opencms-dev mailing list<br>
To change your list options, or to unsubscribe from the list, please visit<br>
<a href="http://lists.opencms.org/mailman/listinfo/opencms-dev" target="_blank">http://lists.opencms.org/mailman/listinfo/opencms-dev</a><br></blockquote></div><br>