# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=4 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 5 --- ## [Installing Ignition using apt-get](https://forum.inductiveautomation.com/t/installing-ignition-using-apt-get/4390)
**Author:** [@Greg.Buehler](https://forum.inductiveautomation.com/u/Greg.Buehler)\ **Replies:** 14\ **Last updated:** [July 8, 2016, 1:22pm UTC](https://forum.inductiveautomation.com/t/installing-ignition-using-apt-get/4390 "2016-07-08T13:22:42Z")
Installing using apt-get seems to be much more user friendly in most respects, so here are some instructions. 1) Install Linux. (For Ubuntu I also install OpenSSH and the LAMP stack at install time) 2) Download and a… --- ## [Moving big amount of data from PLC to MySql DB](https://forum.inductiveautomation.com/t/moving-big-amount-of-data-from-plc-to-mysql-db/11904)
**Author:** [@jhortig](https://forum.inductiveautomation.com/u/jhortig)\ **Replies:** 1\ **Last updated:** [July 7, 2016, 4:03pm UTC](https://forum.inductiveautomation.com/t/moving-big-amount-of-data-from-plc-to-mysql-db/11904 "2016-07-07T16:03:35Z")
I need to move a huge amount of process data from a Siemens S7 300 PLC into a MySql database and than display these values as a graph in Ignition. The details: I have a Siemens S7 PLC with a cycle time of approximate… --- ## [Allen Bradley ControlLogix DHRIO 18F1 or 28F1 Error](https://forum.inductiveautomation.com/t/allen-bradley-controllogix-dhrio-18f1-or-28f1-error/8010)
**Author:** [@Clkman](https://forum.inductiveautomation.com/u/Clkman)\ **Replies:** 4\ **Last updated:** [June 27, 2016, 7:00pm UTC](https://forum.inductiveautomation.com/t/allen-bradley-controllogix-dhrio-18f1-or-28f1-error/8010 "2016-06-27T19:00:21Z")
Hi, Our setup: Windows 2003 R2 server Ignition 7.6.4 32 bit AB drivers 1.6.4(b2013112117) Most of our PLC's on site are AB SLC504 and these form many individual DH+ networks in up to 6 seperate buildings. We've conn… --- ## [Siemens LOGO OPC driver](https://forum.inductiveautomation.com/t/siemens-logo-opc-driver/11795)
**Author:** [@jesus.osorio.gtz](https://forum.inductiveautomation.com/u/jesus.osorio.gtz)\ **Replies:** 0\ **Last updated:** [June 8, 2016, 10:24pm UTC](https://forum.inductiveautomation.com/t/siemens-logo-opc-driver/11795 "2016-06-08T22:24:15Z")
Hi, Does anybody know which free OPC server can work for Siemens LOGO (http://w3.siemens.com/mcms/programmable-logic-controller/en/logic-module-logo/pages/default.aspx? :open\_mouth: Thanks in advance. Jesús Osorio --- ## [Copy data from one table to another](https://forum.inductiveautomation.com/t/copy-data-from-one-table-to-another/11749)
**Author:** [@Curlyandshemp](https://forum.inductiveautomation.com/u/Curlyandshemp)\ **Replies:** 1\ **Last updated:** [May 31, 2016, 12:02am UTC](https://forum.inductiveautomation.com/t/copy-data-from-one-table-to-another/11749 "2016-05-31T00:02:10Z")
I have an existing application where I have a MySQL table recording CIP data from 10 unique CIP systems using transaction groups to insert data into the table called CipRunData Each of the 10 CIP systems has a unique i… --- ## [MySQL Replication fails periodically](https://forum.inductiveautomation.com/t/mysql-replication-fails-periodically/11739)
**Author:** [@Caleb\_Bohon](https://forum.inductiveautomation.com/u/Caleb_Bohon)\ **Replies:** 0\ **Last updated:** [May 27, 2016, 7:38pm UTC](https://forum.inductiveautomation.com/t/mysql-replication-fails-periodically/11739 "2016-05-27T19:38:58Z")
Hi, I am working on a fully redundant Ignition and MySQL system, but it seems to fail if one of the servers is turned off too long. Both machines have: Windows 7 Pro Ignition 7.8.2 MySQL 5.7.12 Community Server I h… --- ## [Freeze table column](https://forum.inductiveautomation.com/t/freeze-table-column/1621)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 10\ **Last updated:** [May 27, 2016, 7:03pm UTC](https://forum.inductiveautomation.com/t/freeze-table-column/1621 "2016-05-27T19:03:18Z")
Is it possible to freeze a column in a table so that when you scroll to the side the column will stay stationary? --- ## [Ubuntu 16.04 LTE](https://forum.inductiveautomation.com/t/ubuntu-16-04-lte/11721)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 7\ **Last updated:** [May 27, 2016, 4:38pm UTC](https://forum.inductiveautomation.com/t/ubuntu-16-04-lte/11721 "2016-05-27T16:38:23Z")
Anyone deployed 7.8.2 to 16.04? I've had a couple of failures, but its on an old laptop that has been upgraded from 13.03 and then 14.04. So it could be something with the environment. I'm thinking about a fresh instal… --- ## [Yokogawa Centum VP](https://forum.inductiveautomation.com/t/yokogawa-centum-vp/11637)
**Author:** [@josercl](https://forum.inductiveautomation.com/u/josercl)\ **Replies:** 0\ **Last updated:** [May 9, 2016, 7:20pm UTC](https://forum.inductiveautomation.com/t/yokogawa-centum-vp/11637 "2016-05-09T19:20:19Z")
Hi guys, has anyone managed to connect ignition to one of these controllers? Do i need an extra module or have to use an OPC? Thanks in advance --- ## [RaspberryPi 3 Terminal Install ability](https://forum.inductiveautomation.com/t/raspberrypi-3-terminal-install-ability/11612)
**Author:** [@Michael\_Tilrico](https://forum.inductiveautomation.com/u/Michael_Tilrico)\ **Replies:** 5\ **Last updated:** [May 5, 2016, 7:04pm UTC](https://forum.inductiveautomation.com/t/raspberrypi-3-terminal-install-ability/11612 "2016-05-05T19:04:43Z")
Hello, This is my first time posting here so short intro my name is Mike and I am an Engineer for Boise Cascade. We are investigating the abilities of RaspberryPi to host a single Ignition screen at every machine center… --- ## [system.db.runQuery fails when inserting into temporary table](https://forum.inductiveautomation.com/t/system-db-runquery-fails-when-inserting-into-temporary-table/11573)
**Author:** [@DavidWisely](https://forum.inductiveautomation.com/u/DavidWisely)\ **Replies:** 0\ **Last updated:** [April 25, 2016, 12:27pm UTC](https://forum.inductiveautomation.com/t/system-db-runquery-fails-when-inserting-into-temporary-table/11573 "2016-04-25T12:27:10Z")
I have the script shown below that tries to run an SQL query against an MS SQL database. The query runs fine in Management Studio. The code fails every time with the error shown below. The problem line is: insert i… --- ## [Raspberry Pi Ignition Install?](https://forum.inductiveautomation.com/t/raspberry-pi-ignition-install/9144)
**Author:** [@flynhawaiian](https://forum.inductiveautomation.com/u/flynhawaiian)\ **Replies:** 22\ **Last updated:** [April 19, 2016, 6:00pm UTC](https://forum.inductiveautomation.com/t/raspberry-pi-ignition-install/9144 "2016-04-19T18:00:47Z")
Is there a way to install ignition on a raspberry pi, and if so how is it done? I have java 8 installed already. --- ## [Ubuntu error - vmware demo project - sharing folder issue](https://forum.inductiveautomation.com/t/ubuntu-error-vmware-demo-project-sharing-folder-issue/11482)
**Author:** [@falko](https://forum.inductiveautomation.com/u/falko)\ **Replies:** 4\ **Last updated:** [April 14, 2016, 2:24am UTC](https://forum.inductiveautomation.com/t/ubuntu-error-vmware-demo-project-sharing-folder-issue/11482 "2016-04-14T02:24:19Z")
Whenever I try to configure sharing folder (on Ignition 7.8 Demo Project VMWare Image, Ubuntu 15.10) I am getting error: "Unable to update run-time folder sharing status: There was an error mounting the Shared Folders fi… --- ## [OPC-UA server, controllogix and read whole array](https://forum.inductiveautomation.com/t/opc-ua-server-controllogix-and-read-whole-array/11423)
**Author:** [@aFlex](https://forum.inductiveautomation.com/u/aFlex)\ **Replies:** 1\ **Last updated:** [March 28, 2016, 3:00pm UTC](https://forum.inductiveautomation.com/t/opc-ua-server-controllogix-and-read-whole-array/11423 "2016-03-28T15:00:10Z")
Hello, I'm using the 7.8 ignition OPC-UA server with a controllogix with firmware version 28, as language to communicate with the server python with this library ( github.com/FreeOpcUa/python-opcua) . However I can't man… --- ## [Hacking History](https://forum.inductiveautomation.com/t/hacking-history/11316)
**Author:** [@CJVR](https://forum.inductiveautomation.com/u/CJVR)\ **Replies:** 1\ **Last updated:** [March 23, 2016, 12:40pm UTC](https://forum.inductiveautomation.com/t/hacking-history/11316 "2016-03-23T12:40:55Z")
I need to access historical data outside of the Ignition ecosystem. So, after some hacking (in the good sense of the word) I came up with the following script to return the closest (back in time) history record for a spe… --- ## [Dynamic Power Table Size](https://forum.inductiveautomation.com/t/dynamic-power-table-size/11386)
**Author:** [@EricFrancoeur](https://forum.inductiveautomation.com/u/EricFrancoeur)\ **Replies:** 0\ **Last updated:** [March 18, 2016, 2:46pm UTC](https://forum.inductiveautomation.com/t/dynamic-power-table-size/11386 "2016-03-18T14:46:52Z")
Hi, I'm trying to get my table the same size as the numbers of row I have it's result set. (I know I'll probably have to set the hight of the root container and window, but I'm not preoccupied with that right now.) I… --- ## [Update data from a table to DB](https://forum.inductiveautomation.com/t/update-data-from-a-table-to-db/11330)
**Author:** [@skallepalli](https://forum.inductiveautomation.com/u/skallepalli)\ **Replies:** 3\ **Last updated:** [March 12, 2016, 11:57am UTC](https://forum.inductiveautomation.com/t/update-data-from-a-table-to-db/11330 "2016-03-12T11:57:40Z")
I have used a binding function to populate data in table.In the execute() method i have done a select query operation which fills the table. When i change the table properties to editable and edit data, it goes back to o… --- ## [Linux best practices](https://forum.inductiveautomation.com/t/linux-best-practices/11205)
**Author:** [@heybales](https://forum.inductiveautomation.com/u/heybales)\ **Replies:** 4\ **Last updated:** [March 3, 2016, 3:42pm UTC](https://forum.inductiveautomation.com/t/linux-best-practices/11205 "2016-03-03T15:42:49Z")
I've been deploying Ignition on linux for 3 years now, and I'm wondering how many others are out there? Is linux an important segment of the Ignition market? I'm not looking for specifics, but curious if I'm a 'thought l… --- ## [Data Collection Error](https://forum.inductiveautomation.com/t/data-collection-error/11249)
**Author:** [@estout](https://forum.inductiveautomation.com/u/estout)\ **Replies:** 1\ **Last updated:** [February 22, 2016, 10:08pm UTC](https://forum.inductiveautomation.com/t/data-collection-error/11249 "2016-02-22T22:08:42Z")
Getting the error: WARN: Simple Query could not be completedYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OPTION SQL\_SELECT\_LIMIT… --- ## [Too many open files... linux file descriptors](https://forum.inductiveautomation.com/t/too-many-open-files-linux-file-descriptors/10953)
**Author:** [@accyroy](https://forum.inductiveautomation.com/u/accyroy)\ **Replies:** 1\ **Last updated:** [February 12, 2016, 2:09am UTC](https://forum.inductiveautomation.com/t/too-many-open-files-linux-file-descriptors/10953 "2016-02-12T02:09:29Z")
I’ve recently been experiencing hard lockups on linux clients used for line display of ignition screens. These screens generally auto rotate every 10-20 seconds and each screen subscribes to around 3-400 tags. After vary… --- ## [The people side of moving the control room to Linux](https://forum.inductiveautomation.com/t/the-people-side-of-moving-the-control-room-to-linux/10996)
**Author:** [@Engianeer](https://forum.inductiveautomation.com/u/Engianeer)\ **Replies:** 1\ **Last updated:** [February 12, 2016, 2:04am UTC](https://forum.inductiveautomation.com/t/the-people-side-of-moving-the-control-room-to-linux/10996 "2016-02-12T02:04:42Z")
Hi everyone. I am wondering if you will share your anecdotes of how you managed the people aspect of a shift from Windows to Linux for your SCADA system. How did you get buy in from the operators? How did you get buy … --- ## [Do More PLC and Ignition](https://forum.inductiveautomation.com/t/do-more-plc-and-ignition/7185)
**Author:** [@Henry](https://forum.inductiveautomation.com/u/Henry)\ **Replies:** 1\ **Last updated:** [February 2, 2016, 1:06am UTC](https://forum.inductiveautomation.com/t/do-more-plc-and-ignition/7185 "2016-02-02T01:06:16Z")
Has anyone used the Do More PLC with Ignition? --- ## [Windows event log](https://forum.inductiveautomation.com/t/windows-event-log/11083)
**Author:** [@amolinse](https://forum.inductiveautomation.com/u/amolinse)\ **Replies:** 2\ **Last updated:** [January 22, 2016, 12:23pm UTC](https://forum.inductiveautomation.com/t/windows-event-log/11083 "2016-01-22T12:23:21Z")
I would like to know if it is possible to write a log in windows event logs using a python script. I found some an script that can do that: win32evtlogutil.ReportEvent(applicationName, eventID, eventCategory=category, … --- ## [Schindler PLC communication](https://forum.inductiveautomation.com/t/schindler-plc-communication/11094)
**Author:** [@umeshgharde](https://forum.inductiveautomation.com/u/umeshgharde)\ **Replies:** 0\ **Last updated:** [January 22, 2016, 4:37am UTC](https://forum.inductiveautomation.com/t/schindler-plc-communication/11094 "2016-01-22T04:37:49Z")
Hi All, I am using schindler PLC . Can anyone tell me how to do comunication between schindler and Ignition SCADA.? Anyone has any sample document please post. --- ## [Slow SQL Query](https://forum.inductiveautomation.com/t/slow-sql-query/11017)
**Author:** [@jruben84](https://forum.inductiveautomation.com/u/jruben84)\ **Replies:** 4\ **Last updated:** [January 21, 2016, 6:45pm UTC](https://forum.inductiveautomation.com/t/slow-sql-query/11017 "2016-01-21T18:45:57Z")
Hi, I'm having a trouble with my SQL Server DB. Basically, I broke up the relationships (it's a long history). After I did that, the DB queries (for example SELECT ...) takes around 10 sec (I see them in the Ignition G… --- ## [Parameterized query performance](https://forum.inductiveautomation.com/t/parameterized-query-performance/11016)
**Author:** [@fledder](https://forum.inductiveautomation.com/u/fledder)\ **Replies:** 1\ **Last updated:** [January 9, 2016, 12:35am UTC](https://forum.inductiveautomation.com/t/parameterized-query-performance/11016 "2016-01-09T00:35:16Z")
Ignition 7.8, MS SQL Server 2008 SP1 Express So I'm doing some query optimization on a report, and I'm having some trouble getting the parameterized query performance to match the unparameterized query performance. The… --- ## [PostgreSQL](https://forum.inductiveautomation.com/t/postgresql/10915)
**Author:** [@vnewman1963](https://forum.inductiveautomation.com/u/vnewman1963)\ **Replies:** 2\ **Last updated:** [December 16, 2015, 9:34am UTC](https://forum.inductiveautomation.com/t/postgresql/10915 "2015-12-16T09:34:19Z")
Has anyone used PostgreSQL with ignition? How was it , Stability etc.. --- ## [Dynamic SQL](https://forum.inductiveautomation.com/t/dynamic-sql/10908)
**Author:** [@Tim](https://forum.inductiveautomation.com/u/Tim)\ **Replies:** 5\ **Last updated:** [December 14, 2015, 2:52pm UTC](https://forum.inductiveautomation.com/t/dynamic-sql/10908 "2015-12-14T14:52:13Z")
How to compare an int column with a varchar column containing SQL comparison operators? If I have a column1 containing 3315 and column2 containing '6287 OR 4596 OR 3315' how can the value of the 2nd column be treated a… --- ## [Allen-Bradley Version 24 - supported yet?](https://forum.inductiveautomation.com/t/allen-bradley-version-24-supported-yet/10909)
**Author:** [@MP-SysEng](https://forum.inductiveautomation.com/u/MP-SysEng)\ **Replies:** 2\ **Last updated:** [December 11, 2015, 10:38pm UTC](https://forum.inductiveautomation.com/t/allen-bradley-version-24-supported-yet/10909 "2015-12-11T22:38:58Z")
Does anyone know if AB Version 24 is supported yet by Ignition? Do we just follow the Version 21 driver setup steps? Do we need any special modules or add ons for this? --- ## [Mysql Slow Select](https://forum.inductiveautomation.com/t/mysql-slow-select/10866)
**Author:** [@MoisesZV](https://forum.inductiveautomation.com/u/MoisesZV)\ **Replies:** 15\ **Last updated:** [December 10, 2015, 6:26pm UTC](https://forum.inductiveautomation.com/t/mysql-slow-select/10866 "2015-12-10T18:26:52Z")
Hi, I have a problem when I try to get data from a mysql db, I have this table : CREATE TABLE \`events\_table\` ( \`id\` int(11) NOT NULL AUTO\_INCREMENT, \`date\` timestamp NOT NULL DEFAULT CURRENT\_TIMESTAMP ON UPDATE CU… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=3) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=5)