mpd5 HELP parameter negotiation failed

Вопросы и пожелания
Ответить
Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

erpolka mpd: [B-1] IPCP: rec'd Configure Request #7 (Ack-Rcvd)
erpolka mpd: [B-1] IPADDR 0.0.0.0
erpolka mpd: [B-1] NAKing with 10.10.10.241
erpolka mpd: [B-1] PRIDNS 0.0.0.0
erpolka mpd: [B-1] NAKing with 77.87.152.2
erpolka mpd: [B-1] SECDNS 0.0.0.0
erpolka mpd: [B-1] NAKing with 188.230.119.19
erpolka mpd: [B-1] IPCP: SendConfigNak #7
erpolka mpd: [B-1] IPADDR 10.10.10.241
erpolka mpd: [B-1] PRIDNS 77.87.152.2
erpolka mpd: [B-1] SECDNS 188.230.119.19
erpolka mpd: [B-1] IPCP: rec'd Configure Request #8 (Ack-Rcvd)
erpolka mpd: [B-1] IPADDR 10.10.10.241
erpolka mpd: [B-1] 10.10.10.241 is OK
erpolka mpd: [B-1] PRIDNS 77.87.152.2
erpolka mpd: [B-1] SECDNS 188.230.119.19
erpolka mpd: [B-1] IPCP: SendConfigAck #8
erpolka mpd: [B-1] IPADDR 10.10.10.241
erpolka mpd: [B-1] PRIDNS 77.87.152.2
erpolka mpd: [B-1] SECDNS 188.230.119.19
erpolka mpd: [B-1] IPCP: state change Ack-Rcvd --> Opened
erpolka mpd: [B-1] IPCP: LayerUp
erpolka mpd: [B-1] 10.10.10.1 -> 10.10.10.241
erpolka mpd: [L-1] RADIUS: Rec'd RAD_ACCOUNTING_RESPONSE for user 'siuhin'
erpolka mpd: [B-1] system: command "/usr/abills/libexec/linkupdown mpd up ng0 inet 10.10.10.1/32 10.10.10.241 'siuhin' '' '' '00:1e:8c:a6:2f:8f'" returned 65
erpolka mpd: [B-1] IPCP: parameter negotiation failed
erpolka mpd: [B-1] IPCP: state change Opened --> Stopping
erpolka mpd: [B-1] IPCP: SendTerminateReq #2
erpolka mpd: [B-1] IPCP: LayerDown
erpolka mpd: [B-1] system: command "/usr/abills/libexec/linkupdown mpd down ng0 inet 10.10.10.1/32 10.10.10.241 'siuhin' '00:1e:8c:a6:2f:8f'" returned 65280
erpolka mpd: [B-1] IPCP: rec'd Terminate Ack #2 (Stopping)
erpolka mpd: [B-1] IPCP: state change Stopping --> Stopped
erpolka mpd: [B-1] IPCP: LayerFinish
erpolka mpd: [B-1] Bundle: No NCPs left. Closing links...
erpolka mpd: [B-1] Bundle: closing link "L-1"...
erpolka mpd: [L-1] PPPoE: connection closed
Jun 10 07:31:51 superpolka mpd: [L-1] Link: DOWN event
Jun 10 07:31:51 superpolka mpd: [L-1] LCP: Close event
Jun 10 07:31:51 superpolka mpd: [L-1] LCP: state change Opened --> Closing
Jun 10 07:31:51 superpolka mpd: [L-1] Link: Leave bundle "B-1"
Jun 10 07:31:51 superpolka mpd: [L-1] RADIUS: Accounting user 'siuhin' (Type: 2)
Jun 10 07:31:51 superpolka mpd: [B-1] Bundle: Status update: up 0 links, total bandwidth 9600 bps
Jun 10 07:31:51 superpolka mpd: [B-1] IPCP: Close event
Jun 10 07:31:51 superpolka mpd: [B-1] IPCP: state change Stopped --> Closed
Jun 10 07:31:51 superpolka mpd: [B-1] IPCP: Down event
Jun 10 07:31:51 superpolka mpd: [B-1] IPCP: state change Closed --> Initial
Jun 10 07:31:51 superpolka mpd: [B-1] Bundle: Shutdown
Jun 10 07:31:51 superpolka mpd: [L-1] LCP: SendTerminateReq #3
Jun 10 07:31:51 superpolka mpd: [L-1] LCP: LayerDown
Jun 10 07:31:51 superpolka mpd: [L-1] LCP: Down event
Jun 10 07:31:51 superpolka mpd: [L-1] LCP: LayerFinish
Jun 10 07:31:51 superpolka mpd: [L-1] LCP: state change Closing --> Initial
Jun 10 07:31:51 superpolka mpd: [L-1] Link: CLOSE event
Jun 10 07:31:51 superpolka mpd: [L-1] LCP: Close event
Jun 10 07:31:51 superpolka mpd: [L-1] RADIUS: Rec'd RAD_ACCOUNTING_RESPONSE for user 'siuhin'
Jun 10 07:31:51 superpolka mpd: [L-1] Link: SHUTDOWN event
Jun 10 07:31:51 superpolka mpd: [L-1] Link: Shutdown


