WIKI Liberasys

Outils pour utilisateurs

Outils du site

Piste :
dolibarr:dolibarr

Différences

Ci-dessous, les différences entre deux révisions de la page.

Lien vers cette vue comparative

Les deux révisions précédentesRévision précédente
dolibarr:dolibarr [2018/09/05 15:00] – ronandolibarr:dolibarr [2019/01/14 10:14] (Version actuelle) – rguyader
Ligne 6: Ligne 6:
 ===== Créer les espaces de données, pour le snapshot mylvmbackup ===== ===== Créer les espaces de données, pour le snapshot mylvmbackup =====
  
-  apt-get install lvm2 mylvmbackup +<code bash> 
-  pvcreate /dev/vda4 +apt-get install lvm2 mylvmbackup 
-  vgcreate vg-data /dev/vda4 +pvcreate /dev/vda4 
-  lvcreate -n data vg-data -l 40%VG +vgcreate vg-data /dev/vda4 
-  lvcreate -n data-sqlbkp vg-data -l 40%VG +lvcreate -n data vg-data -l 40%VG 
-  mkfs.xfs /dev/vg-data/data +lvcreate -n data-sqlbkp vg-data -l 40%VG 
-  mkfs.xfs /dev/vg-data/data-sqlbkp +mkfs.xfs /dev/vg-data/data 
-  mkdir /data +mkfs.xfs /dev/vg-data/data-sqlbkp 
-  mkdir /data-sqlbkp +mkdir /data 
-  echo -e "/dev/vg-data/data /data\t\txfs\tdefaults\t0\t2" >> /etc/fstab +mkdir /data-sqlbkp 
-  echo -e "/dev/vg-data/data-sqlbkp /data-sqlbkp\txfs\tdefaults\t0\t2" >> /etc/fstab +echo -e "/dev/vg-data/data /data\t\txfs\tdefaults\t0\t2" >> /etc/fstab 
-  mount -a+echo -e "/dev/vg-data/data-sqlbkp /data-sqlbkp\txfs\tdefaults\t0\t2" >> /etc/fstab 
 +mount -a 
 +</code>
  
 ===== Télécharger dollideb installer dans /opt ===== ===== Télécharger dollideb installer dans /opt =====
Ligne 23: Ligne 25:
 http://sourceforge.net/projects/dolibarr/files/ http://sourceforge.net/projects/dolibarr/files/
  
-  apt-get install dbconfig-common +<code bash> 
-  dpkg -i /opt/dolibarr_XXX_all.deb +apt-get install dbconfig-common 
-  apt-get install -f+dpkg -i /opt/dolibarr_XXX_all.deb 
 +apt-get install -f 
 +</code>
  
 Nouveau mot de passe du superutilisateur de MySQL : créer un nouveau mot de passe, le renseigner dans les keepass (mysql/root)   Nouveau mot de passe du superutilisateur de MySQL : créer un nouveau mot de passe, le renseigner dans les keepass (mysql/root)  
Ligne 32: Ligne 36:
 ===== Déplacer la base mysql ===== ===== Déplacer la base mysql =====
  
-  service mysql stop +<code bash> 
-  mv /var/lib/mysql/ /data +service mysql stop 
-  cp -a /etc/mysql/my.cnf /etc/mysql/my.cnf_ +mv /var/lib/mysql/ /data 
-  sed -i "s/^datadir.*=.*$/datadir\t\t= \/data\/mysql/g" /etc/mysql/my.cnf +cp -a /etc/mysql/my.cnf /etc/mysql/my.cnf_ 
-  service mysql start+sed -i "s/^datadir.*=.*$/datadir\t\t= \/data\/mysql/g" /etc/mysql/my.cnf 
 +service mysql start 
 +</code>
  
 ===== Déplacer les données dolibarr ===== ===== Déplacer les données dolibarr =====
  
