Newbie Help - Docker onlyoffice/communityserver install instructions - MySQL Section

Workspace
1

NOTES:

  1. Installing on Ubuntu in-house server with Docker and Docker-Compose installed.
  2. The instructions I refer to below are from the Docker Hub onlyoffice/communityserver image (I’m using :latest)
  3. I’m following the Docker install instructions. They do not include Docker Compose instructions, so I’m not even going to try. I am installing OnlyOffice Community Server as a Docker container which I’ll manage under Portainer. I do not want DocSpace since I have my own method for simultaneous editing (not Nextcloud or Owncloud).
  4. I am not a programmer (anymore). I haven’t done command line work since the DOS days in the 1980’s, but I’m comfortable with it on Ubuntu if I have very clear instructions without assumptions.
  5. I tried OnlyOffice online and liked it a lot. I want to self-host for a total of 11 people.
  6. I’m self-hosting to maintain US HIPAA compliance (my customers are mostly in the medical field).
  7. I write a LOT of documentation that has to pass muster with the FDA, so I’m a manager, systems engineer, and tech writer rolled up into one.
  8. The enterprise version is far too expensive considering both Microsoft and Google cover 11 employees for a LOT less.

I will be as clear and concise as possible so I don’t get told there’s a similar thread elsewhere (There is not. I spent 2 hours checking).

