Issues with Freeside and Radius

Tue May 10 01:42:31 PDT 2005

Good Evening Everyone,

I'm having issues getting freeside to export into freeRadius to create
new users.

I'll give you background on the network I'm running, its currently a
test network designed to work out the quirks of the system

I have 2 servers

Postgresql is used on both

Freeside:10.0.3.7 - This has Freeside, Apache and Perl along with the
other things needed for FS 

Aaa:10.0.3.8 - This has Apahce, FreeRadius etc running and is intended
as a public server - this will have the Selfservice area once I get past
this problem

AAA is just a simple Debian Stable server running apache 1 and
freeradius 1.0.2

Freeside is running the following config

Freeside 1.4.1

HTML::Mason 1.0.4

All Software Is working Fine

Server is Debian "Woody" Stable, Perl is 5.8.4, DB is Postgresql, DBI is
1.46 and DBD is 1.4.1 (Postgresql version)

OK, so I have my export - I'm certain its something to do with this

It exports to AAA Postgres Server with the following datasrc
"dbi:Pg:dbname=freeradius;host=10.0.3.8"

I can create the user and provision the service for them, it reports
back saying its completed but I don't see anything in the SQL db and I
get rejected when trying to login. The following is everything that
happens to the Postgresql DB from when I hit "submit" on the provision
screen to then it comes up with the account view

May 10 20:04:28 localhost postgres[2396]: [2-1] LOG:  connection
received: host=10.0.3.7 port=1045

May 10 20:04:28 localhost postgres[2396]: [3-1] LOG:  connection
authorized: user=freeradius database=freeradius

May 10 20:04:28 localhost postgres[2396]: [4-1] LOG:  statement: SELECT
version(), 'DBD::Pg'

May 10 20:04:28 localhost postgres[2396]: [5-1] LOG:  statement: SELECT
SUM(acctsessiontime)

May 10 20:04:28 localhost postgres[2396]: [5-2] ^I
FROM radacct

May 10 20:04:28 localhost postgres[2396]: [5-3] ^I
WHERE UserName = 'jdow'

May 10 20:04:28 localhost postgres[2396]: [5-4] ^I
AND EXTRACT( EPOCH FROM  AcctStartTime) >= '0'

May 10 20:04:28 localhost postgres[2396]: [5-5] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime ) <  '1115712268'

May 10 20:04:28 localhost postgres[2396]: [5-6] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime ) > 0

May 10 20:04:28 localhost postgres[2396]: [5-7] ^I
AND AcctStopTime IS NOT NULL

May 10 20:04:28 localhost postgres[2396]: [6-1] LOG:  statement: SELECT
SUM( '1115712268' - EXTRACT( EPOCH FROM  AcctStartTime ) )

May 10 20:04:28 localhost postgres[2396]: [6-2] ^I                FROM
radacct

May 10 20:04:28 localhost postgres[2396]: [6-3] ^I                WHERE
UserName = 'jdow'

May 10 20:04:28 localhost postgres[2396]: [6-4] ^I                  AND
EXTRACT( EPOCH FROM  AcctStartTime ) >= '0'

May 10 20:04:28 localhost postgres[2396]: [6-5] ^I                  AND
EXTRACT( EPOCH FROM  AcctStartTime ) <  '1115712268'

May 10 20:04:28 localhost postgres[2396]: [6-6] ^I                  AND
( '1115712268' - EXTRACT( EPOCH FROM  AcctStartTime ) ) < 86400

May 10 20:04:28 localhost postgres[2396]: [6-7] ^I                  AND
(    EXTRACT( EPOCH FROM  AcctStopTime ) = 0

May 10 20:04:28 localhost postgres[2396]: [6-8] ^I
OR AcctStopTime IS NULL )

May 10 20:04:28 localhost postgres[2396]: [7-1] LOG:  statement: SELECT
SUM( EXTRACT( EPOCH FROM  AcctStopTime ) - '0' )

May 10 20:04:28 localhost postgres[2396]: [7-2] ^I
FROM radacct

May 10 20:04:28 localhost postgres[2396]: [7-3] ^I
WHERE UserName = 'jdow'

May 10 20:04:28 localhost postgres[2396]: [7-4] ^I
AND EXTRACT( EPOCH FROM  AcctStartTime ) < '0'

