Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1

TOPIC: MySql database problem

MySql database problem 4 years 7 months ago #10357

  • nicope13
  • nicope13's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Hi everyone, I am a beginner with Proview and I just followed a tutorial to learn how save variables in a MySql database.
I think my MySql configuration is good, I allow all access to pwrp user.
I use DsTrend and DsTrendCurve and it works, I can see the variable fluctuations in my DsTrendCurve object.

My problem is I can't find the database create by Proview (doesnt appear with the command "show databes" in mysql monitor). I also noticed that the runtime monitor button is yellow and not green.

Do you think there is a connection problem with mysql ?

Thanks a lot.

tutorial :
The administrator has disabled public write access.

MySql database problem 4 years 7 months ago #10358

  • claes
  • claes's Avatar
  • OFFLINE
  • Platinum Boarder
  • Posts: 3177
  • Thank you received: 502
  • Karma: 133
Hi nicope,

The data for the DsTrend and DsTrendCurve are stored in the realtime database, not in mysql.
If you want to store in mysql you should have a look at the SevHist, SevHistMonitor and SevServer objects.

/Claes
The administrator has disabled public write access.

MySql database problem 4 years 7 months ago #10359

  • nicope13
  • nicope13's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Thanks for your answer, sorry for my imcomplete post.
I have also configured this objects.

Here is a screenshot of my server node configuration :
Capturedcrandu2019-08-2711-25-36.png
The administrator has disabled public write access.

MySql database problem 4 years 7 months ago #10361

  • nicope13
  • nicope13's Avatar
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Problem solved.

There was a connection problem to mysql.

To solve it I modified the file named : connection.dmsql
I add the mysql pwrp client password next "PASSWD.:" (value was null).


Maybe this solution will help someone.


Nicolas.
Last Edit: 4 years 7 months ago by nicope13.
The administrator has disabled public write access.
  • Page:
  • 1
Time to create page: 8.119 seconds