Sysadmin blog

Aller au contenu | Aller au menu | Aller à la recherche

Bienvenue sur mon blog!

Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Quisque sed felis. Aliquam sit amet felis. Mauris semper, velit semper laoreet dictum, quam diam dictum urna, nec placerat elit nisl in quam. Etiam augue pede, molestie eget, rhoncus at, convallis ut, eros. Aliquam pharetra. Nulla in tellus eget odio sagittis blandit. Maecenas at nisl. Nullam lorem mi, eleifend a, fringilla vel, semper at, ligula. Mauris eu wisi. Ut ante dui, aliquet nec...

Vous pouvez éditer ce texte grâce à la page de configuration du thème.

dimanche 25 septembre 2016

MySQL error : MySQL: “Access denied for user 'debian-sys-maint'@'localhost'”

Problem ?

For example when you need to do :

MySQL: “Access denied for user 'debian-sys-maint'@'localhost'”

Solution ?

# more /etc/mysql/debian.cnf
password = Password

You have to update

mysql> use mysql;
mysql> update user set password=PASSWORD("Password") where User='debian-sys-maint';

Lsyncd : "Consider increasing /proc/sys/fs/inotify/max_user_watches"

Problem ?

When you set up lsyncd with rsync, you could get this error in your logs :

Consider increasing /proc/sys/fs/inotify/max_user_watches

Solution ?

You need to increase the "max users watches" value :

echo 524288 > /proc/sys/fs/inotify/max_user_watches

For a permanent setting, update the value in /etc/sysctl.conf :

fs.inotify.max_user_watches = 524288

dimanche 18 septembre 2016

Assign an IP to your SMTP (with zimbra)

In your /opt/zimbra/postfix/conf/

sender_dependent_default_transport_maps = regexp:/opt/zimbra/postfix/conf/sdd_transport_maps.regexp

And in your map file :

  1. more /opt/zimbra/postfix/conf/sdd_transport_maps.regexp
# example :
# /@domain-test\.com$/  domain_test_com:

Set by domain in /opt/zimbra/postfix/conf/ :

domain_test_com  unix -       -       n       -       -       smtp
   -o smtp_bind_address=
   -o syslog_name=postfix-customer-domain_test_com

You check in your mail's head :

Received: from [] (	

mercredi 24 août 2016

VEEAM 2012 : System.OperationCanceledException: The operation was canceled.

Errors :

Service cannot be started. System.OperationCanceledException: The operation was canceled.
   at Veeam.Backup.DBCreator.BackupDatabaseDeployer.CanDeploy(IDatabaseVersion databaseVersion)
   at Veeam.Backup.DBCreator.BackupDatabaseDeployer.DatabaseDeploy()
   at Veeam.Backup.DBCreator.BackupDatabaseDeployer.Deploy()
   at Veeam.Backup.DBManager.SqlRetryableInitializer.Init()
   at Veeam.Backup.Service.CVbServiceImpl..ctor(CVbEnvironment env, CTerminationMediator terminator, IAirInteractions airInteractions)
   at Veeam.Backup.Service.CVeeamBackupSvc.OnStart(String[] args)
   at System.ServiceProcess.ServiceBase.ServiceQueuedMainCallback(Object state)

Solution :

You have to start/restart manually the SQL SERVER ! (via the SQL SERVER CONFIGURATION MANAGER)

jeudi 18 août 2016

[ASTUCE] Perte mot de passe admin owncloud

Dans le cas où vous perdez le mot de passe administrateur (admin) de l'application owncloud, vous pouvez le réinitialiser (il y a plusieurs solutions).

1/ Il faut générer un nouveau mot de passe en SHA :

echo -n "NewPassword" | sha1sum

2/ Puis mettre à jour le champ "password" dans la table "oc_users".

dimanche 17 avril 2016

Setting up HA with pfense

How to set up HA (high availability) with pfsense (master & slave) ?

In our case, we have :

  • two pfsense servers, already installed
  • two physical interfaces (1 for WAN and 1 for LAN).
  • 3 WAN IP (1 for each pfsense, one for the server which needs the network HA)
  • 3 LAN IP (1 for each pfsense, one will be the gateway)

1/ On each pfsense, assign two IPs for LAN ( & .172) & WAN :


2/ On the master

a/ We set up the virtual IP/gateway : (tab "firewall") :


b/ in "carps settings" (tab firewall/virt IP), we set the slave's IP (, add the login/password, click on "save" to apply the changes.


2/ On the slave

a/ in "carps settings" (tab firewall/virt IP), we set the master's IP (, click on "save" to apply the changes.


The next step is : the two pfsense must be synchronized.

On the master :


On the slave :


Conclusion :

From now , all the changes you will do must be done on the master.

mercredi 13 avril 2016

How to setup with HA

What is the purpose ?

We want to upgrade a loadbalancer (from from 7.x.x to 8.x.x. The solution is to reinstall the two lb.

Image v8.0.1 : v8.0.1-c758f11b.img.tar (1).xz

set up the network conf

On each lb :

1/ Next, you need to make a bootable USB with the image and then you boot on.

2/ You have to enter "Yes" to install, After that, you reboot your system.

3/ The first thing to do is to log in (user / password): root / loadbalancer

4/ Set up the two main interfaces : eth0 and eth1

# cat /etc/sysconfig/network-scripts/ifcfg-eth0_0
# Auto generated by appliance
# cat /etc/sysconfig/network-scripts/ifcfg-eth1_0
# Auto generated by appliance

And :

ifup eth0 & ifup eth1

Ping is now OK.

Set up the HA via the web after the two install

Start you browser and go on the : http://xx.xx.xx.xx:9080/ (login/passowrd :loadbalancer/loadbalancer)

You now go to "High Availability Configuration" fill in the peer adress and the password (loadbalancer in our case)