-  service apache2 stop +<code bash> 
-  mv /var/lib/dolibarr /data/dolibarr +service apache2 stop 
-  cp -a /etc/dolibarr/install.forced.php /etc/dolibarr/install.forced.php_ +mv /var/lib/dolibarr /data/dolibarr 
-  cp -a /etc/dolibarr/install.forced.php.install /etc/dolibarr/install.forced.php.install_ +cp -a /etc/dolibarr/install.forced.php /etc/dolibarr/install.forced.php_ 
-  sed -i "s/^datadir.*=.*$/datadir\t\t= \/data\/mysql/g" /etc/mysql/my.cnf +cp -a /etc/dolibarr/install.forced.php.install /etc/dolibarr/install.forced.php.install_ 
-  sed -i "s/^\$force_install_main_data_root.*=.*$/\$force_install_main_data_root='\/data\/dolibarr';/g" /etc/dolibarr/install.forced.php +sed -i "s/^datadir.*=.*$/datadir\t\t= \/data\/mysql/g" /etc/mysql/my.cnf 
-  sed -i "s/^\$force_install_main_data_root.*=.*$/\$force_install_main_data_root='\/data\/dolibarr';/g" /etc/dolibarr/install.forced.php.install +sed -i "s/^\$force_install_main_data_root.*=.*$/\$force_install_main_data_root='\/data\/dolibarr';/g"/etc/dolibarr/install.forced.php 
-  chown www-data:www-data /data/dolibarr +sed -i "s/^\$force_install_main_data_root.*=.*$/\$force_install_main_data_root='\/data\/dolibarr';/g"/etc/dolibarr/install.forced.php.install 
-  service apache2 start+chown www-data:www-data /data/dolibarr 
 +service apache2 start 
 +</code>
  
 ===== Sécuriser/tuner apache ===== ===== Sécuriser/tuner apache =====
  
-  cp -aL /etc/apache2/conf.d/dolibarr.conf /data-bkp/apache_conf.d_dolibarr.conf +<code bash> 
-  sed -i "s/Alias \/dolibarr \/usr\/share\/dolibarr\/htdocs/Alias \/dol \/usr\/share\/dolibarr\/htdocs/g" /etc/apache2/conf.d/dolibarr.conf +cp -aL /etc/apache2/conf.d/dolibarr.conf /data-bkp/apache_conf.d_dolibarr.conf 
-  service apache2 stop +sed -i "s/Alias \/dolibarr \/usr\/share\/dolibarr\/htdocs/Alias \/dol \/usr\/share\/dolibarr\/htdocs/g"/etc/apache2/conf.d/dolibarr.conf 
-  service apache2 start+service apache2 stop 
 +service apache2 start 
 +</code>
  
 XXXXXXXXXXXXXXXXXXXXXXXXXX  secu   XXXXXXXXXXXXXXXXXXXXXXXXXX  secu  
Ligne 116: Ligne 126:
 ----- -----
  
-  cd /opt +<code bash> 
-  wget http://www.espocrm.com/downloads/EspoCRM-3.6.2.zip +cd /opt 
-  apt-get install unzip php5-mcrypt php5-imap +wget http://www.espocrm.com/downloads/EspoCRM-3.6.2.zip 
-  unzip EspoCRM-3.6.2.zip +apt-get install unzip php5-mcrypt php5-imap 
-  cd EspoCRM-3.6.2 +unzip EspoCRM-3.6.2.zip 
-  find . -type d -exec chmod 755 {} \; +cd EspoCRM-3.6.2 
-  find . -type f -exec chmod 644 {} \; +find . -type d -exec chmod 755 {} \; 
-  find data custom -type d -exec chmod 775 {} \; +find . -type f -exec chmod 644 {} \; 
-  find data custom -type f -exec chmod 664 {} \; +find data custom -type d -exec chmod 775 {} \; 
-  chmod 775 client/custom +find data custom -type f -exec chmod 664 {} \; 
-  cd .. +chmod 775 client/custom 
-  chown -R www-data:www-data EspoCRM-3.6.2 +cd .. 
-  mv EspoCRM-3.6.2 /data/espocrm +chown -R www-data:www-data EspoCRM-3.6.2 
-  cd /data/espocrm+mv EspoCRM-3.6.2 /data/espocrm 
 +cd /data/espocrm
  
-  cp -a /etc/php5/apache2/php.ini /data-bkp/php5_php.ini.original +cp -a /etc/php5/apache2/php.ini /data-bkp/php5_php.ini.original 
-  sed -i "s/^max_execution_time.*/max_execution_time = 180/g" /etc/php5/apache2/php.ini +sed -i "s/^max_execution_time.*/max_execution_time = 180/g" /etc/php5/apache2/php.ini 
-  sed -i "s/^max_input_time.*/max_input_time = 180/g" /etc/php5/apache2/php.ini +sed -i "s/^max_input_time.*/max_input_time = 180/g" /etc/php5/apache2/php.ini 
-  sed -i "s/^memory_limit.*/memory_limit = 256M/g" /etc/php5/apache2/php.ini +sed -i "s/^memory_limit.*/memory_limit = 256M/g" /etc/php5/apache2/php.ini 
-  sed -i "s/^post_max_size.*/post_max_size = 50M/g" /etc/php5/apache2/php.ini +sed -i "s/^post_max_size.*/post_max_size = 50M/g" /etc/php5/apache2/php.ini 
-  sed -i "s/^upload_max_filesize.*/upload_max_filesize = 50M/g" /etc/php5/apache2/php.ini+sed -i "s/^upload_max_filesize.*/upload_max_filesize = 50M/g" /etc/php5/apache2/php.ini
  
