Using username "root". Using keyboard-interactive authentication. Password: Last login: Wed Apr 21 14:30:18 2010 [root@pld_pdns ~]# poldek Wczytywanie [pndir]th... Wczytywanie [pndir]th... Przeczytano 15707 pakietów Wczytywanie [rpmdbcache]/var/lib/rpm... Przeczytano 150 pakietów Witaj w poldkowym trybie interaktywnym. Wpisz "help" aby otrzymać pomoc. poldek:/all-avail> install mysql mysql++-3.0.9-1.i686 mysql-ruby-2.8.2-3.i686 mysql++-devel-3.0.9-1.i686 mysql-ruby-rdoc-2.8.2-3.i686 mysql-5.1.45-1.i686 mysql-ruby-ri-2.8.2-3.i686 mysql-administrator-5.0-0.r12.2.i686 mysql-static-5.1.45-1.i686 mysql-bench-5.1.45-1.i686 mysql-workbench-5.0-0.r12.2.i686 mysql-charsets-5.1.45-1.i686 mysqlcc-0.9.4-15.i686 mysql-client-5.1.45-1.i686 mysqlcppapi-2.0.0-0.rc2.2.i686 mysql-devel-5.1.45-1.i686 mysqlcppapi-devel-2.0.0-0.rc2.2.i686 mysql-extras-5.1.45-1.i686 mysqlcppapi-static-2.0.0-0.rc2.2.i686 mysql-extras-perl-5.1.45-1.i686 mysqldiff-0.33-3.noarch mysql-gui-tools-5.0-0.r12.2.i686 mysqldumpgrants-1.0-3.noarch mysql-libs-5.1.45-1.i686 mysqlhotcopy-5.1.45-1.i686 mysql-proxy-0.6.1-3.i686 mysqlsniffer-1.2-3.i686 mysql-query-browser-5.0-0.r12.2.i686 mysqltoolkit-1012-1.noarch poldek:/all-avail> install mysql mysql-client mysql-libs Przetwarzanie zależności... mysql-5.1.45-1.i686 zaznaczył mysql-charsets-5.1.45-1.i686 (wł. /usr/share/mysql) mysql-5.1.45-1.i686 zaznaczył logrotate-3.7.8-7.i686 (wł. /var/log/archive) logrotate-3.7.8-7.i686: required "/etc/cron.daily" is provided by following packages: a) anacron-2.3-26.i686 b) cronie-1.4.4-3.i686 c) fcron-3.0.4-3.i686 d) hc-cron-0.14-27.i686 Który z nich chcesz zainstalować ('Q' anuluje)? [a] logrotate-3.7.8-7.i686 zaznaczył cronie-1.4.4-3.i686 (wł. /etc/cron.daily) There are 6 packages to install (3 marked by dependencies): I mysql-5.1.45-1.i686, mysql-client-5.1.45-1.i686, I mysql-libs-5.1.45-1.i686 D cronie-1.4.4-3.i686, logrotate-3.7.8-7.i686, D mysql-charsets-5.1.45-1.i686 This operation will use 22.9MB of disk space. Potrzeba pobrać 7.1MB archiwów (7.1MB do pobrania). Pobieranie th::cronie-1.4.4-3.i686.rpm... .............................. 100.0% [57.9K (57.9K/s)] Pobieranie th::logrotate-3.7.8-7.i686.rpm... .............................. 100.0% [37.0K (37.0K/s)] Pobieranie th::mysql-charsets-5.1.45-1.i686.rpm... .............................. 100.0% [20.6K (20.6K/s)] Pobieranie th::mysql-libs-5.1.45-1.i686.rpm... .............................. 100.0% [480.7K (5.7K/s)] Pobieranie th::mysql-5.1.45-1.i686.rpm... .............................. 100.0% [5.9M (1.0M/s)] Pobieranie th::mysql-client-5.1.45-1.i686.rpm... .............................. 100.0% [632.6K (15.6K/s)] Uruchamianie rpm --upgrade -vh --root /... ostrzeżenie: /var/cache/poldek/ftp_ftp.th.pld-linux.org.dists.th.PLD.i686.RPMS/cronie-1.4.4-3.i686.rpm: Nagłówek V4 sygnatura DSA: NOKEY, key ID e4f1bc2d Przygotowywanie... ########################################### [100%] 1:mysql-libs ########################################### [ 17%] Adding group crontab GID=117. 2:cronie ########################################### [ 33%] Run "/sbin/service crond start" to start Cron Daemon. 3:mysql-charsets ########################################### [ 50%] 4:mysql-client ########################################### [ 67%] 5:logrotate ########################################### [ 83%] Adding group mysql GID=89. Adding user mysql UID=89. 6:mysql ########################################### [100%] Run "/sbin/service mysql start" to start mysql service. poldek:/all-avail> install pdns pdns-2.9.22-1.i686 pdns-backend-ldap-2.9.22-1.i686 pdns-backend-gmysql-2.9.22-1.i686 pdns-backend-pipe-2.9.22-1.i686 pdns-backend-gpgsql-2.9.22-1.i686 pdnsd-1.2.7-3.i686 pdns-backend-gsqlite3-2.9.22-1.i686 poldek:/all-avail> install pdns pdns-backend-gmysql Przetwarzanie zależności... There are 2 packages to install: I pdns-2.9.22-1.i686, pdns-backend-gmysql-2.9.22-1.i686 This operation will use 3.7MB of disk space. Potrzeba pobrać 1.2MB archiwów (1.2MB do pobrania). Pobieranie th::pdns-2.9.22-1.i686.rpm... .............................. 100.0% [1.2M (456.0K/s)] Pobieranie th::pdns-backend-gmysql-2.9.22-1.i686.rpm... .............................. 100.0% [20.6K (20.6K/s)] Uruchamianie rpm --upgrade -vh --root /... ostrzeżenie: /var/cache/poldek/ftp_ftp.th.pld-linux.org.dists.th.PLD.i686.RPMS/pdns-2.9.22-1.i686.rpm: Nagłówek V4 sygnatura DSA: NOKEY, key ID e4f1bc2d Przygotowywanie... ########################################### [100%] Adding group djbdns GID=32. Adding user pdns UID=30. 1:pdns ########################################### [ 50%] Run "/sbin/service pdns start" to start pdns service. 2:pdns-backend-gmysql ########################################### [100%] poldek:/all-avail> Zapisywanie /var/cache/poldek/packages.rpmdbcache.var.lib.rpm.gz... [root@pld_pdns ~]# /etc/init.d/mysql init Initializing cluster /var/lib/mysql................................ Installing MySQL system tables for /var/lib/mysql/mysqldb/db.......[ ZROBIONE ] PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS! This is done, after starting database, in the order shown, with: For 'mysql_sysadmin' (RELOAD and SHUTDOWN privileges): echo "update mysql.user set password=password('newpassword') where user='mysql_sysadmin'; FLUSH PRIVILEGES;" | mysql -u mysql -S /var/lib/mysql/mysqldb/mysql.sock For 'mysql' user (ALL privileges, DB admin): echo "update mysql.user set password=password('newpassword') where user='mysql'; FLUSH PRIVILEGES;" | mysql -u mysql -S /var/lib/mysql/mysqldb/mysql.sock NOTE: mysql_sysadmin password should be placed to /var/lib/mysql/mysqld.conf in mysqladmin section. See the manual for more instructions. (This user is used at logs rotation and server shutdown) Filling help tables................................................[ ZROBIONE ] [root@pld_pdns ~]# pico /var/lib/mysql/mysql 1) mysql.sock 2) mysqld.conf 3) mysqldb/ [root@pld_pdns ~]# pico /var/lib/mysql/mysqld 1) mysqld.conf 2) mysqldb/ co /var/lib/mysql/mysqld.conf < [root@pld_pdns ~]# /etc/init.d/mysql start Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZAJĘTY ] Waiting for MySQL to start.........................................[ ZROBIONE ] -u mysql -S /var/lib/mysql/mysqldb/mysql.sock < [root@pld_pdns ~]# /etc/init.d/mysql restart Zatrzymywanie usługi MySQL /var/lib/mysql..........................[ ZROBIONE ] Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZROBIONE ] d('naszetajnehaslo_mysqladmin') where user='mysql'; FLUSH PRIVILEGES;" | mysql* ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NIE) [root@pld_pdns ~]# /etc/init.d/mysql restart Zatrzymywanie usługi MySQL /var/lib/mysql..........................[ ZROBIONE ] Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZROBIONE ] password=password('newpassword0') where user='mysql'; FLUSH PRIVILEGES;" | mys* ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NIE) [root@pld_pdns ~]# /etc/init.d/mysql stop Zatrzymywanie usługi MySQL /var/lib/mysql..........................[ ZROBIONE ] /lib/mysql/mysqldb/mysql.sock < ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysqldb/mysql.sock' (2) [root@pld_pdns ~]# /etc/init.d/mysql start Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZROBIONE ] /lib/mysql/mysqldb/mysql.sock < ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NIE) SH PRIVILEGES;" | mysql -p -u mysql -S /var/lib/mysql/mysqldb/mysql.sock < Enter password: ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NIE) [root@pld_pdns ~]# /etc/init.d/mysql start Usługa MySQL /var/lib/mysql jest już uruchomiona. [root@pld_pdns ~]# /etc/init.d/mysql restart Zatrzymywanie usługi MySQL /var/lib/mysql..........................[ ZROBIONE ] Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZROBIONE ] ewpassword0') where user='mysql'; FLUSH PRIVILEGES;" | mysql -p -u mysql -S /v* Enter password: ERROR 1045 (28000): Access denied for user 'mysql'@'localhost' (using password: NIE) [root@pld_pdns ~]# mc [root@pld_pdns mysql]# /etc/init.d/mysql init Initializing cluster /var/lib/mysql................................ Installing MySQL system tables for /var/lib/mysql/mysqldb/db.......[ ZROBIONE ] PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS! This is done, after starting database, in the order shown, with: For 'mysql_sysadmin' (RELOAD and SHUTDOWN privileges): echo "update mysql.user set password=password('newpassword') where user='mysql_sysadmin'; FLUSH PRIVILEGES;" | mysql -u mysql -S /var/lib/mysql/mysqldb/mysql.sock For 'mysql' user (ALL privileges, DB admin): echo "update mysql.user set password=password('newpassword') where user='mysql'; FLUSH PRIVILEGES;" | mysql -u mysql -S /var/lib/mysql/mysqldb/mysql.sock NOTE: mysql_sysadmin password should be placed to /var/lib/mysql/mysqld.conf in mysqladmin section. See the manual for more instructions. (This user is used at logs rotation and server shutdown) Filling help tables................................................[ ZROBIONE ] [root@pld_pdns mysql]# mc t password=password('naszehaslo_mysql') where user='mysql'; FLUSH PRIVILEGES;"* ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysqldb/mysql.sock' (2) [root@pld_pdns mysql]# /etc/init.d/mysql start Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZAJĘTY ] Waiting for MySQL to start.........................................[ PROBLEMY ] [root@pld_pdns mysql]# mc [root@pld_pdns mysql]# /etc/init.d/mysql init Initializing cluster /var/lib/mysql................................ Installing MySQL system tables for /var/lib/mysql/mysqldb/db.......[ ZROBIONE ] PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL USERS! This is done, after starting database, in the order shown, with: For 'mysql_sysadmin' (RELOAD and SHUTDOWN privileges): echo "update mysql.user set password=password('newpassword') where user='mysql_sysadmin'; FLUSH PRIVILEGES;" | mysql -u mysql -S /var/lib/mysql/mysqldb/mysql.sock For 'mysql' user (ALL privileges, DB admin): echo "update mysql.user set password=password('newpassword') where user='mysql'; FLUSH PRIVILEGES;" | mysql -u mysql -S /var/lib/mysql/mysqldb/mysql.sock NOTE: mysql_sysadmin password should be placed to /var/lib/mysql/mysqld.conf in mysqladmin section. See the manual for more instructions. (This user is used at logs rotation and server shutdown) Filling help tables................................................[ ZROBIONE ] [root@pld_pdns mysql]# /etc/init.d/mysql start Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZAJĘTY ] Waiting for MySQL to start.........................................[ ZROBIONE ] [root@pld_pdns mysql]# echo "update mysql.user set password=password('naszehas> user='naszetajnehaslo_mysqladmin'; FLUSH PRIVILEGES;" | mysql -p -u mysql -S * Enter password: [root@pld_pdns mysql]# /etc/init.d/mysql stop Zatrzymywanie usługi MySQL /var/lib/mysql..........................[ ZROBIONE ] [root@pld_pdns mysql]# /etc/init.d/mysql start Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZROBIONE ] [root@pld_pdns mysql]# mc [root@pld_pdns mysql]# /etc/init.d/mysql restart Zatrzymywanie usługi MySQL /var/lib/mysql..........................[ ZROBIONE ] Uruchamianie usługi MySQL /var/lib/mysql...........................[ ZAJĘTY ] Waiting for MySQL to start.........................................[ PROBLEMY ] [root@pld_pdns mysql]# mc [root@pld_pdns mysql]# ps axu USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND root 1 0.0 0.1 1804 616 ? Ss 14:29 0:00 init [3] root 2 0.0 0.0 0 0 ? S 14:29 0:00 [kthreadd] root 3 0.0 0.0 0 0 ? S 14:29 0:00 [migration/0] root 4 0.0 0.0 0 0 ? S 14:29 0:00 [ksoftirqd/0] root 5 0.0 0.0 0 0 ? S 14:29 0:00 [watchdog/0] root 6 0.0 0.0 0 0 ? S 14:29 0:00 [events/0] root 7 0.0 0.0 0 0 ? S 14:29 0:00 [cpuset] root 8 0.0 0.0 0 0 ? S 14:29 0:00 [khelper] root 20 0.0 0.0 0 0 ? S 14:29 0:00 [netns] root 23 0.0 0.0 0 0 ? S 14:29 0:00 [async/mgr] root 24 0.0 0.0 0 0 ? S 14:29 0:00 [pm] root 91 0.0 0.0 0 0 ? S 14:29 0:00 [sync_supers] root 93 0.0 0.0 0 0 ? S 14:29 0:00 [bdi-default] root 94 0.0 0.0 0 0 ? S 14:29 0:00 [kintegrityd/0] root 96 0.0 0.0 0 0 ? S 14:29 0:00 [kblockd/0] root 98 0.0 0.0 0 0 ? S 14:29 0:00 [kacpid] root 99 0.0 0.0 0 0 ? S 14:29 0:00 [kacpi_notify] root 100 0.0 0.0 0 0 ? S 14:29 0:00 [kacpi_hotplug] root 138 0.0 0.0 0 0 ? S 14:29 0:00 [kseriod] root 179 0.0 0.0 0 0 ? S 14:29 0:00 [khungtaskd] root 180 0.0 0.0 0 0 ? S 14:29 0:00 [kswapd0] root 181 0.0 0.0 0 0 ? SN 14:29 0:00 [ksmd] root 286 0.0 0.0 0 0 ? S 14:29 0:00 [aio/0] root 291 0.0 0.0 0 0 ? S 14:29 0:00 [crypto/0] root 1017 0.0 0.0 0 0 ? S 14:30 0:00 [ata/0] root 1018 0.0 0.0 0 0 ? S 14:30 0:00 [ata_aux] root 1021 0.0 0.0 0 0 ? S 14:30 0:00 [scsi_eh_0] root 1026 0.0 0.0 0 0 ? S 14:30 0:00 [scsi_eh_1] root 1051 0.0 0.0 0 0 ? S 14:30 0:00 [kjournald] root 1194 0.0 0.0 0 0 ? S 14:30 0:00 [ksuspend_usbd] root 1199 0.0 0.0 0 0 ? S 14:30 0:00 [khubd] root 1205 0.0 0.0 0 0 ? S 14:30 0:00 [usbhid_resume] root 1235 0.0 0.0 0 0 ? S 14:30 0:00 [kauditd] root 1393 0.0 0.0 0 0 ? S 14:30 0:00 [flush-8:0] root 1409 0.0 0.0 1860 316 ? Ss 14:30 0:00 /sbin/dhcpcd -h root 1453 0.0 0.1 4812 576 ? S 14:30 0:00 supervising sys root 1454 0.0 0.3 4984 1984 ? Ss 14:30 0:00 /usr/sbin/syslo root 1473 0.0 0.2 7164 1112 ? Ss 14:30 0:00 /usr/sbin/sshd root 1645 0.0 0.0 1892 364 ? S help . When enabled, the named commands can be used from any line of the query, otherwise only from the first line, before an enter. Disable with --disable-named-commands. This option is disabled by default. -g, --no-named-commands Named commands are disabled. Use \* form only, or use named commands only in the beginning of a line ending with a semicolon (;). Since version 10.9, the client now starts with this option ENABLED by default. Disable with '-G'. Long format commands still work from the first line. WARNING: option deprecated; use --disable-named-commands instead. -i, --ignore-spaces Ignore space after function names. --local-infile Enable/disable LOAD DATA LOCAL INFILE. -b, --no-beep Turn off beep on error. -h, --host=name Connect to host. -H, --html Produce HTML output. -X, --xml Produce XML output. --line-numbers Write line numbers for errors. -L, --skip-line-numbers Don't write line number for errors. -n, --unbuffered Flush buffer after each query. --column-names Write column names in results. -N, --skip-column-names Don't write column names in results. -O, --set-variable=name Change the value of a variable. Please note that this option is deprecated; you can set variables directly with --variable-name=value. --sigint-ignore Ignore SIGINT (CTRL-C). -o, --one-database Only update the default database. This is useful for skipping updates to other database in the update log. --pager[=name] Pager to use to display results. If you don't supply an option, the default pager is taken from your ENV variable PAGER. Valid pagers are less, more, cat [> filename], etc. See interactive help (\h) also. This option does not work in batch mode. Disable with --disable-pager. This option is disabled by default. --no-pager Disable pager and print to stdout. See interactive help (\h) also. WARNING: option deprecated; use --disable-pager instead. -p, --password[=name] Password to use when connecting to server. If password is not given it's asked from the tty. -P, --port=# Port number to use for connection or 0 for default to, in order of preference, my.cnf, $MYSQL_TCP_PORT, /etc/services, built-in default (3306). --prompt=name Set the mysql prompt to this value. --protocol=name The protocol to use for connection (tcp, socket, pipe, memory). -q, --quick Don't cache result, print it row by row. This may slow down the server if the output is suspended. Doesn't use history file. -r, --raw Write fields without conversion. Used with --batch. --reconnect Reconnect if the connection is lost. Disable with --disable-reconnect. This option is enabled by default. -s, --silent Be more silent. Print results with a tab as separator, each row on new line. -S, --socket=name The socket file to use for connection. --ssl Enable SSL for connection (automatically enabled with other flags). Disable with --skip-ssl. --ssl-ca=name CA file in PEM format (check OpenSSL docs, implies --ssl). --ssl-capath=name CA directory (check OpenSSL docs, implies --ssl). --ssl-cert=name X509 cert in PEM format (implies --ssl). --ssl-cipher=name SSL cipher to use (implies --ssl). --ssl-key=name X509 key in PEM format (implies --ssl). --ssl-verify-server-cert Verify server's "Common Name" in its cert against hostname used when connecting. This option is disabled by default. -t, --table Output in table format. --tee=name Append everything into outfile. See interactive help (\h) also. Does not work in batch mode. Disable with --disable-tee. This option is disabled by default. --no-tee Disable outfile. See interactive help (\h) also. WARNING: Option deprecated; use --disable-tee instead. -u, --user=name User for login if not current user. -U, --safe-updates Only allow UPDATE and DELETE that uses keys. -U, --i-am-a-dummy Synonym for option --safe-updates, -U. -v, --verbose Write more. (-v -v -v gives the table output format). -V, --version Output version information and exit. -w, --wait Wait and retry if connection is down. --connect_timeout=# Number of seconds before connection timeout. --max_allowed_packet=# The maximum packet length to send to or receive from server. --net_buffer_length=# The buffer size for TCP/IP and socket communication. --select_limit=# Automatic limit for SELECT when using --safe-updates. --max_join_size=# Automatic limit for rows in a join when using --safe-updates. --secure-auth Refuse client connecting to server if it uses old (pre-4.1.1) protocol. --server-arg=name Send embedded server this as a parameter. --show-warnings Show warnings after every statement. Default options are read from the following files in the given order: /etc/mysql/my.cnf /etc/my.cnf ~/.my.cnf The following groups are read: mysql client The following options may be given as the first argument: --print-defaults Print the program argument list and exit. --no-defaults Don't read default options from any option file. --defaults-file=# Only read default options from the given file #. --defaults-extra-file=# Read this file after the global files are read. Variables (--variable-name=value) and boolean options {FALSE|TRUE} Value (after reading options) --------------------------------- ----------------------------- auto-rehash TRUE character-sets-dir (No default value) column-type-info FALSE comments FALSE compress FALSE debug-check FALSE debug-info FALSE database (No default value) default-character-set latin1 delimiter ; vertical FALSE force FALSE named-commands FALSE ignore-spaces FALSE local-infile FALSE no-beep FALSE host (No default value) html FALSE xml FALSE line-numbers TRUE unbuffered FALSE column-names TRUE sigint-ignore FALSE port 0 prompt mysql> quick FALSE raw FALSE reconnect TRUE socket (No default value) ssl FALSE ssl-ca (No default value) ssl-capath (No default value) ssl-cert (No default value) ssl-cipher (No default value) ssl-key (No default value) ssl-verify-server-cert FALSE table FALSE user (No default value) safe-updates FALSE i-am-a-dummy FALSE connect_timeout 0 max_allowed_packet 16777216 net_buffer_length 16384 select_limit 1000 max_join_size 1000000 secure-auth FALSE show-warnings FALSE [root@pld_pdns mysql]# mysql -p -u mysql Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 1 Server version: 5.1.45-log PLD Linux Distribution MySQL RPM Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> CREATE USER pdns; Query OK, 0 rows affected (0.00 sec) mysql> CREATE DATABASE pdns; Query OK, 1 row affected (0.00 sec) mysql> DELETE USER pdns; ERROR 1046 (3D000): Nie wybrano żadnej bazy danych mysql> REMOVE USER pdns; ERROR 1064 (42000): Something is wrong in your syntax obok 'REMOVE USER pdns' w linii 1 mysql> DROP USER pdns; Query OK, 0 rows affected (0.00 sec) mysql> CREATE USER 'pdns_user'@'localhost' IDENTIFIED BY 'haslo_do_bazy'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON pdns.* TO pdns_user@localhost; Query OK, 0 rows affected (0.00 sec) mysql> Bye [root@pld_pdns mysql]# mysql -p -u pdns_user Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.1.45-log PLD Linux Distribution MySQL RPM Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> USE pdns; Database changed mysql> create table domains ( -> id SERIAL PRIMARY KEY, -> name VARCHAR(255) NOT NULL, -> master VARCHAR(20) DEFAULT NULL, -> last_check INT DEFAULT NULL, -> type VARCHAR(6) NOT NULL, -> notified_serialINT DEFAULT NULL, -> account VARCHAR(40) DEFAULT NULL -> ); ERROR 1064 (42000): Something is wrong in your syntax obok 'DEFAULT NULL, account VARCHAR(40) DEFAULT NULL )' w linii 7 mysql> CREATE UNIQUE INDEX name_index ON domains(name); ERROR 1146 (42S02): Table 'pdns.domains' doesn't exist mysql> mysql> CREATE TABLE records ( -> id SERIAL PRIMARY KEY, -> domain_id INT DEFAULT NULL, -> name VARCHAR(255) DEFAULT NULL, -> type VARCHAR(6) DEFAULT NULL, -> content VARCHAR(255) DEFAULT NULL, -> ttl INT DEFAULT NULL, -> prio INT DEFAULT NULL, -> change_dateINT DEFAULT NULL, -> CONSTRAINT domain_exists -> FOREIGN KEY(domain_id) REFERENCES domains(id) -> ON DELETE CASCADE -> ); ERROR 1064 (42000): Something is wrong in your syntax obok 'DEFAULT NULL, CONSTRAINT domain_exists FOREIGN KEY(domain_id) REFERENCES domai' w linii 9 mysql> mysql> CREATE INDEX rec_name_index ON records(name); ERROR 1146 (42S02): Table 'pdns.records' doesn't exist mysql> CREATE INDEX nametype_index ON records(name,type); ERROR 1146 (42S02): Table 'pdns.records' doesn't exist mysql> CREATE INDEX domain_id ON records(domain_id); ERROR 1146 (42S02): Table 'pdns.records' doesn't exist mysql> mysql> create table supermasters ( -> ip VARCHAR(25) NOT NULL, -> nameserver VARCHAR(255) NOT NULL, -> account VARCHAR(40) DEFAULT NULL -> ); Query OK, 0 rows affected (0.00 sec) mysql> \d ERROR: DELIMITER must be followed by a 'delimiter' character or string mysql> Bye [root@pld_pdns mysql]# mysql -p -u mysql Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 3 Server version: 5.1.45-log PLD Linux Distribution MySQL RPM Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> DROP USER pdns_user; ERROR 1396 (HY000): Operation DROP USER failed for 'pdns_user'@'%' mysql> DROP USER pdns_user; ERROR 1396 (HY000): Operation DROP USER failed for 'pdns_user'@'%' mysql> DROP DATABASE pdns; Query OK, 1 row affected (0.00 sec) mysql> DROP USER pdns_user; ERROR 1396 (HY000): Operation DROP USER failed for 'pdns_user'@'%' mysql> DROP USER pdns; ERROR 1396 (HY000): Operation DROP USER failed for 'pdns'@'%' mysql> DROP USER 'pdns_user'@'localhost' IDENTIFIED BY 'haslo_do_bazy'; ERROR 1064 (42000): Something is wrong in your syntax obok 'IDENTIFIED BY 'haslo_do_bazy'' w linii 1 mysql> DROP USER 'pdns_user'@'localhost'; Query OK, 0 rows affected (0.00 sec) mysql> CREATE USER pdns; Query OK, 0 rows affected (0.00 sec) mysql> DROP USER pdns; Query OK, 0 rows affected (0.00 sec) mysql> CREATE USER 'pdns'@'localhost' IDENTIFIED BY 'haslo_do_bazy'; Query OK, 0 rows affected (0.00 sec) mysql> CREATE DATABASE pdns; Query OK, 1 row affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON pdns.* TO pdns@localhost; Query OK, 0 rows affected (0.00 sec) mysql> create table domains ( -> id SERIAL PRIMARY KEY, -> name VARCHAR(255) NOT NULL, -> master VARCHAR(20) DEFAULT NULL, -> last_check INT DEFAULT NULL, -> type VARCHAR(6) NOT NULL, -> notified_serialINT DEFAULT NULL, -> account VARCHAR(40) DEFAULT NULL -> ); ERROR 1046 (3D000): Nie wybrano żadnej bazy danych mysql> Bye [root@pld_pdns mysql]# mysql -p -u pdns Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 4 Server version: 5.1.45-log PLD Linux Distribution MySQL RPM Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> USE pdns; Database changed mysql> create table domains ( -> id SERIAL PRIMARY KEY, -> name VARCHAR(255) NOT NULL, -> master VARCHAR(20) DEFAULT NULL, -> last_check INT DEFAULT NULL, -> type VARCHAR(6) NOT NULL, -> notified_serialINT DEFAULT NULL, -> account VARCHAR(40) DEFAULT NULL -> ); ERROR 1064 (42000): Something is wrong in your syntax obok 'DEFAULT NULL, account VARCHAR(40) DEFAULT NULL )' w linii 7 mysql> Bye [root@pld_pdns mysql]# pico ./pdns.sql p -u pdns pdns < ./pdns.sql < Enter password: ERROR 1142 (42000) at line 36: GRANT command denied to user 'pdns'@'localhost' for table 'supermasters' [root@pld_pdns mysql]# mysql -p -u pdns pdns Enter password: ERROR 1045 (28000): Access denied for user 'pdns'@'localhost' (using password: TAK) [root@pld_pdns mysql]# mysql -p -u pdns pdns Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.1.45-log PLD Linux Distribution MySQL RPM Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SELECT * FROM domains; Empty set (0.01 sec) mysql> SELECT * FROM domains0; ERROR 1146 (42S02): Table 'pdns.domains0' doesn't exist mysql> Bye [root@pld_pdns mysql]# mc [root@pld_pdns pdns]# pico ./pdns.conf [root@pld_pdns pdns]# mkdir /var/log/pdns [root@pld_pdns pdns]# chmod 750 /var/log/pdns [root@pld_pdns pdns]# chown root:logs /var/log/pdns [root@pld_pdns pdns]# cd .. [root@pld_pdns /etc]# cd syslog-ng/ [root@pld_pdns syslog-ng]# ls syslog-ng.conf [root@pld_pdns syslog-ng]# pico ./syslog-ng.conf [root@pld_pdns syslog-ng]# /etc/init.d/pdns start Uruchamianie usługi PowerDNS (Powered DNS server)..................[ ZROBIONE ] [root@pld_pdns syslog-ng]# mc [root@pld_pdns syslog-ng]# /etc/init.d/syslog-ng reload Przeładowanie usługi syslog-ng.....................................[ ZROBIONE ] [root@pld_pdns syslog-ng]# /etc/init.d/pdns restart Zatrzymywanie usługi PowerDNS......................................[ ZROBIONE ] PowerDNS (3 sec. timeout)..........................................[ ZROBIONE ] Uruchamianie usługi PowerDNS (Powered DNS server)..................[ ZROBIONE ] [root@pld_pdns syslog-ng]# mc [root@pld_pdns pdns]# cd / [root@pld_pdns /]# poldek Wczytywanie [pndir]th... Wczytywanie [pndir]th... Przeczytano 15707 pakietów Wczytywanie [rpmdbcache]/var/lib/rpm... Przeczytano 158 pakietów Witaj w poldkowym trybie interaktywnym. Wpisz "help" aby otrzymać pomoc. poldek:/all-avail> install apache apache-mod_php php-mysql Przetwarzanie zależności... apache-2.2.15-2.i686 zaznaczył apache-errordocs-2.2.15-2.i686 (wł. apache-errordocs = 2.2.15-2) apache-errordocs-2.2.15-2.i686 zaznaczył apache-base-2.2.15-2.i686 (wł. /etc/httpd/conf.d) apache-base-2.2.15-2.i686 zaznaczył apr-1.3.9-1.i686 (wł. apr >= 1:1.2) apache-base-2.2.15-2.i686 zaznaczył apr-util-1.3.9-2.i686 (wł. libaprutil-1.so.0) apache-errordocs-2.2.15-2.i686 zaznaczył apache-mod_alias-2.2.15-2.i686 (wł. apache-mod_alias = 2.2.15-2) apache-errordocs-2.2.15-2.i686 zaznaczył apache-mod_authz_host-2.2.15-2.i686 (wł. apache-mod_authz_host = 2.2.15-2) apache-errordocs-2.2.15-2.i686 zaznaczył apache-mod_include-2.2.15-2.i686 (wł. apache-mod_include = 2.2.15-2) apache-errordocs-2.2.15-2.i686 zaznaczył apache-mod_negotiation-2.2.15-2.i686 (wł. apache-mod_negotiation = 2.2.15-2) apache-mod_negotiation-2.2.15-2.i686 zaznaczył apache-mod_mime-2.2.15-2.i686 (wł. apache-mod_mime = 2.2.15-2) apache-mod_mime-2.2.15-2.i686 zaznaczył mailcap-2.3-3.noarch (wł. mailcap) apache-2.2.15-2.i686 zaznaczył apache-mod_auth-2.2.15-2.i686 (wł. apache-mod_auth = 2.2.15-2) apache-mod_auth-2.2.15-2.i686 zaznaczył apache-mod_auth_basic-2.2.15-2.i686 (wł. apache-mod_auth_basic = 2.2.15-2) apache-mod_auth-2.2.15-2.i686 zaznaczył apache-mod_authn_file-2.2.15-2.i686 (wł. apache-mod_authn_file = 2.2.15-2) apache-mod_auth-2.2.15-2.i686 zaznaczył apache-mod_authz_groupfile-2.2.15-2.i686 (wł. apache-mod_authz_groupfile = 2.2.15-2) apache-mod_auth-2.2.15-2.i686 zaznaczył apache-mod_authz_user-2.2.15-2.i686 (wł. apache-mod_authz_user = 2.2.15-2) apache-2.2.15-2.i686 zaznaczył apache-mod_env-2.2.15-2.i686 (wł. apache-mod_env = 2.2.15-2) apache-2.2.15-2.i686 zaznaczył apache-mod_log_config-2.2.15-2.i686 (wł. apache-mod_log_config = 2.2.15-2) apache-2.2.15-2.i686 zaznaczył apache-mod_mime_magic-2.2.15-2.i686 (wł. apache-mod_mime_magic = 2.2.15-2) apache-2.2.15-2.i686 zaznaczył apache-mod_setenvif-2.2.15-2.i686 (wł. apache-mod_setenvif = 2.2.15-2) apache-2.2.15-2.i686 zaznaczył apache-mod_speling-2.2.15-2.i686 (wł. apache-mod_speling = 2.2.15-2) apache-2.2.15-2.i686 zaznaczył apache-mod_userdir-2.2.15-2.i686 (wł. apache-mod_userdir = 2.2.15-2) apache-2.2.15-2.i686 zaznaczył apache-mod_version-2.2.15-2.i686 (wł. apache-mod_version = 2.2.15-2) apache-2.2.15-2.i686 zaznaczył apache-tools-2.2.15-2.i686 (wł. apache-tools = 2.2.15-2) apache-mod_php-5.2.13-1.i686 zaznaczył php-common-5.2.13-1.i686 (wł. /etc/php) php-common-5.2.13-1.i686 zaznaczył php-dirs-1.1-8.noarch (wł. php-dirs) There are 27 packages to install (25 marked by dependencies): I apache-2.2.15-2.i686, apache-mod_php-5.2.13-1.i686 D apache-base-2.2.15-2.i686, apache-errordocs-2.2.15-2.i686, D apache-mod_alias-2.2.15-2.i686, apache-mod_auth-2.2.15-2.i686, D apache-mod_auth_basic-2.2.15-2.i686, D apache-mod_authn_file-2.2.15-2.i686, D apache-mod_authz_groupfile-2.2.15-2.i686, D apache-mod_authz_host-2.2.15-2.i686, D apache-mod_authz_user-2.2.15-2.i686, apache-mod_env-2.2.15-2.i686, D apache-mod_include-2.2.15-2.i686, apache-mod_log_config-2.2.15-2.i686, D apache-mod_mime-2.2.15-2.i686, apache-mod_mime_magic-2.2.15-2.i686, D apache-mod_negotiation-2.2.15-2.i686, apache-mod_setenvif-2.2.15-2.i686, D apache-mod_speling-2.2.15-2.i686, apache-mod_userdir-2.2.15-2.i686, D apache-mod_version-2.2.15-2.i686, apache-tools-2.2.15-2.i686, D apr-1.3.9-1.i686, apr-util-1.3.9-2.i686, mailcap-2.3-3.noarch, D php-common-5.2.13-1.i686, php-dirs-1.1-8.noarch This operation will use 5.0MB of disk space. Potrzeba pobrać 1.6MB archiwów (1.6MB do pobrania). Pobieranie th::apr-1.3.9-1.i686.rpm... .............................. 100.0% [114.3K (114.3K/s)] Pobieranie th::apr-util-1.3.9-2.i686.rpm... .............................. 100.0% [68.8K (68.8K/s)] Pobieranie th::apache-base-2.2.15-2.i686.rpm... .............................. 100.0% [342.6K (312.5K/s)] Pobieranie th::apache-mod_alias-2.2.15-2.i686.rpm... .............................. 100.0% [10.7K (10.7K/s)] Pobieranie th::apache-mod_authz_host-2.2.15-2.i686.rpm... .............................. 100.0% [9.0K (9.0K/s)] Pobieranie th::apache-mod_include-2.2.15-2.i686.rpm... .............................. 100.0% [21.0K (21.0K/s)] Pobieranie th::apache-mod_mime-2.2.15-2.i686.rpm... .............................. 100.0% [12.3K (12.3K/s)] Pobieranie th::apache-mod_negotiation-2.2.15-2.i686.rpm... .............................. 100.0% [19.5K (19.5K/s)] Pobieranie th::apache-errordocs-2.2.15-2.i686.rpm... .............................. 100.0% [32.6K (32.6K/s)] Pobieranie th::apache-mod_auth_basic-2.2.15-2.i686.rpm... .............................. 100.0% [8.3K (8.3K/s)] Pobieranie th::apache-mod_authn_file-2.2.15-2.i686.rpm... .............................. 100.0% [7.6K (7.6K/s)] Pobieranie th::apache-mod_authz_groupfile-2.2.15-2.i686.rpm... .............................. 100.0% [8.6K (8.6K/s)] Pobieranie th::apache-mod_authz_user-2.2.15-2.i686.rpm... .............................. 100.0% [7.4K (7.4K/s)] Pobieranie th::apache-mod_auth-2.2.15-2.i686.rpm... .............................. 100.0% [3.8K (3.8K/s)] Pobieranie th::apache-mod_env-2.2.15-2.i686.rpm... .............................. 100.0% [7.7K (7.7K/s)] Pobieranie th::apache-mod_log_config-2.2.15-2.i686.rpm... .............................. 100.0% [13.8K (13.8K/s)] Pobieranie th::apache-mod_mime_magic-2.2.15-2.i686.rpm... .............................. 100.0% [14.0K (14.0K/s)] Pobieranie th::apache-mod_setenvif-2.2.15-2.i686.rpm... .............................. 100.0% [9.2K (9.2K/s)] Pobieranie th::apache-mod_speling-2.2.15-2.i686.rpm... .............................. 100.0% [10.1K (10.1K/s)] Pobieranie th::apache-mod_userdir-2.2.15-2.i686.rpm... .............................. 100.0% [8.5K (2.8K/s)] Pobieranie th::apache-mod_version-2.2.15-2.i686.rpm... .............................. 100.0% [8.2K (8.2K/s)] Pobieranie th::apache-tools-2.2.15-2.i686.rpm... .............................. 100.0% [36.4K (36.4K/s)] Pobieranie th::apache-2.2.15-2.i686.rpm... .............................. 100.0% [5.4K (5.4K/s)] Pobieranie th::php-common-5.2.13-1.i686.rpm... .............................. 100.0% [840.8K (565.6K/s)] Pobieranie th::apache-mod_php-5.2.13-1.i686.rpm... .............................. 100.0% [16.6K (16.6K/s)] Pobieranie th::mailcap-2.3-3.noarch.rpm... .............................. 100.0% [26.4K (26.4K/s)] Pobieranie th::php-dirs-1.1-8.noarch.rpm... .............................. 100.0% [5.1K (5.1K/s)] Uruchamianie rpm --upgrade -vh --root /... ostrzeżenie: /var/cache/poldek/ftp_ftp.th.pld-linux.org.dists.th.PLD.i686.RPMS/apr-1.3.9-1.i686.rpm: Nagłówek V4 sygnatura DSA: NOKEY, key ID e4f1bc2d Przygotowywanie... ########################################### [100%] 1:apr ########################################### [ 4%] 2:php-dirs ########################################### [ 7%] 3:mailcap ########################################### [ 11%] 4:apr-util ########################################### [ 15%] 5:apache-base ########################################### [ 19%] 6:apache-mod_mime ########################################### [ 22%] 7:apache-mod_negotiation ########################################### [ 26%] 8:apache-mod_alias ########################################### [ 30%] 9:apache-mod_authz_host ########################################### [ 33%] 10:apache-mod_userdir ########################################### [ 37%] 11:apache-mod_include ########################################### [ 41%] 12:apache-mod_auth_basic ########################################### [ 44%] 13:apache-mod_authn_file ########################################### [ 48%] 14:apache-mod_authz_groupf########################################### [ 52%] 15:apache-mod_authz_user ########################################### [ 56%] 16:apache-mod_env ########################################### [ 59%] 17:apache-mod_log_config ########################################### [ 63%] 18:apache-mod_mime_magic ########################################### [ 67%] 19:apache-mod_setenvif ########################################### [ 70%] 20:apache-mod_speling ########################################### [ 74%] 21:apache-mod_version ########################################### [ 78%] 22:apache-tools ########################################### [ 81%] 23:php-common ########################################### [ 85%] 24:apache-mod_auth ########################################### [ 89%] 25:apache-errordocs ########################################### [ 93%] 26:apache ########################################### [ 96%] 27:apache-mod_php ########################################### [100%] Run "/sbin/service httpd start" to start httpd service. Installing set #2 Przetwarzanie zależności... There are 1 package to install: I php-mysql-5.2.13-1.i686 This operation will use 44.5KB of disk space. Potrzeba pobrać 21.2KB archiwów (21.2KB do pobrania). Pobieranie th::php-mysql-5.2.13-1.i686.rpm... .............................. 100.0% [21.2K (14.1K/s)] Uruchamianie rpm --upgrade -vh --root /... ostrzeżenie: /var/cache/poldek/ftp_ftp.th.pld-linux.org.dists.th.PLD.i686.RPMS/php-mysql-5.2.13-1.i686.rpm: Nagłówek V4 sygnatura DSA: NOKEY, key ID e4f1bc2d Przygotowywanie... ########################################### [100%] 1:php-mysql ########################################### [100%] poldek:/all-avail> install php błąd: php: nie ma takiego pakietu Wystąpiły błędy podczas instalacji poldek:/all-avail> install php-common php-common-5.2.13-1.i686: equal version installed, skipped Nie ma roboty poldek:/all-avail> ls php*xml* php-pear-XML_sql2xml-0.3.4-2.noarch php-pecl-wbxml-1.0.3-1.i686 php-simplexml-5.2.13-1.i686 php-xml-5.2.13-1.i686 php-xmlreader-5.2.13-1.i686 php-xmlrpc-5.2.13-1.i686 php-xmlwriter-5.2.13-1.i686 php4-domxml-4.4.9-22.i686 php4-xml-4.4.9-22.i686 php4-xmlrpc-4.4.9-22.i686 10 pakietów poldek:/all-avail> install php-xml php-xmlreader php-xmlwriter Przetwarzanie zależności... There are 3 packages to install: I php-xml-5.2.13-1.i686, php-xmlreader-5.2.13-1.i686, I php-xmlwriter-5.2.13-1.i686 This operation will use 86.8KB of disk space. Potrzeba pobrać 50.0KB archiwów (50.0KB do pobrania). Pobieranie th::php-xml-5.2.13-1.i686.rpm... .............................. 100.0% [20.1K (20.1K/s)] Pobieranie th::php-xmlreader-5.2.13-1.i686.rpm... .............................. 100.0% [15.6K (15.6K/s)] Pobieranie th::php-xmlwriter-5.2.13-1.i686.rpm... .............................. 100.0% [14.3K (14.3K/s)] Uruchamianie rpm --upgrade -vh --root /... ostrzeżenie: /var/cache/poldek/ftp_ftp.th.pld-linux.org.dists.th.PLD.i686.RPMS/php-xml-5.2.13-1.i686.rpm: Nagłówek V4 sygnatura DSA: NOKEY, key ID e4f1bc2d Przygotowywanie... ########################################### [100%] 1:php-xmlwriter ########################################### [ 33%] 2:php-xml ########################################### [ 67%] 3:php-xmlreader ########################################### [100%] poldek:/all-avail> Zapisywanie /var/cache/poldek/packages.rpmdbcache.var.lib.rpm.gz... [root@pld_pdns /]# cd root/ [root@pld_pdns ~]# mkdir install [root@pld_pdns ~]# cd install/ [root@pld_pdns install]# wget "http://pdnsadmin.iguanadons.net/index.php?a=fil> --2010-04-21 15:28:23-- http://pdnsadmin.iguanadons.net/index.php?a=files&s=download&cid=2&fid=18 Translacja pdnsadmin.iguanadons.net (pdnsadmin.iguanadons.net)... 66.218.49.114 Łączenie się z pdnsadmin.iguanadons.net (pdnsadmin.iguanadons.net)|66.218.49.114|:80... połączono. Żądanie HTTP wysłano, oczekiwanie na odpowiedź... 200 OK Długość: 115656 (113K) [application/octet-stream] Zapis do: `index.php?a=files&s=download&cid=2&fid=18' 100%[======================================>] 115.656 15,9K/s w 12s 2010-04-21 15:28:39 (9,26 KB/s) - zapisano `index.php?a=files&s=download&cid=2&fid=18' [115656/115656] &s=download\&cid=2\&fid=18 pdnsadmin1.1.9.tgz < xzvf ./pdnsadmin1.1.9.tgz < pdnsadmin1.1.9/ pdnsadmin1.1.9/install/ pdnsadmin1.1.9/install/choose_install.php pdnsadmin1.1.9/install/footer.php pdnsadmin1.1.9/install/pgsql_data_tables.php pdnsadmin1.1.9/install/new_install.php pdnsadmin1.1.9/install/mysql_data_tables.php pdnsadmin1.1.9/install/header.php pdnsadmin1.1.9/install/index.php pdnsadmin1.1.9/install/upgrade.php pdnsadmin1.1.9/install/skin_default.xml pdnsadmin1.1.9/func/ pdnsadmin1.1.9/func/debug.php pdnsadmin1.1.9/func/users.php pdnsadmin1.1.9/func/domains.php pdnsadmin1.1.9/func/login.php pdnsadmin1.1.9/func/main.php pdnsadmin1.1.9/func/constants.php pdnsadmin1.1.9/func/cp.php pdnsadmin1.1.9/func/index.php pdnsadmin1.1.9/skins/ pdnsadmin1.1.9/skins/default/ pdnsadmin1.1.9/skins/default/styles.css pdnsadmin1.1.9/skins/default/images/ pdnsadmin1.1.9/skins/default/images/background3.png pdnsadmin1.1.9/skins/default/images/icons/ pdnsadmin1.1.9/skins/default/images/icons/user_online.png pdnsadmin1.1.9/skins/default/images/icons/computer_delete.png pdnsadmin1.1.9/skins/default/images/icons/world_link.png pdnsadmin1.1.9/skins/default/images/icons/members.png pdnsadmin1.1.9/skins/default/images/icons/table_multiple.png pdnsadmin1.1.9/skins/default/images/icons/wrench.png pdnsadmin1.1.9/skins/default/images/icons/table_add.png pdnsadmin1.1.9/skins/default/images/icons/phone.png pdnsadmin1.1.9/skins/default/images/icons/delete_domain.png pdnsadmin1.1.9/skins/default/images/icons/computer.png pdnsadmin1.1.9/skins/default/images/icons/layout_content.png pdnsadmin1.1.9/skins/default/images/icons/database_gear.png pdnsadmin1.1.9/skins/default/images/icons/login.png pdnsadmin1.1.9/skins/default/images/icons/new_record.png pdnsadmin1.1.9/skins/default/images/icons/edit.png pdnsadmin1.1.9/skins/default/images/icons/table_edit.png pdnsadmin1.1.9/skins/default/images/icons/vcard_edit.png pdnsadmin1.1.9/skins/default/images/icons/table_delete.png pdnsadmin1.1.9/skins/default/images/icons/delete.png pdnsadmin1.1.9/skins/default/images/icons/key.png pdnsadmin1.1.9/skins/default/images/icons/control_panel.png pdnsadmin1.1.9/skins/default/images/icons/computer_add.png pdnsadmin1.1.9/skins/default/images/index.php pdnsadmin1.1.9/skins/default/images/Logo.png pdnsadmin1.1.9/skins/default/acp.css pdnsadmin1.1.9/skins/default/index.php pdnsadmin1.1.9/skins/default/print.css pdnsadmin1.1.9/skins/index.php pdnsadmin1.1.9/languages/ pdnsadmin1.1.9/languages/en.php pdnsadmin1.1.9/admincp/ pdnsadmin1.1.9/admincp/admin.php pdnsadmin1.1.9/admincp/sources/ pdnsadmin1.1.9/admincp/sources/logs.php pdnsadmin1.1.9/admincp/sources/optimize.php pdnsadmin1.1.9/admincp/sources/query.php pdnsadmin1.1.9/admincp/sources/supermaster.php pdnsadmin1.1.9/admincp/sources/php_info.php pdnsadmin1.1.9/admincp/sources/perms.php pdnsadmin1.1.9/admincp/sources/backup.php pdnsadmin1.1.9/admincp/sources/settings.php pdnsadmin1.1.9/admincp/sources/index.php pdnsadmin1.1.9/admincp/sources/groups.php pdnsadmin1.1.9/admincp/sources/user_control.php pdnsadmin1.1.9/admincp/sources/templates.php pdnsadmin1.1.9/admincp/sources/db_repair.php pdnsadmin1.1.9/admincp/sources/home.php pdnsadmin1.1.9/admincp/index.php pdnsadmin1.1.9/docs/ pdnsadmin1.1.9/docs/CHANGES.txt pdnsadmin1.1.9/docs/README.txt pdnsadmin1.1.9/docs/COPYING.txt pdnsadmin1.1.9/docs/FAQ.txt pdnsadmin1.1.9/docs/CREDITS.txt pdnsadmin1.1.9/global.php pdnsadmin1.1.9/settings.php pdnsadmin1.1.9/robots.txt pdnsadmin1.1.9/index.php pdnsadmin1.1.9/packages/ pdnsadmin1.1.9/javascript/ pdnsadmin1.1.9/javascript/utils.js pdnsadmin1.1.9/javascript/permissions.js pdnsadmin1.1.9/defaultutils.php pdnsadmin1.1.9/lib/ pdnsadmin1.1.9/lib/error.php pdnsadmin1.1.9/lib/user.php pdnsadmin1.1.9/lib/packageutil.php pdnsadmin1.1.9/lib/tar.php pdnsadmin1.1.9/lib/mailer.php pdnsadmin1.1.9/lib/xmlparser.php pdnsadmin1.1.9/lib/perms.php pdnsadmin1.1.9/lib/htmlwidgets.php pdnsadmin1.1.9/lib/pgsql.php pdnsadmin1.1.9/lib/tool.php pdnsadmin1.1.9/lib/templater.php pdnsadmin1.1.9/lib/globalfunctions.php pdnsadmin1.1.9/lib/mysql.php pdnsadmin1.1.9/lib/database.php [root@pld_pdns install]# mv ./pdnsadmin1.1.9 ./pdnsadmin [root@pld_pdns install]# ls pdnsadmin pdnsadmin1.1.9.tgz [root@pld_pdns install]# mv ./pdnsadmin /home/services/httpd/ 1) cgi-bin/ 2) error/ 3) html/ 4) icons/ 5) vhosts/ /home/services/httpd/html/ < [root@pld_pdns install]# mc [root@pld_pdns pdnsadmin]# /etc/init.d/httpd start Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] [root@pld_pdns pdnsadmin]# ip add 1: lo: mtu 16436 qdisc noqueue state UNKNOWN link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00 inet 127.0.0.1/8 scope host lo inet6 ::1/128 scope host valid_lft forever preferred_lft forever 2: eth0: mtu 1500 qdisc pfifo_fast state UP qlen 1000 link/ether 08:00:27:09:cb:98 brd ff:ff:ff:ff:ff:ff inet 10.100.5.68/24 brd 10.100.5.255 scope global eth0 inet6 2001:6f8:93c:f:a00:27ff:fe09:cb98/64 scope global dynamic valid_lft 2591593sec preferred_lft 604393sec inet6 fe80::a00:27ff:fe09:cb98/64 scope link valid_lft forever preferred_lft forever [root@pld_pdns pdnsadmin]# poldek Wczytywanie [pndir]th... Wczytywanie [pndir]th... Przeczytano 15707 pakietów Wczytywanie [rpmdbcache]/var/lib/rpm... Przeczytano 189 pakietów Witaj w poldkowym trybie interaktywnym. Wpisz "help" aby otrzymać pomoc. poldek:/all-avail> install apache-mod_dir Przetwarzanie zależności... There are 1 package to install: I apache-mod_dir-2.2.15-2.i686 This operation will use 5.6KB of disk space. Potrzeba pobrać 7.9KB archiwów (7.9KB do pobrania). Pobieranie th::apache-mod_dir-2.2.15-2.i686.rpm... .............................. 100.0% [7.9K (7.9K/s)] Uruchamianie rpm --upgrade -vh --root /... ostrzeżenie: /var/cache/poldek/ftp_ftp.th.pld-linux.org.dists.th.PLD.i686.RPMS/apache-mod_dir-2.2.15-2.i686.rpm: Nagłówek V4 sygnatura DSA: NOKEY, key ID e4f1bc2d Przygotowywanie... ########################################### [100%] 1:apache-mod_dir ########################################### [100%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] poldek:/all-avail> Zapisywanie /var/cache/poldek/packages.rpmdbcache.var.lib.rpm.gz... [root@pld_pdns pdnsadmin]# mc hown -R http:http /home/services/httpd/ < 1) cgi-bin/ 2) error/ 3) html/ 4) icons/ 5) vhosts/ tp /home/services/httpd/html/pdnsadmin/ < ces/httpd/html/pdnsadmin/ < [root@pld_pdns pdnsadmin]# mc [root@pld_pdns httpd]# poldek Wczytywanie [pndir]th... Wczytywanie [pndir]th... Przeczytano 15707 pakietów Wczytywanie [rpmdbcache]/var/lib/rpm... Przeczytano 190 pakietów Witaj w poldkowym trybie interaktywnym. Wpisz "help" aby otrzymać pomoc. poldek:/all-avail> ls php-*reg* błąd: php-*reg*: nie ma takiego pakietu lub katalogu poldek:/all-avail> ls php-* | less 934 pakiety poldek:/all-avail> install php-dom php-gd php-gettext php-iconv php-mbstring php-mcrypt php-openssl php-readline php-session php-spl Przetwarzanie zależności... php-gd-5.2.13-1.i686 zaznaczył libjpeg-8a-1.i686 (wł. libjpeg.so.8) php-gd-5.2.13-1.i686 zaznaczył libpng-1.4.1-1.i686 (wł. libpng14.so.14) php-gd-5.2.13-1.i686 zaznaczył t1lib-5.1.2-2.i686 (wł. libt1.so.5) t1lib-5.1.2-2.i686 zaznaczył fontpostinst-0.1-15.noarch (wł. fontpostinst >= 0.1-6) php-mcrypt-5.2.13-1.i686 zaznaczył libltdl-2.2.6-12.i686 (wł. libltdl.so.7) php-mcrypt-5.2.13-1.i686 zaznaczył libmcrypt-2.5.8-1.i686 (wł. libmcrypt.so.4) php-readline-5.2.13-1.i686 zaznaczył php-cli-5.2.13-1.i686 (wł. /etc/php/cli.d) php-spl-5.2.13-1.i686 zaznaczył php-pcre-5.2.13-1.i686 (wł. php-pcre = 4:5.2.13-1) php-spl-5.2.13-1.i686 zaznaczył php-simplexml-5.2.13-1.i686 (wł. php-simplexml = 4:5.2.13-1) There are 19 packages to install (9 marked by dependencies): I php-dom-5.2.13-1.i686, php-gd-5.2.13-1.i686, php-gettext-5.2.13-1.i686, I php-iconv-5.2.13-1.i686, php-mbstring-5.2.13-1.i686, I php-mcrypt-5.2.13-1.i686, php-openssl-5.2.13-1.i686, I php-readline-5.2.13-1.i686, php-session-5.2.13-1.i686, I php-spl-5.2.13-1.i686 D fontpostinst-0.1-15.noarch, libjpeg-8a-1.i686, libltdl-2.2.6-12.i686, D libmcrypt-2.5.8-1.i686, libpng-1.4.1-1.i686, php-cli-5.2.13-1.i686, D php-pcre-5.2.13-1.i686, php-simplexml-5.2.13-1.i686, t1lib-5.1.2-2.i686 This operation will use 3.9MB of disk space. Potrzeba pobrać 1.4MB archiwów (1.4MB do pobrania). Pobieranie th::fontpostinst-0.1-15.noarch.rpm... .............................. 100.0% [5.6K (5.6K/s)] Pobieranie th::libjpeg-8a-1.i686.rpm... .............................. 100.0% [106.2K (106.2K/s)] Pobieranie th::libltdl-2.2.6-12.i686.rpm... .............................. 100.0% [16.3K (16.3K/s)] Pobieranie th::libmcrypt-2.5.8-1.i686.rpm... .............................. 100.0% [61.3K (61.3K/s)] Pobieranie th::libpng-1.4.1-1.i686.rpm... .............................. 100.0% [112.7K (7.1K/s)] Pobieranie th::php-cli-5.2.13-1.i686.rpm... .............................. 100.0% [18.0K (18.0K/s)] Pobieranie th::php-dom-5.2.13-1.i686.rpm... .............................. 100.0% [45.3K (31.1K/s)] Pobieranie th::t1lib-5.1.2-2.i686.rpm... .............................. 100.0% [439.1K (439.1K/s)] Pobieranie th::php-gd-5.2.13-1.i686.rpm... .............................. 100.0% [79.9K (79.9K/s)] Pobieranie th::php-gettext-5.2.13-1.i686.rpm... .............................. 100.0% [10.5K (10.5K/s)] Pobieranie th::php-iconv-5.2.13-1.i686.rpm... .............................. 100.0% [19.2K (19.2K/s)] Pobieranie th::php-mbstring-5.2.13-1.i686.rpm... .............................. 100.0% [372.3K (372.3K/s)] Pobieranie th::php-mcrypt-5.2.13-1.i686.rpm... .............................. 100.0% [16.0K (7.1K/s)] Pobieranie th::php-openssl-5.2.13-1.i686.rpm... .............................. 100.0% [32.4K (32.4K/s)] Pobieranie th::php-pcre-5.2.13-1.i686.rpm... .............................. 100.0% [19.0K (19.0K/s)] Pobieranie th::php-readline-5.2.13-1.i686.rpm... .............................. 100.0% [9.3K (9.3K/s)] Pobieranie th::php-session-5.2.13-1.i686.rpm... .............................. 100.0% [25.6K (25.6K/s)] Pobieranie th::php-spl-5.2.13-1.i686.rpm... .............................. 100.0% [71.2K (5.7K/s)] Pobieranie th::php-simplexml-5.2.13-1.i686.rpm... .............................. 100.0% [16.9K (16.9K/s)] Uruchamianie rpm --upgrade -vh --root /... ostrzeżenie: /var/cache/poldek/ftp_ftp.th.pld-linux.org.dists.th.PLD.noarch.RPMS/fontpostinst-0.1-15.noarch.rpm: Nagłówek V3 sygnatura DSA: NOKEY, key ID e4f1bc2d Przygotowywanie... ########################################### [100%] 1:fontpostinst ########################################### [ 5%] 2:t1lib ########################################### [ 11%] Searching for Type 1 fonts and AFM files... No Type 1 fonts were found in the expected locations. If you want t1lib to be aware of your fonts, you should run /usr/bin/t1libconfig with the names of your local font directories as arguments, or you should edit the /etc/t1lib/FontDatabase file manually. See the FontDatabase(5) manual page for more information. 3:php-simplexml ########################################### [ 16%] 4:php-pcre ########################################### [ 21%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 5:php-cli ########################################### [ 26%] 6:libpng ########################################### [ 32%] 7:libmcrypt ########################################### [ 37%] 8:libltdl ########################################### [ 42%] 9:libjpeg ########################################### [ 47%] 10:php-dom ########################################### [ 53%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 11:php-gd ########################################### [ 58%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 12:php-gettext ########################################### [ 63%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 13:php-iconv ########################################### [ 68%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 14:php-mbstring ########################################### [ 74%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 15:php-mcrypt ########################################### [ 79%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 16:php-openssl ########################################### [ 84%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 17:php-readline ########################################### [ 89%] 18:php-session ########################################### [ 95%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] 19:php-spl ########################################### [100%] Zatrzymywanie usługi Apache 2.2 Web Server (prefork)...............[ ZROBIONE ] Uruchamianie usługi Apache 2.2 Web Server (prefork)................[ ZROBIONE ] poldek:/all-avail> Zapisywanie /var/cache/poldek/packages.rpmdbcache.var.lib.rpm.gz... [root@pld_pdns httpd]# mc fr /home/services/httpd/html/pdnsadmin/in < 1) index.php 2) install/ /services/httpd/html/pdnsadmin/install < [root@pld_pdns /]# mc [root@pld_pdns httpd]# mysql -p -u pdns pdns Enter password: Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 46 Server version: 5.1.45-log PLD Linux Distribution MySQL RPM Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> SELECT * FROM logs; Empty set (0.00 sec) mysql> SELECT * FROM logs2; ERROR 1146 (42S02): Table 'pdns.logs2' doesn't exist mysql> Bye [root@pld_pdns httpd]# mc [root@pld_pdns services]# mc [root@pld_pdns pdns]# host 1) hostid 2) hostname [root@pld_pdns pdns]# poldek Wczytywanie [pndir]th... Wczytywanie [pndir]th... Przeczytano 15707 pakietów Wczytywanie [rpmdbcache]/var/lib/rpm... Przeczytano 209 pakietów Witaj w poldkowym trybie interaktywnym. Wpisz "help" aby otrzymać pomoc. poldek:/all-avail> install bi biew-610-1.i686 binutils-2.20.51.0.4-1.i686 bigloo-3.2a-1.i686 binutils-devel-2.20.51.0.4-1.i686 billreminder-0.3.2-1.i686 binutils-gasp-2.20.51.0.4-1.i686 bin2iso-1.9b-8.i686 binutils-libs-2.20.51.0.4-1.i686 bin86-0.16.17-3.i686 binutils-static-2.20.51.0.4-1.i686 bind-9.7.0.P1-1.i686 bird-1.2.1-1.i686 bind-devel-9.7.0.P1-1.i686 bird-ipv4-1.2.1-1.i686 bind-libs-9.7.0.P1-1.i686 bird-ipv6-1.2.1-1.i686 bind-static-9.7.0.P1-1.i686 bison-2.4.1-1.i686 bind-utils-9.7.0.P1-1.i686 bison-runtime-2.4.1-1.i686 binflash-1.38-1.i686 bitbake-1.8.18-1.noarch binfmt-detector-0.2-3.i686 poldek:/all-avail> [root@pld_pdns pdns]# poldek Wczytywanie [pndir]th... Wczytywanie [pndir]th... Przeczytano 15707 pakietów Wczytywanie [rpmdbcache]/var/lib/rpm... Przeczytano 209 pakietów Witaj w poldkowym trybie interaktywnym. Wpisz "help" aby otrzymać pomoc. poldek:/all-avail> search --file *nslookup* Przeszukiwanie pakietów..........................................zrobione. 4 package(s) found: bind-utils-9.7.0.P1-1.i686 mibs-libsmi-0.4.8-5.i686 zsh-4.3.10-2.i686 zsh-completions-4.3.10-2.i686 poldek:/all-avail> install bind-utils Przetwarzanie zależności... bind-utils-9.7.0.P1-1.i686 zaznaczył bind-libs-9.7.0.P1-1.i686 (wł. bind-libs = 7:9.7.0.P1-1) bind-utils-9.7.0.P1-1.i686 zaznaczył idnkit-1.0-5.i686 (wł. libidnkit.so.1) There are 3 packages to install (2 marked by dependencies): I bind-utils-9.7.0.P1-1.i686 D bind-libs-9.7.0.P1-1.i686, idnkit-1.0-5.i686 This operation will use 3.2MB of disk space. Potrzeba pobrać 815.4KB archiwów (815.4KB do pobrania). Pobieranie th::bind-libs-9.7.0.P1-1.i686.rpm... .............................. 100.0% [552.6K (552.6K/s)] Pobieranie th::idnkit-1.0-5.i686.rpm... .............................. 100.0% [131.0K (131.0K/s)] Pobieranie th::bind-utils-9.7.0.P1-1.i686.rpm... .............................. 100.0% [131.8K (131.8K/s)] Uruchamianie rpm --upgrade -vh --root /... ostrzeżenie: /var/cache/poldek/ftp_ftp.th.pld-linux.org.dists.th.PLD.i686.RPMS/bind-libs-9.7.0.P1-1.i686.rpm: Nagłówek V4 sygnatura DSA: NOKEY, key ID e4f1bc2d Przygotowywanie... ########################################### [100%] 1:idnkit ########################################### [ 33%] 2:bind-libs ########################################### [ 67%] 3:bind-utils ########################################### [100%] poldek:/all-avail>