Recent Posts

51

Koozali SME Server 10.x / Re: Remote Access to MariaDB

« Last post by isotropic on July 19, 2025, 01:49:10 PM »

To answer your question:
I only want an internal network. 192.168.160.0. That's it. No external access.
On this network, with Tomcat and MySQL, I can install small applications to help with its operation. Things like student registration. Books in the library. Things like that. No external access. A completely internal network.

I'm very happy and gratified to have discovered SME Server. And I intend to participate more actively. Since I don't have enough knowledge to help with development, I intend to participate in testing. Or even through donations.
I want to thank you for the help I'm receiving. And I want to say that I would never try to jeopardize the work I'm trying to develop.
Thank you.

52

Koozali SME Server 10.x / Re: Remote Access to MariaDB

« Last post by isotropic on July 19, 2025, 01:45:27 PM »

Hello, gentlemen, good morning!
I'm Isotropic, from Brazil.
I'm a JAVA programmer and I study at a Philosophy School.
This school needs support in the IT area.
That's why I decided to learn the basics of Linux so I could set up a network where teachers could share their work. The most basic thing possible. I tried TruNAS. Rokstar. Several options available. Until I discovered SME Server. Love at first sight! I'm studying to learn a lot and be able to participate in the version 11 testing.

53

Koozali SME Server 10.x / Re: help installing tomcat

« Last post by ReetP on July 19, 2025, 08:34:10 AM »

Cool!!

54

Koozali SME Server 10.x / Re: Remote Access to MariaDB

« Last post by ReetP on July 19, 2025, 08:33:54 AM »

I can access MariaDB. I created a user with a password. But I need to access it remotely. Can you teach me how to open port 3306?

So always check the docs - you'll learn more that way.

https://wiki.koozali.org/Mariadb105

And, if it's not too much to ask, can you show an example of a connection via JDBC?

I have no experience of that. See the notes in the wiki on urls.

Also, bearing in mind your questions (Tomcat too) be VERY careful with what you are doing.

Exposing services remotely when you're not really sure of what you are doing is a rapid route to getting yourself hacked.

Always ask yourself "do I absolutely have to do this or is there a better way?"

As you haven't described what you are actually trying to achieve in either of your posts, I can see you becoming a XY Problem if you aren't careful...... I'm not trying to be unkind, just saving you from yourself!!

https://xyproblem.info/

You may want to read this too.

https://forums.koozali.org/index.php/topic,54724.0.html

Take a deep breath and start from the beginning!!

55

Koozali SME Server 10.x / Remote Access to MariaDB

« Last post by isotropic on July 19, 2025, 04:41:42 AM »

Good evening, gentlemen.
I can access MariaDB. I created a user with a password. But I need to access it remotely. Can you teach me how to open port 3306?
And, if it's not too much to ask, can you show an example of a connection via JDBC?
I use SME 10.1.
Thank you in advance.
Best regards.

56

Koozali SME Server 10.x / Re: help installing tomcat

« Last post by isotropic on July 19, 2025, 02:30:06 AM »

Good evening.
Coming back to thank you for your help.
I was able to install and configure Tomcat. It's running perfectly thanks to the support I received.
Thank you.
Best regards.

57

Koozali SME Server 10.x / Re: help installing tomcat

« Last post by ReetP on July 18, 2025, 11:37:06 AM »

This is not a 5 minute job.

A start is here

https://linuxize.com/post/how-to-install-tomcat-9-on-centos-7/

You can follow the first parts down to the systemd unit file.

Create that and then you will need a dropin file as per this:

https://forums.koozali.org/index.php/topic,54569.msg286027.html#msg286027

THisis the important bit:

/etc/systemd/system/tomcat.service.d/51custom.conf

Code: [Select]

[Install]
WantedBy= sme-server.target


(You can do the same thing but put it in /usr/lib/systemd/system is you prefer)

You will need a key:

Code: [Select]

config set tomcat service status enabled access public
Probably a post-upgrade/reboot and see if the service is up:

Code: [Select]

systemctl status tomcat
After that then you need to look at access - you could use AllowHosts and TCPPort keys in the config above to open ports and limit access.

Note :

In most cases, when running Tomcat in a production environment, you will use a load balancer or reverse proxy . It’s a best practice to allow access to port 8080 only to your internal network.

This is only a VERY rough and untested guide - you will lneed to do a lot of reading, and I suggest you build a test VM and experiment on that before using it in production.

Note also - v11 is around the corner. Instructions would be similar though.

58

General Discussion / Koozali SME Server v11 2025-07-15 - view from the coalface

« Last post by ReetP on July 18, 2025, 10:17:46 AM »

Churning Betas.

Over at the sweatshop ie our Rocket.Chat instance - there is lots of activity.

Trevor is thrash building Beta isos as we try and refine a few bits.

If you are testing ask us about zsync.... Saves a LOT of downloading.

Again, PLEASE help. We just want your time to rinse/repeat installs, and click everything to make sure it works. No dev skills required.

Note we have NOT really touched contribs beyond a few test ones.

Once we have a Beta we'll look at them properly. So Beta is pretty good to go, but if you rely on a lot of contribs you'll have to wait a bit (did I mention helping us to get this done faster?)

So a proper release is tantalisingly close!

59

Koozali SME Server 10.x / help installing tomcat

« Last post by isotropic on July 18, 2025, 04:31:12 AM »

Good evening, gentlemen.
I'm Isotropic, from Brazil. And I came to ask: can anyone help me install Apache Tomcat?
I use SME version 10.1.
I'd like to install Tomcat version 9.x, but I always get an error. It runs at boot but stops shortly after.

Stopping ProtocolHandler http-nio-8080.

Thank you.

60

General Discussion / Re: Koozali SME Server v11 2025-07-08 - view from the coalface

« Last post by TerryF on July 17, 2025, 10:01:19 PM »

To any who do read this topic and are curios, testing of the beta iso is just about on the money, just a little window dressing to go, as a non business and just home user I would be happy to use in a prod environment.