MySQL Data source setup

[pradeepdissa]

Hi I am trying to setup MySQL data base for reading and writing data point values.
So far I found the method to write data in to the MySQL data base (using "watch list") but I can not find a way to read data into "watch list".
when I press the statement test button ("Execute" button) in SQL properties page I can see my data. Please help me to configure this .

Summary:
what I need is, using a Gambas3 program I will update or read a table in MySQL database (control or monitoring points). I want to use the same database and same data points in mango Scada to read or control

Thank you all

[JoelHaggar]

I don't fully understand your question but here is the documentation on the SQL Data Source:
http://infiniteautomation.com/wiki/doku.php?id=datasources:sql_data_source

I think what you need to do is to configure data point under this data source.

If you want to use the entire Mango database with MySQL see the installation documentation:
http://infiniteautomation.com/wiki/doku.php?id=installation:configuration#mysql

[pradeepdissa]

Hi Joel,
thanks for the quick reply

I had a look into both documents you mentioned at the beginning.
my requirement is not to have entire mango data base on MYSQL.

I want to:

1. setup MYSql data source In data sources. (this step is successful)

2. I can update values into the MYSql database using update statement ,but I don't know that how to read a value from MYSql database into Mango (the statement)

I tried several ways eg:

typing "SELECT ......" statement inside the update query area (I may be silly because it self says that "Update statement"

without typing anything inside the query area.
nothing is successful. below is what I get

Your advice is highly appreciated

Regards.

[JoelHaggar]

This forum is for Mango and not scadaBR which is a derivative of a much older version of Mango. That said I think your problem is that for the row based query to work you need to have only three columns. Try just selecting data_point, data_value and ts from the database so that you don't get the id column.

[pradeepdissa]

Great it did work !!

much appreciate the advise.
I think, I started using Mango M2M (the great Scada product) around 2010. My gratitude goes to the developers.

When I installed Mango on Windows it did work like a charm, but every time I tried installing on Ubuntu gave me a headache. finally I did manged to install on a Ubuntu server (I don't want to allocate more resources just for running a server)

The reason I want to install Mango on Ubuntu desktop version is the Gambas3 is another opensource SDK.

when I did some google research I found that ScadaBR which is a derivative from Mango M2M, but easy to install, and I can install it on Ubuntu desktop.

What soever I still love Mango M2M. much appreciate that if you can direct me to sort out the Mango Ubuntu installtion issue. I know this Forum is not for discussing installation issues.

Anyway thank you once again for helping me
Have a great day !!