Не работает mediawiki, moodle(5.0.2)

[valobasoff]

установил altlinux-5.0.2-20101219-school-server-i586-ru-install-cd.iso
читаю локальную документацию, дошел до вики, решил проверить, но не тут-то было, при вводе в браузере http://servername/mediawiki/ получаю следующее.

Wiki has a problem

Sorry! This site is experiencing technical difficulties.

Try waiting a few minutes and reloading.

(Can't contact the database server: Access denied for user 'wikiuser'@'localhost' (using password: YES) (localhost))

на запрос https://servername/moodle/

Error: Database connection failed.

It is possible that the database is overloaded or otherwise not running properly.

The site administrator should also check that the database details have been correctly specified in config.php

как я понимаю проблемма связи движка с базой в обоих случаях. Почему ?
так же заметил что при вводе адреса http://servername/mediawiki/  в строке автоматически подставляется https://servername/mediawiki/
тоже самое с moodle.

[Skull]

Пройдите на сервере этап начальной настройки с прописыванием домена.

[valobasoff]

я это делал в самом начале, или вы предлагаете сделать это ещё раз ?
на сервере так же работает NAT, DHCP и сервер сетевых установок.
На внешнем интерфейсе включена переадресация 80 порта на другую машину.

[Skull]

Проверьте запукс слуюбы mysqld:

Код: [Выделить]

service mysqld statusподнять:

Код: [Выделить]

service mysqld start

[valobasoff]

# service mysqld status
mysqld is running

рестарт тоже делал, не помогало.

[Skull]

Так смотрите, что в /var/log/messages

[valobasoff]

там всё просто засыпано следующими строчками

Dec 30 23:39:17 servername arpwatch[8744]: flip flop 170.151.24.203 52:54:4c:f3:2d:28 (52:54:4c:f3:e6:98)
Dec 30 23:39:17 servername arpwatch[8744]: flip flop 170.151.24.203 52:54:4c:f3:e6:98 (52:54:4c:f3:2d:28)
Dec 30 23:39:18 servername arpwatch[8744]: flip flop 170.151.24.203 52:54:4c:f3:2d:28 (52:54:4c:f3:e6:98)
Dec 30 23:39:18 servername arpwatch[8744]: flip flop 170.151.24.203 52:54:4c:f3:e6:98 (52:54:4c:f3:2d:28)

адрес 170.151.24.203 не имеет никакого отношения ни к внутренней ни к внешней сети.
Мне раньше казалось что arp работает только в сегменте ethernet..
Далее скачал сервер RC4, поставил, результат тот-же, вики с мудлом не работают, журнал засыпан теми же строчками.

[ruslandh]

А что кроме этого есть ?

[valobasoff]

как локализовать сообщение flip flop? лог файл забивается с сумасшедшей скоростью...

Dec 31 00:08:50 servername httpd2: httpd2: apr_sockaddr_info_get() failed for servername.localdomain
Dec 31 00:08:50 servername httpd2-office-server: httpd2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
Dec 31 00:08:50 servername httpd2: httpd2: Could not reliably determine the server's fully qualified domain name, using 127.0.0.1 for ServerName
Dec 31 00:08:51 servername httpd2: httpd2 startup succeeded
Dec 31 00:08:51 servername httpd2-office-server: ^[[73G
Dec 31 00:08:51 servername httpd2-office-server: [
Dec 31 00:08:51 servername httpd2-office-server: ^[[1m^[[32m
Dec 31 00:08:51 servername httpd2-office-server: DONE
Dec 31 00:08:51 servername httpd2-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:51 servername first_time: Executing httpd2-office-server first time script: succeeded
Dec 31 00:08:51 servername first_time: Executing indexhtml first time script: succeeded
Dec 31 00:08:53 servername mysql-office-server: Adjusting environment for mysqld:
Dec 31 00:08:53 servername mysqld: Adjusting environment for mysqld: succeeded
Dec 31 00:08:53 servername mysql-office-server: ^[[73G
Dec 31 00:08:53 servername mysql-office-server: [
Dec 31 00:08:53 servername mysql-office-server: ^[[1m^[[32m
Dec 31 00:08:53 servername mysql-office-server: DONE
Dec 31 00:08:53 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:53 servername mysql-office-server: Starting mysqld service:
Dec 31 00:08:53 servername mysqld: mysqld startup succeeded
Dec 31 00:08:53 servername mysql-office-server: ^[[73G
Dec 31 00:08:53 servername mysql-office-server: [
Dec 31 00:08:53 servername mysql-office-server: ^[[1m^[[32m
Dec 31 00:08:53 servername mysql-office-server: DONE
Dec 31 00:08:53 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:53 servername mysql-office-server: ERROR
Dec 31 00:08:53 servername mysql-office-server:  2002 (HY000)
Dec 31 00:08:53 servername mysql-office-server: : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Dec 31 00:08:53 servername mysql-office-server: ERROR
Dec 31 00:08:53 servername mysql-office-server:  2002 (HY000)
Dec 31 00:08:53 servername mysql-office-server: : Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Dec 31 00:08:53 servername mysql-office-server: Sending TERM signal to mysqld:
Dec 31 00:08:53 servername mysql-office-server: Service mysqld is not running.
Dec 31 00:08:53 servername mysqld: sending signal 15 to mysqld succeeded
Dec 31 00:08:53 servername mysql-office-server: ^[[73G
Dec 31 00:08:53 servername mysql-office-server: [
Dec 31 00:08:53 servername mysql-office-server: ^[[1m^[[33m
Dec 31 00:08:53 servername mysql-office-server: PASSED
Dec 31 00:08:53 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:53 servername mysql-office-server: Waiting, while mysqld actualy stopped:
Dec 31 00:08:53 servername mysql-office-server: ^[[73G
Dec 31 00:08:53 servername mysql-office-server: [
Dec 31 00:08:53 servername mysql-office-server: ^[[1m^[[32m
Dec 31 00:08:53 servername mysql-office-server: DONE
Dec 31 00:08:53 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:53 servername mysql-office-server: Adjusting environment for mysqld:
Dec 31 00:08:53 servername mysqld: Adjusting environment for mysqld: succeeded
Dec 31 00:08:53 servername mysql-office-server: ^[[73G
Dec 31 00:08:53 servername mysql-office-server: [
Dec 31 00:08:53 servername mysql-office-server: ^[[1m^[[32m
Dec 31 00:08:53 servername mysql-office-server: DONE
Dec 31 00:08:53 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:53 servername mysql-office-server: Starting mysqld service:
Dec 31 00:08:54 servername mysqld: (null) already running.
Dec 31 00:08:54 servername mysqld: (null) already running.
Dec 31 00:08:54 servername mysql-office-server: (null) already running.
Dec 31 00:08:54 servername mysqld: mysqld startup failed
Dec 31 00:08:54 servername mysql-office-server: ^[[73G
Dec 31 00:08:54 servername mysql-office-server: [
Dec 31 00:08:54 servername mysql-office-server: ^[[1m^[[31m
Dec 31 00:08:54 servername mysql-office-server: FAILED
Dec 31 00:08:54 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1
Dec 31 00:08:56 servername mysql-office-server: : The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement
Dec 31 00:08:56 servername mysql-office-server: Sending TERM signal to mysqld:
Dec 31 00:08:56 servername mysqld: sending signal 15 to mysqld succeeded
Dec 31 00:08:56 servername mysql-office-server: ^[[73G
Dec 31 00:08:56 servername mysql-office-server: [
Dec 31 00:08:56 servername mysql-office-server: ^[[1m^[[32m
Dec 31 00:08:56 servername mysql-office-server: DONE
Dec 31 00:08:56 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:56 servername mysql-office-server: Waiting, while mysqld actualy stopped:
Dec 31 00:08:56 servername mysql-office-server:   300
Dec 31 00:08:57 servername mysql-office-server:   299
Dec 31 00:08:58 servername mysql-office-server:   298
Dec 31 00:08:59 servername mysql-office-server: ^[[73G
Dec 31 00:08:59 servername mysql-office-server: [
Dec 31 00:08:59 servername mysql-office-server: ^[[1m^[[32m
Dec 31 00:08:59 servername mysql-office-server: DONE
Dec 31 00:08:59 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:08:59 servername mysql-office-server: Adjusting environment for mysqld:
Dec 31 00:08:59 servername mysqld: Adjusting environment for mysqld: succeeded
Dec 31 00:08:59 servername mysql-office-server: ^[[73G
Dec 31 00:08:59 servername mysql-office-server: [
Dec 31 00:09:00 servername mysql-office-server: ^[[1m^[[32m
Dec 31 00:09:00 servername mysql-office-server: DONE
Dec 31 00:09:00 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:09:00 servername mysql-office-server: Starting mysqld service:
Dec 31 00:09:00 servername mysqld: mysqld startup succeeded
Dec 31 00:09:00 servername mysql-office-server: ^[[73G
Dec 31 00:09:00 servername mysql-office-server: [
Dec 31 00:09:00 servername mysql-office-server: ^[[1m^[[32m
Dec 31 00:09:00 servername mysql-office-server: DONE
Dec 31 00:09:00 servername mysql-office-server: ^[[39;49m^[[0;10m
Dec 31 00:09:00 servername first_time: Executing mysql-office-server first time script: succeeded
Dec 31 00:09:01 servername kernel: [   54.313174] bootsplash 3.1.6-2004/03/31: looking for picture...
Dec 31 00:09:01 servername kernel: [   54.322076] bootsplash: silentjpeg size 40233 bytes
Dec 31 00:09:01 servername kernel: [   54.333958] bootsplash: ...found (800x600, 41216 bytes, v3).
Dec 31 00:09:01 servername kernel: [   54.334058] bootsplash: status on console 0 changed to on
Dec 31 00:09:01 servername publish-acc-to-console: Publishing web administration console addresses succeeded
Dec 31 00:09:01 servername kernel: [   54.417698] bootsplash: status on console 0 changed to on
Dec 31 00:11:02 servername mysqld: sending signal 15 to mysqld succeeded
Dec 31 00:11:04 servername mysqld: Adjusting environment for mysqld: succeeded
Dec 31 00:11:04 servername mysqld: mysqld startup succeeded
Dec 31 00:11:09 servername dhcpd: dhcpd startup failed
Dec 31 00:11:10 servername bind: named startup succeeded
Dec 31 00:11:10 servername named[6995]: loading configuration from '/etc/named.conf'
Dec 31 00:11:10 servername named[6995]: using default UDP/IPv4 port range: [1024, 65535]
Dec 31 00:11:10 servername named[6995]: using default UDP/IPv6 port range: [1024, 65535]
Dec 31 00:11:10 servername named[6995]: zone 0.22.172.in-addr.arpa/IN: loaded serial 2010123100
Dec 31 00:11:10 servername named[6995]: zone 135.47.84.in-addr.arpa/IN: loaded serial 2010123100
Dec 31 00:11:10 servername named[6995]: zone co1497.org/IN: loaded serial 2010123100
Dec 31 00:11:10 servername bind: sending signal 1 to named succeeded
Dec 31 00:11:10 servername bind: sending signal 1 to named succeeded
Dec 31 00:11:10 servername named[6995]: client 127.0.0.1#15889: updating zone 'co1497.org/IN': adding an RR at 'co1497.org' A
Dec 31 00:11:10 servername named[6995]: journal file ddns/co1497.org.jnl does not exist, creating it
Dec 31 00:11:10 servername named[6995]: client 127.0.0.1#46712: updating zone 'co1497.org/IN': adding an RR at 'servername.co1497.org' A
Dec 31 00:11:10 servername named[6995]: client 127.0.0.1#45584: updating zone 'co1497.org/IN': adding an RR at 'ns.co1497.org' A
Dec 31 00:11:10 servername named[6995]: client 127.0.0.1#1355: updating zone 'co1497.org/IN': adding an RR at 'ldap.co1497.org' A
Dec 31 00:11:10 servername named[6995]: client 127.0.0.1#27093: updating zone 'co1497.org/IN': adding an RR at 'co1497.org' A
Dec 31 00:11:10 servername named[6995]: client 127.0.0.1#16399: updating zone 'co1497.org/IN': adding an RR at 'servername.co1497.org' A
Dec 31 00:11:10 servername named[6995]: client 127.0.0.1#1210: updating zone 'co1497.org/IN': adding an RR at 'ns.co1497.org' A
Dec 31 00:11:10 servername named[6995]: client 127.0.0.1#34647: updating zone 'co1497.org/IN': adding an RR at 'ldap.co1497.org' A
Dec 31 00:11:11 servername named[6995]: loading configuration from '/etc/named.conf'
Dec 31 00:11:11 servername named[6995]: using default UDP/IPv4 port range: [1024, 65535]
Dec 31 00:11:11 servername named[6995]: using default UDP/IPv6 port range: [1024, 65535]
Dec 31 00:11:11 servername bind: sending signal 1 to named succeeded
Dec 31 00:11:11 servername named[6995]: loading configuration from '/etc/named.conf'
Dec 31 00:11:11 servername named[6995]: using default UDP/IPv4 port range: [1024, 65535]
Dec 31 00:11:11 servername named[6995]: using default UDP/IPv6 port range: [1024, 65535]
Dec 31 00:11:11 servername bind: sending signal 1 to named succeeded
Dec 31 00:11:11 servername slapd: slapd SSL PEM certificate generation succeeded
Dec 31 00:11:13 servername slapd: Adjusting environment for slapd: succeeded
Dec 31 00:11:13 servername slaptest: config file testing succeeded
Dec 31 00:11:13 servername slapd: Checking slapd configuration succeeded
Dec 31 00:11:13 servername slapd: slapd shutdown succeeded
Dec 31 00:11:16 servername slapd: slapd startup succeeded
Dec 31 00:11:17 servername krb5kdc: krb5kdc shutdown succeeded
Dec 31 00:11:17 servername krb5kdc[12888]: preauth pkinit failed to initialize: No realms configured correctly for pkinit support
Dec 31 00:11:17 servername krb5kdc[12888]: setting up network...
Dec 31 00:11:17 servername krb5kdc[12888]: skipping unrecognized local address family 17
Dec 31 00:11:17 servername krb5kdc[12888]: skipping unrecognized local address family 17
Dec 31 00:11:17 servername krb5kdc[12888]: listening on fd 10: udp 84.47.xxx.xxx.750
Dec 31 00:11:17 servername krb5kdc[12888]: listening on fd 11: udp 84.47.xxx.xxx.88
Dec 31 00:11:17 servername krb5kdc[12888]: listening on fd 12: udp 172.22.0.254.750
Dec 31 00:11:17 servername krb5kdc[12888]: listening on fd 13: udp 172.22.0.254.88
Dec 31 00:11:17 servername krb5kdc[12888]: set up 4 sockets
Dec 31 00:11:17 servername krb5kdc[12920]: commencing operation
Dec 31 00:11:17 servername krb5kdc: krb5kdc startup succeeded
Dec 31 00:11:17 servername kadmin.local[12928]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12930]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12931]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12933]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12935]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12936]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12938]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12940]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12941]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12943]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12945]: No dictionary file specified, continuing without one.
Dec 31 00:11:17 servername kadmin.local[12946]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12948]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12950]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12951]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12953]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12955]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12956]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12960]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12962]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12963]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12965]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12967]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12968]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12973]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12975]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12976]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12978]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12980]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12981]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12982]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12984]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12986]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12987]: No dictionary file specified, continuing without one.
Dec 31 00:11:18 servername kadmin.local[12988]: No dictionary file specified, continuing without one.
Dec 31 00:11:23 servername gpm[13806]: Started gpm successfully. Entered daemon mode.
Dec 31 00:11:23 servername gpm: gpm startup succeeded

Dec 31 00:48:32  arpwatch[8744]: reused old ethernet address 0.0.0.0 54:42:49:2b:38:94 (0:18:f3:75:17:84)
Dec 31 00:45:56  anacron[8505]: Job `cron.monthly' started
Dec 31 00:45:56 anacron[25571]: Updated timestamp for job `cron.monthly' to `2010-12-31 00:45:56'
Dec 31 00:45:56  anacron[8505]: Job `cron.monthly' terminated
Dec 31 00:45:56  anacron[8505]: Normal exit (2 jobs run)

[ruslandh]

как локализовать сообщение flip flop? лог файл забивается с сумасшедшей скоростью...

Отключите arpwatch

[ruslandh]

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

[ruslandh]

Dec 31 00:08:56 servername mysql-office-server: ERROR
Dec 31 00:08:56 servername mysql-office-server:  1290 (HY000)
Dec 31 00:08:56 servername mysql-office-server:  at line 1

осталось выяснить что за мусор идёт типа : ^[[1m^[[32m
и в первой строке какого файла ошибка.

[valobasoff]

спасибо, arpwatch отключил, а как быть дальше не понял, при попытке обращения к сайтам wiki и moodle сообщений в журнале нет. И почему так второй раз получилось ? установка с нуля, с удалением всех разделов и созданием их автоматически. Хард 80GB.

[ruslandh]

В принципе - проблема с настройкой mysql. Подозреваю, что как-то связано с именем домена, но не факт.

[mk]

У нас тоже с доменами вида xxx.local были сложности - просьба в порнухе не подозревать :)