May 10 20:04:28 localhost postgres[2396]: [7-5] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime  ) >= '0'

May 10 20:04:28 localhost postgres[2396]: [7-6] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime  ) <  '1115712268'

May 10 20:04:28 localhost postgres[2396]: [7-7] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime ) > 0

May 10 20:04:28 localhost postgres[2396]: [7-8] ^I
AND AcctStopTime IS NOT NULL

May 10 20:04:28 localhost postgres[2396]: [8-1] LOG:  statement: SELECT
COUNT(*)

May 10 20:04:28 localhost postgres[2396]: [8-2] ^I
FROM radacct

May 10 20:04:28 localhost postgres[2396]: [8-3] ^I
WHERE UserName = 'jdow'

May 10 20:04:28 localhost postgres[2396]: [8-4] ^I
AND EXTRACT( EPOCH FROM  AcctStartTime ) < '0'

May 10 20:04:28 localhost postgres[2396]: [8-5] ^I
AND ( EXTRACT( EPOCH FROM  AcctStopTime ) >= '1115712268'

May 10 20:04:28 localhost postgres[2396]: [8-6] ^I
)

May 10 20:04:28 localhost postgres[2397]: [2-1] LOG:  connection
received: host=10.0.3.7 port=1046

May 10 20:04:28 localhost postgres[2397]: [3-1] LOG:  connection
authorized: user=freeradius database=freeradius

May 10 20:04:28 localhost postgres[2397]: [4-1] LOG:  statement: SELECT
version(), 'DBD::Pg'

May 10 20:04:28 localhost postgres[2397]: [5-1] LOG:  statement: SELECT
SUM(AcctInputOctets)

May 10 20:04:28 localhost postgres[2397]: [5-2] ^I
FROM radacct

May 10 20:04:28 localhost postgres[2397]: [5-3] ^I
WHERE UserName = 'jdow'

May 10 20:04:28 localhost postgres[2397]: [5-4] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime ) >= '0'

May 10 20:04:28 localhost postgres[2397]: [5-5] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime ) <  '1115712270'

May 10 20:04:28 localhost postgres[2397]: [5-6] ^I
AND AcctStopTime IS NOT NULL

May 10 20:04:28 localhost postgres[2398]: [2-1] LOG:  connection
received: host=10.0.3.7 port=1047

May 10 20:04:28 localhost postgres[2398]: [3-1] LOG:  connection
authorized: user=freeradius database=freeradius

May 10 20:04:29 localhost postgres[2398]: [4-1] LOG:  statement: SELECT
version(), 'DBD::Pg'

May 10 20:04:29 localhost postgres[2398]: [5-1] LOG:  statement: SELECT
SUM(AcctOutputOctets)

May 10 20:04:29 localhost postgres[2398]: [5-2] ^I
FROM radacct

May 10 20:04:29 localhost postgres[2398]: [5-3] ^I
WHERE UserName = 'jdow'

May 10 20:04:29 localhost postgres[2398]: [5-4] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime ) >= '0'

May 10 20:04:29 localhost postgres[2398]: [5-5] ^I
AND EXTRACT( EPOCH FROM  AcctStopTime ) <  '1115712270'

May 10 20:04:29 localhost postgres[2398]: [5-6] ^I
AND AcctStopTime IS NOT NULL

>From what I can see Freeside is failing to insert the record yet on the
Account View page it shows me

Top of Form

Job

Args

Date

Status

30

FS::part_export::sqlradius::sqlradius_insert

Tue May 10 20:20:50 2005

New

31

FS::part_export::sqlradius::sqlradius_usergroup_insert

Tue May 10 20:20:50 2005

New

32

FS::part_export::sqlradius::sqlradius_insert

Tue May 10 20:20:51 2005

New

33

FS::part_export::sqlradius::sqlradius_usergroup_insert

Tue May 10 20:20:51 2005

New

34

FS::svc_acct::append_fuzzyfiles

jdow

Tue May 10 20:20:52 2005

New

>From What I can see it should be updating, is anyone able to help me?

Cheers

Tristram

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://420.am/pipermail/freeside-users/attachments/20050510/fab32734/attachment.htm