Re: SqlCounter reload after initial authentication

2010-08-14 Thread liran tal
As Alan said this happens since the remaining time was already sent to the NAS which causes the disconnection, although if the user added more time then after he was initially disconnected by the NAS the user may still login again for the remaining time (which is the delta - what he already added -

Re: Time based usage

2010-06-01 Thread liran tal
Hey, 1. I don't understand what's the problem you're describing. Whatever amount the user has used, whenever the user conencts back the NAS should get an accurate Session-Timeout value to count-down from, hence the NAS should take care of enforcing the connection time (thus, disc

Re: Login scripts

2010-05-23 Thread liran tal
Quite new to FR2, though you could use that unlang feature to change 'on the fly' attributes and such. By identifying the nas type you could send the correct attributes. There is another way to approach this problem and that is to include both vendor's set of attributes to the NAS in your group pr

Re: FreeRADIUS 1.1.7 and exec modules

2010-05-10 Thread liran tal
On Sun, May 9, 2010 at 11:13 AM, Alan DeKok wrote: > liran tal wrote: > > Yep, I'll test this with the latest stable 2.1.8 though for the sake of > > clarity I wanted to know if it's anything > > wrong with my setup or a known problem. > > I don'

2.1.8 doesn't include the certs/ directory for the debian package build

2010-05-10 Thread liran tal
Hey Alan, Just a heads up for the next release. The 2.1.8 version doesn't include the certs/ directory files when building the debian package. Would be cool if you could push this change in the repo for the time being. Regards, Liran. - List info/subscribe/unsubscribe? See http://www.freeradiu

Re: FreeRADIUS 1.1.7 and exec modules

2010-05-08 Thread liran tal
Hey Alan, On Fri, May 7, 2010 at 8:22 AM, Alan DeKok wrote: > liran tal wrote: > > Just to be sure I'm not banging my head around this - is it a known > > issue where for a > > defined exec module which is later used in the authorize { } section, if > > it return

FreeRADIUS 1.1.7 and exec modules

2010-05-06 Thread liran tal
Hey, Just to be sure I'm not banging my head around this - is it a known issue where for a defined exec module which is later used in the authorize { } section, if it returns -1 to reject the user then freeradius doesn't return an access-reject and the request simply times out? Debug log: rad_r

Re: Remote MySQL backend encryption

2010-04-26 Thread liran tal
, depending on your deployment I guess. Regards, Liran Tal. > Not currently, but I've got a patch for the 1.1.7 version of rlm_ldap, so > it might need some tweaking for 2.x > > > >> Also is there a nas/radacct table equivalent in the ldap solution or is >> it st

Re: Counters reset period

2010-02-15 Thread liran tal
On Mon, Feb 15, 2010 at 9:52 PM, Alan DeKok wrote: > liran tal wrote: > >> Use a cron job && SQL statements. > > > > Alan, could you explain? > > The counters are stored in a DB. You can reset them any time you want > by just editing the DB. >

Re: Counters reset period

2010-02-15 Thread liran tal
On Mon, Feb 15, 2010 at 5:21 PM, Alan DeKok wrote: > liran tal wrote: > > > > It seems that the counting period is X months until the current month. > > So if reset=3m is specified and it's now February it will count 3 months > > earlier (thus, december, ja

Re: Counters reset period

2010-02-15 Thread liran tal
:1-3,4-6,7-9,10-12). Regards, Liran. On Mon, Feb 15, 2010 at 1:58 PM, liran tal wrote: > Hey, > > I've defined a quarterly reset period counter (reset=3m), and when > logging-in the %b and %e (beginning of counter > and ending of counter periods) I am getting values for

Counters reset period

2010-02-15 Thread liran tal
Hey, I've defined a quarterly reset period counter (reset=3m), and when logging-in the %b and %e (beginning of counter and ending of counter periods) I am getting values for beginning which are equal to the 1st of December and ending which is equal to the beginning of March. Meaning, the quarter b

Auth-Type and Group precedence

2010-01-14 Thread liran tal
Hey guys, Setting an Auth-Type := Accept to a user while also associating the same user to a group with Auth-Type := Reject results in a successful login of the user due to the Auth-Type := Accept in radcheck table taking precedence. Is it possible to give a higher priority to the group associati

Re: Different realms for different databases

