# Latest **URL:** https://forum.inductiveautomation.com/latest.md?page=1570 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 1571 --- ## [SSO or straight up LDAP user source?](https://forum.inductiveautomation.com/t/sso-or-straight-up-ldap-user-source/21511)
**Author:** [@alfred\_dussault](https://forum.inductiveautomation.com/u/alfred_dussault)\ **Replies:** 8\ **Last updated:** [January 17, 2019, 3:07pm UTC](https://forum.inductiveautomation.com/t/sso-or-straight-up-ldap-user-source/21511 "2019-01-17T15:07:33Z")
I'm relatively new to Ignition, and this may be covered already in the forums, but I couldn't find a search function in the forums.. so We will be moving to 2 factor authentication with PKI cards in the near future, … --- ## [Database connection status stuck as "Connecting"](https://forum.inductiveautomation.com/t/database-connection-status-stuck-as-connecting/21888)
**Author:** [@brendan.curran](https://forum.inductiveautomation.com/u/brendan.curran)\ **Replies:** 3\ **Last updated:** [January 17, 2019, 2:07pm UTC](https://forum.inductiveautomation.com/t/database-connection-status-stuck-as-connecting/21888 "2019-01-17T14:07:45Z")
I was getting store and forward errors “Returning autogenerated keys is only supported for 8.2 and later servers” so I updated the JDBC drivers. Now when I check the Database connection status in the gateway it seems to … --- ## [\[BUG\]Problems with V8 on Google Compute Instance](https://forum.inductiveautomation.com/t/bug-problems-with-v8-on-google-compute-instance/21848)
**Author:** [@NorthPoint](https://forum.inductiveautomation.com/u/NorthPoint)\ **Replies:** 11\ **Last updated:** [January 17, 2019, 1:37pm UTC](https://forum.inductiveautomation.com/t/bug-problems-with-v8-on-google-compute-instance/21848 "2019-01-17T13:37:20Z")
This is a follow on to several other topics on the same subject. I have installed V8 on both a Linux and a Windows Server machine hosted on Google’s Compute Engine, and I have attempted to work with Perspective on both … --- ## [Table with tags and their values](https://forum.inductiveautomation.com/t/table-with-tags-and-their-values/21882)
**Author:** [@emovspunk1996](https://forum.inductiveautomation.com/u/emovspunk1996)\ **Replies:** 5\ **Last updated:** [January 17, 2019, 1:04pm UTC](https://forum.inductiveautomation.com/t/table-with-tags-and-their-values/21882 "2019-01-17T13:04:34Z")
I am creating a table where it displays the tags and their values. I used a timer to refresh the contents of the table. I cant figure out how to append the values of the two scripting functions which are the system.tag.b… --- ## [Database Schema](https://forum.inductiveautomation.com/t/database-schema/21926)
**Author:** [@damean.thomas](https://forum.inductiveautomation.com/u/damean.thomas)\ **Replies:** 3\ **Last updated:** [January 17, 2019, 12:04pm UTC](https://forum.inductiveautomation.com/t/database-schema/21926 "2019-01-17T12:04:18Z")
What are the best practices for designing database schema for projects? Should there be one db schema for the entire project to contain alarms, historical, etc… or one schema for each area i.e. schema: alarms, historica… --- ## [Named Query - MySQL SET Variable Not Working](https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895)
**Author:** [@hodgins.e](https://forum.inductiveautomation.com/u/hodgins.e)\ **Replies:** 4\ **Last updated:** [January 17, 2019, 10:39am UTC](https://forum.inductiveautomation.com/t/named-query-mysql-set-variable-not-working/21895 "2019-01-17T10:39:42Z")
Is it not possible SET a variable in a SQL query? This does not seem to work but works fine on my server directly. SELECT @foo :=1; SELECT @foo or SET @foo = 1; SELECT @foo --- ## [Using a MySQL variable in a data query throwing me an error](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 3\ **Last updated:** [January 17, 2019, 10:37am UTC](https://forum.inductiveautomation.com/t/using-a-mysql-variable-in-a-data-query-throwing-me-an-error/21826 "2019-01-17T10:37:41Z")
I am doing a data query for a tree component. With this query, I am making a column for the treeItem number, which I accomplished just by ordering correctly and it seems to work fine, my column treeNum corresponds direc… --- ## [Epoch time to time with timezone](https://forum.inductiveautomation.com/t/epoch-time-to-time-with-timezone/4787)
**Author:** [@quper](https://forum.inductiveautomation.com/u/quper)\ **Replies:** 1\ **Last updated:** [July 9, 2012, 9:39am UTC](https://forum.inductiveautomation.com/t/epoch-time-to-time-with-timezone/4787 "2012-07-09T09:39:27Z")
Hello, I am reading register from controller. Register is epoch time like "1341832802". I need to display that as time with local timezone. I am using expression toDate({register path}\*1000), but I am getting time wit… --- ## [Alarm Status Table Question (TAGS)](https://forum.inductiveautomation.com/t/alarm-status-table-question-tags/21918)
**Author:** [@curtisfennell](https://forum.inductiveautomation.com/u/curtisfennell)\ **Replies:** 4\ **Last updated:** [January 16, 2019, 11:11pm UTC](https://forum.inductiveautomation.com/t/alarm-status-table-question-tags/21918 "2019-01-16T23:11:35Z")
Good Day, Have not got to dig into this to far, but I was looking for a way to identify active alarms. That is easily done with the Alarm Status Table. I was able to get that lined out how I liked, but started exploring… --- ## [Flash client window in taskbar](https://forum.inductiveautomation.com/t/flash-client-window-in-taskbar/21920)
**Author:** [@mrogers](https://forum.inductiveautomation.com/u/mrogers)\ **Replies:** 1\ **Last updated:** [January 16, 2019, 10:54pm UTC](https://forum.inductiveautomation.com/t/flash-client-window-in-taskbar/21920 "2019-01-16T22:54:01Z")
I’m using the messaging system to occasionally send clients a message to show the user. I was wondering if anyone had a way to make the window for this client flash in the taskbar, like some other applications do when th… --- ## [Chart Help](https://forum.inductiveautomation.com/t/chart-help/9303)
**Author:** [@tailfire](https://forum.inductiveautomation.com/u/tailfire)\ **Replies:** 8\ **Last updated:** [January 16, 2019, 8:45pm UTC](https://forum.inductiveautomation.com/t/chart-help/9303 "2019-01-16T20:45:29Z")
I have posted about this several times. This link and context is the closest thing that I can find that might help me achieve this result. What I need to do is this: I would like to be able to calculate the integral o… --- ## [Voice Notification Module with Cisco Call Manager](https://forum.inductiveautomation.com/t/voice-notification-module-with-cisco-call-manager/20727)
**Author:** [@Jack\_Lebel](https://forum.inductiveautomation.com/u/Jack_Lebel)\ **Replies:** 1\ **Last updated:** [January 16, 2019, 7:28pm UTC](https://forum.inductiveautomation.com/t/voice-notification-module-with-cisco-call-manager/20727 "2019-01-16T19:28:39Z")
Does anyone know how to connect the Voice Notification Module to a Cisco Call Manager system? I am currently attempting to figure out what would need to be configured within both Cisco and Ignition in order to get this t… --- ## [User Security - User name only with numbers](https://forum.inductiveautomation.com/t/user-security-user-name-only-with-numbers/19137)
**Author:** [@michal.koblasa](https://forum.inductiveautomation.com/u/michal.koblasa)\ **Replies:** 2\ **Last updated:** [January 16, 2019, 5:44pm UTC](https://forum.inductiveautomation.com/t/user-security-user-name-only-with-numbers/19137 "2019-01-16T17:44:43Z")
Hello, in our company we use user identification only with numbers. For example user name is: 321 In ignition project we want to use same system. But when im creating new user in ignition, user form forces me to use on… --- ## [\[BUG-10658\] No titlebar on error box](https://forum.inductiveautomation.com/t/bug-10658-no-titlebar-on-error-box/21825)
**Author:** [@nick.schuetz](https://forum.inductiveautomation.com/u/nick.schuetz)\ **Replies:** 4\ **Last updated:** [January 16, 2019, 4:34pm UTC](https://forum.inductiveautomation.com/t/bug-10658-no-titlebar-on-error-box/21825 "2019-01-16T16:34:15Z")
Error Message box does not have a title bar or allow for resizing. Only seen in vision client. --- ## [How to Manually fire a components expression binding?](https://forum.inductiveautomation.com/t/how-to-manually-fire-a-components-expression-binding/21904)
**Author:** [@paulm1](https://forum.inductiveautomation.com/u/paulm1)\ **Replies:** 2\ **Last updated:** [January 16, 2019, 4:29pm UTC](https://forum.inductiveautomation.com/t/how-to-manually-fire-a-components-expression-binding/21904 "2019-01-16T16:29:47Z")
Let’s say that NumericTextField3.FloatValue property is bound to the following expression - NumericTextField1.floatValue \* NumericTextField2.FloatValue All three numeric text fields are set to True for the Commit On Fo… --- ## [Numeric ldap UID's, ldap attribute as ignition username or prepend/strip character](https://forum.inductiveautomation.com/t/numeric-ldap-uids-ldap-attribute-as-ignition-username-or-prepend-strip-character/21913)
**Author:** [@alfred\_dussault](https://forum.inductiveautomation.com/u/alfred_dussault)\ **Replies:** 3\ **Last updated:** [January 16, 2019, 4:21pm UTC](https://forum.inductiveautomation.com/t/numeric-ldap-uids-ldap-attribute-as-ignition-username-or-prepend-strip-character/21913 "2019-01-16T16:21:42Z")
Hi, I was able to get the user authentication source working against our dirsrv-389 ldap instance with help from the forum. so thanks for that. Now I’m running into a different issue and I’m hoping there is a work aro… --- ## [system.gui.chooseColor not returning Alpha value](https://forum.inductiveautomation.com/t/system-gui-choosecolor-not-returning-alpha-value/11299)
**Author:** [@Duffanator](https://forum.inductiveautomation.com/u/Duffanator)\ **Replies:** 4\ **Last updated:** [January 16, 2019, 3:34pm UTC](https://forum.inductiveautomation.com/t/system-gui-choosecolor-not-returning-alpha-value/11299 "2019-01-16T15:34:30Z")
Is there a way to make the system.gui.chooseColor function return the selected alpha value as well as the RGB values? It doesn't matter what alpha or transparency is selected, it never gets returned. --- ## [Color to string](https://forum.inductiveautomation.com/t/color-to-string/12662)
**Author:** [@Jukka](https://forum.inductiveautomation.com/u/Jukka)\ **Replies:** 4\ **Last updated:** [February 11, 2017, 12:36am UTC](https://forum.inductiveautomation.com/t/color-to-string/12662 "2017-02-11T00:36:11Z")
Is there any way to read the color from the Power table and convert it to string, where R,G and B values can be read? I need to store these values to MySql database as a string. --- ## [What is a locked component?](https://forum.inductiveautomation.com/t/what-is-a-locked-component/21914)
**Author:** [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\ **Replies:** 2\ **Last updated:** [January 16, 2019, 3:04pm UTC](https://forum.inductiveautomation.com/t/what-is-a-locked-component/21914 "2019-01-16T15:04:32Z")
I recently recreated a tree navigator for my application. I replaced all references to the old tree with the new tree so now when I try to delete the old tree, I no longer get the “root container.component.field relies … --- ## [Creating many instances of a data type when AB Logix PLC tag is an array](https://forum.inductiveautomation.com/t/creating-many-instances-of-a-data-type-when-ab-logix-plc-tag-is-an-array/21903)
**Author:** [@nicklas.thystrup](https://forum.inductiveautomation.com/u/nicklas.thystrup)\ **Replies:** 1\ **Last updated:** [January 16, 2019, 12:17am UTC](https://forum.inductiveautomation.com/t/creating-many-instances-of-a-data-type-when-ab-logix-plc-tag-is-an-array/21903 "2019-01-16T00:17:05Z")
I typically use the instance name of the datatype in the OPC Item path so that I can make many instances of the data type by using the multi-instance wizard: However, this time my tags in the Allen Bradley CompactLogi… --- ## [Conecting 2 pcs into the same network](https://forum.inductiveautomation.com/t/conecting-2-pcs-into-the-same-network/21894)
**Author:** [@Sheko29](https://forum.inductiveautomation.com/u/Sheko29)\ **Replies:** 8\ **Last updated:** [January 15, 2019, 9:58pm UTC](https://forum.inductiveautomation.com/t/conecting-2-pcs-into-the-same-network/21894 "2019-01-15T21:58:10Z")
Hello, I’m a little new in ignition environment and I’m having some issues… i want to open my client in 2 different pcs… but my secondary pc create a different ignition network instead of connecting in the principal netw… --- ## [\[BUG-12277\] OpenID to Microsoft Azure](https://forum.inductiveautomation.com/t/bug-12277-openid-to-microsoft-azure/21745)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 9\ **Last updated:** [January 15, 2019, 4:30pm UTC](https://forum.inductiveautomation.com/t/bug-12277-openid-to-microsoft-azure/21745 "2019-01-15T16:30:35Z")
Has anyone been able to get this working? I am getting further with the latest build, but am still getting an error. I believe my Client ID and secret is correct. INFO | jvm 1 | 2019/01/08 09:45:24 | W \[g.D.Rout… --- ## [Transaction Execution not running in set up timer](https://forum.inductiveautomation.com/t/transaction-execution-not-running-in-set-up-timer/21881)
**Author:** [@trishhiyah](https://forum.inductiveautomation.com/u/trishhiyah)\ **Replies:** 1\ **Last updated:** [January 15, 2019, 4:18pm UTC](https://forum.inductiveautomation.com/t/transaction-execution-not-running-in-set-up-timer/21881 "2019-01-15T16:18:20Z")
HI Have you guys encountered that the next execution time is not running in realtime base on the set up of the timer? --- ## [Script to Set Component Security Checkboxes](https://forum.inductiveautomation.com/t/script-to-set-component-security-checkboxes/21792)
**Author:** [@mlindstrom](https://forum.inductiveautomation.com/u/mlindstrom)\ **Replies:** 4\ **Last updated:** [January 11, 2019, 2:36pm UTC](https://forum.inductiveautomation.com/t/script-to-set-component-security-checkboxes/21792 "2019-01-11T14:36:11Z")
I'm creating a popup template with configurable text and buttons on it, for use by a wide range of development and production engineers. Using system.security.getRoles() returns the roles of the active user, which I can … --- ## [OPC-UA Connection Setup](https://forum.inductiveautomation.com/t/opc-ua-connection-setup/21889)
**Author:** [@jonathanlowery](https://forum.inductiveautomation.com/u/jonathanlowery)\ **Replies:** 5\ **Last updated:** [January 15, 2019, 4:07pm UTC](https://forum.inductiveautomation.com/t/opc-ua-connection-setup/21889 "2019-01-15T16:07:02Z")
Trying to connect to 3rd Party OPC-UA Server. (GE Cimplicity). I have trusted Ignitions Client Certificate on the Server. Do I need to install the server certificate onto Ignition. It faults out with “The user identit… --- ## [Can't reach Gateway Home Page](https://forum.inductiveautomation.com/t/cant-reach-gateway-home-page/21884)
**Author:** [@c.bertulli](https://forum.inductiveautomation.com/u/c.bertulli)\ **Replies:** 4\ **Last updated:** [January 15, 2019, 2:17pm UTC](https://forum.inductiveautomation.com/t/cant-reach-gateway-home-page/21884 "2019-01-15T14:17:34Z")
Hi All, I am unable to reach the Gateway Home Page from another computer in the same network and I can’t figure out why :frowning: . The Gateway I’m trying to connect to has the following IP address 192.168.250.2, I’m … --- ## [Direct bit state read from OPC kepserver - Control logix](https://forum.inductiveautomation.com/t/direct-bit-state-read-from-opc-kepserver-control-logix/21873)
**Author:** [@c.sanchez](https://forum.inductiveautomation.com/u/c.sanchez)\ **Replies:** 2\ **Last updated:** [January 15, 2019, 7:20am UTC](https://forum.inductiveautomation.com/t/direct-bit-state-read-from-opc-kepserver-control-logix/21873 "2019-01-15T07:20:22Z")
Hi, is there a way to read dictly a bit state Kepserver OPC with Allen Bradley PLC??? somethig like that: -OPC item Path Int: ns=2;s=FLM.PLC.Global.U\_Eqp\_x.U\_Eqp\_001.S.Bits2 -OPC item Path, bit 15 state: ns=2;s=FLM… --- ## [New Install and the Server Will Not Start](https://forum.inductiveautomation.com/t/new-install-and-the-server-will-not-start/21842)
**Author:** [@David.Reed.Schmidt](https://forum.inductiveautomation.com/u/David.Reed.Schmidt)\ **Replies:** 2\ **Last updated:** [January 15, 2019, 2:14am UTC](https://forum.inductiveautomation.com/t/new-install-and-the-server-will-not-start/21842 "2019-01-15T02:14:18Z")
I uninstalled Ignition 8, deleted the Inductive Automation folder from my computer, reinstalled Java, and a new download of Ignition 8. When I attempt to install the server it will not start. Also, the OS is Windows 10 H… --- ## [Limiting Tag Historian Memory Usage](https://forum.inductiveautomation.com/t/limiting-tag-historian-memory-usage/21880)
**Author:** [@mriederer](https://forum.inductiveautomation.com/u/mriederer)\ **Replies:** 1\ **Last updated:** [January 15, 2019, 2:12am UTC](https://forum.inductiveautomation.com/t/limiting-tag-historian-memory-usage/21880 "2019-01-15T02:12:10Z")
Hi All, I’m looking for a way to limit the amount of memory allocated to a tag historian query via system.db.queryTagHistorian()… or at least prevent the system from bogging down if we perform too large of a query. Mayb… --- ## [\[BUG-12215\] Gateway Startup Fault](https://forum.inductiveautomation.com/t/bug-12215-gateway-startup-fault/21641)
**Author:** [@mattn1](https://forum.inductiveautomation.com/u/mattn1)\ **Replies:** 6\ **Last updated:** [January 14, 2019, 11:06pm UTC](https://forum.inductiveautomation.com/t/bug-12215-gateway-startup-fault/21641 "2019-01-14T23:06:00Z")
I started having some problems with the ignition coming back from the winter break. I tried restarting the vm, and updating to the newest ignition release but have not been able to get the gateway to start. Here is the… [Previous page](https://forum.inductiveautomation.com/latest.md?page=1569) [Next page](https://forum.inductiveautomation.com/latest.md?page=1571)