# Can't set up Tag Historian. Logs

**URL:** <https://forum.inductiveautomation.com/t/cant-set-up-tag-historian-logs/27891>\
**Category:** Ignition Early Access\
**Created:** [August 29, 2019, 9:28pm UTC](https://forum.inductiveautomation.com/t/cant-set-up-tag-historian-logs/27891 "2019-08-29T21:28:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\
**Post date:** [August 29, 2019, 9:28pm UTC](https://forum.inductiveautomation.com/t/cant-set-up-tag-historian-logs/27891/1 "2019-08-29T21:28:36Z")

</div>

Trying to set up tags to log and I get the following…

```auto

java.lang.Exception: Error running query: CREATE TABLE sqlth_drv (`id` int NOT NULL AUTO_INCREMENT,`name` varchar(255),`provider` varchar(255),PRIMARY KEY (`id`))

at com.inductiveautomation.ignition.gateway.db.schema.DBTableSchema.executeCommandSet(DBTableSchema.java:140)

at com.inductiveautomation.ignition.gateway.db.schema.DBTableSchema.createTable(DBTableSchema.java:109)

at com.inductiveautomation.ignition.gateway.db.schema.DBTableSchema.verifyAndUpdate(DBTableSchema.java:91)

at com.inductiveautomation.gateway.tags.history.storage.TagHistoryDatasourceSink.checkTables(TagHistoryDatasourceSink.java:1110)

at com.inductiveautomation.gateway.tags.history.storage.TagHistoryDatasourceSink.initialize(TagHistoryDatasourceSink.java:237)

at com.inductiveautomation.gateway.tags.history.storage.TagHistoryDatasourceSink.lambda$initialize$0(TagHistoryDatasourceSink.java:249)

at com.inductiveautomation.ignition.common.execution.impl.BasicExecutionEngine$ThrowableCatchingRunnable.run(BasicExecutionEngine.java:518)

at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)

at java.base/java.util.concurrent.FutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at java.base/java.lang.Thread.run(Unknown Source)

Caused by: java.sql.SQLException: No database selected

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:129)

at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)

```

---

<div class="post-metadata">

**Author:** ![jpark](https://avatars.discourse-cdn.com/v4/letter/j/a88e57/32.png) [@jpark](https://forum.inductiveautomation.com/u/jpark)\
**Post date:** [August 29, 2019, 9:58pm UTC](https://forum.inductiveautomation.com/t/cant-set-up-tag-historian-logs/27891/2 "2019-08-29T21:58:03Z")

</div>

Do you have a database connection created?

> [@wking](#):
>
> Caused by: java.sql.SQLException: No database selected

---

<div class="post-metadata">

**Author:** ![wking](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/wking/32/21823_2.png) [@wking](https://forum.inductiveautomation.com/u/wking)\
**Post date:** [August 30, 2019, 1:40pm UTC](https://forum.inductiveautomation.com/t/cant-set-up-tag-historian-logs/27891/3 "2019-08-30T13:40:51Z")

</div>

I changed connection string from

jdbc:mysql://localhost:3306/?user=root

to

jdbc:mysql://localhost:3306/MES