радиус

Wed Jun 8 22:47:31 2011 : Auth: Login OK: [siuhin/<CHAP-Password>] (from client localhost port 1 cli 002618c600a6)
Wed Jun 8 22:48:11 2011 : Auth: Login OK: [siuhin/<CHAP-Password>] (from client localhost port 1 cli 002618c600a6)
Wed Jun 8 22:48:51 2011 : Auth: Login OK: [siuhin/<CHAP-Password>] (from client localhost port 1 cli 002618c600a6)

тет проходит

abills-error.log

DBI connect('database=abills;host=localhost','abills',...) failed: Access denied for user 'abills'@'localhost' (using password: YES) at ../../Abills
Can't call method "do" on an undefined value at ../../Abills/mysql//main.pm line 75., referer: https://77.87.154.174:9443/admin/index.cgi?index=118


ifconfigre0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> metric 0 mtu 1500
options=38db<RXCSUM,TXCSUM,VLAN_MTU,VLAN_HWTAGGING,POLLING,VLAN_HWCSUM,WOL_UCAST,WOL_MCAST,WOL_MAGIC>
ether bc:ae:c5:94:78:64
inet 192.168.0.10 netmask 0xffffff00 broadcast 192.168.0.255
media: Ethernet autoselect (100baseTX <full-duplex>)
status: active
rl0: flags=8843<UP,BROADCAST,RUNNING,SIMPLEX,MULTICAST> metric 0 mtu 1500
options=3808<VLAN_MTU,WOL_UCAST,WOL_MCAST,WOL_MAGIC>
ether 00:02:44:91:ac:a2
inet 79.87.77.174 netmask 0xfffffffc broadcast 77.87.154.175
media: Ethernet autoselect (100baseTX <full-duplex>)
status: active
plip0: flags=8810<POINTOPOINT,SIMPLEX,MULTICAST> metric 0 mtu 1500
ipfw0: flags=8801<UP,SIMPLEX,MULTICAST> metric 0 mtu 65536
lo0: flags=8049<UP,LOOPBACK,RUNNING,MULTICAST> metric 0 mtu 16384
options=3<RXCSUM,TXCSUM>
inet6 fe80::1%lo0 prefixlen 64 scopeid 0x5
inet6 ::1 prefixlen 128
inet 127.0.0.1 netmask 0xff000000
nd6 options=3<PERFORMNUD,ACCEPT_RTADV>



ядро

#============================================================
options <------>SC_PIXEL_MODE
options <------>SC_NORM_ATTR=(FG_GREEN|BG_BLACK)
options <------>SC_KERNEL_CONS_ATTR=(FG_RED|BG_BLACK)

options><------>IPFIREWALL
options><------>IPFIREWALL_NAT
options><------>IPFIREWALL_VERBOSE
options><------>IPFIREWALL_VERBOSE_LIMIT=1000
options><------>IPFIREWALL_FORWARD
options><------>IPDIVERT
options><------>DUMMYNET
options><------>IPFIREWALL_DEFAULT_TO_ACCEPT

options><------>DEVICE_POLLING
options><------>HZ=1000

options><------>NETGRAPH
options><------>LIBALIAS
options><------>NETGRAPH_ASYNC
options><------>NETGRAPH_BPF
options><------>NETGRAPH_BRIDGE
options><------>NETGRAPH_CAR
options><------>NETGRAPH_ECHO
options><------>NETGRAPH_ETHER
options><------>NETGRAPH_HOLE
options><------>NETGRAPH_IFACE
options><------>NETGRAPH_IPFW
options><------>NETGRAPH_KSOCKET
options><------>NETGRAPH_MPPC_ENCRYPTION
options><------>NETGRAPH_NAT
options><------>NETGRAPH_NETFLOW
options><------>NETGRAPH_ONE2MANY
options><------>NETGRAPH_PPP
options><------>NETGRAPH_PPPOE
options><------>NETGRAPH_SOCKET
options><------>NETGRAPH_SPLIT
options><------>NETGRAPH_TCPMSS
options><------>NETGRAPH_TEE
options><------>NETGRAPH_VJC

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

