|
|
| Zeile 1: |
Zeile 1: |
| == more packages to install ==
| | #REDIRECT [[:en:Hetzner.de vServer Setup]] |
| # pacman -S net-tools
| |
| | |
| == network ==
| |
| * also see [[:en:Network Configuration]] or [[:en:Network Configuration#Static IP address]]
| |
| * proper values forIP adress and so on can be found from old debian installation at /etc/network/interfaces
| |
| * create and edit /etc/conf.d/network@ens3
| |
| * create and edit /etc/systemd/system/network@.service (without ens3 after @)
| |
| | |
| # systemctl enable network@ens3.service
| |
| | |
| * edit /etc/resolv.conf to setup name server (see same file from old debian installation for proper values)
| |
| | |
| == sshd ==
| |
| * see also [[:en:Secure Shell]]
| |
| * install openssh wih pacman
| |
| * enable it:
| |
| | |
| # systemctl enable sshd.service
| |
| | |
| == activate swap partition ==
| |
| # mkswap /dev/sda1
| |
| # swapon /dev/sda1
| |
| | |
| edit /etc/fstab and add this line at bottom
| |
| /dev/sda1 none swap defaults 0 0
| |
| | |
| == LAMP ==
| |
| # pacman -S apache php php-apache mariadb
| |
| | |
| <nowiki>Installing MariaDB/MySQL system tables in '/var/lib/mysql' ...
| |
| OK
| |
| Filling help tables...
| |
| OK
| |
| | |
| To start mysqld at boot time you have to copy
| |
| support-files/mysql.server to the right place for your system
| |
| | |
| PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER !
| |
| To do so, start the server, then issue the following commands:
| |
| | |
| '/usr/bin/mysqladmin' -u root password 'new-password'
| |
| '/usr/bin/mysqladmin' -u root -h eniac password 'new-password'
| |
| | |
| Alternatively you can run:
| |
| '/usr/bin/mysql_secure_installation'
| |
| | |
| which will also give you the option of removing the test
| |
| databases and anonymous user created by default. This is
| |
| strongly recommended for production servers.
| |
| | |
| See the MariaDB Knowledgebase at http://kb.askmonty.org or the
| |
| MySQL manual for more instructions.
| |
| | |
| You can start the MariaDB daemon with:
| |
| cd '/usr' ; /usr/bin/mysqld_safe --datadir='/var/lib/mysql'
| |
| | |
| You can test the MariaDB daemon with mysql-test-run.pl
| |
| cd '/usr/mysql-test' ; perl mysql-test-run.pl
| |
| | |
| Please report any problems with the '/usr/scripts/mysqlbug' script!
| |
| | |
| The latest information about MariaDB is available at http://mariadb.org/.
| |
| You can find additional information about the MySQL part at:
| |
| http://dev.mysql.com
| |
| Support MariaDB development by buying support/new features from
| |
| Monty Program Ab. You can contact us about this at sales@montyprogram.com.
| |
| Alternatively consider joining our community based development effort:
| |
| http://kb.askmonty.org/en/contributing-to-the-mariadb-project/
| |
| | |
| >> If you are migrating from MySQL, don't forget to run 'mysql_upgrade'
| |
| after mysqld.service restart.</nowiki>
| |
| | |
| == MariaDB ==
| |
| | |
| * login to DB
| |
| | |
| # mysql -u root -p
| |
| | |
| CREATE USER 'wp'@'localhost' IDENTIFIED BY 'somepassword';
| |
| CREATE DATABASE wp_db;
| |
| GRANT ALL PRIVILEGES ON wp_db.* TO 'wp'@'localhost';
| |
| | |
| == Idears ==
| |
| * use btrfs to make snapshots for recovery - but use ro now rw snapshots (tip from irc - whatever that means)
| |
| * port 5060 (sip) scheint offen zu sein
| |
| | |
| # netstat -tuple
| |
| # ss -l
| |