[GeoNetwork-users] Problems connecting to MySQL

GeoNetwork GeoNetwork User
,
1

Hi Everyone,
I have some problems connecting to a MySQL database with Geoserver 2.10. I am running Geoserver on Ubuntu, under Tomcat 6.0.14. I get the following nasty stack trace when I try and connect to a mysql database on my local server. I can access the database through the mysql command line utility, as well as initiating the database tables with GAST. However, I cannot connect to the database with GAST and insert the sample metadata. I suspect the problems are related, but I am not sure.

Here is the stack trace as an attachment. This issue affects both Jetty and Tomcat, but I have included the stack trace from Jetty only.

Thanks for any help.

Best regards,
Jason

(attachments)

geonetwork_stacktrace.txt (40.4 KB)

2

Hi Jason, could you check that in web/geonetwork/WEB-INF/config.xml
$WEBSERVER_HOST is replaced by localhost+port number in the resource
section and that mysql resource is enabled ?

    <resource enabled="true">
      <name>main-db</name>
      <provider>jeeves.resources.dbms.DbmsPool</provider>
      <config>
        <user>admin</user>
        <password>admin</password>
        <driver>com.mysql.jdbc.Driver</driver>
        <url>jdbc:mysql://$WEBSERVER_HOST/geonetwork</url>
        <poolSize>10</poolSize>
        <reconnectTime>3600</reconnectTime>
      </config>
    </resource>

HTH. Francois

Pickering, Jason wrote:

Hi Everyone,
I have some problems connecting to a MySQL database with Geoserver 2.10. I am running Geoserver on Ubuntu, under Tomcat 6.0.14. I get the following nasty stack trace when I try and connect to a mysql database on my local server. I can access the database through the mysql command line utility, as well as initiating the database tables with GAST. However, I cannot connect to the database with GAST and insert the sample metadata. I suspect the problems are related, but I am not sure.

Here is the stack trace as an attachment. This issue affects both Jetty and Tomcat, but I have included the stack trace from Jetty only.

Thanks for any help.

Best regards,
Jason

------------------------------------------------------------------------

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

------------------------------------------------------------------------

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork

--
Francois Xavier Prunayre
Camptocamp France SAS
Savoie Technolac, BP 352
73377 Le Bourget du Lac Cedex
Tel : + 33 (0)6 34 11 71 75
http://www.camptocamp.com
francois-xavier.prunayre@anonymised.com

3

Hi Francois,
I should have thought of this! Thanks for the tip.

This is the combination that worked for me.

<resource enabled="true">
                        <name>main-db</name>
                        <provider>jeeves.resources.dbms.DbmsPool</provider>
                        <config>
                                <user>GEONETWORKUSER</user>
                                <password>PASSWORD</password>
                                <driver>com.mysql.jdbc.Driver</driver>
                                <url>jdbc:mysql://MYHOSTNAME:MYSQLPORT/geonetwork</url>
                                <poolSize>10</poolSize>
                                <reconnectTime>3600</reconnectTime>
                        </config>
                </resource>

where everything in CAPS correspond to my actual connection values. localhost does not work. Maybe this is something specific to Ubuntu?

Thanks anyway, it seems to be working now.

Best regards,
Jason

Francois-Xavier Prunayre wrote:

Hi Jason, could you check that in web/geonetwork/WEB-INF/config.xml
$WEBSERVER_HOST is replaced by localhost+port number in the resource
section and that mysql resource is enabled ?

    <resource enabled="true">
      <name>main-db</name>
      <provider>jeeves.resources.dbms.DbmsPool</provider>
      <config>
        <user>admin</user>
        <password>admin</password>
        <driver>com.mysql.jdbc.Driver</driver>
        <url>jdbc:mysql://$WEBSERVER_HOST/geonetwork</url>
        <poolSize>10</poolSize>
        <reconnectTime>3600</reconnectTime>
      </config>
    </resource>

HTH. Francois

Pickering, Jason wrote:
  

Hi Everyone,
I have some problems connecting to a MySQL database with Geoserver 2.10. I am running Geoserver on Ubuntu, under Tomcat 6.0.14. I get the following nasty stack trace when I try and connect to a mysql database on my local server. I can access the database through the mysql command line utility, as well as initiating the database tables with GAST. However, I cannot connect to the database with GAST and insert the sample metadata. I suspect the problems are related, but I am not sure.

Here is the stack trace as an attachment. This issue affects both Jetty and Tomcat, but I have included the stack trace from Jetty only.

Thanks for any help.

Best regards,
Jason

------------------------------------------------------------------------

-------------------------------------------------------------------------
Check out the new SourceForge.net Marketplace.
It's the best place to buy or sell services for
just about anything Open Source.
http://ad.doubleclick.net/clk;164216239;13503038;w?http://sf.net/marketplace

------------------------------------------------------------------------

_______________________________________________
GeoNetwork-users mailing list
GeoNetwork-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geonetwork-users
GeoNetwork OpenSource is maintained at http://sourceforge.net/projects/geonetwork