Installer Roundcube(Apache: certificat ssl let’s encrypt )

-Télécharger l’archive .tar.gz # wget https://downloads.sourceforge.net/project/roundcubemail/roundcubemail/1.1.3/roundcubemail-1.1.3-complete.tar.gz -Décompresser le fichier: # tar xfz roundcubemail-1.1.3-complete.tar.gz -Déplacer les fichiers vers le dossier du serveur web: # mv roundcubemail-1.1.3/* /home/webmail.domaine.tld/ # chown -R www-data:www-data /home/webmail.domaine.tld/ -Créer la base de données roundcube (avec utilisateur roundcube): mysql> CREATE DATABASE roundcube; mysql> GRANT ALL PRIVILEGES ON roundcube.* TO roundcube@localhost IDENTIFIED BY ‘PASSWD’; mysql> FLUSH PRIVILEGES; -Importer le fichier de dump: mysql -u root -p roundcube < /home/webmail.domaine.tld/SQL/mysql.initial.sql -Créer le vhost (/etc/apache2/site-available/) : DocumentRoot /home/webmail.domaine.tldServerName webmail.domaine.tld Options FollowSymLinksAllowOverride […]

Plus

Mysql: moteurs de stockage

MySQL dispose de nombreux moteurs, Voici les principaux : MyISAM InnoDB MEMORY (anciennement HEAP) MERGE BLACKHOLE BerkeleyDB ou BDB ARCHIVE CSV FEDERATED Pour vérifier les moteurs de stockage disponibles : mysql –defaults-file=/etc/mysql/debian.cnf mysql> use mysql; mysql> show engines; +—————————————+—————+——————————————————————————–+——————+—–+—————-+| Engine                                     | Support    | Comment                                                                                  | Transactions | XA | Savepoints |+—————————————+—————+——————————————————————————–+——————+—–+—————-+| MRG_MYISAM                       | YES          | Collection of identical MyISAM tables                                      | NO                | NO | NO              || CSV                                        | YES          | CSV storage engine                                                                 | NO                | NO | NO              || MyISAM                                  | YES          | MyISAM storage engine                                                           | NO                | NO […]

Plus

GoAccess: Analyser les logs web en temps réel

Installer le paquet: apt-get install goaccess Pour analyser les logs: goaccess -f /path/fichier_log Options: -f :input-file Path to input log file. -c :Prompt date and log format configuration window. -e :Exclude an IP from being counted under the HOST module. -a :Enable a list of User-Agents for the selected host. exemple: goaccess -f /path/fichier_log -e 127.0.0.1   (localhost)

Plus

Debian:installer nagios 4

Installer les pré-requis apt-get install wget unzip zip autoconf gcc libc6 make apache2-utils libmcrypt-dev libssl-dev bc gawk dc build-essential snmp libnet-snmp-perl gettext libldap2-dev smbclient fping libmysqlclient-dev libpqxx3-dev libdbi-dev Ajouter l’utilisateur nagios useradd nagios usermod -a -G nagios www-data Installer nagios 4 avec les sources wget http://prdownloads.sourceforge.net/sourceforge/nagios/nagios-4.4.2.tar.gz tar xzf nagios-4.4.2.tar.gz Lancer la compilation cd nagios-4.4.2 ./configure –with-httpd-conf=/etc/apache2/sites-enabled make all make install make install-init make install-commandmode make install-config make install-webconf Modifier le mot de passe de l’utilisateur nagiosadmin htpasswd -c /usr/local/nagios/etc/htpasswd.users nagiosadmin Activer le module […]

Plus

MySQL installation multi-instances: réplication master slave, réplication master master

MySQL multi-instances: Faire une copie du fichier my.cnf  (sous /etc ou /etc/mysql) scp my.cnf my.cnf.old Modifier le fichier my.cnf Fichier par défaut: [client] port = 3306 socket = /var/run/mysqld/mysqld.sock [mysqld_safe] socket = /var/run/mysqld/mysqld.sock [mysqld] user = mysql pid-file = /var/run/mysqld/mysqld.pid socket = /var/run/mysqld/mysqld.sock port = 3306 basedir = /usr datadir = /var/lib/mysql bind-address = 127.0.0.1 log = /var/log/mysql/mysql.log Ajouter  les instances : [mysqld1] user = mysql pid-file = /var/run/mysqld/mysqld1.pid socket = /var/run/mysqld/mysqld1.sock port = 3307 basedir = /usr datadir = /var/lib/mysql1 bind-address = 127.0.0.1 […]

Plus