1. Home
  2. Server
  3. MySQL "Could not create connection..." - Mirth Community

MySQL "Could not create connection..." - Mirth Community

Rsdaa 29/01/2022 239

['

Hi.

', '

With

', '

fresh

', '

install

', '

of

', '

MIRTH

', '

Connect

', '

3.5.2,

', '

MySQL

', '

8.0

', '

on

', '

Windows

', '

2016

', '

server,

', "

I'm

", '

unable

', '

to

', '

connect

', '

to

', '

MySQL

', '

using

', '

this

', '

string

', '

in

', '

the

', '

server

', '

manager:

', '

"jdbc:mysql://localhost:3306/mirthdb".

', '

I

', '

have

', '

a

', '

local

', '

instance

', '

of

', '

mirthdb

', '

running,

', '

a

', '

"mirthuser"

', '

account

', '

with

', '

full

', '

permissions.

', '

I

', '

am

', '

able

', '

to

', '

login

', '

to

', '

the

', '

mirthdb

', '

from

', '

MySQL

', '

workbench

', '

ok.

', '

There

', '

is

', '

nothing

', '

in

', '

the

', '

MySQL

', '

log

', '

showing

', '

any

', '

communication

', '

from

', '

MIRTH.

', '

I

', '

am

', '

trying

', '

to

', '

use

', '

MySQL

', '

instead

', '

of

', '

Derby.

', '

Any

', '

ideas

', '

would

', '

be

', '

helpful!

', '

Thanks.

', '

Here

', '

is

', '

the

', '

error

', '

log:

', '

INFO

', '

2018-04-27

', '

14:13:08,521

', '

[Main

', '

Server

', '

Thread]

', '

com.mirth.connect.server.Mirth:

', '

Mirth

', '

Connect

', '

3.5.2

', '

(Built

', '

on

', '

March

', '

16,

', '

2018)

', '

server

', '

successfully

', '

started.

', '

INFO

', '

2018-04-27

', '

14:13:08,521

', '

[Main

', '

Server

', '

Thread]

', '

com.mirth.connect.server.Mirth:

', '

This

', '

product

', '

was

', '

developed

', '

by

', '

Mirth

', '

Corporation

', '

(

', '

http://www.mirthcorp.com

', '

)

', '

and

', '

its

', '

contributors

', '

(c)2005-2018.

', '

INFO

', '

2018-04-27

', '

14:13:08,521

', '

[Main

', '

Server

', '

Thread]

', '

com.mirth.connect.server.Mirth:

', '

Running

', '

Java

', '

HotSpot(TM)

', '

64-Bit

', '

Server

', '

VM

', '

1.8.0_172

', '

on

', '

Windows

', '

Server

', '

2016

', '

(10.0,

', '

amd64),

', '

derby,

', '

with

', '

charset

', '

windows-1252.

', '

INFO

', '

2018-04-27

', '

14:13:08,538

', '

[Main

', '

Server

', '

Thread]

', '

com.mirth.connect.server.Mirth:

', '

Web

', '

server

', '

running

', '

at

', '

http://10.1.2.19:8080/

', '

and

', '

https://10.1.2.19:8443/

', '

INFO

', '

2018-04-27

', '

14:16:34,463

', '

[Shutdown

', '

Hook

', '

Thread]

', '

com.mirth.connect.server.Mirth:

', '

shutting

', '

down

', '

mirth

', '

due

', '

to

', '

normal

', '

request

', '

ERROR

', '

2018-04-27

', '

14:16:43,382

', '

[Main

', '

Server

', '

Thread]

', '

com.mirth.connect.server.Mirth:

', '

Error

', '

establishing

', '

connection

', '

to

', '

database,

', '

aborting

', '

startup.

', '

Could

', '

not

', '

create

', '

connection

', '

to

', '

database

', '

server.

', '

INFO

', '

2018-04-27

', '

14:16:43,382

', '

[Shutdown

', '

Hook

', '

Thread]

', '

com.mirth.connect.server.Mirth:

', '

shutting

', '

down

', '

mirth

', '

due

', '

to

', '

normal

', '

request

', '

ERROR

', '

2018-04-27

', '

14:16:43,413

', '

[Shutdown

', '

Hook

', '

Thread]

', '

com.mirth.connect.server.controllers.DefaultConfig

', '

urationController:

', '

Could

', '

not

', '

retrieve

', '

property:

', '

category=core,

', '

name=channelDependencies

', '

org.apache.ibatis.exceptions.PersistenceException:

', '

###

', '

Error

', '

querying

', '

database.

', '

Cause:

', '

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC

', '

onnectionException:

', '

Could

', '

not

', '

create

', '

connection

', '

to

', '

database

', '

server.

', '

###

', '

The

', '

error

', '

may

', '

exist

', '

in

', '

mysql/mysql-configuration.xml

', '

###

', '

The

', '

error

', '

may

', '

involve

', '

Configuration.selectProperty

', '

###

', '

The

', '

error

', '

occurred

', '

while

', '

executing

', '

a

', '

query

', '

###

', '

Cause:

', '

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC

', '

onnectionException:

', '

Could

', '

not

', '

create

', '

connection

', '

to

', '

database

', '

server.

', '

at

', '

org.apache.ibatis.exceptions.ExceptionFactory.wrap

', '

Exception(ExceptionFactory.java:23)

', '

at

', '

org.apache.ibatis.session.defaults.DefaultSqlSessi

', '

on.selectList(DefaultSqlSession.java:104)

', '

at

', '

org.apache.ibatis.session.defaults.DefaultSqlSessi

', '

on.selectList(DefaultSqlSession.java:95)

', '

at

', '

org.apache.ibatis.session.defaults.DefaultSqlSessi

', '

on.selectOne(DefaultSqlSession.java:59)

', '

at

', '

sun.reflect.NativeMethodAccessorImpl.invoke0(Nativ

', '

e

', '

Method)

', '

at

', '

sun.reflect.NativeMethodAccessorImpl.invoke(Unknow

', '

n

', '

Source)

', '

at

', '

sun.reflect.DelegatingMethodAccessorImpl.invoke(Un

', '

known

', '

Source)

', '

at

', '

java.lang.reflect.Method.invoke(Unknown

', '

Source)

', '

at

', '

org.apache.ibatis.session.SqlSessionManager$SqlSes

', '

sionInterceptor.invoke(SqlSessionManager.java:282)

', '

at

', '

com.sun.proxy.$Proxy6.selectOne(Unknown

', '

Source)

', '

at

', '

org.apache.ibatis.session.SqlSessionManager.select

', '

One(SqlSessionManager.java:151)

', '

at

', '

com.mirth.connect.server.controllers.DefaultConfig

', '

urationController.getProperty(DefaultConfiguration

', '

Controller.java:903)

', '

at

', '

com.mirth.connect.server.controllers.DefaultConfig

', '

urationController.getChannelDependencies(DefaultCo

', '

nfigurationController.java:1007)

', '

at

', '

com.mirth.connect.server.util.ChannelDependencySer

', '

verUtil.getDependencyGraph(ChannelDependencyServer

', '

Util.java:26)

', '

at

', '

com.mirth.connect.server.util.ChannelDependencySer

', '

verUtil.getOrderedChannels(ChannelDependencyServer

', '

Util.java:30)

', '

at

', '

com.mirth.connect.server.controllers.DonkeyEngineC

', '

ontroller.undeployChannels(DonkeyEngineController.

', '

java:405)

', '

at

', '

com.mirth.connect.server.controllers.DonkeyEngineC

', '

ontroller.stopEngine(DonkeyEngineController.java:2

', '

25)

', '

at

', '

com.mirth.connect.server.Mirth.stopEngine(Mirth.ja

', '

va:362)

', '

at

', '

com.mirth.connect.server.Mirth.shutdown(Mirth.java

', '

:318)

', '

at

', '

com.mirth.connect.server.Mirth$ShutdownHook.run(Mi

', '

rth.java:432)

', '

Caused

', '

by:

', '

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientC

', '

onnectionException:

', '

Could

', '

not

', '

create

', '

connection

', '

to

', '

database

', '

server.

', '

at

', '

sun.reflect.NativeConstructorAccessorImpl.newInsta

', '

nce0(Native

', '

Method)

', '

at

', '

sun.reflect.NativeConstructorAccessorImpl.newInsta

', '

nce(Unknown

', '

Source)

', '

at

', '

sun.reflect.DelegatingConstructorAccessorImpl.newI

', '

nstance(Unknown

', '

Source)

', '

at

', '

java.lang.reflect.Constructor.newInstance(Unknown

', '

Source)

', '

at

', '

com.mysql.jdbc.Util.handleNewInstance(Util.java:40

', '

8)

', '

at

', '

com.mysql.jdbc.Util.getInstance(Util.java:383)

', '

at

', '

com.mysql.jdbc.SQLError.createSQLException(SQLErro

', '

r.java:1023)

', '

at

', '

com.mysql.jdbc.SQLError.createSQLException(SQLErro

', '

r.java:997)

', '

at

', '

com.mysql.jdbc.SQLError.createSQLException(SQLErro

', '

r.java:983)

', '

at

', '

com.mysql.jdbc.SQLError.createSQLException(SQLErro

', '

r.java:928)

', '

at

', '

com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Co

', '

nnectionImpl.java:2576)

