mathz.nu Asterisk Blacklist Hobby webbhotell

2021/12/28

NET::ERR_CERT_INVALID – Dockerfile docker-unifi-controller

Filed under: Hemsidor — Mathz @ 14:56

There’s a secret passphrase built into the error page. Just make sure the page is selected (click anywhere on the screen), and just type thisisunsafe.

2019/10/17

Automatically owned by www-data

Filed under: Hemsidor,PHP — Mathz @ 09:50

To make sure any file or folder you create in /var/www/html gets automatically owned by www-data you can use inotify, it’s like cron but monitors folders/files for changes in attribuets, file creations, modifications and much more.

First install it with:

$ sudo apt-get install incron

Allow root to use incron by opening /etc/incron.allow with:

$ sudo vim /etc/incron.allow

and add root to the file, then save and exit.

Edit your incrontab with:

$ sudo incrontab -u root -e

and add the following line to it:

/var/www/html IN_CREATE /bin/chown -R www-data:www-data /var/www/html/

save and exit.

Now as soon as a file is created in the /var/www/html direcotry it will automatically set onwership to www-data:www-data.

Explanation of the line in incrontab:

/var/www/html is the directory that will be monitored.

IN_CREATE will watch for created files. It’s the file change mask.

/bin/chown -R www-data:www-data /var/www/html/ is the command/action to execute.

2017/02/13

SQL Update

Filed under: PHP — Mathz @ 21:04

UPDATE `Smslog` SET`State`=7 WHERE RIGHT(‘2017-02-13’,Idate) AND State = 14

2015/01/11

Split IBDATA1

Filed under: Hemsidor,MySQL,Server — Mathz @ 23:44
  1. Dump all databases by calling:
    mysqldump --extended-insert --all-databases --add-drop-database --disable-keys --flush-privileges --quick --routines --triggers > all-databases.sql
  2. Stop the MySQL server;
  3. Rename or remove (in case you’ve already backed it up) the MySQL data directory and create an empty one with the same name and permissions;
  4. Make the appropriate changes in my.cnf;
    innodb_file_per_table
  5. Re-initialize the database with the following command (replace the ‘mysqld‘ with the login of the user your MySQL server runs as):
    sudo -u mysqld mysql_install_db
  6. Start the MySQL server;
  7. Get into the ‘mysql‘ console and type:
    SET FOREIGN_KEY_CHECKS=0;
    SOURCE all-databases.sql;
    SET FOREIGN_KEY_CHECKS=1;
  8. Restart the MySQL server.

2012/05/18

Regexp

Filed under: PHP — Mathz @ 19:15

Simple regex

Regex quick reference
[abc]     A single character: a, b or c
[^abc]     Any single character but a, b, or c
[a-z]     Any single character in the range a-z
[a-zA-Z]     Any single character in the range a-z or A-Z
^     Start of line
$     End of line
\A     Start of string
\z     End of string
.     Any single character
\s     Any whitespace character
\S     Any non-whitespace character
\d     Any digit
\D     Any non-digit
\w     Any word character (letter, number, underscore)
\W     Any non-word character
\b     Any word boundary character
(...)     Capture everything enclosed
(a|b)     a or b
a?     Zero or one of a
a*     Zero or more of a
a+     One or more of a
a{3}     Exactly 3 of a
a{3,}     3 or more of a
a{3,6}     Between 3 and 6 of a

options: i case insensitive m make dot match newlines x ignore whitespace in regex o perform #{...} substitutions only once

2009/01/03

PHP i WordPress

Filed under: Wordpress — Mathz @ 22:03

För att köra PHP kod i WordPress behöver man en kod exekverare. Jag använder mig av PHPExec-2

Powered by WordPress