Like what? A customer management system? Accounting?
this post was submitted on 17 Feb 2024
63 points (95.7% liked)
Selfhosted
40779 readers
1796 users here now
A place to share alternatives to popular online services that can be self-hosted without giving up privacy or locking you into a service you don't control.
Rules:
-
Be civil: we're here to support and learn from one another. Insults won't be tolerated. Flame wars are frowned upon.
-
No spam posting.
-
Posts have to be centered around self-hosting. There are other communities for discussing hardware or home computing. If it's not obvious why your post topic revolves around selfhosting, please include details to make it clear.
-
Don't duplicate the full text of your blog or github here. Just post the link for folks to click.
-
Submission headline should match the article title (don’t cherry-pick information from the title to fit your agenda).
-
No trolling.
Resources:
- selfh.st Newsletter and index of selfhosted software and apps
- awesome-selfhosted software
- awesome-sysadmin resources
- Self-Hosted Podcast from Jupiter Broadcasting
Any issues on the community? Report it using the report flag.
Questions? DM the mods!
founded 2 years ago
MODERATORS
I don't yet know the scope of everything I might need, but right now I believe that a customer management system is the focus. A way to input their details and payment information to have an automatic recurring membership.
I don't think I really need a way for them to view their account as it won't have any fancy features. I just need to know that they are a member and have a membership renewal. They can sign up and cancel in person or over the phone (I'm not making it disgustingly hard for people to cancel like the large gyms).
On top of that I would imagine it would be nice for the software to keep track of my total number of patrons and thus a total income amount
payment information
You can nope alllllllllll the way out of that. Payment information means credit cards means PCI compliance. That's something you'll definitely want to outsource.
And need a paymemt gateway with a bank which can count as cloud.
I understand the payment will have to connect to the internet and be outsourced but I want all my customer data to stay on my server
It's honorable to want to keep all customer data within your control, but seriously unless you already have experience dealing with PCI compliance, that's one part you should definitely offload to a payment processor. This might even be a clause in your insurance (Depending on what it covers)
I don't have any particular software in mind to recommend, but I'd bet they probably have some sort of integration with processors like Stripe or something
This and medical info I will not self host personally. Try to do due diligence but I let someone else take the blame for a breach.
Something like odoo (https://www.odoo.com/) might work?
You probably aren't going to find something that works for your specific needs right out of the box, so your best bet would be finding a platform that gets you 80% of the way there and provides enough of a plugin mechanism that you can develop the remaining 20% of the functionality yourself
There's a lot to look into there. It covers quite a bit so it could work. I'll research this for sure. Thank you a lot!
I've used odoo before, it is a large piece of software and can be modified to do lots of things. Most likely you will be able to get it to do what you want. You'll probably need the e-commerce module, there is probably some sort of mode for subscriptions. You can also add the CRM on top for marketing, etc. there is also the booking module (iirc) which is maybe useful for sessions with trainers etc. maintenance might also be useful.
I did see the subscriptions module. Once you add enough modules it becomes a paid service. I have yet to find info on if Odoo is subscription based or a one time payment. I don't mind paying for a software but do not want a subscription service.
You can easily host the community edition in Docker or otherwise. Odoo has a steep learning curve but it's very versatile. It can definitely do what you describe.
That's good to know. I'll look into the Docker image. Thank you
No worries. It has a stripe integration, too, so it's easy to handle payments without having to hold customers' credit card info.
it is subscription, you pay per user per month. It is quite cheap imo, but I understand if you don't want to pay any subscription. But in that case you can just try to self host it instead.
Okay I see. I'll have to check how much it is. So this can be self hosted for free with the tradeoff of having to figure out how to do that? If that's the case then I could even start off with the ease of the subscription and over time get my self hosting setup figured out.
Yes it can be selfhosted in theory, I haven't personally tried it though. That sounds like a good plan.
https://www.odoo.com/documentation/17.0/applications/finance/payment_providers.html
Nice, it has a recurring payment model (subscriptions) and it integrates with payment processors like Stripe. This looks exactly like what OP needs.
Disclosure: I did not have any business myself.
Maybe it will be worth considering starting with spreadsheets? They are super super flexible and what have been done for years. You would have time to see what scope and needs you have for more dedicated and automated system down the road. Switching ERP software is very painful and time consuming, while importing spreadsheet to ERP is basic transition.
I'm not opposed to tried and true simple solutions. I think my wife would find it much easier with an automated system however. I really need a way for people to pay for their memberships and keep track of that and I have no background with this stuff. I think having a system that's already designed for this would make opening the gym less daunting. I appreciate the thought
I have been using Odoo for years to generate invoices for my little IT business. I don't use any features that cost money. I am working a web store for my wife and have been playing with erpnext. It is written in Python / Javascript and can be installed on your own servers. I has a lot of features that cost in Odoo but are free and looks like it is easer to modify.
Someone else mentioned ERPnext too. It looks interesting. Certainly a possibility. Thank you
I use wger at home and it's waaaay overkill. Designed for the gym part, probably not the whole package
This looks to be just for writing out workout routines, not a client management software. It might be useful one day so thank you anyways
https://www.turnkeylinux.org/ check them out for a lot of your business, self-hosted needs. Odoo, like others have said, is on there. I once used moodle for new employee onboarding and training.
I am confused as to what this is exactly. Is it some type of operating system that makes installing certain software easy like Docker or something?
It was suggested to peruse a big list of projects that might work for you. They pre package a huge amount of open source projects to run on say AWS in their own linux distro. If you find a project that looks interesting you can go to that projects website and look at docs and stuff. Then run that project how you want.
I see. Thank you
I've been using Ubiquiti/Unifi for my brewery setup (cameras, several private networks, phone tree stuff). It comes with some pretty solid management software accessible through the local network, but under the hood, everything's just running Alpine. There's a bit of a learning curve if you keep the management software installed (firmware updates wipe out the crontab, for example), but you can customize it pretty aggressively if you know your way around a terminal.
I used to love Ubiquiti but they're turning into cunts these days. I also heard there's been a lot of people leave and low morale due to the enshitification of the products.
I've since put OpenWRT onto my ERX and ER4. Will likely put it on the UAP-LC next to get rid of it entirely.
That honestly sounds like the way to go, and I'll probably look into it when I have more time. I'm more a software person than a sysadmin and I'm not wildly confident that I won't accidentally close us down for a few days without a lot of prep. 😆
What sort of stuff are you running? Inventory and stock? Do you have any temperature control, gravity or production record keeping software?
I've been searching for brewery management software that I can self host. Currently just have odoo for invoicing.
Inventory is through our POS/processor and production records are through Beer30 (though I have plans to write my own and open source it when I have time; we just opened and we're all still running pretty hard doing new-open stuff). We're also technically a nano-brewery, so anything we're doing is a little bespoke (i.e., I think it's a very situational setup) right now.
The biggest thing from a brewery-specific side that we're doing is controlling the brewhouse. We're running an all-electric system, and all the heating and cellar controls expose UIs over the LAN. In addition to being generally nifty, we're using Unifi to separate brewery-specific stuff onto its own network and the built-in VPN hosting (I opted for the OpenVPN option) to expose that network security. This allows our brewer to do stuff like check the temperature from home or set the boil kettle to start running before he leaves the house. (The useful thing about the UDM (primary server) running Alpine is that I have a task that essentially functions as dynamic DNS and updates an A record with our domain provider so he can always log in at a known hostname).
It also integrates with cameras, phone, and menu boards, which are all useful for the FoH side of things.
All-in-all, we're not doing that much with it yet, but it's pretty nice to use so far, and being a software engineer, I'm excited for the possibilities of useful stuff I can host on it.
I'll keep them in mind when I design my network. Thank you
For camera software, zoneminder is a classic, and frigate is probably the new kid in town. Web hosting will depend on your web developers but docker will have you covered for almost anything. Probably just steer clear of asp.net dev shops.
Why negative on asp.net? I'd steer more away from WordPress though TBH.
I'm assuming OP wants to run on Linux and I'm not familiar enough with .NET Core to know how much or how easily you can run it on Linux. I know some things definitely run, I just don't know how much.
Ah. Old asp .net standard I don't think is cross platform, but core is fully supported in Linux. I mainly support these applications at my job so was kinda surprised to see someone not recommend it.
You might want to look at ITflow. Despite the name, it is really a generic tool for businesses or associations, not IT. Foss and here's a demo
Odoo might have bits you want/need. Linux based.
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
| Fewer Letters | More Letters |
|---|---|
| DNS | Domain Name Service/System |
| Unifi | Ubiquiti WiFi hardware brand |
| VPN | Virtual Private Network |
3 acronyms in this thread; the most compressed thread commented on today has 5 acronyms.
[Thread #526 for this sub, first seen 19th Feb 2024, 05:15] [FAQ] [Full list] [Contact] [Source code]