GUI for Mariadb on the Raspberry Pi

Having issues? Post them here, and help other users.
User avatar
zinfra
Junior Member
Posts: 9
Joined: Thu Mar 22, 2018 7:28 am
Location: Suisse
Contact:

GUI for Mariadb on the Raspberry Pi

Post by zinfra »

Is there a graphical interface to save NEMS Database Tables?
In the beginning I could use PhpMyAdmin, but now it doesn't work anymore.
User avatar
Robbie Ferguson
Posting Freak
Posts: 835
Joined: Wed Mar 07, 2012 3:23 pm
Location: Ontario, Canada
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by Robbie Ferguson »

No, there is not, and I would advise against adding one.
User avatar
zinfra
Junior Member
Posts: 9
Joined: Thu Mar 22, 2018 7:28 am
Location: Suisse
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by zinfra »

this is not good...
on migration 1.5.1 to 1.5.2
NConf lost half of the data
...have an interface to save and restore SQL data...
would help
User avatar
Robbie Ferguson
Posting Freak
Posts: 835
Joined: Wed Mar 07, 2012 3:23 pm
Location: Ontario, Canada
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by Robbie Ferguson »

You'd be better in that case to get me to assist with the Migrator issue you've experienced. Hold onto your backup.nems file. If you're a Patron, open a priority support issue on the Discord server. If not, best to jump on #General or post here and I'll do my best to assist.

Cheers.
Robbie
User avatar
zinfra
Junior Member
Posts: 9
Joined: Thu Mar 22, 2018 7:28 am
Location: Suisse
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by zinfra »

I think I understand where the problem is
the script does NOT import the OS table...

Importing: contact
Importing: contactgroup
Importing: host-template
Importing: host
Importing: hostgroup
Importing: host-dependency
Importing: service-template
Importing: service
Importing: advanced-service
Importing: servicegroup
Importing: service-dependency
Done.
User avatar
Robbie Ferguson
Posting Freak
Posts: 835
Joined: Wed Mar 07, 2012 3:23 pm
Location: Ontario, Canada
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by Robbie Ferguson »

So you've created custom OS's and they're not getting imported? That's no problem; your Migrator backup has all your data - just hold onto the backup.nems file so you don't lose it.

You still have your NEMS Server running where you pulled the backup.nems from? If yes, run a support.nems for me so I can assist.
Last edited by Robbie Ferguson on Mon Aug 17, 2020 8:20 am, edited 1 time in total.
Reason: Add link to docs.
User avatar
zinfra
Junior Member
Posts: 9
Joined: Thu Mar 22, 2018 7:28 am
Location: Suisse
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by zinfra »

Done
I sent the files of the 2 versions
1.5.1 Current
1.5.2 migrated

Thx ;)
User avatar
zinfra
Junior Member
Posts: 9
Joined: Thu Mar 22, 2018 7:28 am
Location: Suisse
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by zinfra »

seems okay
after a restore of the nconf table from version 1.5.1

mysql -u root -p nconf < /tmp/nconf.sql
User avatar
Robbie Ferguson
Posting Freak
Posts: 835
Joined: Wed Mar 07, 2012 3:23 pm
Location: Ontario, Canada
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by Robbie Ferguson »

Thanks zinfra.

What do you mean by 'seems okay'? Do you mean you solved your issue?

Please confirm so I know if I'm to look through your support.nems or if you are already set.

Cheers.
User avatar
zinfra
Junior Member
Posts: 9
Joined: Thu Mar 22, 2018 7:28 am
Location: Suisse
Contact:

Re: GUI for Mariadb on the Raspberry Pi

Post by zinfra »

I checked the tables
after rewriting the NConf database in mariaDB
the features are now correct and complete.
Post Reply