2009-12-20 Thread liran tal
Hey Ivan, Further question regarding the use of realms - do sql counters require a special handling when used in conjunction with realms? Autz-Type SQL_EXAMPLE { sql_example noresetcounter datacounterdaily } What I'm seeing in debug mode is that while there's a reference

Re: dialup-admin problem

2009-10-25 Thread liran tal
There is also daloRADIUS available which is a web platform to manage freeradius based on mysql. On Mon, Sep 21, 2009 at 5:16 PM, Franz X. Maier wrote: > I have the same problem: installed freeradius on Suse Linux 11.2 and got > the dialupadmin partially working, but the web-interface only shows

Re: Web Management

2009-08-29 Thread liran tal
Diego, On Sat, Aug 29, 2009 at 8:46 AM, Diego wrote: > hello list > can someone give me a step by step manual to configure freeradius with web > interface > There is daloRADIUS as well. While dalo isn't provided with stock freeradius1/2 it is well recognized among the community and provides you

matching on nas entry/shortname

2009-07-08 Thread liran tal
Hey, Matching an entry based on the NAS's IP Address value in the request is doable via DEFAULT NAS-IP-Address == "1.2.3.4" ... How about if I wouldn't want to count on that attribute and I'd rather just want to match based on the NAS entry itself (which is read from mysql) or the shortname assig

Re: timestamp in radpostauth and radacct

