Re: lug-bg: seriozen i neotkrivaem problem s Free Radius

[bombe@xxxxxxxxx (Vesselin Kotarov)]

ami maj izliza, che ne e ...
znachi rezultata ot selecta minawa prez edna funkcijka, narechena
sql_userparse(), koqto na pryw pogled iziskwa sql query-to da wyrne 5 koloni
... ot koito za 3-ta i 4-ta se znae, che sa attribute i value .. ili pone
kato gledam source-to na rlm_sql taka izliza ...

tazi funkciq se wika ot sql_getvpdata, w koqto stawa db query-to ...

hmz .. siguren li si, che izobshto se connect-wash do sql servera ? :)

htoto ot towa, koeto gledam (powyrhnosten pogled razbira se .. ne mi se
puska radius za debugging za ideqta) naj-weroqtno sql server-a ti neshto
omazwa ... ubij me ako moga da razbera kakwo ...

ako iskash movesh da slovish malko debug info w tezi 2 funkcii i pak da
probwash ;)

enjoy :)

B.

----- Original Message -----
From: "Vasko Tomanov" <vasko@xxxxxx>
To: <lug-bg@xxxxxxxxxxxxxxxxxx>; "Dimitar Peikov" <mitko@xxxxxxx>
Sent: Friday, January 04, 2002 3:15 PM
Subject: Re: lug-bg: seriozen i neotkrivaem problem s Free Radius

> totshno tva e problema tshe selekta raboti............
>
>
> daje napravihme slednoto ... smenihme selekta naprimer s SELECT 1013
>
> i pak ne raboti.
>
> ima li si niakoi poniatie kakvo totshno otshakva da varne selecta FREE
> radiusa da ne e neshto specialno ???
>
> moita logika e slednata - ako selekta varne neshto to vsithko e OK
>
> ako ne varne nito edin re znatshi usera ne se autentikira...
>
> tova li e
>
>
> Dimitar Peikov wrote:
> >
> > On Fri, 04 Jan 2002 14:08:02 +0200
> > Vasko Tomanov <vasko@xxxxxx> wrote:
> >
> > > problem ase satoi w tova tshe ne moga da go debugna...
> > > usera si go ima w bazat.. selecta raboti obatshe kazva login incorect
> > > ???????
> > > ne moga da mu pisna povesthe debug info radiusa e pusnat s -X  koeto e
> > > naj mnogo info..
> > >
> > > eto screnshot ot rezulta za identifikacia:
> > >
> > > rad_recv: Access-Request packet from host 212.72.196.2:1026, id=36,
> > > length=88
> > > Thread 3 assigned request 2
> > > --- Walking the entire request list ---
> > > Threads: total/active/spare threads = 5/1/4
> > > Waking up in 31 seconds...
> > > Thread 3 handling request 2, (1 handled so far)
> > >         User-Name = "1013"
> > >         Password = "****************"
> > >         NAS-Port = 10
> > >         LE-Terminate-Detail = "test"
> > >         LE-Advice-of-Charge = "TiNC"
> > >         USR-Terminal-Type = "test"
> > >         NAS-IP-Address = 212.72.196.2
> > > modcall: entering group authorize
> > >   modcall[authorize]: module "preprocess" returns ok
> > >   huntgroups: Matched netissat at 21
> > >     users: Matched DEFAULT at 2
> > >   modcall[authorize]: module "files" returns ok
> > > modcall: group authorize returns ok
> > >   rad_check_password:  Found Auth-Type NETISSAT
> > > auth: type "NETISSAT"
> > > modcall: entering group authtype
> > > rlm_sql: Reserving sql socket id: 0
> > > radius_xlat:  '1013'
> > > sql_escape in:  '1013'
> > > sql_escape out:  '1013'
> > > sql_set_user:  escaped user --> '1013'
> > > radius_xlat:  'SELECT id FROM netissat where id = 1013 and password =
> > > 'digex''
> >
> > Ami tuka ti e otgovora :
> >
> > > SELECT id FROM netissat where id = 1013 and password = 'digex'
> > > rlm_sql: Released sql socket id: 0
> > >   modcall[authenticate]: module "sql_netissat" returns reject
> > > modcall: group authtype returns reject
> >
> > proveri si select-a ot SQL-a :
> >
> > > auth: Failed to validate the user.
> > > Login incorrect: [1013/digex] (from nas netissat port 10)
> > > Sending Access-Reject of id 36 to 212.72.196.2:1026
> > > Finished request 2
> > > Going to the next request
> > > Thread 3 waiting to be assigned a request
> > >
===========================================================================
> > > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers)
> > > http://www.linux-bulgaria.org/ Hosted by Internet Group Ltd. - Stara
Zagora
> >
> > --
> > Dimitar Peikov
> > Programmer Analyst
> > Globalization Group
> > "We Build e-Business"
> >
> > RILA Solutions
> > 27 Building, Acad.G.Bonchev Str.
> > 1113 Sofia, Bulgaria
> >
> > phone: (+359 2) 9797320
> > phone: (+359 2) 9797300
> > fax:   (+359 2) 9733355
> > http://www.rila.com
> >
===========================================================================
> > A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers)
> > http://www.linux-bulgaria.org/ Hosted by Internet Group Ltd. - Stara
Zagora
>
===========================================================================
> A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers)
> http://www.linux-bulgaria.org/ Hosted by Internet Group Ltd. - Stara
Zagora
>

===========================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers)
http://www.linux-bulgaria.org/ Hosted by Internet Group Ltd. - Stara Zagora