mpd5 HELP parameter negotiation failed
mpd5 HELP parameter negotiation failed
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
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
Re: mpd5 HELP parameter negotiation failed
вот ещо !
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
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
Re: mpd5 HELP parameter negotiation failed
ABills не может подключится к базе,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
Access denied for user 'abills'@'localhost'
Re: mpd5 HELP parameter negotiation failed
проверил 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 сервер
ГДе имено смотреть тест проходит ??????????????????????????
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 сервер
ГДе имено смотреть тест проходит ??????????????????????????
Re: mpd5 HELP parameter negotiation failed
У вас удаленный или локальный НАС?
Re: mpd5 HELP parameter negotiation failed
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
$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
Re: mpd5 HELP parameter negotiation failed
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
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 раз.
Re: mpd5 HELP parameter negotiation failed
просмотрел права пользователя system
Нету не одной галочки
Что тут должно бить ???????????????
просмотрел права пользователя abills
есть майже есть галочки
Нету не одной галочки
Что тут должно бить ???????????????
просмотрел права пользователя abills
есть майже есть галочки
Re: mpd5 HELP parameter negotiation failed
Сори
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.
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.
Re: mpd5 HELP parameter negotiation failed
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
*************************** 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
Re: mpd5 HELP parameter negotiation failed
есть такой юзер на локалхост
и даже на 127.0.0.1
и даже на 127.0.0.1
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
Проблема осталась
Re: mpd5 HELP parameter negotiation failed
/ Сиcтема/ Сервер доступу/ IP POOLs/
поле mask виставляется но не запоминается
поле mask виставляется но не запоминается