# Rights problem at installatioin, delete cache, and some strange things over night **URL:** \ **Category:** Mautic 5 Install/Upgrade Support\ **Created:** [April 13, 2024, 5:48am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661 "2024-04-13T05:48:53Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 13, 2024, 5:48am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/1 "2024-04-13T05:48:53Z")
Since 5.0.4 i have right problems: Over night something happend, so had now in the morning a 500 error message. After ```auto chown -R www-data:www-data /var/www/html/mautic chmod -R 755 /var/www/html/mautic ``` all works again. At installation and deleting cache sometimes also these rights problems. I have a virtual Ubuntu server 22.04 at [hetzner.com](http://hetzner.com) Can anyone give me an idea why that comes? Btw: Moodle runs on this machine also stable as a tank. So it must come from Mautic 5 0 4, because 4.4.10 didn’t have these problems. ---
**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\ **Post date:** [April 13, 2024, 8:36am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/2 "2024-04-13T08:36:40Z")
Hi, how did you do the update? It sounds like the user used for the update is neither www-data nor in the group of www-data. Did you use a plain Ubuntu Image? Setting up a web server is not a plain vanilla linux server. I recommend using a management panel like Plesk or cpanel, which typically sets up linux in correct way to use it as a webserver. ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 13, 2024, 9:02am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/3 "2024-04-13T09:02:07Z")
I use ubuntu 22.04 and admit with the terminal. The linux system was fresh installation, provided from [hetzer.com](http://hetzer.com) where it’s hosted. ---
**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\ **Post date:** [April 13, 2024, 9:07am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/4 "2024-04-13T09:07:54Z")
A plain Ubuntu image is not a prepared web server. I would strongly recommend not to use it without any adjustments for hosting and running applications. ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 13, 2024, 9:09am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/5 "2024-04-13T09:09:26Z")
Do you have some advice for me? I want to learn it myself ---
**Author:** ![dirk\_s](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/dirk_s/32/748_2.png) [@dirk\_s](https://forum.mautic.org/u/dirk_s)\ **Post date:** [April 13, 2024, 9:13am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/6 "2024-04-13T09:13:17Z")
> [@Update from 4.4.10 to 5.0.4 Tipps - Manual is incomplete](https://forum.mautic.org/t/update-from-4-4-10-to-5-0-4-tipps-manual-is-incomplete/31649/4): > > @stefan-franz actually preparing a system to be a safe and well running web server is nothing that can be achieved by a simple tutorial, let alone to maintain it and keeping it safe. If you don’t have the experience and knowledge, I recommend using Plesk or similar management console. There the groups and users and security features are on a better level for public web hosting. Although I have years of experience with Linux ans web servers I wouldn’t dare to maintain it myself - unless I was a… ---
**Author:** ![marcus42](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@marcus42](https://forum.mautic.org/u/marcus42)\ **Post date:** [April 13, 2024, 2:10pm UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/7 "2024-04-13T14:10:20Z")
Your error and way to solve it indicate that something ran the web app using a user that is more powerful than www-data and that www-data can’t override it (probably root). This is a very bad practice and will eventually give you a headache. Also, inode proper permission set: Directory: 755 File: 644 Based on what you disclosed, that would fix it all: find /var/html/www/mautic -type f -exec chmod 644 {} ; find /var/html/www/mautic -type d -exec chmod 755 {} ; Lastly; Don’t use root user when you can avoid it. ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 14, 2024, 10:14am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/8 "2024-04-14T10:14:54Z")
Hello and thanks in advance for your help: now i made a new user and added him as here written: > **[Ersteinrichtung des Servers mit Ubuntu 20.04 | DigitalOcean](https://www.digitalocean.com/community/tutorials/initial-server-setup-with-ubuntu-20-04-de)** > > Wenn Sie erstmals einen neuen Ubuntu 20.04 Server einrichten, sollten Sie im Rahmen der grundlegenden Einrichtung einige wichtige Konfigurationsschritte ausf… ```auto usermod -aG sudo sammy ``` What steps do i have to do, that Mautic runs under that user? At the moment, all is running under root. I’d like to learn that, so it would be very helpful, if you can here support me. My questions: 1. Do have to install anything new (Apache, php, etc…)? 2. I think i have to adjust some rights in some directories. What do i have to do and how the rights are correctly? My mautic directory is: /var/www/html/mautic/ 3. Do i have to do anything with the database? Btw: I can make after the steps images of my server - so i can test it without the risk to damage it. Thanks in advance for your help. Greetings, Stefan ---
**Author:** ![marcus42](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@marcus42](https://forum.mautic.org/u/marcus42)\ **Post date:** [April 14, 2024, 3:18pm UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/9 "2024-04-14T15:18:16Z")
\*\* You’ll need to be root to perform most of those tasks Vanilla Ubuntu? Apache runs under www-data chown www-data: /var/html/www/mautic -R Next, what is causing your root owned files is probably your cronjobs. List all your current root owned cronjobs (lowercase L): crontab -l remove any mautic related cron if any (there shouldn’t be any). To do so, you may edit the crontab with the following: (if you dislike vi, you may switch to nano as the VISUAL editor. to do so, execute “export VISUAL=nano” before the next step) crontab -e Now that you cleaned up your crontab, let’s give those cronjobs to the Apache user (www-data). To do so, edit the crontab once more. But that time on the behalf of the www-data user: crontab -u www-data -e Slap all your Mautic cronjobs there, save and delete once more Mautic cache using the root user (that should be your last time ever doing that under the root user). Now don’t be root again to manage your Mautic. There is zero advantage of doing anything as root. Really none. And the only extra thing that you may manage to do is extra damage. Bottom line, really, really, really don’t use it. That’s my piece of advice. To run as, the “su”, “sudo” and “runuser” cmd (not limited to) could help you not using root to manage your installation. ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 14, 2024, 4:35pm UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/10 "2024-04-14T16:35:28Z")
Step by step for Dummies - and thanks for your help: I have normal ubuntu server 22.04 I connect now as user stefan (not as root) via ssh? right? ssh stefan@2… right? stefan@mautic01:~$ sudo chown -R www-data:www-data /var/www/html/mautic I need here sudo - right? (without i had no permission) The important change was here, to transfer the cronjob from root to www-data - right? (and that i work not under root - but under my user name) stefan@mautic01:~$ sudo crontab -u www-data -e One question: At the moment i saved via script, started by cronjobs under root the mautic directory every week and the database every day. Should i transfer these cronjobs to my user cronjobs?: stefan@mautic01:~$ crontab -e Are there any special permissions need? ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 14, 2024, 5:17pm UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/11 "2024-04-14T17:17:47Z")
btw: My script mysqldump.sh for backup daily the database under root looks: ```auto #!/bin/sh mysqldump -p'xxxxx' -u root mautic | gzip > ~/backups/mautic/mautic-database-$(date +%Y%m%d-%H%M%S).sql.gz ``` How can i make it executable as normal user with root rights (without i don’t have permission to get the database backup)? The script ist in ~/backups/mautic I’d like to execute with my cronjob: 0 4 \* \* \* ~/backups/mautic/mysqldump.sh under my normal user. ---
**Author:** ![marcus42](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@marcus42](https://forum.mautic.org/u/marcus42)\ **Post date:** [April 14, 2024, 7:29pm UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/12 "2024-04-14T19:29:07Z")
You need to do it as a super user. First thing you’ll need to know is who is running those jobs on mautic I was assuming root. But that could also be your “stefan” user. Have you look who was the owner of the files within the cache directory? If not, do it next time that you’ll face the error. The ownership will tell you who (shouldn’t) runs the jobs. Once identified, you’ll need to do what was suggested (removing the cronjobs from that user crontab. And add the cronjobs to www-data user tab). ---
**Author:** ![marcus42](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@marcus42](https://forum.mautic.org/u/marcus42)\ **Post date:** [April 14, 2024, 7:48pm UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/13 "2024-04-14T19:48:49Z")
copy the code either in your user home - or in any $PATH (do an “echo $PATH” to know your paths) chmod a+x /path/to/script From there you should be to execute it like if it was anything else (the “tab tab” auto-complete will even work) I would suggest to remove any user/pass hard-coding if putting it within a system path. Throw your mysql username and password in a dot-my.cnf: ~/.my.cnf ```auto [client] password="use your mautic mysql password here" user=mautic-mysql-username ``` and replace your script content with something like that: ```auto #!/usr/bin/bash mkdir -p ~/backups/mautic/ mysqldump mautic | gzip > ~/backups/mautic/mautic-database-$(date +%Y%m%d-%H%M%S).sql.gz ``` ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 15, 2024, 3:35am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/14 "2024-04-15T03:35:52Z")
Hmmm…Thanks for you help. My script mysqldump.sh is in that directory stefan@mautic01:~/backups/mautic$ I tried to make it executable: stefan@mautic01:~/backups/mautic$ chmod a+x mysqldump.sh stefan@mautic01:~/backups/mautic$ ./mysqldump.sh mysqldump: Got error: 1698: “Access denied for user ‘root’@‘localhost’” when trying to connect With sudo it did not work either stefan@mautic01:~/backups/mautic$ sudo chmod a+x mysqldump.sh [sudo] password for stefan: stefan@mautic01:~/backups/mautic$ ./mysqldump.sh mysqldump: Got error: 1698: “Access denied for user ‘root’@‘localhost’” when trying to connect For testing step by step is my question: Can i anyhow make the script executeable with my normal user, to start it via cron jobs? ---
**Author:** ![marcus42](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@marcus42](https://forum.mautic.org/u/marcus42)\ **Post date:** [April 15, 2024, 8:10am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/15 "2024-04-15T08:10:16Z")
It may sound silly but this confirm the proper exec bit/exec permission of the script: > mysqldump: Got error: 1698: “Access denied for user ‘root’@‘localhost’” when trying to connect What it say is… Scripts works great! But you messed up user and pass. Use the same user that you used for setting up Mautic DB. Info are located in the config/local.php file. This will save you some time Make sure those info in /home/stefan/.my.cnf are good (update the MySQL user/pass to something that does exist): ```auto [client] password=HudbIikbfd563eNBnh user=mautic ``` ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 15, 2024, 8:47am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/16 "2024-04-15T08:47:21Z")
In my /config/local.php stands: ‘db\_name’ =\> ‘mautic’, ‘db\_user’ =\> ‘mautic’, ‘db\_password’ =\> ‘xxxxxxxxx’, I’m very new at the rights of linux…hmm…need an explanation für dummies How should my script looks that it works? Would very thankful if you explain me that step by step for understanding what and why. As written, i would like to save under my user “stefan” without root rights via cronjob start the script to save database every day in the home directory of stefan as written above. Thanks in advance for your great help ---
**Author:** ![marcus42](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@marcus42](https://forum.mautic.org/u/marcus42)\ **Post date:** [April 15, 2024, 9:59am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/17 "2024-04-15T09:59:39Z")
No worries. As “stefan”, execute this (execute each of those 2 blocks as a single copy&paste + hit enter style): ```auto echo '[client] password="xxxxxxxxx" user=mautic' > ~/.my.cnf ``` Obviously you want to replace the xxxxxx with your db\_password info. This will create your local mysql client configuration. Your backup script: ```auto sudo echo '#!/usr/bin/bash mkdir -p ~/backups/mautic/ mysqldump mautic | gzip > ~/backups/mautic/mautic-database-$(date +%Y%m%d-%H%M%S).sql.gz' > /usr/local/bin/mbackup && sudo chmod a+x /usr/local/bin/mbackup ``` This will generate a file located at /usr/local/bin/mbackup and give it the exec bit. The script itself will first attempt to create a directory in the user’s home path (in case of a first run or what ever reason why that directory went awol) Then it will generate a dump in the designated path using the provided mysql info stored in your local mysql client configuration file - avoiding hardcoding user/pass in a script. Test it by running the following as stefan: `mbackup` When successful, add the following cronjob to stefan (do it as stefan, not root nor any other user): `0 4 * * * /usr/local/bin/mbackup` EDIT: There was a typo in the second script (missing a / in a path) ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 15, 2024, 11:12am UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/18 "2024-04-15T11:12:22Z")
Thanks - it works. I made it. I have also Moodle running on this server. How can i add the Moodle database correctly in the .my.cnf to backup moodle in the same way? ---
**Author:** ![marcus42](https://avatars.discourse-cdn.com/v4/letter/m/ac91a4/32.png) [@marcus42](https://forum.mautic.org/u/marcus42)\ **Post date:** [April 15, 2024, 12:10pm UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/19 "2024-04-15T12:10:56Z")
You may need to use a second configuration file for both mysql schemas (and you should consider using a dedicated mysql user which have read only permissions for that - but this would be out of this scope) My suggested solution: To specify a config file, you need to add this to your mysqldump cmd: --defaults-file=/path/to/your/file You could extend your backup script like that (just open the already existing file using sudo and replace its content with this one): ```auto #!/usr/bin/bash source ~/.${1}.my.cnf >/dev/null 2>&1 mkdir -p ~/backups/${1} mysqldump --defaults-file=~/.${1}.my.cnf --single-transaction --add-drop-table $database | gzip > ~/backups/${1}/${1}-database-$(date +%Y%m%d-%H%M%S).sql.gz ``` Then, for each app that you want to backup, create a .(app name).my.cnf file containing the specific app mysql user/pass info. i.e. ```auto ~/.mautic.my.cnf <= containing Mautic DB info) ~/.moodle.my.cnf <= (containing Moodle DB info) ``` You’ll also need to add a line inside both of the MySQL client configuration files: ```auto database=your-db-schema-name ``` i.e. ~/.mautic.my.cnf ```auto [client] password=HudbIikbfd563eNBnh user=mautic [server] database=mautic ``` i.e. ~/.moodle.my.cnf ```auto [client] password=HudbIikbfd563eNBnh user=moodle [server] database=moodle ``` Then run your backup script like that: ```auto mbackup mautic #This is for backing up Mautic DB mbackup moodle #This is for backing up Moodle DB ``` In a crontab: ```auto 0 4 * * * /usr/local/bin/mbackup mautic 0 4 * * * /usr/local/bin/mbackup moodle ``` From there you should be good to go in order to use that quick basic backup script with any other projects that you may have. EDIT: Forgot to remove the “mautic” reference within the backup script - sorry about it, fixed! ---
**Author:** ![stefan-franz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/stefan-franz/32/12758_2.png) [@stefan-franz](https://forum.mautic.org/u/stefan-franz)\ **Post date:** [April 15, 2024, 1:37pm UTC](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661/20 "2024-04-15T13:37:55Z")
Thanks . Wow. i adjusted the script and got these error message: mysqldump: unknown variable ‘defaults-file=~/.mautic.my.cnf’ I checked it more times. Can’t find an error in the files. Any idea? [Next page](https://forum.mautic.org/t/rights-problem-at-installatioin-delete-cache-and-some-strange-things-over-night/31661.md?page=2)