# BL.4404.G Authentication DB Table not automagically created

**URL:** <https://forum.inductiveautomation.com/t/bl-4404-g-authentication-db-table-not-automagically-created/1476>\
**Category:** Ignition\
**Created:** [January 31, 2010, 7:34am UTC](https://forum.inductiveautomation.com/t/bl-4404-g-authentication-db-table-not-automagically-created/1476 "2010-01-31T07:34:40Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\
**Post date:** [January 31, 2010, 7:34am UTC](https://forum.inductiveautomation.com/t/bl-4404-g-authentication-db-table-not-automagically-created/1476/1 "2010-01-31T07:34:40Z")

</div>

When I add a Database Authentication Profile, It does not create the database table for me. I have auto-create checked with the defaults.

Host is Ubuntu 9.10 Server x86\_64 connecting to a MySQl 5.1.42 database.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [January 31, 2010, 5:03pm UTC](https://forum.inductiveautomation.com/t/bl-4404-g-authentication-db-table-not-automagically-created/1476/2 "2010-01-31T17:03:51Z")

</div>

Any table creation errors in the log? Just tested this in-house and it worked for me.

---

<div class="post-metadata">

**Author:** ![Kyle\_Chase](https://avatars.discourse-cdn.com/v4/letter/k/9de0a6/32.png) [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\
**Post date:** [January 31, 2010, 7:31pm UTC](https://forum.inductiveautomation.com/t/bl-4404-g-authentication-db-table-not-automagically-created/1476/3 "2010-01-31T19:31:58Z")

</div>

Just tried it again, Made a new DB Auth profile, and it did not add the tables to the database. No error in the log file

---

<div class="post-metadata">

**Author:** ![Matthew\_Temple](https://avatars.discourse-cdn.com/v4/letter/m/7ea924/32.png) [@Matthew\_Temple](https://forum.inductiveautomation.com/u/Matthew_Temple)\
**Post date:** [October 17, 2011, 6:04pm UTC](https://forum.inductiveautomation.com/t/bl-4404-g-authentication-db-table-not-automagically-created/1476/4 "2011-10-17T18:04:19Z")

</div>

Sorry to bring up an old thread.

I was having the exact same problem on setting up my 7.3 auth database. I was using the same basic options, and when I would apply the settings I would not get any errors nor would I get any tables created.

What I just discovered was this…

Create the authentication profile as you normally would. Try to test the auth profile with junk login information. You will get a login error, but your tables will then be created.

---

<div class="post-metadata">

**Author:** ![Carl.Gould](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/carl.gould/32/7262_2.png) [@Carl.Gould](https://forum.inductiveautomation.com/u/Carl.Gould)\
**Post date:** [October 17, 2011, 6:51pm UTC](https://forum.inductiveautomation.com/t/bl-4404-g-authentication-db-table-not-automagically-created/1476/5 "2011-10-17T18:51:46Z")

</div>

Yes, good point - the tables only get created the first time the profile is used, not when in is first created.