The instructions (https://hub.docker.com/r/onlyoffice/communityserver) for installing MySQL state:

Installing MySQL

After that you need to create MySQL server Docker container. Create the configuration file:

echo "[mysqld]
sql_mode = 'NO_ENGINE_SUBSTITUTION'
max_connections = 1000
max_allowed_packet = 1048576000
group_concat_max_len = 2048
log-error = /var/log/mysql/error.log" > /app/onlyoffice/mysql/conf.d/onlyoffice.cnf

Q1. What should be the configuration file name and where should it be located?

The next section states:

Create the SQL script which will generate the users and issue the rights to them. The onlyoffice_user is required for ONLYOFFICE Community Server, and the mail_admin is required for ONLYOFFICE Mail Server in case it is going to be installed:

echo "CREATE USER 'onlyoffice_user'@'localhost' IDENTIFIED BY 'onlyoffice_pass';
CREATE USER 'mail_admin'@'localhost' IDENTIFIED BY 'Isadmin123';
GRANT ALL PRIVILEGES ON * . * TO 'root'@'%' IDENTIFIED BY 'my-secret-pw';
GRANT ALL PRIVILEGES ON * . * TO 'onlyoffice_user'@'%' IDENTIFIED BY 'onlyoffice_pass';
GRANT ALL PRIVILEGES ON * . * TO 'mail_admin'@'%' IDENTIFIED BY 'Isadmin123';
FLUSH PRIVILEGES;" > /app/onlyoffice/mysql/initdb/setup.sql

Please note, that the above script will set permissions to access SQL server from any domains (%). If you want to limit the access, you can specify hosts which will have access to SQL server.

Q2. What should the SQL script be named and where should it be located?

Once these questions are answered, I should be able to get up and running.

Thanks!

2

Hello there,
you don’t seem to know what

echo "my string" > /tmp/myfile.txt

means? This is basic stuff in Linux. With that hint, you should be able to figure it out now :slight_smile:

3

Per the forum guidlines (yes, as a new user of this forum, I have a huge orange box telling the the community guidelines), I hope the following improves the conversation, as it should help for all the potential newbies after me.

So @bermuda I see that you obviously knew everything Linux on day 2 of your first time with Linux. Good for you! You’re very smart! BTW, I only have 2 days (about 7 hours) on Linux.
In this case, it’s not obvious for me. Per your example where you show echo "my string" > /tmp/myfile.txt, the string of text shown in the Docker instructions does not have a filename (in your example “myfile.txt”). So, although YOU know what to do, your example doesn’t show me what to do.
If you’re “hinting” that the text following:

log-error =

or following:

FLUSH PRIVILEGES;

I will say logging and/or flushing do not indicate configuration files. Maybe they do to you, but not so obvious to a day-2 Linux newbie.

Per the forum guidelines, here is my constructive criticism:
I maintain that if one (meaning a person) writes instructions, those instructions should not assume knowledge unless there are prerequisites defined prior to use of such instructions.
You clearly assume that everyone knows Linux in and out. Again, good for you, but not helpful to others who actually do not.

I’m not a hacker, nor do I do I.T., nor am I a daily (or weekly, or monthly) Linux user. This is not my day job nor my hobby. I’m just trying to accomplish a task that should be fairly easy. I installed Docker, Docker-Compose, Portainer, a custom medical CRM, and PostGreSQL. No issues with any of them by following their instructions. I even got the CRM and database talking to each other by FOLLOWING INSTRUCTIONS with only 2 days (maybe 7 hours) on Linux. OnlyOffice instructions are not crystal clear. That’s the fault of the person who wrote them (hopefully not you!), not my fault.

I was hoping the OnlyOffice forum would have skilled, knowledgeable people who want to help others (I belong to many such forums). Enough said considering this particular example of helpfulness.

Here, let’s use some programming terminology… If you’re willing to be more explicit rather than implicit in your advice, I will gladly listen and run with that information. If you want to just “hint” at me, I hope someone else can be more helpful.

I am still hoping to use OnlyOffice for my business needs. I felt very comfortable with it when I used their hosted service.

Thank you

4

Hello there,
I’m not here to teach you how to use Linux. That is not what a forum is for. I’m not a member of onlyoffice and I am not connected to them in any other way.
You are facing a very basic issue or rather lack of basic knowledge. If you don’t understand simple stream redirection “>”, you probably should learn it first. That is what the friendly hint was for.

I explained to you what you are basically looking at, with a very simple example.
How you are not able to follow up on that is beyond me.

Good luck!

5

Hello all,

Here’s a follow-up…

@bermuda is correct!
Nobody is here to teach me Linux. I’m in full agreement with this.

Background:
In my OP, I asked some direct questions about ONLYOFFICE docker instructions. Since the Docker image was put onto the Docker Hub by OnlyOffice, my questions were directly related to that, not to “how do I redirect in Linux” (yes, I know the difference between > and >>).

Here’s the Update:
When my 3 software people came in this morning (Monday), I sent each of them, individually at 15 minute intervals, an email with the same questions as my OP.
Two of them were snarky about it and skirted around the direct answer (sound familiar?).
After about an hour, I had a meeting with both of them along with the business attorney where they were immediately fired for cause (failed to give an answer they knew to their manager) and removed from the premises.
They were not at the job to teach me (unless I asked). They were there to move the business forward without impedance.

The third software person gave me the exact filenames and where to put them. Simple and quick. I’ll do the install tonight. If successful, he’ll get a hefty raise because I know I can trust him. After all, I’m saving a lot of money without those other two.

I know that some people are asking why I didn’t just have my software people do this install for me. That’s a valid and important question!
Per several of the business contracts, I am the only person permitted to have access to the HIPAA compliant servers, except at a user level through a web portal. For example, an OnlyOffice user creating, editing, or viewing documents. If you’re not from the USA, you may not understand that it is similar to GDPR as far as privacy, but far more rigid in HOW the privacy is accomplished and for how long and by whom (such as server locations, backups, training, access, etc.).

So there it is… bermuda actually helped me weed out 2 useless people from my organization by showing me how I don’t want to be treated. After all, in a professional environment (which I hope OnlyOffice is), when a question is asked, it should NOT be an opportunity to put down someone’s lack of wider knowledge in order to feel superior to them. Be helpful and efficient! Teach if asked to teach (if you want to).

What happens now?
All future potential software people will have these same OP questions asked on their initial phone interview and, of course, more in-depth knowledge tests for on-site interviews. That should weed out most of the “superior mentality” of the non-helpful people. I have similar tests to weed out Engineers who claim their expertise. I’m getting about 35% of professional engineers who can actually pass the tests (they are given 2 hours to do what the passing engineers do in about 30 minutes).
All-in-all, this exercise over the weekend taught me something that will save my company hundreds of thousands of dollars per year by eliminating resource waste, so for that I am grateful.

6

Hi @daconlyoffice,
Instead of manually configuring the database config files, I’d recommend that you choose the following way to install ONLYOFFICE Workspace:

This way you will get a fully automated installation via script. Please let me know if this helps.

7

Well, that could have been a very funny story, but it fear, it is rather a really, really sad one.
Trying to convince people, that someone who is clearly out of his depth, as he struggles to understand even the simplest basic semantics, gets anyone actually fired, while he can keep his imaginary job and even brag about his obvious lack of knowledge, is the most -lets say- unfortunate step you could have taken.

Your initial issue has nothing to do with onlyoffice itself. And as you stated yourself, you are the only one who had it. So, everyone else seems to be capable to follow the instructions successfully.

8

Hi Carl,

Your suggestion worked perfectly.
Also, my employee’s instructions worked perfectly, too, using the manual configure method.
Since I have several servers, I used 2 for this installation test, 1 per method.
I’m going through all the setup now, duplicating the setups, but so far so good.

Thank you!