2009-07-01 Thread liran tal
Hey Ivan, On Thu, Jul 2, 2009 at 2:00 AM, Ivan Kalik wrote: > >> To include information about the NAS in a listing of the radpostauth > >> (which > >> doesn't have an entry regarding the nas > >> from which the request originated from) I am joining the tables based on > >> the > >> radacct.accts

timestamp in radpostauth and radacct

2009-07-01 Thread liran tal
Hey, To include information about the NAS in a listing of the radpostauth (which doesn't have an entry regarding the nas from which the request originated from) I am joining the tables based on the radacct.acctstarttime = radpostauth.date which works "part" of the time. Meaning, for most of my tes

Re: RADIUS attributes: acctoutputoctects and acctinputoctect inmikrotik

2009-05-19 Thread liran tal
Hey Santiago, I am in a need to get a Nomadix AG3100 gateway to do the same thing as you have done - get it authenticate to FreeRADIUS and redirect to portal pages for a simple user/pass login. I've exchanged a bunch of emails with their support team (which is awful) and read their guides but it's

Re: freeradius mysql apache2 for Wi Fi hotspotsetup

2009-05-19 Thread liran tal
Hey Jerome, I am in a need to get a Nomadix AG3100 gateway to do the same thing as you have done - get it authenticate to FreeRADIUS and redirect to portal pages for a simple user/pass login. I've exchanged a bunch of emails with their support team (which is awful) and read their guides but it's t

Re: Removing tunnel attributes only for specific NAS

2009-05-19 Thread liran tal
Hey Ignacio, I am in a need to get a Nomadix AG3100 gateway to do the same thing as you have done - get it authenticate to FreeRADIUS and redirect to portal pages for a simple user/pass login. I've exchanged a bunch of emails with their support team (which is awful) and read their guides but it's

Re: SQL Counters and Realms

2009-05-06 Thread liran tal
You're correct, I haven't noticed this parameter and it's default 'sql' is a different database setup indeed. Thanks, Liran. On Wed, May 6, 2009 at 11:16 PM, Ivan Kalik wrote: > > Hey, > > > > In my FR1.1.7 setup, I have different realms for the same machine using > > different databases for ea

SQL Counters and Realms

2009-05-06 Thread liran tal
Hey, In my FR1.1.7 setup, I have different realms for the same machine using different databases for each. The login part is ok, as well as the accounting, which has entries in the radacct table for "account". I enabled one of the sql counters modules which, as it seems, isn't returning any resul

Re: Fwd: Realms and Accounting

2009-03-07 Thread liran tal
Thanks Ivan, I was able to find that from this post http://www.mail-archive.com/freeradius-users@lists.freeradius.org/msg17929.html too. So for Session-Type and for Post-Auth-Type, they should all go into acct_users as well? On Sat, Mar 7, 2009 at 11:54 PM, wrote: > >Regarding realms handled i

Fwd: Realms and Accounting

2009-03-07 Thread liran tal
This issue has yet to be resolved for me, running 1.1.7. Any pointers? -- Forwarded message -- From: liran tal Date: Sun, Feb 22, 2009 at 12:24 AM Subject: Realms and Accounting To: FreeRadius users mailing list Hey, Regarding realms handled in the local server (mysql) and

Realms and Accounting

2009-02-21 Thread liran tal
Hey, Regarding realms handled in the local server (mysql) and accounting... I have defined realms in the users file such as: DEFAULT Realm == "example.com", Autz-Type := SQL_EXAMPLE and in radiusd.conf I add in authorize { } Autz-Type SQL_EXAMPLE {

Re: daloRADIUS: Web Platform to manage FreeRADIUS

2009-02-19 Thread liran tal
ents indeed then I would hardly think that anyone would use daloradius over the existing Microsoft Windows tools for management. Please correct me on that as I am not familiar with many LDAP deployments. Regards, Liran. > > On Thu, Feb 19, 2009 at 5:50 AM, liran tal wrote: > > Hey E

daloRADIUS: Web Platform to manage FreeRADIUS

2009-02-19 Thread liran tal
Hey Everyone, I here-by would like to recommend daloRADIUS as a web platform for managing many aspects of a FreeRAIDUS deployment, among them: Users, Groups, Realms, Attributes, Dictionaries and much more. For those of you who are unfamiliar with daloRADIUS, it also provides many other function

Re: SQL multiple passwords for same user

2009-02-19 Thread liran tal
server and client, therefore I need freeradius to > try auth on multiple passwords in a table, for the same user. Is this > possible ? > You should be able to this by customizing the SQL syntax on sql.conf to reflect your needs. Regards, Liran Tal. - List info/subscribe/unsubscribe? See htt

Re: radius web managment

2009-02-03 Thread liran tal
The file is called daloradius.conf.php There's a file called INSTALL, if you would have done some reading it would have saved you 2 days and the world a couple of hundreds bytes of un-necessary email. Regards, Liran. On Tue, Feb 3, 2009 at 9:37 PM, Mr Little Crazzy wrote: > I found my error the

Re: radius web managment

2009-02-03 Thread liran tal
Hey, I am the author of the daloRADIUS project. All that has been said so far is true - you are really lacking some basic knowledge to be able to set it up, and true, the mysql database connection shouldn't really be root but that's another course in security so we won't go diving into that now...

Re: Different realms for different databases

2009-01-27 Thread liran tal
Thanks Ivan, That works just fine. On Wed, Jan 28, 2009 at 12:24 AM, wrote: >>To allow authentication of different realms for 2 different databases >>the setup for the authentication >>is quite straight forward with the Autz-Type directive as follows: >> >>authenticate { >> >> Autz-Type SQ

Different realms for different databases

2009-01-27 Thread liran tal
Hey, To allow authentication of different realms for 2 different databases the setup for the authentication is quite straight forward with the Autz-Type directive as follows: authenticate { ... Autz-Type SQL_EXAMPLE2 { sql_example2 } ... } Although the same trick wouldn't work for the

Re: Omitting Password

2009-01-24 Thread liran tal
On Sat, Jan 24, 2009 at 11:58 AM, wrote: > Hi, > > Our users are CDMA phones. The login credentials are: > > Username: phone...@isp.com > Password: phone_no > > Please is it possible to make the RADIUS Server not to ask for password > again and simply use the phone_no stripped from the username?

Re: Time based billing

2008-12-03 Thread liran tal
Hey Saeed, daloRADIUS will introduce in the next version (0.9-8) a better billing system with rates supported, though currently the rates are flat (i.e: all session is taken into account and not devided per the time of day) but if you have suggestions for improvements we can take this into account

Re: Daloradius Help

2008-12-01 Thread liran tal
Hey Bashir, As Ivan said, this is a matter due with the daloRADIUS list. The error message is pretty obvious but we'll continue this on the correct list. Thanks, Liran. On Mon, Dec 1, 2008 at 3:33 PM, Bashir Jahed <[EMAIL PROTECTED]> wrote: > I have managed to get freeradius + mysql authentic

Just wondering - are you using several groups for a user?

2008-11-17 Thread liran tal
Hey everyone, It's obvious that the structure of the tables allows to assign a user to several groups though I would like to ask you to the nature of why would you need to do that? Why is it not possible for you to put all attributes in that one group and assign the user to it? Regards, Liran.

Re: sqlcounter returning wrong value?

2008-11-12 Thread liran tal
al release, this entire support for data information too. Regards, Liran. On Wed, Nov 12, 2008 at 11:02 AM, Flamur Rogova <[EMAIL PROTECTED]> wrote: > liran tal wrote: > >> Waiting for that traffic limitation patch, Venkatesh. >> Thanks. >> >> > Hi, > I

Re: sqlcounter returning wrong value?

2008-11-11 Thread liran tal
Waiting for that traffic limitation patch, Venkatesh. Thanks. On Sun, Nov 9, 2008 at 6:00 AM, Venkatesh K <[EMAIL PROTECTED]> wrote: > Hi Liran, > > On Sun, Nov 9, 2008 at 4:16 AM, liran tal <[EMAIL PROTECTED]> wrote: > > Hey Venkatesh, > > > > On Fr

Re: sqlcounter returning wrong value?

2008-11-09 Thread liran tal
On Sun, Nov 9, 2008 at 6:00 AM, Venkatesh K <[EMAIL PROTECTED]> wrote: > Hi Liran, > > On Sun, Nov 9, 2008 at 4:16 AM, liran tal <[EMAIL PROTECTED]> wrote: > > Hey Venkatesh, > > > > On Fri, Oct 31, 2008 at 2:26 AM, Venkatesh K <[EMAIL PROTECTED]>

Re: sqlcounter returning wrong value?

2008-11-08 Thread liran tal
Hey Venkatesh, On Fri, Oct 31, 2008 at 2:26 AM, Venkatesh K <[EMAIL PROTECTED]> wrote: > 2008/10/31 <[EMAIL PROTECTED]>: > > It does make sense. rlm_sqlcounterworks like this toward the time of the > > reset: lets say you have an hour left, your limit is 20 hours and you > > have signed in 15 mi

Re: sqlcounter returning wrong value?

2008-10-30 Thread liran tal
Well, taking this issue back to the begining - it all started with my report that using the attribute Chilli-Max-Total-Octets in the sqlcounter provided as follows yields wrong results for all of the reset times (daily/weekly/monthly): sqlcounter counterChilliSpotMaxDailyOctets {

Re: sqlcounter returning wrong value?

2008-10-29 Thread liran tal
ays left in this month) and returned value will be > > 26MB + number of seconds untill 1.11. Run debug twice. You will see that > > the returned value will be reduced by the number of seconds between two > > requests. > > > > Allowance left would have to be well bel

Re: Insert billiplan code in radacct table during authenticaiton

2008-10-27 Thread liran tal
e.net/ Regards, Liran. > > > Bishal > > On 10/27/2008, "liran tal" <[EMAIL PROTECTED]> wrote: > > >On Sun, Oct 26, 2008 at 4:12 AM, Bishal <[EMAIL PROTECTED]> wrote: > > > >> > >> Following is my radcheck table format: > &g

Re: Insert billiplan code in radacct table during authenticaiton

2008-10-27 Thread liran tal
On Sun, Oct 26, 2008 at 4:12 AM, Bishal <[EMAIL PROTECTED]> wrote: > > Following is my radcheck table format: > > --+--+-+--+ > | id | UserName | Attribute| op | Value| CrDate > | creator | Usemac | activated | activeDate | status | >

Re: sqlcounter returning wrong value?

2008-10-25 Thread liran tal
t_time - > request->timestamp))) { > res += check_vp->vp_integer; > } > > where trigger would be set to a minute for hourly counter and hour for > daily, weekly and monthly counters. I am sorry but I don't know how to > write a patch. > > Ivan Kalik

Re: sqlcounter returning wrong value?

2008-10-24 Thread liran tal
e backported to 1.1.7? Thanks, Liran. > > > > Dana 24/10/2008, "liran tal" <[EMAIL PROTECTED]> piše: > > >Hey, > > > >2008/10/24 <[EMAIL PROTECTED]> > > > >> No, he wants a data not time counter. > > > > > >T

Re: sqlcounter returning wrong value?

2008-10-24 Thread liran tal
> > >http://www.indohotspot.net > >Your Hotspot solution > > -Original Message- > > From: [EMAIL PROTECTED] > >[mailto:freeradius-users-bounces+mulianto > [EMAIL PROTECTED] > >Behalf Of liran tal > > Sent: Friday, October 24, 2008 1:07 AM > >

sqlcounter returning wrong value?

2008-10-23 Thread liran tal
Hey, I'm experimenting with some sqlcounter directives in radiusd.conf and chilli as the NAS. I've defined the following sqlcounter stanza for a daily traffic limit: sqlcounter defined in radiusd.conf: (the query was corrected as suggested by tnt on a previous thread on the list, correct me if I

Adding a counter to raddb/sql/mysql/counter.conf

2008-07-30 Thread Liran Tal
Hey, How about adding more widely used counters to the counter.conf collection? One suggestion is the Access-Period counter which is provided with the attachment. Regards, Liran Tal. counter.conf.diff Description: Binary data - List info/subscribe/unsubscribe? See http://www.freeradius.org

Re: simple web interface

2008-06-15 Thread Liran Tal
me know if I can further assist you with anything. Regards, Liran Tal. On 15/06/2008, Liran Tal <[EMAIL PROTECTED]> wrote: > >> Hey Vittore >> >> On Tue, Jun 3, 2008 at 1:25 PM, Vittore Zen <[EMAIL PROTECTED]> wrote: >> >>> Hi, >>> >>>

Re: simple web interface

2008-06-15 Thread liran tal
ead and enlighten me, I'd like to know. Regards, Liran Tal. -Original Message- > From: [EMAIL PROTECTED] > [mailto:freeradius-users-bounces+sk = > [EMAIL PROTECTED] On > Behalf Of Vittore Zen > Sent: Dienstag, 3. Juni 2008 14:26 > To: freeradius-users@lists.freeradius

Re: simple web interface

2008-06-15 Thread Liran Tal
so you can get a good impression. http://sourceforge.net/projects/daloradius Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Session-Timeout conditionally appearing

2008-05-23 Thread Liran Tal
dress = 192.168.3.128 >NAS-Port = 1212 >Idle-Timeout = 900 >Session-Timeout = 1 > >Is Session-Timeout not showing due to misconfiguration on my > part (Fairly stock configuration), or because of some other reason? > >Thanks, Tuc >

Re: Move from text to SQL(Postgresql)

2008-05-13 Thread Liran Tal
commands > \? for help with psql commands > \g or terminate with semicolon to execute query > \q to quit > > radius=> select * from radcheck; > id | username | attribute | op | value > +--+++- > 2 | tuc | Cleartext-Password | := | ICANSEE > (1 row) > > radius=> > >Thanks, Tuc > - > List info/subscribe/unsubscribe? See > http://www.freeradius.org/list/users.html > Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Recommendations for manging user password

2008-05-11 Thread Liran Tal
(you obviously don't need to posses any mysql skills). It hasn't been tested with Oracle but if you're willing to give it a chance I will devote my free time to help you getting it installed and running. Any feedback is welcome, goodluck. Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: ippool usage question

2008-05-11 Thread Liran Tal
s as to how the management of IP Pools should be arranged. If you're up to it, I'd like to get some feedback. Regards, Liran Tal. On Thu, May 8, 2008 at 10:43 PM, John Joe <[EMAIL PROTECTED]> wrote: > Hy, > What happens if the ip addresses from the ippool are finished? I

Re: Weird shared secret issues

2008-05-01 Thread Liran Tal
Hey Tuc, This might happen because of interface changes. Also add a record to the nas table for the 127.0.0.1 ip address (or the other IP address you have configured on your ethernet interface). And I'm also assuming you have configured the nas table in sql.conf Regards, Liran Tal. On Wed

Re: Dialup-Admin Alternatives?

2008-04-22 Thread Liran Tal
net/ Demo: http://daloradius.xdsl.by/ (login with administrator/radius by default) Regards, Liran Tal. On Tue, Apr 22, 2008 at 3:21 AM, JaxxMaxx the Elder Druid <[EMAIL PROTECTED]> wrote: > Greetings folks! > > I'm wondering if there is something else that o

Re: WildcardCllients

2008-04-10 Thread Liran Tal
You may specify a class in CIDR format. For example: 10.0.0.0/8 Regards, Liran Tal. On Thu, Apr 10, 2008 at 12:11 PM, Andre Hübner <[EMAIL PROTECTED]> wrote: > Hello List, > > i use freeradius 0.8.1 coming with my distribution (yes, older system) > > Is it necessary to

Re: Prepaid Cards Setup

2008-03-30 Thread Liran Tal
ference: http://sourceforge.net/projects/daloradius Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: A good Open Source Billing Program For Freeradius?

2008-03-23 Thread Liran Tal
gards, Liran Tal. On Fri, Mar 21, 2008 at 8:48 PM, Lance Buttars <[EMAIL PROTECTED]> wrote: > I need to setup a hotspot with billing capabilities and was wondering if > anyone had some recommendations. > > > - > List info/subscribe/unsubscribe? See > http://www.freerad

Re: stay in account list after disconnecting

2008-03-02 Thread Liran Tal
tools that come with FreeRADIUS. On Sun, Mar 2, 2008 at 2:00 PM, Zahra Bahar <[EMAIL PROTECTED]> wrote: > Hi, > > some users stay in freeradius online users list after disconnecting. > Is there any idea about the problem? > Regards, Liran Tal. - List info/subscribe/

Re: freeradius web administration

2008-02-28 Thread Liran Tal
> i'm using freeradius server like proxy, and i want to administrate it with > web mode. > please can you give applications or how i can implement the web mode > option on my freeradius server. > thanks for all. > Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Consuming card code

2008-02-28 Thread Liran Tal
st and special .net app on every user machine > to control everything. Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Radius MAC filtering with EAP-PEAP

2008-02-27 Thread Liran Tal
s will send a Calling-Station-Id attribute reply to the NAS in return, which is not what you wanted... I hope this makes more sense. Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: 'Idle-Timeout' and the 'Acct-Session-Time' argument

2008-02-24 Thread Liran Tal
atically every 30 seconds, maybe some windows update software is running in the background, maybe some DNS records are resolving, maybe you have an IM software in the background doing it's stuff... Get my point? Regards, Liran Tal. On Sun, Feb 24, 2008 at 11:31 AM, GNULinuxSlackware < [E

Re: 'Idle-Timeout' and the 'Acct-Session-Time' argument

2008-02-23 Thread Liran Tal
Hey Pierre, Chillispot will disconnect the user but the problem you're facing is that it isn't actually idle (can happen because of many reasons that you didn't take in consideration). So instead of idle-timeout use the session-timeout attribute and give it a try. Regards, Lir

Re: Wifi and Client-Side authentication

2008-02-17 Thread Liran Tal
- no encryption on the wireless. used web-based login > which may (if you want) talk PAP to FreeRadius e.g. ChilliSpot > > WPA/WPA2 - gives wireless encryption, REQUIRES 802.1x supplicant > software on the clients (e.g. wpa_supplicant, xsupplicant, windows > XP/Vists or M

Re: How to connect to mySql

2008-02-04 Thread Liran Tal
Hey Johnson, The wiki is a great resource of information. Have fun - http://wiki.freeradius.org/SQL_HOWTO Regards, Liran Tal. On Feb 4, 2008 9:32 AM, johnson elangbam <[EMAIL PROTECTED]> wrote: > hi, > I am a new user in free radius server, i wanted to keep the > username/pa

Re: Monitoring Tool for Freeradius

2008-02-03 Thread Liran Tal
ing else that you had on your mind I'd be very happy to work on it. Don't hesitate to email me. Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: cannot connect to sql databse

2008-01-30 Thread Liran Tal
on your distribution which is configured with apache. Please let's continue this discussion in a new thread, the daloradius mailing list or the on the irc channel #daloradius on freenode. Regards, Liran Tal. > > > On 28/01/2008, liran tal <[EMAIL PROTECTED]> wrote: >

Re: cannot connect to sql databse

2008-01-30 Thread Liran Tal
ius is an appropriate alternative for you I will be happy to assist you with it. Regards, Liran Tal. > > On 29/01/2008, liran tal <[EMAIL PROTECTED]> wrote: > > > > Hey Devinder, > > > > On Jan 29, 2008 9:50 AM, Devinder Singh <[EMAIL PROTECTED]> wrote:

Re: cannot connect to sql databse

2008-01-29 Thread liran tal
ql -u freeradius -pmysuperpassword radius - do you have the necessary php mysql package installed? (php4-mysql or php5-mysql) Regards, Liran Tal. > > > On 29/01/2008, Liran Tal <[EMAIL PROTECTED]> wrote: > > > > Hey Devinder, > > > > On Jan 29, 2

Re: cannot connect to sql databse

2008-01-29 Thread Liran Tal
guration file (on debian it's found at /etc/mysql/my.cnf). What is the exact error message you receive in the web page? "Dial Up admin page i get cannot connect to sql databse" is too ambiguous. Copy and paste it here. Regards, Liran Tal. > > > On 29/01/2008, lira

Re: Logging from another PC

2008-01-29 Thread Liran Tal
27;t want to put Idle-Timeout attribute. > > Explain better please. Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: cannot connect to sql databse

2008-01-29 Thread liran tal
ysql logging and see if there's even a connection attempt and if there is you can track what query is going wrong. You haven't detailed what is the exact error, it could just as well be that everything is configured fine but you haven't installed any php-mysql package and you have error_

Re: Administering with MySQL DB

2008-01-28 Thread liran tal
#x27;s SVN and by definition I try new stuff on it but I also commit fixes straight away so you really enjoy the latest. I hope to hear from you again, Regards, Liran Tal. > liran tal wrote: > > Hey Dashmir, > > > > On Jan 28, 2008 1:28 PM, Dashamir Hoxha <[EMAIL PROTE

Re: Administering with MySQL DB

2008-01-28 Thread liran tal
which is almost always the recent version of svn so you can see new features: http://daloradius.xdsl.by User: administrator Pass: radius Regards, Liran Tal. > > http://cakeforge.org/projects/hotcakes/ > http://sourceforge.net/projects/phpmyprepaid/ > http://sourceforge.net/projec

Re: Administering with MySQL DB

2008-01-28 Thread liran tal
Glad to hear that Andy. I'll be happy to assist you with whatever daloradius questions you have, including feature requests and bug fixes :) Regards, Liran Tal. On Jan 20, 2008 8:15 PM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi All, > > thanks for the assistance from

Re: cannot connect to sql databse

2008-01-28 Thread Liran Tal
essage that you get? It is also very useful to turn on mysql logging to see if there's even a connection attempt and if there is, what is causing the error. Regards, Liran Tal. > > On 28/01/2008, liran tal <[EMAIL PROTECTED]> wrote: > > > > > Hey Devinder,

Re: cannot connect to sql databse

2008-01-27 Thread liran tal
Hey Devinder, On Jan 28, 2008 4:35 AM, Devinder Singh <[EMAIL PROTECTED]> wrote: > > Hi > > I am using Dial Up Admin on Free radius > > > Free Radius is Running but when i acccess Dial Up admin page i get cannot > connect to sql databse > > I have done most of the configuration settings and follo

Re: NAS list update without restarting radius server.

2008-01-23 Thread liran tal
Hey Alan, On Jan 23, 2008 9:47 AM, Alan DeKok <[EMAIL PROTECTED]> wrote: > liran tal wrote: > > Maybe freeradius can read the nas list from sql at startup to some > > linked list and this list will be updated every given interval with a > query > > to the databa

Re: NAS list update without restarting radius server.

2008-01-23 Thread liran tal
Exactly my point Alan :) Regards, Liran Tal. On Jan 23, 2008 2:04 PM, Alan DeKok <[EMAIL PROTECTED]> wrote: > Pawel Cieplinski wrote: > > I wont be adding NASes, but users will do, so i am thinking 0-10 a day. > > > > Linking to a dynamic list using interal its n

Re: NAS list update without restarting radius server.

2008-01-23 Thread liran tal
to wait at least a couple of hours if not the full 72 hours for the dns records to update on servers/routers across the globe. Regards, Liran Tal. On Jan 23, 2008 12:08 PM, Pawel Cieplinski <[EMAIL PROTECTED]> wrote: > I wont be adding NASes, but users will do, so i am thinking 0-10 a da

Re: NAS list update without restarting radius server.

2008-01-22 Thread liran tal
Maybe freeradius can read the nas list from sql at startup to some linked list and this list will be updated every given interval with a query to the database. Sounds reasonable. Regards, Liran Tal. On Jan 23, 2008 12:51 AM, Marinko Tarlac <[EMAIL PROTECTED]> wrote: > Cron can hel

Re: Administering with MySQL DB

2008-01-19 Thread liran tal
al reasons. Everyone else are ofcourse welcome to look around. Please be kind and share some feedback :-) Regards, Liran Tal. On Jan 18, 2008 8:18 PM, Andy Smith <[EMAIL PROTECTED]> wrote: > Hi, > > thanks, Ive looked at this and its a good guide to initial install but >

Re: how can I change freeradius logs in other format?

2008-01-17 Thread liran tal
you mean table format? If you'd like a better way to manage it you can setup accounting to work with an sql database server and have all accounting records populated in a database table (radacct). You can later analyze it or do whatever you'd like with it. Regards, Liran Tal. - List

Re: Freeradius is unable to connect to Oracle Server through an Oracle client

2008-01-15 Thread liran tal
remote DB info > in oraclesql.conf and sql.conf freeradius server is unable to connect to > remote DB. There is some error that pops up on console - reads like : Could > not resolve TNS name Plz help How about showing us the debug output? Regards, Liran Tal. - List info/subscri

Re: Failed MAKE on SLES10

2008-01-15 Thread liran tal
hy more people don't bother > using them... > You're right. Maybe the download page on freeradius.org should also include some info about additional sources of packages for the various distributions? Regards, Liran Tal. > > On Tue 15 Jan 2008, David W Bell wrote: > > T

Re: Failed MAKE on SLES10

2008-01-15 Thread liran tal
Hey David, How about trying a more recent FreeRADIUS version? If not, check that your libgdbm library is installed properly. Regards, Liran Tal. On Jan 15, 2008 3:39 PM, David W Bell <[EMAIL PROTECTED]> wrote: > Anyone else seen this, and if so is there an easy fix, or do I need to

Re: radgroupreply do not read (read_grous directive)

2008-01-15 Thread liran tal
Ivan, While you're at it, can you check up on my forth-coming paperwork grade for Statistics B class? :-) Regards, Liran. 2008/1/15 <[EMAIL PROTECTED]>: > OK, can we see database entries for a user (and group he belongs to) and > the debug of the access request? Or should I get my crystal bal

Re: help help help

2008-01-14 Thread liran tal
he network and how it operates. Basically, you should also consider adding a NAS to your network configuration so that you can actually do some authentication and possibly accounting. Otherwise you can just use the radclient as a proof-of-concept show-case. Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Problem with accounting

2008-01-14 Thread liran tal
ur, you might be overlooking something. It would also be wise to turn on mysql logging and monitor the queries running (if at all) as they might be badly processed. Regards, Liran Tal. - List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html

Re: Radius Load-Balancing concept

2008-01-03 Thread liran tal
Hey Sebastian, I think that you are making a rather not too complicated task very complicated with your view of the clustered solution. First you should decide what you want to load balance, the freeradius servers, the database servers or both? I also don't understand the need for some NASes con

Re: Radius Load-Balancing concept

2008-01-03 Thread liran tal
Hey Duane, On Jan 3, 2008 4:31 PM, Duane Cox <[EMAIL PROTECTED]> wrote: > I'm doing this with no problem. > > I have 2 freeradius servers both writing/reading the same dbms > In a case where the entire transaction goes through one server it's ok, but if it gets split up through the two of them,

Re: Problem with pptp and freeradius

2008-01-03 Thread liran tal
Hey Danny, It would probably be more useful if you attach also your freeradius configuration and the debug log of freeradius when ran with -X argument for debugging. Also consider checking that rc_avpair attribute. Regards, Liran. On Jan 3, 2008 1:59 PM, Danny Milshtein <[EMAIL PROTECTED]> wr

Re: query

2008-01-03 Thread liran tal
Hey Mark, On Jan 3, 2008 1:01 PM, Mark J Elkins <[EMAIL PROTECTED]> wrote: > liran tal wrote: > > Hey Mark, > > > > On Jan 3, 2008 11:57 AM, Mark J Elkins <[EMAIL PROTECTED] > > <mailto:[EMAIL PROTECTED]>> wrote: > > > > Radius m

Re: Radius Load-Balancing concept

2008-01-03 Thread liran tal
; thanks for your quick answer. > > On Thu, January 3, 2008 11:39, liran tal wrote: > > First you should decide what you want to load balance, the freeradius > > servers, > > the database servers or both? > > I'd like to load balance both. Or isn't their

  1   2   >