mysql hints

First steps mysql_secure_installation Passwordpress login mysql create ~/.my.cnf  with [client] password=plaintextpassword user=root Create Database long variant ; create database testdb; create user ‘testuser’@’localhost’ identified by ‘password’; grant all on testdb.* to ‘testuser’ identified by ‘password’; short one : create database testdb; grant all on testdb.* to ‘testuser’ identified by ‘password’; Reset the MySQL Root Password …

Continue reading ‘mysql hints’ »

simple lsyncd config.

—-Node1—- — User configuration file for lsyncd. — — Simple example for default rsync, but executing moves through on the target. — — For more examples, see /usr/share/doc/lsyncd*/examples/ — settings = { logfile = “/var/log/lsyncd.log”, statusFile =”var/log/lsyncd.stat”, statusInterval = 1, insist = true, } sync { default.rsync, source=”/etc/asterisk”, target=”asterisk2:/etc/asterisk”, rsync = { verbose = true, …

Continue reading ‘simple lsyncd config.’ »

openvpn client/server conf + iptables forward

// client // client dev tun proto udp remote IP  1194 nobind persist-key persist-tun comp-lzo log-append openvpn-log verb 3 mute 10 // Server // proto udp dev tun port 1194 server 10.100.200.0 255.255.255.0 push “route 192.168.3.0 255.255.255.0” client-config-dir ccd client-to-client ifconfig-pool-persist ipp.txt keepalive 10 120 comp-lzo persist-key persist-tun status openvpn-status.log 20 log-append openvpn-log verb 3 …

Continue reading ‘openvpn client/server conf + iptables forward’ »