Gourmet

Central database storage?

Asked by Ned Hedrick

Is it possible to have the data reside on a network drive? I want to run the application on two Linux laptops, and share a central data repository on my home NAS.

Thank you in advance!

Question information

Language:
English Edit question
Status:
Solved
For:
Gourmet Edit question
Assignee:
No assignee Edit question
Solved by:
Harald Franzen
Solved:
Last query:
Last reply:
Revision history for this message
Best Harald Franzen (harald-franzen-lotcavediving) said : 		#1

Yes, it is possible.
I have the recipes in a centralized MySQL database.
Then, on Ubuntu, I edit the following file: /usr/share/applications/gourmet.desktop
Line 78 holds the Exec command that will lauch the application. I change that to: Exec=gourmet --database-url=mysql://user:password@serverurl/databasename
where user, password, serverurl and databasename are the items you change to fit your configuration.

Revision history for this message
Ned Hedrick (nhedrick) said : 		#2

Thank you!. That looks like it is a good solution for me.

Revision history for this message
Harald Franzen (harald-franzen-lotcavediving) said : 		#3

Yes you can.

I have my recipes in a MySQL database on a central server. All clients
can connect to it and retrieve the recipes, etcetera.

This is how I did this:

I created a MySQL database with a user and a password on a central
server accessible by the various clients.

Then - this is under Ubuntu - I edited the following file (for each
client!): /usr/share/applications/gourmet.desktop

Line 76 is the exec-line, where the application is actually started. It
starts with exec= . I changed that to reflect the different database,
location and credentials: Exec=gourmet
--database-url=mysql://user:password@serverurl/database

Of course, in your environment, "user", "password", "serverurl" and
"database" have specific values.

Good luck and don't hesitate to ask questions!

Best,

Harald

--
Harald Franzen
SAS Centre de Plongée Souterraine
1420, Chemin des Trois Fons
46330 BLARS
La France
I: www.lotcavediving.eu
E: <email address hidden>
M: +33(0)6-45639437

Op 26-11-2021 om 16:30 schreef Ned Hedrick:
> New question #699648 on Gourmet:
> https://answers.launchpad.net/gourmet/+question/699648
>
> Is it possible to have the data reside on a network drive? I want to run the application on two Linux laptops, and share a central data repository on my home NAS.
>
> Thank you in advance!
>