вот ещо !
MPD.conf

startup:
<------>set user admin mpdpass admin
<------>set global enable tcp-wrapper
<------>set console self 127.0.0.1 5005
<------>set console open
#<----->set web self 77.87.154.174 5006
<------>set web self 0.0.0.0 5006
<------>set web open

default:
<------>load pppoe_server

pppoe_server:
## new -i ng0 pppoe_server pppoe_server
<------>create bundle template B
<------>set ipcp ranges 10.10.10.1/32 ippool 10.10.10.0/24
<------>set ipcp dns 77.87.152.2 188.230.119.19 77.87.152.9
<------>set iface idle 6000
<------>set iface session 86400
<------>set iface enable tcpmssfix
<------>set ipcp no vjcomp
<------>set iface up-script "/usr/abills/libexec/linkupdown mpd up"
<------>set iface down-script "/usr/abills/libexec/linkupdown mpd down"

<------>create link template L pppoe
<------>set link action bundle B
<------>set pppoe acname "bras1"
<------>set pppoe iface re0
<------>set pppoe service "*"
<------>load server_common

server_common:
<------>set link no pap eap
<------>set link yes chap-md5
<------>set link keep-alive 20 60
<------>set link enable incoming
<------> set link no acfcomp protocomp

<------>load radius

radius:
<------>set radius server localhost radsecret 1812 1813
<------>set radius retries 3
<------>set radius timeout 5
<------> set radius config /etc/radius.conf
<------>set auth acct-update 300
<------>set auth enable radius-auth
<------>set auth enable radius-acct
<------>set auth disable internal
<------>set radius enable message-authentic

Moose
Сообщения: 61
Зарегистрирован: Чт дек 24, 2009 4:45 pm
Откуда: Planet Earth

Re: mpd5 HELP parameter negotiation failed

Сообщение Moose »

DBI connect('database=abills;host=localhost','abills',...) failed: Access denied for user 'abills'@'localhost' (using password: YES) at ../../Abills
Can't call method "do" on an undefined value at ../../Abills/mysql//main.pm line 75., referer: https://77.87.154.174:9443/admin/index.cgi?index=118
ABills не может подключится к базе,

Access denied for user 'abills'@'localhost'

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

проверил gn0 создается


returned 65280

[B-2] system: command "/usr/abills/libexec/linkupdown mpd up ng0 inet 192.168.100.1/32 10.0.0.63 'test' '' ''
'178.93.132.92'" returned 65280
Такая ошибка возникает если МYSQL клиент на НАСе не может связаться с МYSQL сервером. Проверьте или хост МYSQL клиента добавлен в МYSQL сервер

ГДе имено смотреть тест проходит ??????????????????????????

Moose
Сообщения: 61
Зарегистрирован: Чт дек 24, 2009 4:45 pm
Откуда: Planet Earth

Re: mpd5 HELP parameter negotiation failed

Сообщение Moose »

У вас удаленный или локальный НАС?

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

локальний

Moose
Сообщения: 61
Зарегистрирован: Чт дек 24, 2009 4:45 pm
Откуда: Planet Earth

Re: mpd5 HELP parameter negotiation failed

Сообщение Moose »

1. попробуйте зайти с консоли в базу абилс пользователем и паролем что прописаны в конфиге
$conf{dbname}='abills';
$conf{dbuser}='abills';
$conf{dbpasswd}='123';

mysql -u abills -p123 -D abills

2. проверте есть ли пользователь abills'@'localhost в базе mysql
mydsql> use mysql;
mydsql> select * from user where User="abills" \G;
mydsql> select * from db where User="abills" \G;

3. Проверте установлени ли DBI

pkg_info |grep DBI

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

1
mysql -u abills -p 123 -D abills
Enter password:
ERROR 1044 (42000): Access denied for user 'abills'@'localhost' to database '123'

2
mysql> use abills;
Database changed
mysql> select * from user where User="abills" \G;
ERROR 1146 (42S02): Table 'abills.user' doesn't exist
ERROR:
No query specified

mysql> select * from db where User="abills" \G;
ERROR 1146 (42S02): Table 'abills.db' doesn't exist
ERROR:
No query specified

mysql>
Без G


3 pkg_info |grep DBI
p5-DBD-mysql-4.018 MySQL driver for the Perl5 Database Interface (DBI)
p5-DBI-1.615 The perl5 Database Interface. Required for DBD::* modules
Последний раз редактировалось Sasha462 Пн июн 20, 2011 7:47 am, всего редактировалось 1 раз.

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

