I have tried to use the configuration provided I cannot connect to any database even on different servers with what has been provided. These are the parameters of one of my databases Database Information Name and Hostname Database name 477675_ftplogging Hostname mysql50-57.wc1.sat1.stabletransit.com Please use the hostname for all connection settings inside your code. Working With The Database Online Manager https://mysql.websitesettings.com Click to work with your database online. Alternate Hostname 64.49.221.176 The alternate hostname should be used to manage your databases from a client external to our network.
What would be the exact connection url down to the last letter <property name="connection.url">jdbc:mysql:// mysql50-57.wc1.sat1.stabletransit.com /477675_ftplogging? autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8</ property> I have tried and tried even on different databases on different serves this url connection does not work. Here's what I used on the second server <propertyname="connection.url">jdbc:mysql:// faxme4fr_dol1:passw...@174.133.190.11/faxme4fr_openmeeting? autoReconnect=true&useUnicode=true&createDatabaseIfNotExist=true&characterEncoding=utf-8</ property> I have tried both server returned the same sql exceptions. Both of these databases already exist. What am I missing? My mysql databases are hosted by a provider. I don't configure them I just access them thru my applications. I am not a database expert by no means. Thx On Apr 5, 8:12 pm, RickkciR <richard.liberatosci...@gmail.com> wrote: > Database MUST listen and allow TCP/IP connections! And the default > character-set/scheme must be UTF8! For example a fresh MySQL does not > listen on TCP/IP by default and has not utf8 as default-character-set > defined. You have to change these settings and restart your database > server so that changes take effect (mysql-config is in my.cnf). > Postgres for example does also not listen by default on TCP/IP but > uses by default UTF8 (since postgres 7 or 8). To change Postgres > listening on TCP/IP check postgresql.conf and add your host to the > pg_hba.conf. In Postgres you need to create a database using template1 > cause template1 create automatically a scheme called public which is > needed (and since postgres 8 you can use several schemes inside one > database public is the default one Postgres-Docs). > > On Apr 5, 5:53 pm, lfloyd <f...@faxme4free.net> wrote: > > > > > Not sure if this is a JAVA error or sql connection error? > > > [WARN] [com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread- > > #2] com.mch > > ange.v2.resourcepool.BasicResourcePool - > > com.mchange.v2.resourcepool.BasicResour > > cepool$acquiret...@1a81bd5 -- Acquisition Attempt Failed!!! Clearing > > pending acq > > uires. While trying to acquire a needed new resource, we failed to > > succeed more > > than the maximum number of allowed acquisition attempts (30). Last > > acquisition a > > ttempt exception: > > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: > > Could not > > create connection to database server. Attempted reconnect 3 times. > > Giving up. > > at > > sun.reflect.GeneratedConstructorAccessor20.newInstance(Unknown Source > > ) [na:na] > > at > > sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou > > rce) [na:1.6.0_05] > > at java.lang.reflect.Constructor.newInstance(Unknown Source) > > [na:1.6.0_0 > > 5] > > at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) [mysql- > > connector > > -java-5.1.7-bin.jar:na] > > at com.mysql.jdbc.Util.getInstance(Util.java:381) [mysql- > > connector-java- > > 5.1.7-bin.jar:na] > > at com.mysql.jdbc.SQLError.createSQLException(SQLError.java: > > 984) [mysql- > > connector-java-5.1.7-bin.jar:na]- Hide quoted text - > > - Show quoted text - -- You received this message because you are subscribed to the Google Groups "OpenMeetings User" group. To post to this group, send email to openmeetings-u...@googlegroups.com. To unsubscribe from this group, send email to openmeetings-user+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/openmeetings-user?hl=en.
