Hi
I did a bunch of work on Dialup Admin, and it works with PostgreSQL in CVS,
I have just put up a patch site for the dialup_admin/bin scripts, but
they have not
been approved yet. This is where you can find the patch for the
dialup_admin/bin
scripts against the cvs :
http
Hi All,
does anyone know if Dialup_admin works with
PostgreSQL 7.3.4 ? I'm using RH9b with Freeradius 0.9.3.
Thanks in advance.
Roberto Fichera.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
I hoped these patches would have been applied to CVS by now, but they
haven't.
If anyone is interested in PostgreSQL support for freeradius, please
check out
the site I have setup, and send feedback if you find any problems.
I have verified my patch against the CVS as of 2003 Dec 15
>up on the list.
> >>
> >>The attachment was 70kB, I presume thats why.
> >>
> >>Where should I send this updated source, so it can be tested, and
> >>put into the main source?
> >
> >I 'd rather prefer a patch to the current CVS versi
t on a web page somewhere, or send it to me directly. Though
i don't use postgresql
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 , 1-888-450-6787
There is a fine line between genius and lunacy, fear not, walk the
line with pride. Not all things will end up as you
to the main source?
I 'd rather prefer a patch to the current CVS version rather than the whole
thing. Either put it on a web page somewhere, or send it to me directly. Though
i don't use postgresql
>
> --
> Guy Fraser
> Network Administrator
> The Internet Centre
> 78
Didi Rieder wrote:
--On Friday, November 28, 2003 06:13:30 PM +0200 Peter Nixon
<[EMAIL PROTECTED]> wrote:
In any case I have added your suggested changes to sql.conf in the
mainline cvs. However can you please double check your suggestions and
compare with Arthur's patch for postgres. His patch
Guy Fraser wrote:
Hmm...
The updated version of dialup admin I sent in didn't seem to show
up on the list.
The attachment was 70kB, I presume thats why.
Where should I send this updated source, so it can be tested, and
put into the main source?
Mail it to me directly..
Peter
-
List info/subsc
Hmm...
The updated version of dialup admin I sent in didn't seem to show
up on the list.
The attachment was 70kB, I presume thats why.
Where should I send this updated source, so it can be tested, and
put into the main source?
--
Guy Fraser
Network Administrator
The Internet Centre
780-450-6787 ,
--On Friday, November 28, 2003 06:13:30 PM +0200 Peter Nixon
<[EMAIL PROTECTED]> wrote:
In any case I have added your suggested changes to sql.conf in the
mainline cvs. However can you please double check your suggestions and
compare with Arthur's patch for postgres. His patch does some checks th
Peter Nixon wrote:
Arthur B Olsen wrote:
The Acct-Interim-Interval does not update the acctinputoctets and
acctoutputoctets in postgresql as it does in files.
I dont know if this is the desired behavior, or if this is a mistake.
But to correct/change this, you can change your postgresql.conf
Arthur B Olsen wrote:
The Acct-Interim-Interval does not update the acctinputoctets and acctoutputoctets in
postgresql as it does in files.
I dont know if this is the desired behavior, or if this is a mistake.
But to correct/change this, you can change your postgresql.conf like this
Didi Rieder wrote:
--On Wednesday, November 26, 2003 01:13:48 AM +0200 Peter Nixon
<[EMAIL PROTECTED]> wrote:
Thanks.
I will check this into CVS tomorrow.
I asked this list about this issue some week ago:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg21337.html
http://www.mail-archive.com
(sql): starting 0
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #0
> rlm_sql_postgresql: Couldn't connect socket to PostgreSQL server
> [EMAIL PROTECTED]:radius
> rlm_sql_postgresql: Postgresql error 'could not connect to server:
> Connection refused ?Is the serve
You have to put an entry in postgresql.conf like this :
tcpip_socket = true
I would still suggest reading postgresql documentation.
Deepak Singhal
- Original Message -
From: "David Cadenas" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, November 27
If to enable the postgres TCP socket is to load 'postgresql start' in /etc/init.d,
I've just done it. If not, what is to enable the postgres TCP socket exactly?
Thanks a lot.
David
>
> David Cadenas wrote:
> > Hi! I have a problem when I load the radiusd -X
&g
rlm_sql_postgresql #0
rlm_sql_postgresql: Couldn't connect socket to PostgreSQL server
[EMAIL PROTECTED]:radius
rlm_sql_postgresql: Postgresql error 'could not connect to server:
Connection refused ?Is the server running on host localhost and
accepting ?TCP/IP connections on port 5432? '
rlm_sq
rlm_sql_postgresql: Couldn't connect socket to PostgreSQL server
[EMAIL PROTECTED]:radius
rlm_sql_postgresql: Postgresql error 'could not connect to server:
Connection refused ?Is the server running on host localhost and
accepting ?TCP/IP connections on port 5432? '
rlm_sql (sql): Failed to co
7:20 AM
To: [EMAIL PROTECTED]
Subject: Re: Postgresql Traffic Accounting Update
--On Wednesday, November 26, 2003 01:13:48 AM +0200 Peter Nixon
<[EMAIL PROTECTED]> wrote:
> Thanks.
>
> I will check this into CVS tomorrow.
I asked this list about this issue some week ago:
--On Wednesday, November 26, 2003 01:13:48 AM +0200 Peter Nixon
<[EMAIL PROTECTED]> wrote:
Thanks.
I will check this into CVS tomorrow.
I asked this list about this issue some week ago:
http://www.mail-archive.com/[EMAIL PROTECTED]/msg21337.html
http://www.mail-archive.com/[EMAIL PROTECTED]/msg
-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Peter Nixon
Sent: Tuesday, November 25, 2003 4:14 PM
To: [EMAIL PROTECTED]
Subject: Re: Postgresql Traffic Accounting Update
Arthur B Olsen wrote:
The Acct-Interim-Interval does not update the acctinputoctets and
acctoutputoctets in
SpeedyQuick Networks, Inc
Boise, Id
www.speedyquick.net
208.284.5505
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Peter Nixon
Sent: Tuesday, November 25, 2003 4:14 PM
To: [EMAIL PROTECTED]
Subject: Re: Postgresql Traffic Accounting Update
Arthur B Olsen wrote
Arthur B Olsen wrote:
The Acct-Interim-Interval does not update the acctinputoctets and acctoutputoctets in
postgresql as it does in files.
I dont know if this is the desired behavior, or if this is a mistake.
But to correct/change this, you can change your postgresql.conf like this
The Acct-Interim-Interval does not update the acctinputoctets and acctoutputoctets in
postgresql as it does in files.
I dont know if this is the desired behavior, or if this is a mistake.
But to correct/change this, you can change your postgresql.conf like this:
# accounting_update_query
padmin
definitely working with pg. The only thing is that i will have to make sure
that it works ok with mysql first.
>
> Guy Fraser wrote:
>
> > Hi
> >
> > I have started to look at the dialup_admin for use with postgresql.
> > I am using PostgreSQL 7.3.4, and
OK I almost got it working
When I finish teasing it into shape, I'll post a patch if anyone want's one.
If nobody wants the patch where should I submit the fix.
Guy Fraser wrote:
Hi
I have started to look at the dialup_admin for use with postgresql.
I am using PostgreSQL 7.3.4, and
Hi
I have started to look at the dialup_admin for use with postgresql.
I am using PostgreSQL 7.3.4, and FreeRadius 0.9.2.
The porblem I just discovered is that the PHP is looking for case
sensitive column names when processing returned data.
Example :
while(($row = @da_sql_fetch_array($res
Hi everybody,
I have a problem with the loading of the driver rlm_sql_postgresql.
I have added "sql" to the list in authorize section of the radiusd.conf,
between suffix and files.
When the radiusd -X tries to load the Module SQL appears:
Module: Loaded SQL
sql: driver = "rlm_sql_postgresql"
sq
x27; AND UserName = '00022d284b47' AND NASIPAddress=
> '192.168.1.209' AND AcctStopTime = 0
> rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
> rlm_sql_postgresql: affected rows =
> rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERROR, returning
> SQL_DOWN
>
Nick Taylor <[EMAIL PROTECTED]> wrote:
>
> The SQL server spits out:
>
> ERROR: Bad int8 external representation ""
> ERROR: invalid INET value ''
So edit the SQL statements to print out something when the attribute
doesn't exist:
%{Framed-IP-Address:-0.0.0.0} ...
See 'doc/variables.tx
I am trying to set up mac-based authentication, and accounting using
freeradius and postgresql under linux. I've tried to read the
documentation and search through the list archive before posting, but if
I've missed something pointers to RTFM are always appreciated.
I'm in over
as a test, but late last week I decided to> upgrade to 0.9.1> before modifying dial-admin to work with PostgreSQL. Having run into a> problem> porting 0.9.1 to FreeBSD I no longer have a functional example to show> you.> > Unless you have a specific reason to use PostgreSQL, you ar
Hi
I did have 0.8.1 working as a test, but late last week I decided to
upgrade to 0.9.1
before modifying dial-admin to work with PostgreSQL. Having run into a
problem
porting 0.9.1 to FreeBSD I no longer have a functional example to show you.
Unless you have a specific reason to use PostgreSQL
i did that already.it still wont...do you have working
configs?al about FR and
PGSQL> Make sure the user you have setup to access the database has insert and> update permissions> for the radacct table.> > [EMAIL PROTECTED] wrote:> >>hi list,>>>>good day to
;>>>good day to all...>>>>i have setup my postgresql 7.3.2 and freeradius 0.9.1 on a freebsd 4.8>>machine.>>>>i have successfully setup the postgresql and freeradius to support dial>> up>>services. i tried to test the original configuration of freera
Make sure the user you have setup to access the database has insert and
update permissions
for the radacct table.
[EMAIL PROTECTED] wrote:
hi list,
good day to all...
i have setup my postgresql 7.3.2 and freeradius 0.9.1 on a freebsd 4.8
machine.
i have successfully setup the postgresql and
i know what you want to do :-)
but alan is right. don't set EAP manually. rather do the following:
- let the EAP module in the authorization section. put the sql module in
the authorization section as well.
- create an sql group with Auth-Type := Reject.
- create an sql group with Auth-Type :=
try putting it in radgroupcheck and usergroup should assign a group to
each user.
that's how i use it with mysql
ciao
artur
[EMAIL PROTECTED] wrote:
Hi,
I'm currently configuring a Freeradius 0.9.1 with EAP-TLS support and
Postgresql.
If I put in 'users' file
DEFA
On Sun, Sep 14, 2003 at 02:46:28PM -0400, Alan DeKok wrote:
> [EMAIL PROTECTED] wrote:
>
> You obviously didnt' read any of my earlier messages. I said you
> didn't have to set Auth-Type to EAP. The EAP module will do it for
> you.
ok, it'll do it only if I use EAP in authorize, which
[EMAIL PROTECTED] wrote:
> Do you mean that's impossible to forbids someone to log in
> if he holds a valid certificate ?
No.
> If authorize don't set EAP,
> EAP will not be called in authenticate.
Yes.
> That's exactly what I want, I want sql to authorize and
On Sun, Sep 14, 2003 at 10:28:25AM -0400, Alan DeKok wrote:
> [EMAIL PROTECTED] wrote:
> > > Don't set 'Auth-Type := EAP' *anywhere*. It's automatically set by
> > > the EAP module.
> >
> > I've set it in the radgroupcheck as this :
>
> What part of "Don't set it anywhere" did you not u
[EMAIL PROTECTED] wrote:
> > Don't set 'Auth-Type := EAP' *anywhere*. It's automatically set by
> > the EAP module.
>
> I've set it in the radgroupcheck as this :
What part of "Don't set it anywhere" did you not understand?
> rlm_eap: EAP-Message not found
>
>
On Sat, Sep 13, 2003 at 06:37:03PM -0400, Alan DeKok wrote:
> [EMAIL PROTECTED] wrote:
> > I'm currently configuring a Freeradius 0.9.1 with EAP-TLS support and
> > Postgresql.
>
> That won't work.
>
> > Everything works find, but if someone gets a c
[EMAIL PROTECTED] wrote:
> I'm currently configuring a Freeradius 0.9.1 with EAP-TLS support and
> Postgresql.
That won't work.
> Everything works find, but if someone gets a certificate he can logs in.
That's what EAP-TLS is supposed to do.
> (I don't kno
Hi,
I'm currently configuring a Freeradius 0.9.1 with EAP-TLS support and
Postgresql.
If I put in 'users' file
DEFAULT Auth-Type := EAP
Everything works find, but if someone gets a certificate he can logs in.
I want to permit only user using postgresql. What should I pu
hi list,
good day to all...
i have setup my postgresql 7.3.2 and freeradius 0.9.1 on a freebsd 4.8
machine.
i have successfully setup the postgresql and freeradius to support dial up
services. i tried to test the original configuration of freeradius 0.9.1
using ntradping..i was able to
'2003-09-11
> 00:12:19', '-1', '', '', '', '0', '0', '', '', '', '', '', '', '', '0')
> rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
> rlm_sql_postg
adcc6', 'boggss', '', '10.10.80.23', '', '', '2003-09-11
00:12:19', '-1', '', '', '', '0', '0', '', '', '', '', '', '',
S-IP-Address =
10.10.80.23,Acct-Session-Id = "2836",User-Name = "boggss"'
rlm_acct_unique: Acct-Unique-Session-ID = "3879d6b9c94adcc6".
modcall[accounting]: module "acct_unique" returns ok
radius_xla t: '/usr/local/var/log/radius/radacct/10.10.80
At 10:38 AM 9/10/2003, [EMAIL PROTECTED] wrote:
sorry i made a mistake, i am using the latest snapshot for freeradius. but
still i got errors on accounting. it doesnt insert any on the db when i
try to use accounting start.
What does the debug output say? ( running the server 'radiusd -x -x' )
-C
ow igor chen is on of those i have seen
>>posting some about postgresql and freeradius.
>>
>>i am having problem with postgresql and freeradius on its accounting.
>>there seems to have no entries when i i try radtest using ntradping.
>>
>>i am using postgresql 7.2.3 an
At 09:43 AM 9/10/2003, [EMAIL PROTECTED] wrote:
hello list,
i am just new to this list. i know igor chen is on of those i have seen
posting some about postgresql and freeradius.
i am having problem with postgresql and freeradius on its accounting.
there seems to have no entries when i i try
hello list,
i am just new to this list. i know igor chen is on of those i have seen
posting some about postgresql and freeradius.
i am having problem with postgresql and freeradius on its accounting.
there seems to have no entries when i i try radtest using ntradping.
i am using postgresql
g/postgresql.conf2003-08-12 15:53:02.0 -0600
+++ raddb/postgresql.conf 2003-08-19 14:26:27.0 -0600
@@ -19,11 +19,11 @@
# The following credentials will most likely work on a default install of
Postgresql
# If they do work however, it means that you have a
Hi all,
I use PostgresSQL and I have problem with database:
freeradius dies when user connects to server so I must change
radacct::AcctStart/StopTime : datetime -> TIMESTAMP with time zone
in Dialup_admin::user_finger.php3
SELECT ... WHERE AcctStopTime = '0'
And error report: query-error. AcctSto
On Wed, 6 Aug 2003, Truong Manh Cuong wrote:
> Hi all,
> I use PostgresSQL and I have problem with database:
> freeradius dies when user connects to server so I must change
> radacct::AcctStart/StopTime : datetime -> TIMESTAMP with time zone
>
> in Dialup_admin::user_finger.php3
> SELECT ... WHERE
On Wed August 6 2003 14:21, Truong Manh Cuong wrote:
> Hi all,
> I use PostgresSQL and I have problem with database:
> freeradius dies when user connects to server so I must change
> radacct::AcctStart/StopTime : datetime -> TIMESTAMP with time zone
>
> in Dialup_admin::user_finger.php3
> SELECT ..
On Thu August 7 2003 12:29, Truong Manh Cuong wrote:
> I wonder is there anyone use postgresql for freeradius? there is so many
> thing I have to fix if I want to use postgres.
> But freeradius staffs do not fix it. or may be I do wrong ?
Tell us and we will either fix the problems or e
uot;Peter Nixon" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 07, 2003 4:39
PM
Subject: Re: postgresql -
dialup-admin
> On Thu August 7 2003 12:29, Truong Manh Cuong wrote:> > I
wonder is there anyone use postgresql for freeradius? there is so many
On Thu August 7 2003 12:54, Truong Manh Cuong wrote:
> I try to create table in dialup_admin/sql directory, and it come to fail.
> ERROR: parser: parse error at or near "("
> and dialup_admin will not work with database fields in lower case. because
> of query sentence like this: SELECT UserName,A
I wonder is there anyone use postgresql for freeradius? there is so many
thing I have to fix if I want to use postgres.
But freeradius staffs do not fix it. or may be I do wrong ?
is there any type like this:
CREATE TABLE badusers (
id int(10) DEFAULT '0' NOT NULL auto_increment,
"radius" as db.also i have
created a user "radius" with "radius123" password in my postgresql server
and chenged owner of "radius" db to "radius" user.i walked the same steps
for mysql server and it works fine!!!
> When you start radius with radi
On Mon, Jul 21, 2003 at 01:27:04PM +0900, CW wrote:
> Please exuse my last post I accidentily sent it off before I was done
>
>
>
> I am running redhat 9.0 with postgresql 7.3 and freeradius-0.8.1.
> I use it for authentication for our fiber connections. Everything was
>
> hi all,
> i have installed freeRADIUS-0.8.1 and don't have any problem with auth
when
> using users file, but when i wanna use postgresql, get this message from
> radius -X command:
> rad_recv: Access-Request packet from host 127.0.0.1:32773, id=38,
length=55
>
(B
(B
(BPlease exuse my last post I accidentily
(Bsent it off before I was done
(B
(B
(B
(BI am running redhat 9.0 with postgresql 7.3 and freeradius-0.8.1.I use
(Bit for authentication for our fiber connections. Everything wasworking
(Bwell untill lately. I have noticed that I
I am running redhat 9.0 with postgresql 7.3 and freeradius-0.8.1.
(BI use it for authentication for our fiber connections. Everything was
(Bworking well untill lately. I have noticed that I get an error like the
(Bfollowing in my radius.log and after that it looses the connection with
hi all,
i switched to MySQL and it worked fine.( i did same things for MySQL), but why
when freeRADIUS wants connect to PostgreSQL, it prompts: no connection to
server.
thank you in advance,
bye
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
hi all,
i have installed freeRADIUS-0.8.1 and don't have any problem with auth when
using users file, but when i wanna use postgresql, get this message from
radius -X command:
rad_recv: Access-Request packet from host 127.0.0.1:32773, id=38, length=55
User-Name = "fred&quo
On Wed, 16 Jul 2003 03:54 pm, Bernie, CTA wrote:
> Hi Peter,
>
> We use a modified (well hacked) version of PostgreSQL Replicator
> and have experienced no significant problem.
>
> These were our primary DBMS replication requirements:
>
> 1. We needed a solution to ope
On 16 Jul 2003 at 8:54, Sean wrote:
> On Wed, 16 Jul 2003, Bernie, CTA wrote:
> >
> > We use a modified (well hacked) version of PostgreSQL
> > Replicator and have experienced no significant problem.
>
>
> Just out of curiosity, I am wondering why postgres looked
On Wed, 16 Jul 2003, Bernie, CTA wrote:
>
> We use a modified (well hacked) version of PostgreSQL Replicator
> and have experienced no significant problem.
Just out of curiosity, I am wondering why postgres looked like a better
solution than an ldap based solution. LDAP is suppo
Hi Peter,
We use a modified (well hacked) version of PostgreSQL Replicator
and have experienced no significant problem.
These were our primary DBMS replication requirements:
1. We needed a solution to operate securely within our
distributed data environment > 100 physical locations,
[EMAIL PROTECTED] wrote on 7/10/2003 11:56:53 AM:
>
>
>Hi
>
>I managed to compile freeradius with postgresql but when I start the radius server
>and try to do
accounting
>using NT RadPing then I get the following error message :
>
>rlm_sql_postgresql: Postgr
On Fri, Jul 04, 2003 at 11:38:20AM -0700, Tom Emerson wrote:
> On Thursday 03 July 2003 11:07 am, Kevin Fenzi wrote:
> > I am seeing a problem with a new freeradius 0.8.1 install using
> > postgresql as the backend. [...]
> > Nothing to do. Sleeping u
On Thursday 03 July 2003 11:07 am, Kevin Fenzi wrote:
> I am seeing a problem with a new freeradius 0.8.1 install using
> postgresql as the backend. [...]
> Nothing to do. Sleeping until we see a request.
[...]
[reformatting for readability]
> rlm_sql_postgresql: query:
UP
On Thu, Jul 03, 2003 at 12:07:31PM -0600, Kevin Fenzi wrote:
> This seems like something wrong in the postgresql.conf accounting stop
> sql, but I'm not sure what.
Use '%{Radius-Attribute:-0}' for numeric ones.
Look at postgresql.conf from current CVS.
--
Fduch M. Pravking
-
List info/subscri
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Greetings.
I am seeing a problem with a new freeradius 0.8.1 install using
postgresql as the backend.
Authentication works fine.
Accounting Start records work fine.
Accounting stop records dont.
Here is the radiusd -x -x -x output:
Nothing
BOOK NAME : RADIUS from Johathan
Hassell.
C
ya,Sagar
-Original Message-From: Salvin Kumar
[mailto:[EMAIL PROTECTED]Sent: 02 July 2003
01:22To: [EMAIL PROTECTED]Subject:
accounting with postgresql
Hi,
I have installed freeradius on freebsd and for
testing
records from the detail file into a database using postgresql.
How could that be possible. I would really
appreciate for the help.
cheers
Dmitriy Milashenko <[EMAIL PROTECTED]> wrote:
> There is a small error (if it is an error) in default postgresql.conf. You
> should change your authorize_group_check_query to
...
I've fixed this in the CVS head. Please check that it's OK before
0.9 is released!
Alan DeKok.
-
List info/su
Dear Sirs,
I want to implement PPTP server (either mpd or poptop) with CHAP+MPPE
authentication against freeradius.
I've successfully configured freeradius+postgresql, but I'm lost in the
database, I've no idea how to populate database.
Can anyone provide me some dump for examp
freeradius_user wrote:
> freeradius and postgresql is on the same machine (localhost)
Which still needs a TCP connection. Can you connect to
postgresql using 'psql -h localhost'?
--
Regards,
Daryl Tester, Software Wrangler and Bit Herder, IOCANE Pty. Ltd.
SCO Rep: "L
freeradius and postgresql is on the same machine (localhost)
- Original Message -
From: "Daryl Tester" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, June 21, 2003 4:30 PM
Subject: Re: freeradius and postgresql
freeradius_user wrote:
>
freeradius_user wrote:
> rlm_sql_postgresql: PostgreSQL Query failed Error: no connection to
> the server
> rlm_sql_getvpdata: database query error
Did you enable Postgres for connection via TCP? All the create
commands you gave typically use a local Unix doma
list,
i have a working freeradius 0.8.1 with mysql 4.0 on freebsd 4.8 deployed.
freeradius 0.8.1 with rlm-sql for postgresql 7.3 compiled and installed on
freebsd 4.8 with no problems
radiusd started without any complains
but when i tried to run radtest
rlm_sql_postgresql: PostgreSQL
>
> I have tried making to op field in radgroupreply empty and removing the
> field alltogether but I still get these errors. Is there something I need
> to change in /etc/raddb/postgresql.conf
>
>
> Sincerely,
> craig
There is a small error (if it is an error) in default postgresql.conf. You
s
(B
(B
(BAfter two days of suffering I have the postgresql
(Bserver and freeradius running each with the newest versions possible.
(BThanks to this list and others...
(B
(BI have the system authenticating successfully
(Bthrough postgresql now but I get these errors in /var/log/radius
Hi
i have installed freeradius-0.8 and
postgresql 7.0.2
and i configure my radiusd.conf and
sql.conf in /usr/loca/etc/raddb
when i runn : /usr/local/sbin/radiusd -X it ive some error
such as:
rlm_sql (sql): Attempting to connect
rlm_sql_postgresql #23rlm_sql (sql): Connected new DB handle
c driver instead of
FreeTDS ?
Best regards,
Bangla
- Original Message -
From: "Roman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, April 12, 2002 12:19 PM
Subject: postgresql accounting (bug?)
> Hi!
>I use freeradius 0.5 with postgresql 7.2 on Fr
be fixed there.
I use a CVS client to get the postgresql code, it work correctly now !
Thanks a lot Alan
Frederic Jacquet
Le dim 16/03/2003 à 12:42, Alan DeKok a écrit :
> Frederic JACQUET <[EMAIL PROTECTED]> wrote:
> > Seems that the postgresql.conf is a little bit outdated :
> ...
> > it seems that it lacks ,${groupcheck_table}.Op before FROM
>
> Check the CVS head. It should be fixed there.
When browsing http
Frederic JACQUET <[EMAIL PROTECTED]> wrote:
> Seems that the postgresql.conf is a little bit outdated :
...
> it seems that it lacks ,${groupcheck_table}.Op before FROM
Check the CVS head. It should be fixed there.
> anyway even it adding this attribut I can not make freeradius run
> cleanly.
Hello all,
Seems that the postgresql.conf is a little bit outdated :
in both request
authorize_group_check_query = "SELECT
${groupcheck_table}.id,${groupcheck_table}.GroupName,${groupcheck_table}.Attribute,${groupcheck_table}.Value
FROM ${groupcheck_table},${usergroup_table} WHERE ${us
KOZUKA Masahiro <[EMAIL PROTECTED]> wrote:
> I use freeradius-0.8 with PostgreSQL for authorize, for accounting.
> But in accounting, I often come accross the following error
> --
> Sun Mar 2 00:39:16 2003 : Error: rlm_sql (sql): Couldn't update SQL accountingSTOP
Hi, My name is KOZUKA Masahiro.
I use freeradius-0.8 with PostgreSQL for authorize, for accounting.
But in accounting, I often come accross the following error
--
Sun Mar 2 00:39:16 2003 : Error: rlm_sql (sql): Couldn't update SQL accountingSTOP
record - ERROR: Bad numeric input f
I am having a problem with Freeradius 0.8.1 and also with the cvs build using 99% of
my processor for a while then losing its db connections. If I run it with radiusd -x
it also segfaults within a minute. I compiled from source so I know it is using the
correct postgresql libraries. Can
s( cpu usage 99% ) :
>
> rlm_sql_postgresql: Status: PGRES_FATAL_ERROR
> rlm_sql_postgresql: affected rows =
> rlm_sql_postgresql: Postgresql check_error: PGRES_FATAL_ERRORs, returning
> SQL_DOWN
> rlm_sql (sql): Attempting to connect rlm_sql_postgresql #13
> rlm_sql_postgresql:
I have problem with radius.
Radiusd dead with some errors( cpu usage 99% )
:
rlm_sql_postgresql: Status:
PGRES_FATAL_ERRORrlm_sql_postgresql: affected rows =rlm_sql_postgresql:
Postgresql check_error: PGRES_FATAL_ERRORs, returningSQL_DOWNrlm_sql
(sql): Attempting to connect
"leaobicalho" <[EMAIL PROTECTED]> wrote:
> How Can i use my Dictonary with
> postgresql? What i need put in
> postgresql.conf to dictonary work also
> in database?
You can't.
Alan DeKok.
-
List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html
How Can i use my Dictonary with
postgresql? What i need put in
postgresql.conf to dictonary work also
in database?
thanks
Leao Bicalho
__
E-mail Premium BOL
Antivírus, anti-spam e até 100 MB de espaço. Assine já!
http
1 - 100 of 206 matches
Mail list logo