', '

at

', '

com.mysql.jdbc.ConnectionImpl.createNewIO(Connecti

', '

onImpl.java:2309)

', '

at

', '

com.mysql.jdbc.ConnectionImpl.(ConnectionImp

', '

l.java:834)

', '

at

', '

com.mysql.jdbc.JDBC4Connection.(JDBC4Connect

', '

ion.java:46)

', '

at

', '

sun.reflect.NativeConstructorAccessorImpl.newInsta

', '

nce0(Native

', '

Method)

', '

at

', '

sun.reflect.NativeConstructorAccessorImpl.newInsta

', '

nce(Unknown

', '

Source)

', '

at

', '

sun.reflect.DelegatingConstructorAccessorImpl.newI

', '

nstance(Unknown

', '

Source)

', '

at

', '

java.lang.reflect.Constructor.newInstance(Unknown

', '

Source)

', '

at

', '

com.mysql.jdbc.Util.handleNewInstance(Util.java:40

', '

8)

', '

at

', '

com.mysql.jdbc.ConnectionImpl.getInstance(Connecti

', '

onImpl.java:419)

', '

at

', '

com.mysql.jdbc.NonRegisteringDriver.connect(NonReg

', '

isteringDriver.java:344)

', '

at

', '

java.sql.DriverManager.getConnection(Unknown

', '

Source)

