# Table not connecting when launching the project

**URL:** <https://forum.inductiveautomation.com/t/table-not-connecting-when-launching-the-project/21655>\
**Category:** Ignition\
**Tags:** database\
**Created:** [January 3, 2019, 2:30am UTC](https://forum.inductiveautomation.com/t/table-not-connecting-when-launching-the-project/21655 "2019-01-03T02:30:32Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![jalvarado](https://avatars.discourse-cdn.com/v4/letter/j/ce73a5/32.png) [@jalvarado](https://forum.inductiveautomation.com/u/jalvarado)\
**Post date:** [January 3, 2019, 2:30am UTC](https://forum.inductiveautomation.com/t/table-not-connecting-when-launching-the-project/21655/1 "2019-01-03T02:30:32Z")

</div>

Hello all

I have an issue.

I am using a RPI 3 with the latest Debian OS and latest Ignition Server available for it. It runs well in it. I have also configured a MySQL Database (MariaDB) in the RPI and made a python code to fill it. Table is updating ok.

I have configured the Database Connection from the Ignition server page and it says it is valid. Also, when I create a table and link it to show a database table data, it does show it in the Ignition Designer.

However, when i launch the program, the database connection seems to not connect, and the data is not shown.

I upload some pictures regarding my proble.

The server is running on the RPI 3. The designer is run in my laptop (Windows 10 up to date) and i am also launching the server in my laptop for test.

If more information is needed i will look for it.

Thanks in advance

Jose Alvarado Ruiz

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/d/d2ca82d5407d032b1c9250a6010a960702d21eac.PNG)

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [January 3, 2019, 3:18am UTC](https://forum.inductiveautomation.com/t/table-not-connecting-when-launching-the-project/21655/2 "2019-01-03T03:18:15Z")

</div>

Look in your project’s security properties for legacy database query permission.

---

<div class="post-metadata">

**Author:** ![jalvarado](https://avatars.discourse-cdn.com/v4/letter/j/ce73a5/32.png) [@jalvarado](https://forum.inductiveautomation.com/u/jalvarado)\
**Post date:** [January 3, 2019, 4:11am UTC](https://forum.inductiveautomation.com/t/table-not-connecting-when-launching-the-project/21655/3 "2019-01-03T04:11:51Z")

</div>

Here? Should I write something in the text box?

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/121932ebfe37ef14e6dd29f6ebe95042c8f47058.PNG)

---

<div class="post-metadata">

**Author:** ![jalvarado](https://avatars.discourse-cdn.com/v4/letter/j/ce73a5/32.png) [@jalvarado](https://forum.inductiveautomation.com/u/jalvarado)\
**Post date:** [January 3, 2019, 4:22am UTC](https://forum.inductiveautomation.com/t/table-not-connecting-when-launching-the-project/21655/4 "2019-01-03T04:22:07Z")

</div>

Thank you so much! It worked 😃  
I didnt know MySQL in RPI was a legacy database…

 ![](https://us1.discourse-cdn.com/inductiveautomation/original/2X/7/73d86c856939fcb2920e0447305d945e393fee50.PNG)

---

<div class="post-metadata">

**Author:** ![Brian](https://avatars.discourse-cdn.com/v4/letter/b/97f17d/32.png) [@Brian](https://forum.inductiveautomation.com/u/Brian)\
**Post date:** [January 3, 2019, 5:17am UTC](https://forum.inductiveautomation.com/t/table-not-connecting-when-launching-the-project/21655/5 "2019-01-03T05:17:46Z")

</div>

It’s not the database that’s legacy, it’s the access method. Ignition is moving toward named queries as the preferred method to interact with any database, as it’s more secure and robust.