просмотрел права пользователя system
Нету не одной галочки
Что тут должно бить ???????????????

просмотрел права пользователя abills
есть майже есть галочки

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

Сори
1
mysql -u abills -p123 -D abills
Enter password:
ERROR 1044 (42000): Access denied for user 'abills'@'localhost' to database '123'

Работает

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 172325
Server version: 5.1.55-log FreeBSD port: mysql-server-5.1.55

Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights reserved.
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL v2 license

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

select * from user where User="abills" \G;
*************************** 1. row ***************************
Host: 127.0.0.1
User: abills
Password:
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
*************************** 2. row ***************************
Host: localhost
User: abills
Password: *A439718346FE112079A7EF4EBD989AC24DA9CF84
Select_priv: N
Insert_priv: N
Update_priv: N
Delete_priv: N
Create_priv: N
Drop_priv: N
Reload_priv: N
Shutdown_priv: N
Process_priv: N
File_priv: N
Grant_priv: N
References_priv: N
Index_priv: N
Alter_priv: N
Show_db_priv: N
Super_priv: N
Create_tmp_table_priv: N
Lock_tables_priv: N
Execute_priv: N
Repl_slave_priv: N
Repl_client_priv: N
Create_view_priv: N
Show_view_priv: N
Create_routine_priv: N
Alter_routine_priv: N
Create_user_priv: N
Event_priv: N
Trigger_priv: N
ssl_type:
ssl_cipher:
x509_issuer:
x509_subject:
max_questions: 0
max_updates: 0
max_connections: 0
max_user_connections: 0
2 rows in set (0.02 sec)

ERROR:
No query specified

select * from db where User="abills" \G;
*************************** 1. row ***************************
Host: localhost
Db: abills
User: abills
Select_priv: Y
Insert_priv: Y
Update_priv: Y
Delete_priv: Y
Create_priv: Y
Drop_priv: Y
Grant_priv: Y
References_priv: Y
Index_priv: Y
Alter_priv: Y
Create_tmp_table_priv: Y
Lock_tables_priv: Y
Create_view_priv: Y
Show_view_priv: Y
Create_routine_priv: Y
Alter_routine_priv: Y
Execute_priv: Y
Event_priv: Y
Trigger_priv: Y
1 row in set (0.02 sec)

ERROR:
No query specified

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

есть такой юзер на локалхост
и даже на 127.0.0.1

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

Sasha462 писал(а):вот ещо !
MPD.conf

startup:
<------>set user admin mpdpass admin
<------>set global enable tcp-wrapper
<------>set console self 127.0.0.1 5005
<------>set console open
#<----->set web self 77.87.154.174 5006
<------>set web self 0.0.0.0 5006
<------>set web open

default:
<------>load pppoe_server

pppoe_server:
## new -i ng0 pppoe_server pppoe_server
<------>create bundle template B
<------>set ipcp ranges 10.10.10.1/32 ippool 10.10.10.0/24
<------>set ipcp dns 77.87.152.2 188.230.119.19 77.87.152.9
<------>set iface idle 6000
<------>set iface session 86400
<------>set iface enable tcpmssfix
<------>set ipcp no vjcomp
<------>set iface up-script "/usr/abills/libexec/linkupdown mpd up"
<------>set iface down-script "/usr/abills/libexec/linkupdown mpd down"

<------>create link template L pppoe
<------>set link action bundle B
<------>set pppoe acname "bras1"
<------>set pppoe iface re0
<------>set pppoe service "*"
<------>load server_common

server_common:
<------>set link no pap eap
<------>set link yes chap-md5
<------>set link keep-alive 20 60
<------>set link enable incoming
<------> set link no acfcomp protocomp

<------>load radius

radius:
<------>set radius server localhost radsecret 1812 1813
<------>set radius retries 3
<------>set radius timeout 5
<------> set radius config /etc/radius.conf с етим не работает
<------>set auth acct-update 300
<------>set auth enable radius-auth
<------>set auth enable radius-acct
<------>set auth disable internal
<------>set radius enable message-authentic

Проблема осталась

Sasha462
Сообщения: 225
Зарегистрирован: Ср дек 27, 2006 2:45 pm
Откуда: Львов

Re: mpd5 HELP parameter negotiation failed

Сообщение Sasha462 »

/ Сиcтема/ Сервер доступу/ IP POOLs/

поле mask виставляется но не запоминается

Ответить