#10 mysql plugin does not even try to connect

Next Release
open
nobody
5
2007-10-04
2007-10-04
Marco Moscardini
No

could this be a bug or a feature requets... do let me know.

there we go, I know you all like it ;-) logs

...
form connection params { port=3306, passwd="apache", dbtype="mysql", host="localhost", validate connections=true, max connections=10, user="apache", database="geoserver", min connections=4}
78094 [WARNING] org.geotools.data.DataStoreFinder - Could not acquire MySQL Database:java.lang.NoClassDefFoundError: org/geotools/data/jdbc/datasource/DataSourceUtil
java.lang.NoClassDefFoundError: org/geotools/data/jdbc/datasource/DataSourceUtil
at org.geotools.data.mysql.MySQLDataStoreFactory.getDefaultDataSource(MySQLDataStoreFactory.java:187)
at org.geotools.data.mysql.MySQLDataStoreFactory.createDataStore(MySQLDataStoreFactory.java:175)
at org.geotools.data.DataStoreFinder.getDataStore(DataStoreFinder.java:95)
at org.vfny.geoserver.util.DataStoreUtils.acquireDataStore(DataStoreUtils.java:40)
at org.vfny.geoserver.action.data.DataDataStoresEditorAction.execute(DataDataStoresEditorAction.java:132)
at org.vfny.geoserver.action.ConfigAction.execute(ConfigAction.java:102)
at org.apache.struts.action.RequestProcessor.processActionPerform(RequestProcessor.java:431)
at org.apache.struts.action.RequestProcessor.process(RequestProcessor.java:236)
at org.apache.struts.action.ActionServlet.process(ActionServlet.java:1196)
at org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:432)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:445)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1050)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:103)
at org.mortbay.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1041)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:354)
at org.mortbay.jetty.servlet.SessionHandler.handle(SessionHandler.java:226)
at org.mortbay.jetty.handler.ContextHandler.handle(ContextHandler.java:627)
at org.mortbay.jetty.handler.ContextHandlerCollection.handle(ContextHandlerCollection.java:149)
at org.mortbay.jetty.handler.HandlerCollection.handle(HandlerCollection.java:123)
at org.mortbay.jetty.handler.HandlerWrapper.handle(HandlerWrapper.java:141)
at org.mortbay.jetty.Server.handle(Server.java:269)
at org.mortbay.jetty.HttpConnection.handleRequest(HttpConnection.java:430)
at org.mortbay.jetty.HttpConnection$RequestHandler.content(HttpConnection.java:701)
at org.mortbay.jetty.HttpParser.parseNext(HttpParser.java:617)
at org.mortbay.jetty.HttpParser.parseAvailable(HttpParser.java:199)
at org.mortbay.jetty.HttpConnection.handle(HttpConnection.java:339)
at org.mortbay.jetty.nio.HttpChannelEndPoint.run(HttpChannelEndPoint.java:270)
at org.mortbay.thread.BoundedThreadPool$PoolThread.run(BoundedThreadPool.java:475)

and what is worse is that the credntials are correct and do work, the dbase exists... but from the connection log of mysql, the geoserver does not even try to connect, nevermind auhtenticating himself.

could be some thing to do with my setup?

GeoServer 1.5.3

java version "1.6.0_03"
Java(TM) SE Runtime Environment (build 1.6.0_03-b05)
Java HotSpot(TM) Client VM (build 1.6.0_03-b05, mixed mode, sharing)

jetty-5.1.12-1jpp.7.fc8

it all seams to work and save data in the file system... but mysql fails to work, I will try now with posGIS.

Just to let you know if I do connect manually with any client I normally get an entry like:
071004 1:22:31 2 Connect root@localhost on geoserver
2 Query show databases
2 Query show tables
2 Query select @@version_comment limit 1
071004 1:22:35 2 Quit

where in this case I get NOTTHING AT ALL.

Discussion