MySQL persistence not showing in HABmin

, ,
1

Hi,

I saw in the forum that I should install HABmin to see if MySQL persistence is working however I don’t see anything shown there when I select MySQL in persistence tab. Here’s what I see:

Screen Shot 2016-05-02 at 6.50.54 PM.png2394×1292 184 KB

Here’s the configs at openhab.cfg:

    mysql:url=jdbc:mysql://127.0.0.1:3306/openhab

    # the database user
    mysql:user=openhab

    # the database password
    mysql:password=openhab

I don’t get any error in the logs with regards to MySQL database connector so I am not sure what is missing! Any help is greatly appreciated.

2

If you don’t see any persisted items, it’s likely that your mysql.persist is wrong … or missing at all.

(take a look at the configuration section)

1 Like
3

@sihui
This is my .persist file. Is there anything wrong with it?

pi@raspberrypi:/opt/openhab/configurations/persistence $ cat mysql.persist 
    Strategies {  
         default = everyChange
    }  
      
    Items {  
          * : strategy = default, restoreOnStartup  
    }
4

I don’t use mysql persistence, therefore I can only guess:

Try:

Strategies {  
         default = everyChange
    }  
      
    Items {  
          * : strategy = everyChange, restoreOnStartup  
    }

If that doesn’t work, try to persist only a single item instead of a “*” wildcard. If you are not successful on a single item the problem is somewhere else …