-  vi /etc/apache2/sites-enabled/000-default+vi /etc/apache2/sites-enabled/000-default
  
-  echo -e "<IfModule mod_alias.c>\nAlias /espo /data/espocrm\n</IfModule>\n\t<Directory /data/espocrm/>\n\t\tAllowOverride All\n\t\tOrder deny,allow\n\t\tAllow from all\n\t</Directory>\n" > /etc/apache2/conf.d/espocrm.conf +echo -e "<IfModule mod_alias.c>\nAlias /espo /data/espocrm\n</IfModule>\n\t<Directory /data/espocrm/>\n\t\tAllowOverride All\n\t\tOrder deny,allow\n\t\tAllow from all\n\t</Directory>\n" > /etc/apache2/conf.d/espocrm.conf 
-  a2enmod rewrite +a2enmod rewrite 
-  a2enmod headers +a2enmod headers 
-  service apache2 stop +service apache2 stop 
-  service apache2 start+service apache2 start
  
-  export ESPODBNAME="db_espocrm" +export ESPODBNAME="db_espocrm" 
-  export ESPODBUSER="espouser" +export ESPODBUSER="espouser" 
-  export ESPODBPW="ObJFt0mUiYGZH2R8" +export ESPODBPW="ObJFt0mUiYGZH2R8" 
-  # initialisation tables mysql +</code> 
-  echo "CREATE DATABASE $ESPODBNAME;" > /root/tmp_mysql_espocrm.sql +# initialisation tables mysql 
-  echo "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER" >> /root/tmp_mysql_espocrm.sql +<code bash> 
-  echo "ON $ESPODBNAME.*" >> /root/tmp_mysql_espocrm.sql +echo "CREATE DATABASE $ESPODBNAME;" > /root/tmp_mysql_espocrm.sql 
-  echo "TO $ESPODBUSER@localhost" >> /root/tmp_mysql_espocrm.sql +echo "GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP,ALTER" >> /root/tmp_mysql_espocrm.sql 
-  echo "IDENTIFIED BY '$ESPODBPW';" >> /root/tmp_mysql_espocrm.sql +echo "ON $ESPODBNAME.*" >> /root/tmp_mysql_espocrm.sql 
-  echo "FLUSH PRIVILEGES;" >> /root/tmp_mysql_espocrm.sql +echo "TO $ESPODBUSER@localhost" >> /root/tmp_mysql_espocrm.sql 
-  cat /root/tmp_mysql_espocrm.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf +echo "IDENTIFIED BY '$ESPODBPW';" >> /root/tmp_mysql_espocrm.sql 
-  rm /root/tmp_mysql_espocrm.sql+echo "FLUSH PRIVILEGES;" >> /root/tmp_mysql_espocrm.sql 
 +cat /root/tmp_mysql_espocrm.sql | mysql --defaults-extra-file=/etc/mysql/debian.cnf 
 +rm /root/tmp_mysql_espocrm.sql
  
-  sed -i "s/^# RewriteBase \//RewriteBase \/espo\/api\/v1\//g" /data/espocrm/api/v1/.htaccess  +sed -i "s/^# RewriteBase \//RewriteBase \/espo\/api\/v1\//g" /data/espocrm/api/v1/.htaccess  
-  sed -i "s/.*RewriteEngine On.*/  RewriteEngine On\n  RewriteBase \/espo\//g" /data/espocrm/.htaccess +sed -i "s/.*RewriteEngine On.*/  RewriteEngine On\n  RewriteBase \/espo\//g" /data/espocrm/.htaccess  
 +</code>
  
 http://ddb01.liberasys.com:8081/espo/install/ http://ddb01.liberasys.com:8081/espo/install/
  
-  cat << 'EOF' > /etc/cron.d/espocrm +<code bash> 
-  # start atop daily at midnight +cat << 'EOF' > /etc/cron.d/espocrm 
-  * * * * * www-data /usr/bin/php -f /data/espocrm/cron.php > /dev/null 2>&1 +# start atop daily at midnight 
-  EOF +* * * * * www-data /usr/bin/php -f /data/espocrm/cron.php > /dev/null 2>&1 
-  service cron stop +EOF 
-  service cron start+service cron stop 
 +service cron start 
 +</code>
dolibarr/dolibarr.1536159616.txt.gz · Dernière modification : 2018/09/05 15:00 de ronan