d00p Posted September 14, 2019 Author Posted September 14, 2019 9 minutes ago, Chaos234 said: /var/www/froxlor/lib/navigation/10.tickets.php This file is no longer part of froxlor. Remove it I think the updater should do that ... Definitely something for the final version
Chaos234 Posted September 14, 2019 Posted September 14, 2019 vor 3 Minuten schrieb d00p: This file is no longer part of froxlor. Remove it I think the updater should do that ... Definitely something for the final version Yes, this was the only problem Uhm, is this also normal? I means the double / between froxlor and installĀ ? php /var/www/froxlor//install/scripts/config-services.php --froxlor-dir=/var/www/froxlor/ --create Looking at all the settings to check all new ones out and if I find smth. wired, I'll post it here ok?
d00p Posted September 14, 2019 Author Posted September 14, 2019 38 minutes ago, Chaos234 said: Uhm, is this also normal? I means the double / between froxlor and installĀ ? Can happen, but harmless 39 minutes ago, Chaos234 said: Looking at all the settings to check all new ones out and if I find smth. wired, I'll post it here ok? Awesome, thanks
d00p Posted September 15, 2019 Author Posted September 15, 2019 19 hours ago, d00p said: This file is no longer part of froxlor. Remove it I think the updater should do that ... Definitely something for the final version added, commited, pushed, now part of current git-master.Ā
DaSilva Posted September 17, 2019 Posted September 17, 2019 Hi, is set up a new Server with Debian Buster. The Wiki install guide provides no guidance whatsoever on what the server needs to start the web-installer, would be nice to have a complete install guide when there is no LAMP Stack in place. i now get this error message during the installation: Ā Checking MySQL-root access... OK Creating backup of old database... OK (/tmp/froxlor_backup_201909171108.sql) Preparing database... OK Creating database and username... OK Testing if database and user have been created correctly... SQLSTATE[HY000] [1045] Access denied for user 'froxlor'@'localhost' (using password: YES) SQLSTATE[HY000] [1045] Access denied for user 'froxlor'@'localhost' (using password: YES) mysql> use mysql; Database changed mysql> select user from user; +------------------+ | userĀ Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā | +------------------+ | mysql.infoschema | | mysql.sessionĀ Ā Ā | | mysql.sysĀ Ā Ā Ā Ā Ā Ā | | rootĀ Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā Ā | +------------------+ 4 rows in set (0,00 sec) Ā I am Using: mysql 8.0.17-1debian10 (With mysql native password) php 7.3.4-2 apache 2.4 Kernel 4.9.0-3 i hope you can help with this. Should i create the user and Database manually?
d00p Posted September 17, 2019 Author Posted September 17, 2019 49 minutes ago, DaSilva said: The Wiki install guide provides no guidance whatsoever on what the server needs to start the web-installer, would be nice to have a complete install guide when there is no LAMP Stack in place. Updated the wiki 49 minutes ago, DaSilva said: Should i create the user and Database manually? No, normally the installer does this for you. What version are you testing with, latest git-master?
DaSilva Posted September 17, 2019 Posted September 17, 2019 4 minutes ago, d00p said: No, normally the installer does this for you. What version are you testing with, latest git-master? I downloaded froxlor-0.10.0-rc2.tar.gz from your first post. Should i pull the current git? Ā Thanks!
d00p Posted September 17, 2019 Author Posted September 17, 2019 There were over 100 commits since rc2 ....especially regarding mysql8 - you should give it a try using current git. But beware, if you checkout git repo you need to run composer install manually, seeĀ https://github.com/Froxlor/Froxlor/wiki/Install-froxlor-from-git-sources#3-download-dependencies
DaSilva Posted September 17, 2019 Posted September 17, 2019 Wonderfull, works like a Charm. Now i wanted to test the configuration Script: Here is what i did: php /var/www/froxlor//install/scripts/config-services.php --froxlor-dir=/var/www/froxlor/ --create this is the json i got: {"distro":"buster","http":"apache24","dns":"x","smtp":"postfix_dovecot","mail":"dovecot_postfix2","ftp":"proftpd","system":["cron","awstats","libnssextrausers","logrotate","php-fpm"]} All went well until php fpm, here is the output: php7.3-fpm (7.3.4-2) wird eingerichtet ... Creating config file /etc/php/7.3/fpm/php.ini with new version NOTICE: Not enabling PHP 7.3 FPM by default. NOTICE: To enable PHP 7.3 FPM in Apache2 do: NOTICE: a2enmod proxy_fcgi setenvif NOTICE: a2enconf php7.3-fpm NOTICE: You are seeing this message because you have apache2 package installed. Created symlink /etc/systemd/system/multi-user.target.wants/php7.3-fpm.service ā /lib/systemd/system/php7.3-fpm.service. php-fpm (2:7.3+69) wird eingerichtet ... Trigger fĆ¼r systemd (241-7~deb10u1) werden verarbeitet ... PHP Warning: Error while sending QUERY packet. PID=22149 in /var/www/froxlor/lib/Froxlor/Database/Database.php on line 83 froxlor[22149]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away froxlor[22149]: --- DEBUG: #0 /var/www/froxlor/lib/Froxlor/Database/Database.php(83): PDOStatement->execute(Array) #1 /var/www/froxlor/lib/Froxlor/Settings.php(109): Froxlor\Database\Database::pexecute(Object(PDOStatement), Array) #2 /var/www/froxlor/lib/Froxlor/Settings.php(179): Froxlor\Settings::storeSetting('panel', 'is_configured', '1') #3 /var/www/froxlor/lib/Froxlor/Cli/Action/ConfigServicesAction.php(298): Froxlor\Settings::Set('panel.is_config...', '1', true) #4 /var/www/froxlor/lib/Froxlor/Cli/Action/ConfigServicesAction.php(41): Froxlor\Cli\Action\ConfigServicesAction->applyConfig() #5 /var/www/froxlor/lib/Froxlor/Cli/Action/ConfigServicesAction.php(19): Froxlor\Cli\Action\ConfigServicesAction->validate() #6 /var/www/froxlor/lib/Froxlor/Cli/CmdLineHandler.php(64): Froxlor\Cli\Action\ConfigServicesAction->run() #7 /var/www/froxlor/lib/Froxlor/Cli/CmdLineHandler.php(47): Froxlor\Cli\CmdLineHandler->__construct(2, Array) #8 /var/www/froxlor/install/scripts/config-services.php(28): Froxlor\Cli\CmdLineHandler::processParameters(2, Array) #9 {main} We are sorry, but a MySQL - error occurred. The administrator may find more information in the syslog here are the last few lines from the syslog: Sep 17 12:46:41 froxlorimage systemd[1]: Starting The PHP 7.3 FastCGI Process Manager... Sep 17 12:46:41 froxlorimage systemd[1]: Started The PHP 7.3 FastCGI Process Manager. Sep 17 12:46:41 froxlorimage systemd[1]: Reloading. Sep 17 12:46:41 froxlorimage systemd[1]: /lib/systemd/system/dovecot.service:9: PIDFile= references path below legacy directory /var/run/, updating /var/run/dovecot/master.pid ā /run/dovecot/master.pid; please update the unit file accordingly. Sep 17 12:46:42 froxlorimage systemd[1]: Stopping The Apache HTTP Server... Sep 17 12:46:42 froxlorimage systemd[1]: apache2.service: Succeeded. Sep 17 12:46:42 froxlorimage systemd[1]: Stopped The Apache HTTP Server. Sep 17 12:46:42 froxlorimage systemd[1]: Starting The Apache HTTP Server... Sep 17 12:46:42 froxlorimage systemd[1]: Started The Apache HTTP Server. Sep 17 12:46:42 froxlorimage froxlor[22149]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away Sep 17 12:46:42 froxlorimage froxlor[22149]: --- DEBUG: #0 /var/www/froxlor/lib/Froxlor/Database/Database.php(83): PDOStatement->execute(Array) #1 /var/www/froxlor/lib/Froxlor/Settings.php(109): Froxlor\Database\Database::pexecute(Object(PDOStatement), Array) #2 /var/www/froxlor/lib/Froxlor/Settings.php(179): Froxlor\Settings::storeSetting('panel', 'is_configured', '1') #3 /var/www/froxlor/lib/Froxlor/Cli/Action/ConfigServicesAction.php(298): Froxlor\Settings::Set('panel.is_config...', '1', true) #4 /var/www/froxlor/lib/Froxlor/Cli/Action/ConfigServicesAction.php(41): Froxlor\Cli\Action\ConfigServicesAction->applyConfig() #5 /var/www/froxlor/lib/Froxlor/Cli/Action/ConfigServicesAction.php(19): Froxlor\Cli\Action\ConfigServicesAction->validate() #6 /var/www/froxlor/lib/Froxlor/Cli/CmdLineHandler.php(64): Froxlor\Cli\Action\ConfigServicesAction->run() #7 /var/www/froxlor/lib/Froxlor/Cli/CmdLineHandler.php(47): Froxlor\Cli\CmdLineHandler->__construct(2, Array) #8 /var/www/froxlor/install/scripts/config-services.php(28): Froxlor\Cli\CmdLineHandler::processParameters(2, Array) #9 {main} Thanks for all your work!
d00p Posted September 17, 2019 Author Posted September 17, 2019 47 minutes ago, DaSilva said: froxlor[22149]: SQLSTATE[HY000]: General error: 2006 MySQL server has gone away That is the problem. hard to tell where this comes from. My latest installations/configurations on debian buster went through just fine
DaSilva Posted September 17, 2019 Posted September 17, 2019 Can i just repeat the step? edit: Btw. there is no reported error in the mysql error.log, very strange.
d00p Posted September 17, 2019 Author Posted September 17, 2019 You can repeat the --apply of the config-script as often as you like Ā I wouldn't recommend doing that when already in production but for the setup - no problem
DaSilva Posted September 17, 2019 Posted September 17, 2019 Woks like a charm the second time! i had to manually set the parameters in the Froxlor panel settings (e.g. libnss-extrausers flag). Is this intended or should i have run the Froxlor master cronjob for the changes to take effect?
d00p Posted September 17, 2019 Author Posted September 17, 2019 this is intended as libnss-extrausers is optional (but required for fpm / fcgid) - that's why the docs say, first adjust settings, then run configuration
DaSilva Posted September 17, 2019 Posted September 17, 2019 Very well, the system runs flawlessly for now. We are setting it up in an semi-production environment and can not wait for more features in the API (cronjobs are very high on our wish list). we are testing this release and will report any major bugs or changes that we made to the code(pull request). Ā Thank you so much!
d00p Posted September 17, 2019 Author Posted September 17, 2019 what more features in the API??? We're at release-candidate level....What exactly do you mean by "cronjobs"? You mean managing the froxlor-cronjobs via API? or do you want customers to be able to manage their own cronjobs?
DaSilva Posted September 17, 2019 Posted September 17, 2019 20 minutes ago, d00p said: what more features in the API??? We're at release-candidate level That's correct and i dont mean it in any bad way. The API Should be able to add/modify/remove/sanity-check Cronjobs on Customer Level. We are now also working on such a function, as this is the main reason we have to do anything Froxlor related, except updates. Would be a massive convenience. Are you interested in this function when we have it up and running?
d00p Posted September 18, 2019 Author Posted September 18, 2019 Well - implementing this is not the big deal...but it's just a huge security risk letting customers do that themselves, you never know what kind of script is being added and what it does and whether it's possible malware due to some security leaks or whatever...
DaSilva Posted September 18, 2019 Posted September 18, 2019 Could be an option, that has to be enabled with caution, like /bin/bash for FTP users. We will fiddle with this idea and see what we can do to help prevent most of the bad things, that customers can do. Maybe limit it to curl/wget and stuff, without execute permissions for piped commands or strip them entirely.
d00p Posted September 18, 2019 Author Posted September 18, 2019 17 minutes ago, DaSilva said: without execute permissions for piped commands or strip them entirely. Then I would just add a bash / PHP script that executes what I want...doesn't prevent anything Yes, basically it would have to be enabled on a per customer base and maybe even limited like other resources (amount of subdomains, amount of FTP accounts, etc). In case you want to do such a feature, a pull request is a good way to start. Maybe for 0.10.1 or similar.
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