2011 December

APK List

By WladyX on 29 December, 2011 | Android | A comment?

gLabels

gLabels is a program for creating labels and business cards for the GNOME desktop environment. It is designed to work with various laser/ink-jet peel-off label and business card sheets that you’ll find at most office supply stores. gLabels is free software and is distributed under the terms of the GNU General Public License (GPL).

homepage

By WladyX on | Cool Apps | A comment?

Ubuntu VirtualHost overlap on port 443, the first has precedence

log:

[warn] _default_ VirtualHost overlap on port 443,the first has precedence

solution:
add NameVirtualHost *:443 to /etc/apache2/ports.conf

source
By WladyX on | Apache, Ubuntu | A comment?

Strange character appearances in old posts (after db restore)

wp-config.php:
define('DB_CHARSET', 'utf8');

source

By WladyX on | Mysql, Wordpress | A comment?

Export the privileges from MySQL and then import to a new server

.bashrc:
mygrants()
{
mysql -B -N $@ -e "SELECT DISTINCT CONCAT(
'SHOW GRANTS FOR ''', user, '''@''', host, ''';'
) AS query FROM mysql.user" | \
mysql $@ | \
sed 's/\(GRANT .*\)/\1;/;s/^\(Grants for .*\)/## \1 ##/;/##/{x;p;x;}'
}

mygrants --host=prod-db1 --user=admin --password=secret | grep rails_admin | mysql --host=staging-db1 --user=admin --password=secret
mygrants --password=xxx> /mysql.grant

source

By WladyX on | Mysql, Scripts | A comment?

SSH Reverse DNS Lookup Disable

/etc/ssh/sshd_config:

UseDNS no

source

By WladyX on 15 December, 2011 | Ssh | A comment?

ssh-keygen & ssh-copy-id

ssh-keygen
ssh-copy-id -i ~/.ssh/id_rsa.pub root@ip

By WladyX on 14 December, 2011 | Ssh | A comment?

Install Legato client on Ubuntu Server

  • Install alien to convert rpmpackages
    • apt-get install alien
  • Convert to debian packages and install
    • alien --to-deb -i lgtoman-7.6.2.6-1.x86_64.rpm
    • alien --to-deb -i --scripts lgtoclnt-7.6.2.6-1.x86_64.rpm (ignore scripts warning)
  • cd /etc/init.d
  • update-rc.d networker defaults
  • Update /nsr/res/servers adding legatosrv (/nsr directory isn’t created until after networker is started the first time, even then the servers file isn’t created)
  • ./networker start

source

By WladyX on 13 December, 2011 | Ubuntu | A comment?