-
-
Notifications
You must be signed in to change notification settings - Fork 162
Greater Lincolnshire species data bank #1116
-
Link: https://glincsson.glnp.org.uk/
This is an SQLPage based system I've developed for the organisation I work for to collate information on species within our area, running on FreeBSD and MariaDB. Collating the information is still a work in progress, but there's a complete example 'data sheet' at https://glincsson.glnp.org.uk/view?taxon_list_item_key=NBNORG0000018213 which pulls in all the various elements of information and a complete group listing at https://glincsson.glnp.org.uk/taxon_group?taxon_group=60 showing various colour coding and indicators.
SQLPage has made it trivial to implement this and allowed us to easily add in new aspects based on feedback from others. Most of it is stock SQLPage, but there are a couple of simple modified/custom components, with some custom javascript to allow saving png images of the maps. Its something we've long been wanted to do and have attempted in various guises over the years but using SQLPage is the first time we've been able to achieve exactly what we wanted (and more). And it's been fun!
Beta Was this translation helpful? Give feedback.
All reactions
-
👍 2
Replies: 3 comments 3 replies
-
I'm always happy to see projects like this 😃 Congrats on the launch !
Beta Was this translation helpful? Give feedback.
All reactions
-
Hi, I’m asking for a little help. I’m trying to run in a FreeBSD jail and it will run fine from the command line within the jail, but so far I cannot get it running as a service. It says it starts but it never does show up "ps aux". I know for sure it’s not writing to the user pid file, and I found that the .json file is not parsing. So I set up variables to take the place of the .json file, and it works fine from the command line. I’m using SQLite but I’m prob gonna switch to Maria or Postgres once I get it running. Can you help me? A look at your RC.d script and other configuration files "passwords blanked out-" would be most helpful. Thank you
Beta Was this translation helpful? Give feedback.
All reactions
-
Not sure I can be of much help as we use a hosted environment - I just use a basic script i.e. exec sqlpage and set it to run as a daemon using the hosts dashboard.
Are you looking at the same sqlpage.json file that sqlpage is looking at/for? That was the only issue I had - when the script first ran it created an sqlpage directory in the same location as the script into which I placed sqlpage.json, but sqlpage was looking for it in the public webroot (the default working directory for web daemons on my host).
Beta Was this translation helpful? Give feedback.
All reactions
-
Thank you for replying. Since I can get the server running from the command line I'm just going to write a simple daemon script and avoid the FreeBSD RC.d subsystem.
I'm convinced it's erroring out on the json file. So I will try setting the variables in the startup script.
I didn't know I could run a daemon without the RC subsystem. Thanks for the idea. I'll let you know when I get back to it if this gets it running!
Thanks
Karl pieleck
Beta Was this translation helpful? Give feedback.
All reactions
-
So. you actually did help me.
As you said, I made sure it was going after the correct .json file, and it wasn't. So I added the variable (name=sqlpage)
SQLPAGE_CONFIGURATION_DIRECTORY="/usr/local/etc/${name}/"
Then as soon as i started up Sqlpage, it threw a parse error. So I stripped out everything in the json file except for the configuration lines and removed the comma's from the end of the lines, and it worked from the command line.
Then as you suggested, I set up a simple Nohup command to run it in the background, and it's running perfectly. I built my first table to display data today.
Thanks again
Karl Pieleck
Beta Was this translation helpful? Give feedback.
All reactions
-
🚀 1