Jump to content
Froxlor Forum

lanbo

Members
  • Content Count

    27
  • Joined

  • Last visited

Community Reputation

4 Neutral

About lanbo

  • Rank
    Froxie

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. Hi! I am replicating the froxlor db (with many other DBs) to a SLAVE mysql server that is used to make backups. I've found an error in the SLAVE: Could not execute Delete_rows event on table froxlor.panel_sessions; Can't find record in 'panel_sessions', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.000350, end_log_pos 6002396 This is probably because panel_sessions is using a HEAP/MEMORY engine and the SLAVE was rebooted. Being a MEMORY table, I guess it's not a very important table and it is safe to skip panel_sessions from the replication to avoid such errors. What is it used this table for? Do you think it's safe to skip replicating it? Thanks!
  2. Thanks @d00p! Did not know that. I added the extension directive to php_admin_values and it worked great! I could remove it from /etc/php/7.2/fpm/php.ini. It's cleaner now.
  3. I'm not sure I understand what I have to check. Which settings? http://php.net/manual/en/ini.list.php "extension" is a valid directive. In fact I'm using it in /etc/php/7.2/fpm/php.ini I think I did not understand your question. You mean this directive can be blocked somehow?
  4. I have a custom PHP Configuration for most of my domains. I can set the typical stuff such as: upload_max_filesize = 32M I used to set also some extensions such as extension=xxxx.so Well, when I run phpinfo() on a process on apache for a particular domain, I see that upload_max_filesize is correctly set to any value that I choose. But the extension is not set. I finally had to add the "extension=xxx.so" in: /etc/php/7.2/fpm/php.ini Is that an expected behaviour with php-fpm? With FCGID it worked just fine. I tried everything. Setting the full path, etc. The logs did not show anything. The extension works when I set it directly here /etc/php/7.2/fpm/php.ini The problem is that the extension then is available for all the domains. It is not a big problem. Just wanted to let you know in case it is a bug. Thanks
  5. I have some notes of an old Froxlor installation I did with Postfix. I used to configure the Server with the following option: Postfix MX-Access (anti spam) I now see this option has been removed from the list of System Configurations. I have a couple of questions: a) What did it use to do? b) Why has it been removed? Was it not necessary, was it dangerous, has it been deprecated by something better or you simply lost interest in it? Thanks
  6. I finally solved it. If you happen to find this very same problem please follow this discussion here: https://forum.froxlor.org/index.php?/topic/14102-bionic-beaver
  7. lanbo

    Bionic Beaver

    I finally fixed it. This was the final step needed: phpenmod pdo_mysql Then restart apache. Thanks @d00p for ideas and for froxlor.
  8. lanbo

    Bionic Beaver

    Yeah, I don't care about that deprecation warning. However I already have php-mysql installed. That's the first thing I checked. I have restarted apache2, also restarted php7.2-fpm and php /var/www/html/froxlor/scripts/froxlor_master_cronjob.php --force --debug. I created a phpinfo.php so that I can run it on the froxlor vhost and get: PDO PDO support enabled PDO drivers no value The message I got while it was being installed was: php_invoke pdo_mysql: no action - module was disabled by maintainer for PHP 7.2 fpm sapi I'm not sure what it means. Thanks again @d00p
  9. lanbo

    Bionic Beaver

    Oups! You made me think. I updated the id of panel_fpdaemons record so that it matched "fpmsettingid: 1" update panel_fpdaemons set id =1; I made some progress. It now shows a froxlor screen with Just a couple of issues: #8192 assert(): Calling assert() with a string argument is deprecated The php PDO extension or PDO-MySQL driver is not available Working on these issues now. Thanks again. EDIT: The pdo stuff may be related with this message I got while installing php-fpm: (Reading database ... 88139 files and directories currently installed.) Preparing to unpack .../php7.2-fpm_7.2.10-0ubuntu0.18.04.1_amd64.deb ... Unpacking php7.2-fpm (7.2.10-0ubuntu0.18.04.1) ... Selecting previously unselected package php-fpm. Preparing to unpack .../php-fpm_1%3a7.2+60ubuntu1_all.deb ... Unpacking php-fpm (1:7.2+60ubuntu1) ... Setting up php7.2-fpm (7.2.10-0ubuntu0.18.04.1) ... Not replacing deleted config file /etc/php/7.2/fpm/php.ini php_invoke pdo_mysql: no action - module was disabled by maintainer for PHP 7.2 fpm sapi NOTICE: Not enabling PHP 7.2 FPM by default. NOTICE: To enable PHP 7.2 FPM in Apache2 do: NOTICE: a2enmod proxy_fcgi setenvif NOTICE: a2enconf php7.2-fpm NOTICE: You are seeing this message because you have apache2 package installed. Processing triggers for ureadahead (0.100.0-20) ... Setting up php-fpm (1:7.2+60ubuntu1) ... Processing triggers for systemd (237-3ubuntu10.3) ... Processing triggers for man-db (2.8.3-2) ...
  10. lanbo

    Bionic Beaver

    Thank you so much @d00p TBH I'm not superfamilar with system administration. Just the basic stuff to make it work and install (or update) once every 3 years. I only host my own domains (not that many). I removed the 7.0 stuff in panel_fpdaemons. Now it is: *************************** 1. row *************************** id: 2 description: Bionic Beaver reload_cmd: service php7.2-fpm restart config_dir: /etc/php/7.2/fpm/pool.d/ pm: static max_children: 1 start_servers: 20 min_spare_servers: 5 max_spare_servers: 35 max_requests: 0 idle_timeout: 30 limit_extensions: .php 1 row in set (0.00 sec) Regarding phpconfigs it's huge: *************************** 1. row *************************** id: 1 description: Default Config binary: /usr/bin/php-cgi file_extensions: php mod_fcgid_starter: -1 mod_fcgid_maxrequests: -1 mod_fcgid_umask: 022 fpm_slowlog: 0 fpm_reqterm: 60s fpm_reqslow: 5s phpsettings: allow_call_time_pass_reference = Off allow_url_fopen = Off asp_tags = Off disable_classes = disable_functions = curl_exec,curl_multi_exec,exec,parse_ini_file,passthru,popen,proc_close,proc_get_status,proc_nice,proc_open,proc_terminate,shell_exec,show_source,system display_errors = Off display_startup_errors = Off enable_dl = Off error_reporting = E_ALL & ~E_NOTICE expose_php = Off file_uploads = On cgi.force_redirect = 1 gpc_order = "GPC" html_errors = Off ignore_repeated_errors = Off ignore_repeated_source = Off include_path = ".:{PEAR_DIR}" log_errors = On log_errors_max_len = 1024 magic_quotes_gpc = Off magic_quotes_runtime = Off magic_quotes_sybase = Off max_execution_time = 30 max_input_time = 60 memory_limit = 128M {OPEN_BASEDIR_C}open_basedir = "{OPEN_BASEDIR}" output_buffering = 4096 post_max_size = 16M precision = 14 register_argc_argv = Off register_globals = Off report_memleaks = On sendmail_path = "/usr/sbin/sendmail -t -i -f {CUSTOMER_EMAIL}" session.auto_start = 0 session.bug_compat_42 = 0 session.bug_compat_warn = 1 session.cache_expire = 180 session.cache_limiter = nocache session.cookie_domain = session.cookie_lifetime = 0 session.cookie_path = / session.entropy_file = /dev/urandom session.entropy_length = 16 session.gc_divisor = 1000 session.gc_maxlifetime = 1440 session.gc_probability = 1 session.name = PHPSESSID session.referer_check = session.save_handler = files session.save_path = "{TMP_DIR}" session.serialize_handler = php session.use_cookies = 1 session.use_trans_sid = 0 short_open_tag = On suhosin.mail.protect = 1 suhosin.simulation = Off track_errors = Off upload_max_filesize = 32M upload_tmp_dir = "{TMP_DIR}" variables_order = "GPCS" ;mail.add_x_header = On ;mail.log = "/var/log/phpmail.log" opcache.restrict_api = "{DOCUMENT_ROOT}" fpmsettingid: 1 pass_authorizationheader: 0 *************************** 2. row *************************** id: 2 description: Froxlor Vhost Config binary: /usr/bin/php-cgi file_extensions: php mod_fcgid_starter: -1 mod_fcgid_maxrequests: -1 mod_fcgid_umask: 022 fpm_slowlog: 0 fpm_reqterm: 60s fpm_reqslow: 5s phpsettings: allow_call_time_pass_reference = Off allow_url_fopen = On asp_tags = Off disable_classes = disable_functions = curl_multi_exec,exec,parse_ini_file,passthru,popen,proc_close,proc_get_status,proc_nice,proc_open,proc_terminate,shell_exec,show_source,system display_errors = Off display_startup_errors = Off enable_dl = Off error_reporting = E_ALL & ~E_NOTICE expose_php = Off file_uploads = On cgi.force_redirect = 1 gpc_order = "GPC" html_errors = Off ignore_repeated_errors = Off ignore_repeated_source = Off include_path = ".:{PEAR_DIR}" log_errors = On log_errors_max_len = 1024 magic_quotes_gpc = Off magic_quotes_runtime = Off magic_quotes_sybase = Off max_execution_time = 60 max_input_time = 60 memory_limit = 128M output_buffering = 4096 post_max_size = 16M precision = 14 register_argc_argv = Off register_globals = Off report_memleaks = On sendmail_path = "/usr/sbin/sendmail -t -i -f {CUSTOMER_EMAIL}" session.auto_start = 0 session.bug_compat_42 = 0 session.bug_compat_warn = 1 session.cache_expire = 180 session.cache_limiter = nocache session.cookie_domain = session.cookie_lifetime = 0 session.cookie_path = / session.entropy_file = /dev/urandom session.entropy_length = 16 session.gc_divisor = 1000 session.gc_maxlifetime = 1440 session.gc_probability = 1 session.name = PHPSESSID session.referer_check = session.save_handler = files session.save_path = "{TMP_DIR}" session.serialize_handler = php session.use_cookies = 1 session.use_trans_sid = 0 short_open_tag = On suhosin.mail.protect = 1 suhosin.simulation = Off track_errors = Off upload_max_filesize = 32M upload_tmp_dir = "{TMP_DIR}" variables_order = "GPCS" ;mail.add_x_header = On ;mail.log = "/var/log/phpmail.log" opcache.restrict_api = "" fpmsettingid: 1 pass_authorizationheader: 0 2 rows in set (0.00 sec)
  11. @headtrick, @Keon, did you solve it? I'm stuck at the exactly same step after upgrading php version while I was on php-fpm. /run/php/php7.2-fpm.sock is not found. But this is not the file that should be used anyway I guess... This is my froxlor config file: # 10_froxlor_ipandport_xxx.xxx.xxx.xxx.80.conf # Created 29.09.2018 11:22 # Do NOT manually edit this file, all changes will be deleted after the next domain change at the panel. <VirtualHost xxx.xxx.xxx.xxx:80> DocumentRoot "/var/www/html/" ServerName xxxx.xxxx.com <FilesMatch \.()$> SetHandler proxy:unix:/var/lib/apache2/fastcgi/1-froxlor.panel-xxx.xxx.com-php-fpm.socket|fcgi://localhost </FilesMatch> </VirtualHost> It's strange why this other file is not being created and therefore not being picked up. This are the logs with LogLevel debug: [Sat Sep 29 11:50:23.986229 2018] [proxy:debug] [pid 27113:tid 140463228737280] proxy_util.c(2252): [client xxx.xxx.189.83:53264] AH02545: fcgi: has determined UDS as /run/php/php7.2-fpm.sock So I guess is something related to proxy_fcgi. I'm stuck... I made some progress: <FilesMatch \.()$> SetHandler proxy:unix:/var/lib/apache2/fastcgi/1-froxlor.panel-xxx.xxxxxx.com-php-fpm.socket|fcgi://localhost </FilesMatch> should be: <FilesMatch \.php$>...</FilesMatch> Strange. Why is it not correctly generated? However, even if I try to fix it manually, then apache still fails because the socket file has not been generated anyway: [Sat Sep 29 12:06:06.752157 2018] [proxy:error] [pid 28900:tid 140013299574528] (2)No such file or directory: AH02454: FCGI: attempt to connect to Unix domain socket /var/lib/apache2/fastcgi/1-froxlor.panel-xxx.xxxxx.com-php-fpm.socket (*) failed [Sat Sep 29 12:06:06.752228 2018] [proxy_fcgi:error] [pid 28900:tid 140013299574528] [client 95.120.189.83:54668] AH01079: failed to make connection to backend: httpd-UDS What did you end up doing guys? Thanks
  12. @headtrick, @Keon, did you solve it? I'm stuck at the exactly same step after upgrading php version while I was on php-fpm. /run/php/php7.2-fpm.sock is not found. But this is not the file that should be used anyway I guess... This is my froxlor config file: # 10_froxlor_ipandport_xxx.xxx.xxx.xxx.80.conf # Created 29.09.2018 11:22 # Do NOT manually edit this file, all changes will be deleted after the next domain change at the panel. <VirtualHost xxx.xxx.xxx.xxx:80> DocumentRoot "/var/www/html/" ServerName xxxx.xxxx.com <FilesMatch \.()$> SetHandler proxy:unix:/var/lib/apache2/fastcgi/1-froxlor.panel-xxx.xxx.com-php-fpm.socket|fcgi://localhost </FilesMatch> </VirtualHost> It's strange why this other file is not being created and therefore not being picked up. This are the logs with LogLevel debug: [Sat Sep 29 11:50:23.986229 2018] [proxy:debug] [pid 27113:tid 140463228737280] proxy_util.c(2252): [client xxx.xxx.189.83:53264] AH02545: fcgi: has determined UDS as /run/php/php7.2-fpm.sock Si I guess is something related to proxy_fcgi. I'm stuck... I made some progress: <FilesMatch \.()$> SetHandler proxy:unix:/var/lib/apache2/fastcgi/1-froxlor.panel-xxx.xxxxxx.com-php-fpm.socket|fcgi://localhost </FilesMatch> should be: <FilesMatch \.php$>...</FilesMatch> Strange. Why is it not correctly generated? Then apache al least tries to pick the correct one (even if it fails): [Sat Sep 29 12:06:06.752157 2018] [proxy:error] [pid 28900:tid 140013299574528] (2)No such file or directory: AH02454: FCGI: attempt to connect to Unix domain socket /var/lib/apache2/fastcgi/1-froxlor.panel-xxx.xxxxx.com-php-fpm.socket (*) failed [Sat Sep 29 12:06:06.752228 2018] [proxy_fcgi:error] [pid 28900:tid 140013299574528] [client 95.120.189.83:54668] AH01079: failed to make connection to backend: httpd-UDS What did you end up doing guys? Thanks
  13. lanbo

    Bionic Beaver

    Thanks. I installed pdo-mysql I can run the cron: php /var/www/html/froxlor/scripts/froxlor_master_cronjob.php --force --debug [information] cron_tasks: Searching for tasks to do [information] apache::createIpPort: creating ip/port settings for 148.251.136.148:80 [debug] 148.251.136.148:80 :: inserted vhostcontainer [information] apache::createIpPort: creating ip/port settings for 148.251.136.148:443 [debug] 148.251.136.148:443 :: inserted vhostcontainer [information] apache::writeConfigs: rebuilding /etc/apache2/sites-enabled/ [information] apache::writeConfigs: rebuilding /etc/apache2/htpasswd/ [information] apache::writeConfigs: rebuilding /etc/apache2/sites-enabled/ mkdir: cannot create directory ‘’: No such file or directory [information] apache::reload: fpm config directory "/etc/php/7.2/fpm/pool.d/" is empty. Creating dummy. [information] apache::reload: running service php7.2-fpm restart [information] apache::reload: reloading apache [information] Task4 started - Rebuilding froxlor_bind.conf [information] Cleaning dns zone files from /etc/bind/domains/ [information] No domains found for nameserver-config, skipping... [notice] Creating passwd file [notice] Writing 0 entries to passwd file [notice] Succesfully wrote passwd file [notice] Creating group file [notice] Writing 0 entries to group file [notice] Succesfully wrote group file [notice] Creating shadow file [notice] Writing 0 entries to shadow file [notice] Succesfully wrote shadow file [notice] Checking system's last guid fpm is running: service php7.2-fpm status ● php7.2-fpm.service - The PHP 7.2 FastCGI Process Manager Loaded: loaded (/lib/systemd/system/php7.2-fpm.service; enabled; vendor preset: enabled) Active: active (running) since Sat 2018-09-29 10:42:41 CEST; 7min ago Docs: man:php-fpm7.2(8) Main PID: 21885 (php-fpm7.2) Status: "Processes active: 0, idle: 1, Requests: 0, slow: 0, Traffic: 0req/sec" Tasks: 2 (limit: 4915) CGroup: /system.slice/php7.2-fpm.service ├─21885 php-fpm: master process (/etc/php/7.2/fpm/php-fpm.conf) └─21886 php-fpm: pool dummy Sep 29 10:42:41 ihtaca systemd[1]: Starting The PHP 7.2 FastCGI Process Manager... Sep 29 10:42:41 ihtaca systemd[1]: Started The PHP 7.2 FastCGI Process Manager. however, for some reason some socket file is missing: [Sat Sep 29 10:49:33.135842 2018] [proxy:error] [pid 21903:tid 140444239369984] (2)No such file or directory: AH02454: FCGI: attempt to connect to Unix domain socket /run/php/php7.2-fpm.sock (*) failed [Sat Sep 29 10:49:33.135893 2018] [proxy_fcgi:error] [pid 21903:tid 140444239369984] [client 95.120.189.83:59498] AH01079: failed to make connection to backend: httpd-UDS Should this file be created by the cron?
  14. lanbo

    Bionic Beaver

    I understand. But, exactly what did I have to do? I'm checking demo.froxlor.org trying to understand what settings should I have done. How should I have prepared froxlor for 7.2 while I did not have it. There's no php7.0. That was one the points to upgrade to Bionic Beaver. To upgrade all the stuff without using PPAs... I have tried to: cp -a /etc/php/7.0 /etc/php/7.2 And then php /var/www/html/froxlor/scripts/froxlor_master_cronjob.php --force --debug froxlor[11284]: The php PDO extension or PDO-MySQL driver is not available froxlor[11284]: --- DEBUG: #0 /var/www/html/DB_UNPRIV_PWD/lib/classes/database/class.Database.php(178): Database::getDB() #1 /var/www/html/DB_UNPRIV_PWD/lib/cron_init.php(92): Database::__callStatic('query', Array) #2 /var/www/html/DB_UNPRIV_PWD/scripts/DB_UNPRIV_PWD_master_cronjob.php(20): include_once('/var/www/html/f...') #3 {main} We are sorry, but a MySQL - error occurred. The administrator may find more information in the syslog
  15. lanbo

    Bionic Beaver

    Yeah, so I guess it's all broken now. How should I have done it? I mean, what should I have done before upgrading to Bionic Beaver (php 7.2)?
×
×
  • Create New...