Tealk Posted July 29, 2019 Posted July 29, 2019 i had it installed before as a package can there be a problem when the package was uninstalled and i uploaded the data via ftp?
d00p Posted July 29, 2019 Author Posted July 29, 2019 No, as said, the initial services config is not automatically called
Tealk Posted July 29, 2019 Posted July 29, 2019 I believe you already. But where does it come from if I didn't execute anything? that wasn't even possible because the problem occurred in the middle of the update process.
Tealk Posted July 30, 2019 Posted July 30, 2019 In the package "froxlor-0.10.0-rc2.tar.gz" the "froxlor_master_cronjob.php" is not executable. Couldn't this be stored in tar.gz? I only came across it because I had to update it manually and the crons didn't run through.
d00p Posted July 30, 2019 Author Posted July 30, 2019 10 minutes ago, Tealk said: In the package "froxlor-0.10.0-rc2.tar.gz" the "froxlor_master_cronjob.php" is not executable. Couldn't this be stored in tar.gz? I only came across it because I had to update it manually and the crons didn't run through. it's run with "php", not directly...cron works fine here on my servers
Tealk Posted July 30, 2019 Posted July 30, 2019 ok interesting, only since I made it executable the crons works again.
d00p Posted July 30, 2019 Author Posted July 30, 2019 How is your cron run? can you please specify what exactly it is you do? It's hard to help with so few information
Tealk Posted July 30, 2019 Posted July 30, 2019 I raised froxlor to 0.10 before the Debian update. Renamed the old folder and restored the config file. Since then I haven't changed anything in the settings. After the Debian Update I have removed old cipher and noticed that the cron doesn't work anymore. When I make the file "froxlor_master_cronjob.php" executable it runs as usual again. I had installed Froxlor before as a package, that was uninstalled during the update of Debian.
d00p Posted July 30, 2019 Author Posted July 30, 2019 That does not answer the question how you run the cronjob...
Tealk Posted July 30, 2019 Posted July 30, 2019 With the following file: /etc/cron.d/froxlor # automatically generated cron-configuration by froxlor # do not manually edit this file as it will be re-generated periodically. PATH=/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin # */5 * * * * root /usr/bin/nice -n 5 /usr/bin/php7.2 -q /var/www/froxlor//scripts/froxlor_master_cronjob.php --tasks 1> /dev/null 0 0 * * * root /usr/bin/nice -n 5 /usr/bin/php7.2 -q /var/www/froxlor//scripts/froxlor_master_cronjob.php --traffic 1> /dev/null 5 0 * * * root /usr/bin/nice -n 5 /usr/bin/php7.2 -q /var/www/froxlor//scripts/froxlor_master_cronjob.php --usage_report 1> /dev/null 0 */6 * * * root /usr/bin/nice -n 5 /usr/bin/php7.2 -q /var/www/froxlor//scripts/froxlor_master_cronjob.php --mailboxsize 1> /dev/null */5 * * * * root /usr/bin/nice -n 5 /usr/bin/php7.2 -q /var/www/froxlor//scripts/froxlor_master_cronjob.php --letsencrypt 1> /dev/null 10 0 * * * root /usr/bin/nice -n 5 /usr/bin/php7.2 -q /var/www/froxlor//scripts/froxlor_master_cronjob.php --backup 1> /dev/null Â
d00p Posted July 30, 2019 Author Posted July 30, 2019 My cronjob has the following permissions and works just fine: -rw-r--r-- 1 froxlor froxlor 641 Jan 2 2019 froxlor_master_cronjob.php Â
Tealk Posted July 30, 2019 Posted July 30, 2019 Like I said I have to give the user executive permissions. Why don't I know and currently don't know where to start investigating.
d00p Posted July 30, 2019 Author Posted July 30, 2019 And like I said, works for me flawlessly, no idea what you've done to your system...seems like you a few issues here
mike87 Posted August 7, 2019 Posted August 7, 2019 As recommended I copied my database to a fresh Debian 10 and started the internal update. Changed the IP and got stuck. Apache doesn't start due: AH00526: Syntax error on line 11 of /etc/apache2/sites-enabled/28_froxlor_normal_vhost_web1.s01.XXXX.info.conf: Invalid command 'php_admin_value', perhaps misspelled or defined by a module not included in the server configuration These are the lines for open basedir and email. Any recommendations how to fix this? If I remove all php_admin_value Entries from all fines it is running fine.
mike87 Posted August 9, 2019 Posted August 9, 2019 I enabled mod_php, looked into it ten times and still missed that it was disabled again... Thx a lot. Â Another strange thing I found is that I disabled a customer and tried to reenable it. Ending here: A database error occurred SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'froxlor_root'@'127.0.0.1' to database 'web8sql1' Dear froxlor-team, the following error has been reported by a user: ------------------------------------------------------------- 42000 SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'froxlor_root'@'127.0.0.1' to database 'web8sql1' File: lib/Froxlor/Database/Database.php:203 Trace: #0 [internal function]: PDO->query('GRANT ALL PRIVI...') #1 lib/Froxlor/Database/Database.php(203): call_user_func_array(Array, Array) #2 lib/Froxlor/Database/Manager/DbManagerMySQL.php(203): Froxlor\Database\Database::__callStatic('query', Array) #3 lib/Froxlor/Api/Commands/Customers.php(1081): Froxlor\Database\Manager\DbManagerMySQL->enableUser('web8sql1', '127.0.0.1') #4 admin_customers.php(376): Froxlor\Api\Commands\Customers->update() #5 {main} ------------------------------------------------------------- Froxlor-version: 0.10.0-rc2 DB-version: 201904250 End of report User froxlor_root got full global rights. So this shouldn't be a problem. Any guesses?
d00p Posted August 9, 2019 Author Posted August 9, 2019 Could you please try to reproduce this using the real root user to be sure it's not a permission issue?
mike87 Posted August 9, 2019 Posted August 9, 2019 That doesn't change anything. SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'root'@'127.0.0.1' to database 'web8sql1' But I think that isn't intended to work. Newer releases only accept root from shell if you are currently a root user.
d00p Posted August 10, 2019 Author Posted August 10, 2019 8 hours ago, mike87 said: But I think that isn't intended to work. But it needs to work for froxlor. In order to manage mysql databases and users we need a privileged user.
mike87 Posted August 10, 2019 Posted August 10, 2019 vor 5 Stunden schrieb d00p: But it needs to work for froxlor. In order to manage mysql databases and users we need a privileged user. I know. I just wanted you to know about this problem. Debian 10/MariaDB 10.3 uses unix_socket as plugin for the root user. So this isn't working anymore and you have to create another root-like user. That's why I use froxlor_root with full global rights, identified by password from 127.0.0.1/localhost/server-ip. Connecting via shell is working:Â mysql -u froxlor_root -p May you know the SQL-statement so I could test it via shell?
d00p Posted August 10, 2019 Author Posted August 10, 2019 This was an issue even before Debian buster. There are many many topics here how to fix that. Also, a fresh install should do the required steps. 3 minutes ago, mike87 said: May you know the SQL-statement so I could test it via shell As said, search the Forum, it's on here a few times, try searching for "update mysql.user" maybe
mike87 Posted August 10, 2019 Posted August 10, 2019 Before I imported the old database I did a fresh install and my froxlor_root user was accepted. It took me some time but I found the issue. MariaDB got a bug in 10.3. Granting ALL PRIVILEGES lacks DELETE HISTORY. So another grant ALL PRIVILEGES fails. You need to grant all priviliges manually and it is working. (See Bug Report)
Chaos234 Posted September 14, 2019 Posted September 14, 2019 Hey d00p, I updated/upgraded from 0.9.40.1 to this RC and now getting this after the login page: Zitat Fatal error: Uncaught Error: Class 'Settings' not found in /var/www/froxlor/lib/navigation/10.tickets.php:25 Stack trace: #0 /var/www/froxlor/lib/Froxlor/PhpHelper.php(165): include() #1 /var/www/froxlor/lib/init.php(423): Froxlor\PhpHelper::loadConfigArrayDir('lib/navigation/') #2 /var/www/froxlor/admin_index.php(20): require('/var/www/froxlo...') #3 {main} thrown in /var/www/froxlor/lib/navigation/10.tickets.php on line 25 I downloaded the package and unzipped it to my desktop and then uploaded all the files into my froxlor folder on my server with overwriting existing files. Any help here would be nice.
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now