не могу зайти в abills при попытки ввода пароля

Установка, настройка, поддержка
Ответить
mideni
Сообщения: 3
Зарегистрирован: Ср сен 26, 2012 9:17 pm

не могу зайти в abills при попытки ввода пароля

Сообщение mideni »

Здравствуйте!!! Ни как не могу доконца поднять сервер билинговой сис-мы abills, просто не могу зайти в нее, идет запрос логина и пароля ввожу abills bи пароль abills,есть подозрение на mysql.
У меня опенац. си-ма fedofa 17, все делаю по сайту http://akehayc.yvision.kz/post/180497
зацыклился на пункте 12 создание базы даных
Когда я уже сделал
mysql -u root -p
> GRANT ALL ON abills.* TO abills@localhost IDENTIFIED BY "yourpassword";
> CREATE DATABASE abills;
> quit
и теперь дамп БД из каталога с abills нужно занести в БД
mysql -u root -p abills < abills.sql
-----------------------------------
и когда я ввожу дамп бд то мне myslq выдает ошибку вот такого содержания:
[root@localhost abills]# mysql -u root -p abills < abills.sql
Enter password:
ERROR 1064 (42000) at line 128: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(14) NOT NULL,
KEY `acct_session_id` (`acct_session_id`),
KEY `session_inter' at line 9
-----------------------------
что с этим можно сделать??? помогите плисс!!!!
при читании этой темы как поставить блинг и на других форумах, надо подправить файл /usr/abills/Abills/defs.conf
и поменять приведенные ниже строки на:
$SNMPWALK = '/usr/bin/snmpwalk';
$SNMPSET = '/usr/bin/snmpset';
$GZIP = '/bin/gzip';
$TAR='/bin/tar';
$MYSQLDUMP = '/usr/bin/mysqldump';
$IFCONFIG='/sbin/ifconfig';
$SUDO='/usr/bin/sudo';
но у меня нет файла /usr/bin/snmpwalk, и /usr/bin/snmpset'; ----почему? где косяк

~AsmodeuS~
Site Admin
Сообщения: 5746
Зарегистрирован: Пт янв 28, 2005 3:11 pm
Контактная информация:

Re: не могу зайти в abills при попытки ввода пароля

Сообщение ~AsmodeuS~ »

сморите лог апача

alex
Сообщения: 1
Зарегистрирован: Чт сен 05, 2013 12:28 pm

Re: не могу зайти в abills при попытки ввода пароля

Сообщение alex »

Добрый день!
Устанавливаю Абиллс на Ubuntu 10.04 (танцы с бубном) ))
Устанаыливал согласно вашей документации на странице http://abills.net.ua/wiki/doku.php/abil ... _ubuntu:ru , но теперь никак не могу войти на страницу пользователя и админа, "неправильный пароль!".
$conf{secretkey}= 'qsdfcqwecqwd' совпадает с настройками MySQL

какие логи, конф необходимы , все выложу.
Спасибо.

root@ubuntu:~# radtest test 123456 127.0.0.1 0 radsecret
Sending Access-Request of id 164 to 127.0.0.1 port 1812
User-Name = "test"
User-Password = "123456"
NAS-IP-Address = 127.0.1.1
NAS-Port = 0
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=164, length=47
Reply-Message = "Unknow server '127.0.1.1'"

Поменял в базе nas ip на 127.0.1.1
получилось ..
freeradius restart
apache2 restart

root@ubuntu:~# radtest test 123456 127.0.0.1 0 radsecret
Sending Access-Request of id 184 to 127.0.0.1 port 1812
User-Name = "test"
User-Password = "123456"
NAS-IP-Address = 127.0.1.1
NAS-Port = 0
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=184, length=45
Reply-Message = "Wrong password '123456'"
root@ubuntu:~#


затем проделал


root@ubuntu:/usr/local/freeradius/sbin# /etc/init.d/freeradius stop
* Stopping FreeRADIUS daemon freeradius [ OK ]
1) root@ubuntu:/usr/local/freeradius/sbin# /usr/local/freeradius/sbin/radiusd -X

2) root@ubuntu:~# radtest test 123456 127.0.0.1 0 radsecret

Ответ: 1) + 2) ниже

FreeRADIUS Version 2.2.0, for host i686-pc-linux-gnu, built on Sep 4 2013 at 12:58:59
Copyright (C) 1999-2012 The FreeRADIUS server project and contributors.
There is NO warranty; not even for MERCHANTABILITY or FITNESS FOR A
PARTICULAR PURPOSE.
You may redistribute copies of FreeRADIUS under the terms of the
GNU General Public License v2.
Starting - reading configuration files ...
including configuration file /usr/local/freeradius/etc/raddb/radiusd.conf
including configuration file /usr/local/freeradius/etc/raddb/clients.conf
including files in directory /usr/local/freeradius/etc/raddb/modules/
including configuration file /usr/local/freeradius/etc/raddb/modules/ntlm_auth
including configuration file /usr/local/freeradius/etc/raddb/modules/sradutmp
including configuration file /usr/local/freeradius/etc/raddb/modules/echo
including configuration file /usr/local/freeradius/etc/raddb/modules/files
including configuration file /usr/local/freeradius/etc/raddb/modules/mac2ip
including configuration file /usr/local/freeradius/etc/raddb/modules/expr
including configuration file /usr/local/freeradius/etc/raddb/modules/preprocess
including configuration file /usr/local/freeradius/etc/raddb/modules/realm
including configuration file /usr/local/freeradius/etc/raddb/modules/etc_group
including configuration file /usr/local/freeradius/etc/raddb/modules/linelog
including configuration file /usr/local/freeradius/etc/raddb/modules/detail
including configuration file /usr/local/freeradius/etc/raddb/modules/mac2vlan
including configuration file /usr/local/freeradius/etc/raddb/modules/logintime
including configuration file /usr/local/freeradius/etc/raddb/modules/inner-eap
including configuration file /usr/local/freeradius/etc/raddb/modules/exec
including configuration file /usr/local/freeradius/etc/raddb/modules/ldap
including configuration file /usr/local/freeradius/etc/raddb/modules/expiration
including configuration file /usr/local/freeradius/etc/raddb/modules/always
including configuration file /usr/local/freeradius/etc/raddb/modules/perl
including configuration file /usr/local/freeradius/etc/raddb/modules/acct_unique
including configuration file /usr/local/freeradius/etc/raddb/modules/attr_filter
including configuration file /usr/local/freeradius/etc/raddb/modules/rediswho
including configuration file /usr/local/freeradius/etc/raddb/modules/unix
including configuration file /usr/local/freeradius/etc/raddb/modules/krb5
including configuration file /usr/local/freeradius/etc/raddb/modules/pap
including configuration file /usr/local/freeradius/etc/raddb/modules/policy
including configuration file /usr/local/freeradius/etc/raddb/modules/smsotp
including configuration file /usr/local/freeradius/etc/raddb/modules/dhcp_sqlippool
including configuration file /usr/local/freeradius/etc/raddb/sql/mysql/ippool-dhcp.conf
including configuration file /usr/local/freeradius/etc/raddb/modules/smbpasswd
including configuration file /usr/local/freeradius/etc/raddb/modules/cache
including configuration file /usr/local/freeradius/etc/raddb/modules/redis
including configuration file /usr/local/freeradius/etc/raddb/modules/ippool
including configuration file /usr/local/freeradius/etc/raddb/modules/opendirectory
including configuration file /usr/local/freeradius/etc/raddb/modules/cui
including configuration file /usr/local/freeradius/etc/raddb/modules/attr_rewrite
including configuration file /usr/local/freeradius/etc/raddb/modules/otp
including configuration file /usr/local/freeradius/etc/raddb/modules/chap
including configuration file /usr/local/freeradius/etc/raddb/modules/detail.log
including configuration file /usr/local/freeradius/etc/raddb/modules/dynamic_clients
including configuration file /usr/local/freeradius/etc/raddb/modules/pam
including configuration file /usr/local/freeradius/etc/raddb/modules/checkval
including configuration file /usr/local/freeradius/etc/raddb/modules/passwd
including configuration file /usr/local/freeradius/etc/raddb/modules/replicate
including configuration file /usr/local/freeradius/etc/raddb/modules/wimax
including configuration file /usr/local/freeradius/etc/raddb/modules/digest
including configuration file /usr/local/freeradius/etc/raddb/modules/sqlcounter_expire_on_login
including configuration file /usr/local/freeradius/etc/raddb/modules/sql_log
including configuration file /usr/local/freeradius/etc/raddb/modules/counter
including configuration file /usr/local/freeradius/etc/raddb/modules/detail.example.com
including configuration file /usr/local/freeradius/etc/raddb/modules/radutmp
including configuration file /usr/local/freeradius/etc/raddb/modules/mschap
including configuration file /usr/local/freeradius/etc/raddb/modules/radrelay
including configuration file /usr/local/freeradius/etc/raddb/modules/soh
including configuration file /usr/local/freeradius/etc/raddb/policy.conf
including files in directory /usr/local/freeradius/etc/raddb/sites-enabled/
including configuration file /usr/local/freeradius/etc/raddb/sites-enabled/abills_default
main {
user = "freerad"
group = "freerad"
allow_core_dumps = no
}
including dictionary file /usr/local/freeradius/etc/raddb/dictionary
main {
name = "radiusd"
prefix = "/usr/local/freeradius"
localstatedir = "/var"
sbindir = "/usr/local/freeradius/sbin"
logdir = "/var/log"
run_dir = "/var/run/radiusd"
libdir = "/usr/local/lib/freeradius-2.1.6"
radacctdir = "/var/log/radacct"
hostname_lookups = no
max_request_time = 30
cleanup_delay = 5
max_requests = 512000
pidfile = "/var/run/radiusd/radiusd.pid"
checkrad = "/usr/local/freeradius/sbin/checkrad"
debug_level = 0
proxy_requests = no
log {
stripped_names = no
auth = no
auth_badpass = no
auth_goodpass = no
}
security {
max_attributes = 200
reject_delay = 1
status_server = yes
}
}
radiusd: #### Loading Realms and Home Servers ####
radiusd: #### Loading Clients ####
client 127.0.0.1 {
require_message_authenticator = no
secret = "radsecret"
shortname = "shorrname"
}
radiusd: #### Instantiating modules ####
instantiate {
Module: Linked to module rlm_exec
Module: Instantiating module "exec" from file /usr/local/freeradius/etc/raddb/modules/exec
exec {
wait = no
input_pairs = "request"
shell_escape = yes
}
Module: Linked to module rlm_expiration
Module: Instantiating module "expiration" from file /usr/local/freeradius/etc/raddb/modules/expiration
expiration {
reply-message = "Password Has Expired "
}
Module: Linked to module rlm_logintime
Module: Instantiating module "logintime" from file /usr/local/freeradius/etc/raddb/modules/logintime
logintime {
reply-message = "You are calling outside your allowed timespan "
minimum-timeout = 60
}
}
radiusd: #### Loading Virtual Servers ####
server { # from file /usr/local/freeradius/etc/raddb/radiusd.conf
modules {
Module: Creating Auth-Type = Perl
Module: Creating Post-Auth-Type = REJECT
Module: Checking authenticate {...} for more modules to load
Module: Linked to module rlm_pap
Module: Instantiating module "pap" from file /usr/local/freeradius/etc/raddb/modules/pap
pap {
encryption_scheme = "auto"
auto_header = no
}
Module: Linked to module rlm_mschap
Module: Instantiating module "mschap" from file /usr/local/freeradius/etc/raddb/modules/mschap
mschap {
use_mppe = yes
require_encryption = no
require_strong = no
with_ntdomain_hack = no
allow_retry = yes
}
Module: Linked to module rlm_perl
Module: Instantiating module "perl" from file /usr/local/freeradius/etc/raddb/modules/perl
perl {
module = "/usr/abills/libexec/rlm_perl.pl"
func_authorize = "authorize"
func_authenticate = "authenticate"
func_accounting = "accounting"
func_preacct = "preacct"
func_checksimul = "checksimul"
func_detach = "detach"
func_xlat = "xlat"
func_pre_proxy = "pre_proxy"
func_post_proxy = "post_proxy"
func_post_auth = "post_auth"
func_recv_coa = "recv_coa"
func_send_coa = "send_coa"
}
Module: Checking authorize {...} for more modules to load
Module: Linked to module rlm_preprocess
Module: Instantiating module "preprocess" from file /usr/local/freeradius/etc/raddb/modules/preprocess
preprocess {
huntgroups = "/usr/local/freeradius/etc/raddb/huntgroups"
hints = "/usr/local/freeradius/etc/raddb/hints"
with_ascend_hack = no
ascend_channels_per_line = 23
with_ntdomain_hack = no
with_specialix_jetstream_hack = no
with_cisco_vsa_hack = no
with_alvarion_vsa_hack = no
}
reading pairlist file /usr/local/freeradius/etc/raddb/huntgroups
reading pairlist file /usr/local/freeradius/etc/raddb/hints
Module: Linked to module rlm_files
Module: Instantiating module "files" from file /usr/local/freeradius/etc/raddb/modules/files
files {
usersfile = "/usr/local/freeradius/etc/raddb/users"
acctusersfile = "/usr/local/freeradius/etc/raddb/acct_users"
preproxy_usersfile = "/usr/local/freeradius/etc/raddb/preproxy_users"
compat = "no"
}
reading pairlist file /usr/local/freeradius/etc/raddb/users
reading pairlist file /usr/local/freeradius/etc/raddb/acct_users
reading pairlist file /usr/local/freeradius/etc/raddb/preproxy_users
Module: Checking preacct {...} for more modules to load
Module: Checking accounting {...} for more modules to load
Module: Checking post-auth {...} for more modules to load
} # modules
} # server
radiusd: #### Opening IP addresses and Ports ####
listen {
type = "auth"
ipaddr = *
port = 0
}
listen {
type = "acct"
ipaddr = *
port = 0
}
Listening on authentication address * port 1812
Listening on accounting address * port 1813
Ready to process requests.
rad_recv: Access-Request packet from host 127.0.0.1 port 50276, id=201, length=56
User-Name = "test"
User-Password = "123456"
NAS-IP-Address = 127.0.1.1
NAS-Port = 0
# Executing section authorize from file /usr/local/freeradius/etc/raddb/sites-enabled/abills_default
+- entering group authorize {...}
++[preprocess] returns ok
++[mschap] returns noop
[files] users: Matched entry DEFAULT at line 38
++[files] returns ok
Auth-Type := Accept
rlm_perl: Added pair User-Name = test
rlm_perl: Added pair User-Password = 123456
rlm_perl: Added pair NAS-Port = 0
rlm_perl: Added pair NAS-IP-Address = 127.0.1.1
rlm_perl: Added pair Reply-Message = Wrong password '123456'
rlm_perl: Added pair Auth-Type = Reject
++[perl] returns reject
Using Post-Auth-Type REJECT
# Executing group from file /usr/local/freeradius/etc/raddb/sites-enabled/abills_default
+- entering group REJECT {...}
rlm_perl: Added pair User-Name = test
rlm_perl: Added pair User-Password = 123456
rlm_perl: Added pair NAS-IP-Address = 127.0.1.1
rlm_perl: Added pair NAS-Port = 0
rlm_perl: Added pair Reply-Message = Wrong password '123456'
rlm_perl: Added pair Auth-Type = Reject
rlm_perl: Added pair Post-Auth-Type = REJECT
++[perl] returns ok
Delaying reject of request 0 for 1 seconds
Going to the next request
Waking up in 0.9 seconds.
Sending delayed reject for request 0
Sending Access-Reject of id 201 to 127.0.0.1 port 50276
Reply-Message = "Wrong password '123456'"
Waking up in 4.9 seconds.
Cleaning up request 0 ID 201 with timestamp +6
Ready to process requests.

------------------------------
запрос radiusd -X

root@ubuntu:~# radtest test 123456 127.0.0.1 0 radsecret
Sending Access-Request of id 201 to 127.0.0.1 port 1812
User-Name = "test"
User-Password = "123456"
NAS-IP-Address = 127.0.1.1
NAS-Port = 0
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=201, length=45
Reply-Message = "Wrong password '123456'"

Запрос freeradius start

root@ubuntu:~# radtest test 123456 127.0.0.1 0 radsecret
Sending Access-Request of id 37 to 127.0.0.1 port 1812
User-Name = "test"
User-Password = "123456"
NAS-IP-Address = 127.0.1.1
NAS-Port = 0
rad_recv: Access-Reject packet from host 127.0.0.1 port 1812, id=37, length=45
Reply-Message = "Wrong password '123456'"
root@ubuntu:~#




Спасибо.

seth
Сообщения: 23
Зарегистрирован: Пт авг 30, 2013 7:16 am

Re: не могу зайти в abills при попытки ввода пароля

Сообщение seth »

Авторизация в билинге не имеет отношения к радиусу.
Вот запрос обновляющий пароль пользователя abills (кстати темой ниже).

Код: Выделить всё

INSERT INTO admins (id, name, regdate, password, gid, aid, disable, phone, web_options,comments) VALUES ('abills','abills',curdate(), ENCODE('abills', 'qsdfcqwecqwd'), 0, 1,0,'', '', '');

Ответить