I have a PHP application / website served by nginx. When I navigate around the website using Google Chrome with the dev tools network panel open I can see just prior to navigating to a new page URL page there is a prefetch request, that the server returns with code 503 (not available).
CloudFlare is being used as a proxy.
I'm concerned about these 503 errors. Is an nginx configuration required to handle prefetch requests properly?
My PHP 7.2 application is giving the error Message: Class 'NumberFormatter' not found
We are running:
I tried to install PHP-intl and it seemed to work as now if I try again I get this:
# yum install php72-php-intl
# Package php72-php-intl-7.2.34-4.el7.remi.x86_64 already installed and latest version
# Nothing to do
I have reloaded Apache but the extension is not loaded:
php -m does not list the module.intl.soBy running rpm -ql php72-php-intl I can see these files are installed:
/etc/opt/remi/php72/php.d/20-intl.ini
/opt/remi/php72/root/usr/lib64/php/modules/intl.so
But the extension_dir is set to /usr/lib64/php/modules
Why is it installed to this other location? And how can I either get it to install to the correct modules directory or otherwise what is the correct way to tell PHP to load the .so file from /opt/remi/php72/root/usr/lib64/php/modules ?
I have a production environment where about once a week I'm finding the database needs to be repaired and restarted. The MariaDB database contains some InnoDB and some MyISAM tables (the mixture being mainly for legacy reasons, rather than something considered).
We are experiencing roughly weekly table crashes.
The log has nothing in it today until 13:44 when it starts with an apparent restart followed by a number of tables being reported as crashed:
180725 13:44:20 mysqld_safe Number of processes running now: 0
180725 13:44:20 mysqld_safe mysqld restarted
180725 13:44:21 [Warning] 'THREAD_CONCURRENCY' is deprecated and will be removed in a future release.
180725 13:44:21 [Note] /usr/libexec/mysqld (mysqld 5.5.56-MariaDB) starting as process 11977 ...
180725 13:44:21 InnoDB: The InnoDB memory heap is disabled
180725 13:44:21 InnoDB: Mutexes and rw_locks use GCC atomic builtins
180725 13:44:21 InnoDB: Compressed tables use zlib 1.2.7
180725 13:44:21 InnoDB: Using Linux native AIO
180725 13:44:21 InnoDB: Initializing buffer pool, size = 128.0M
180725 13:44:21 InnoDB: Completed initialization of buffer pool
180725 13:44:21 InnoDB: highest supported file format is Barracuda.
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
InnoDB: Last MySQL binlog file position 0 15064581, file name ./mysql-bin.000014
180725 13:44:22 InnoDB: Waiting for the background threads to start
180725 13:44:23 Percona XtraDB (http://www.percona.com) 5.5.52-MariaDB-38.3 started; log sequence number 355063376
180725 13:44:23 [Note] Plugin 'FEEDBACK' is disabled.
180725 13:44:23 [Note] Recovering after a crash using mysql-bin
180725 13:44:23 [Note] Starting crash recovery...
180725 13:44:23 [Note] Crash recovery finished.
180725 13:44:23 [Note] Server socket created on IP: '0.0.0.0'.
180725 13:44:23 [Warning] 'proxies_priv' entry '@ root@prod3' ignored in --skip-name-resolve mode.
180725 13:44:23 [Note] Event Scheduler: Loaded 0 events
180725 13:44:23 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.5.56-MariaDB' socket: '/var/lib/mysql/mysql.sock' port: 3306 MariaDB Server
180725 13:44:33 [ERROR] mysqld: Table './prod/products' is marked as crashed and should be repaired
180725 13:44:33 [Warning] Checking table: './prod/products'
180725 13:44:33 [ERROR] mysqld: Table './prod/product_images' is marked as crashed and should be repaired
180725 13:44:33 [Warning] Checking table: './prod/product_images'
180725 13:44:33 [ERROR] mysqld: Table './prod/products_linked_groups' is marked as crashed and should be repaired
180725 13:44:33 [Warning] Checking table: './prod/products_linked_groups'
180725 13:44:34 [ERROR] mysqld: Table './prod/pricer_items' is marked as crashed and should be repaired
180725 13:44:34 [Warning] Checking table: './prod/pricer_items'
180725 13:45:03 [ERROR] mysqld: Table './prod/email_queue' is marked as crashed and should be repaired
180725 13:45:03 [Warning] Checking table: './prod/email_queue'
180725 13:45:20 [ERROR] mysqld: Table './prod/stock' is marked as crashed and should be repaired
180725 13:45:20 [Warning] Checking table: './prod/stock'
180725 13:45:56 [ERROR] mysqld: Table './prod/wrpm_users' is marked as crashed and should be repaired
180725 13:45:56 [Warning] Checking table: './prod/wrpm_users'
180725 13:45:56 [ERROR] mysqld: Table './prod/users_files' is marked as crashed and should be repaired
180725 13:45:56 [Warning] Checking table: './prod/users_files'
180725 13:50:50 [ERROR] mysqld: Table './prod/faqs' is marked as crashed and should be repaired
180725 13:50:50 [Warning] Checking table: './prod/faqs'
180725 13:51:20 [ERROR] mysqld: Table './prod/orders' is marked as crashed and should be repaired
180725 13:51:20 [Warning] Checking table: './prod/orders'
180725 13:51:20 [ERROR] mysqld: Table './prod/orders_products' is marked as crashed and should be repaired
180725 13:51:20 [Warning] Checking table: './prod/orders_products'
180725 13:56:41 [Note] /usr/libexec/mysqld: Normal shutdown
I know how recover this and have used all of the following commands:
systemctl status mariadb
mysqlcheck --auto-repair -A -u root -p
myisamchk -o /var/lib/mysql/prod/*.MYI (used with caution!)
What I would like help with is how to begin to diagnose the cause of the problem. Perhaps there is something obviously wrong in the configuration?
The config file /etc/my.cnf.d/server.cnf contains:
[mysqld]
port = 3306
socket = /var/lib/mysql/mysql.sock
skip-external-locking
# Skip reverse DNS lookup of clients
skip_name_resolve = 1
# key_buffer_size = 256M
# max_allowed_packet = 1M
# table_open_cache = 256
sort_buffer_size = 1M
read_buffer_size = 1M
read_rnd_buffer_size = 4M
myisam_sort_buffer_size = 64M
thread_cache_size = 8
query_cache_size= 16M
thread_concurrency = 8
wait_timeout=30
max_allowed_packet = 16M
max_connections = 100 #default is 151
# Replication Master Server (default)
# binary logging is required for replication
log-bin=mysql-bin
# binary logging format - mixed recommended
binlog_format=mixed
# required unique id between 1 and 2^32 - 1
server-id = 1
[mysqldump]
quick
max_allowed_packet = 16M
[mysql]
no-auto-rehash
# Remove the next comment character if you are not familiar with SQL
#safe-updates
[myisamchk]
key_buffer_size = 128M
sort_buffer_size = 128M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
I am running a Lamp server on CentOS release 6.6 (Final) with php5.5:
$ php -v
PHP 5.5.17 (cli) (built: Sep 20 2014 17:12:00)
Copyright (c) 1997-2014 The PHP Group
Zend Engine v2.5.0, Copyright (c) 1998-2014 Zend Technologies
with Zend OPcache v7.0.4-dev, Copyright (c) 1999-2014, by Zend Technologies
with Xdebug v2.2.5, Copyright (c) 2002-2014, by Derick Rethans
When I run yum update I get this dependency error:
Loaded plugins: fastestmirror
Setting up Update Process
Loading mirror speeds from cached hostfile
* webtatic: uk.repo.webtatic.com
Resolving Dependencies
--> Running transaction check
---> Package libwebp.x86_64 0:0.3.1-2.el6.remi will be updated
--> Processing Dependency: libwebp.so.4()(64bit) for package: ImageMagick-last-libs-6.8.9.7-4.el6.remi.x86_64
---> Package libwebp.x86_64 0:0.4.3-3.el6 will be an update
--> Finished Dependency Resolution
Error: Package: ImageMagick-last-libs-6.8.9.7-4.el6.remi.x86_64 (@remi)
Requires: libwebp.so.4()(64bit)
Removing: libwebp-0.3.1-2.el6.remi.x86_64 (@remi)
libwebp.so.4()(64bit)
Updated By: libwebp-0.4.3-3.el6.x86_64 (epel)
Not found
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest
My vague understanding of this is that the ImageMagick update requires libwebp.so.4, but I have libwebp-0.3.1-2.el6.remi.x86_64 from the @remi rpm but this has since been updated to libwebp-0.4.3-3.el6.x86_64 from the epel rpm.
Is that correct? If not what does the above output mean?
And more importantly how might I fix this?
I want the directory index file in the root of my site to be index.html but within a subdirectory /foo I want it to be bar.html
i.e.
Also I want requests to /foo or /foo/ or /foo/:anything to resolve to bar.html
Here's the server definition:
server {
listen 80;
server_name domain.tld;
port_in_redirect off;
location / {
# ssl is terminated at our load bal
if ($http_x_forwarded_proto != 'https') {
rewrite ^ https://$host$request_uri? permanent;
}
root /usr/share/nginx/mysite/public;
index index.html;
add_header Cache-Control "public max-age=600";
add_header "X-UA-Compatible" "IE=Edge,chrome=1";
charset UTF-8;
}
# this location doesn't work <<<<<<<<<<<<<<
location /foo {
root /usr/share/nginx/mysite/public/foo;
index bar.html;
}
# set expiration of assets to 30d for caching
location ~* \.(ico|css|js|gif|jpe?g|png)(\?[0-9]+)?$ {
root /usr/share/nginx/mysite/public;
expires 30d;
add_header Cache-Control "public";
log_not_found off;
}
}
EDIT: I also had the following at the bottom of that server block.
error_page 404 /404.html;
location = /404.html {
root /usr/share/nginx/www;
}
# redirect server error pages to the static page /50x.html
error_page 500 502 503 504 /50x.html;
location = /50x.html {
root /usr/share/nginx/www;
}
I have read the canonical answer at What permissions should my website files/folders have on a Linux webserver?
However I'm still stuck. My setup is:
fastcgi_pass unix:/tmp/php5-fpm.sock;I have created a webadmin group and added both 'ade' and nginx to it:
$ groups ade
ade : ade webadmin
$ groups nginx
nginx : nginx webadmin
I have set the owner of everything in the site to be me and the webadmin group: chown ade:webadmin *
...as you can see:
drwxrwxr-x 2 ade webadmin 4096 Jul 3 13:58 logs
drwxrwxr-x 5 ade webadmin 4096 Jul 4 08:35 public
drwxrwxr-x 4 ade webadmin 4096 Jul 3 16:18 system
drwxrwsr-x 2 ade webadmin 4096 Jul 9 16:13 uploads
However despite the permissions of uploads being 775 (rwx for both user and group) nginx and php cannot write to the folder. Only if I set it to 777 can it upload images to it.
I saw the advice about using chmod u+w in the above canonical answer but don't understand why this is necessary.
I have discovered that I can set the TTL in Varnish as follows in my VCL file:
sub vcl_fetch {
# 1 minute
set obj.ttl = 1m;
}
But what is the default setting (assuming the backend server is setting no cache-control header) ?
I need to run both http and https on the same hostnames on my server. I had everything running without SSL with hosts configured in the /etc/httpd/conf.d directory.
System: CentOS release 5.6 (Final)
Server: Apache/2.2.3
I was following the instructions here: http://shapeshed.com/journal/setting_up_mod_ssl_on_apache_centos_52/
But now:
sudo /etc/init.d/httpd restart
Responds with:
Starting httpd: (98)Address already in use: make_sock: could not bind to address [::]:443
(98)Address already in use: make_sock: could not bind to address 0.0.0.0:443
no listening sockets available, shutting down
Unable to open logs
[FAILED]
At the bottom of /etc/httpd/conf/httpd.conf I have:
NameVirtualHost *:80
I tried adding NameVirtualHost *:443 below that but it didn't help.
One more thing: Webmin was previously installed and that is already running at http://XXX.XXX.XXX.XXX:10000
Could that be a factor?
Any help would be greatly appreciated; as you can probably tell I'm flying by Google here I've not done this before.
Thanks!
I'm having problems getting PHP to send mail via Postfix on CentOS Linux 5.6.
I've got Postfix version 2.3.3, which was installed with Yum. I also installed Dovecot as per a tutorial, though I'm not sure whether I need this just to send via SMTP.
When the PHP mail() command runs I get this in /var/log/maillog:
Aug 22 10:30:57 ade1 postfix[5798]: error: to submit mail, use the Postfix sendmail command
Aug 22 10:30:57 ade1 postfix[5798]: fatal: the postfix command is reserved for the superuser
I have Webmin installed, and here's the SMTP settings page: http://dl.dropbox.com/u/618674/_perma/2011-08/webmin-postfix-smtp.png
I entered some config settings changes in /etc/postfix/main.cf as per this tutorial: http://wiki.centos.org/HowTos/postfix
In /etc/php.ini I have this:
sendmail_path = /usr/sbin/postfix -t -i
Anyone got any ideas about this "to submit mail, use the Postfix sendmail command" error?
Would I be better using Sendmail? I was advised that Postfix was simpler!
Cheers :)
Also... (may be related),
chkconfig --level 345 dovecot on
returns this:
failed to make symlink /etc/rc0.d/K74lvm2-monitor: File exists
failed to make symlink /etc/rc1.d/S26lvm2-monitor: File exists
failed to make symlink /etc/rc2.d/S26lvm2-monitor: File exists
failed to make symlink /etc/rc3.d/S26lvm2-monitor: File exists
failed to make symlink /etc/rc4.d/S26lvm2-monitor: File exists
failed to make symlink /etc/rc5.d/S26lvm2-monitor: File exists
failed to make symlink /etc/rc6.d/K74lvm2-monitor: File exists
failed to make symlink /etc/rc0.d/K35dovecot: File exists
failed to make symlink /etc/rc1.d/K35dovecot: File exists
failed to make symlink /etc/rc2.d/K35dovecot: File exists
failed to make symlink /etc/rc3.d/S65dovecot: File exists
failed to make symlink /etc/rc4.d/S65dovecot: File exists
failed to make symlink /etc/rc5.d/S65dovecot: File exists
failed to make symlink /etc/rc6.d/K35dovecot: File exists
failed to make symlink /etc/rc3.d/S65dovecot: File exists
failed to make symlink /etc/rc4.d/S65dovecot: File exists
failed to make symlink /etc/rc5.d/S65dovecot: File exists