', '

at

', '

java.sql.DriverManager.getConnection(Unknown

', '

Source)

', '

at

', '

org.apache.ibatis.datasource.unpooled.UnpooledData

', '

Source.doGetConnection(UnpooledDataSource.java:181

', '

)

', '

at

', '

org.apache.ibatis.datasource.unpooled.UnpooledData

', '

Source.doGetConnection(UnpooledDataSource.java:176

', '

)

', '

at

', '

org.apache.ibatis.datasource.unpooled.UnpooledData

', '

Source.getConnection(UnpooledDataSource.java:80)

', '

at

', '

org.apache.ibatis.datasource.pooled.PooledDataSour

', '

ce.popConnection(PooledDataSource.java:371)

', '

at

', '

org.apache.ibatis.datasource.pooled.PooledDataSour

', '

ce.getConnection(PooledDataSource.java:80)

', '

at

', '

org.apache.ibatis.transaction.jdbc.JdbcTransaction

', '

.openConnection(JdbcTransaction.java:131)

', '

at

', '

org.apache.ibatis.transaction.jdbc.JdbcTransaction

', '

.getConnection(JdbcTransaction.java:58)

', '

at

', '

org.apache.ibatis.executor.BaseExecutor.getConnect

', '

ion(BaseExecutor.java:279)

', '

at

', '

org.apache.ibatis.executor.SimpleExecutor.prepareS

', '

tatement(SimpleExecutor.java:69)

', '

at

', '

org.apache.ibatis.executor.SimpleExecutor.doQuery(

', '

SimpleExecutor.java:56)

', '

at

', '

org.apache.ibatis.executor.BaseExecutor.queryFromD

', '

atabase(BaseExecutor.java:267)

', '

at

', '

org.apache.ibatis.executor.BaseExecutor.query(Base

', '

Executor.java:141)

', '

at

', '

org.apache.ibatis.executor.CachingExecutor.query(C

', '

achingExecutor.java:105)

', '

at

', '

org.apache.ibatis.executor.CachingExecutor.query(C

', '

achingExecutor.java:81)

', '

at

', '

org.apache.ibatis.session.defaults.DefaultSqlSessi

', '

on.selectList(DefaultSqlSession.java:101)

', '

...

', '

18

', '

more

', '

Caused

', '

by:

', '

java.lang.NullPointerException

', '

at

', '

com.mysql.jdbc.ConnectionImpl.getServerCharset(Con

', '

nectionImpl.java:3299)

', '

at

', '

com.mysql.jdbc.MysqlIO.sendConnectionAttributes(My

', '

sqlIO.java:1967)

', '

at

', '

com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggab

', '

leAuthentication(MysqlIO.java:1893)

', '

at

', '

com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:12

', '

87)

', '

at

', '

com.mysql.jdbc.ConnectionImpl.coreConnect(Connecti

', '

onImpl.java:2494)

', '

at

', '

com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(Co

', '

nnectionImpl.java:2527)

', '

...

', '

45

', '

more

']

PREV: Solved: How to connect Host machine to Virtual Machine ...

NEXT: Simple Steps to a New Virtual Machine - VMware

Popular Articles

Hot Articles
Back to Top