General

Proxy, Firewall, and DNS

NFS

Open Journal System (OJS)

E-mail

Java

Oracle

Python

PDF Support

  • sudo apt-get install pdfmod
  • sudo apt-get install pdftoppm
  • pdftoppm input.pdf outputname -png

WordPress

  • CREATE DATABASE WP_USER;
  • CREATE USER ‘WP_USER’@’localhost’ IDENTIFIED BY ‘PASSWORD’;
  • GRANT ALL PRIVILEGES ON WP_USER.* TO ‘WP_USER’@’localhost’;

MySQL

  • Instalation
  • Backup
    • mysqldump –force –opt –user=$USER –password=$PASSWORD –databases $db | gzip -c > $OUTPUT/$db.gz
  • Restore
    • gzip -d $db.gz
    • mysql -u root -p $db < $db
  • Remote calls
    • CREATE USER ‘user’@’%’ IDENTIFIED BY ‘senha’;
    • GRANT ALL ON *.* TO user@’%’ WITH GRANT OPTION ;

PostgreSQL

  • Backup
    • su - postgres -c "/usr/bin/pg_dump $db | gzip -c > $DIR/$db.gz"
  • Restore
    • gunzip $db.gz
    • su - postgres -c "psql -d $db -f $DIR/$db"
  • Change postgres password
    • su -l postgres
    • psql
      • alter user postgres with password ‘<senha>’;
  • Remote Access
    • Edit postgresql.conf
      • Change:listen = ‘*’
    • Edit pg_hba.conf
      • Include:host all all 0.0.0.0 0.0.0.0 md5
  • Main

Locale

  • locale-gen pt_BR pt_BR.UTF-8
  • dpkg-reconfigure locales
  • apt-get dist-upgrade
  • vi /etc/default/locale
    • LANG=en_US.UTF-8
    • LANGUAGE=en_US.UTF-8
    • LC_CTYPE=en_US.UTF-8Se

[:en]General

Proxy, Firewall, and DNS

NFS

Open Journal System (OJS)

E-mail

Java

Oracle

Python

PDF Support

  • sudo apt-get install pdfmod
  • sudo apt-get install pdftoppm
  • pdftoppm input.pdf outputname -png

WordPress

  • CREATE DATABASE WP_USER;
  • CREATE USER ‘WP_USER’@’localhost’ IDENTIFIED BY ‘PASSWORD’;
  • GRANT ALL PRIVILEGES ON WP_USER.* TO ‘WP_USER’@’localhost’;

MySQL

  • Instalation
  • Backup
    • mysqldump –force –opt –user=$USER –password=$PASSWORD –databases $db | gzip -c > $OUTPUT/$db.gz
  • Restore
    • gzip -d $db.gz
    • mysql -u root -p $db < $db
  • Remote calls
    • GRANT ALL PRIVILEGES ON $db.* TO ‘$USER’@’%’ IDENTIFIED BY ‘$PASSWORD’ WITH GRANT OPTION;

PostgreSQL

  • Backup
    • su - postgres -c "/usr/bin/pg_dump $db | gzip -c > $DIR/$db.gz"
  • Restore
    • gunzip $db.gz
    • su - postgres -c "psql -d $db -f $DIR/$db"
  • Version 9.4
    • Create the file/etc/apt/sources.list.d/pgdg.list, and add a line for the repository
      • deb https://apt.postgresql.org/pub/repos/apt/trusty-pgdg main
    • Import the repository signing key, and update the package lists
      • wget --quiet -O - https://www.postgresql.org/media/keys/ACCC4CF8.asc | \
        sudo apt-key add -
        sudo apt-get update
  • Remote Access
    • Edit postgresql.conf
      • Change:listen = ‘*’
    • Edit pg_hba.conf
      • Include:host all all 0.0.0.0 0.0.0.0 md5
  • Main

Locale

  • locale-gen pt_BR pt_BR.UTF-8
  • dpkg-reconfigure locales
  • apt-get dist-upgrade
  • vi /etc/default/locale
    • LANG=en_US.UTF-8
    • LANGUAGE=en_US.UTF-8
    • LC_CTYPE=en_US.UTF-8Se