[freeside] Issues with Freeside and Radius

Tue May 10 18:27:36 PDT 2005

hi,
from what i can make out, you are not running freeside-queued 'username'.
this can be amplified if you click on the 'pending jobs' link on sysadmin.
and also type
# ps -fe|grep queued
the log that you've pasted doesn't contain a single 'insert' statement. 
it just shows us the queries that are fired when you click on the 
'Radius Sessions' link.
SELECT SUM(acctsessiontime)

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

The username-password pairs go into the radcheck table; the accounting 
info goes into the radacct table.

Regards,

Shivkumar

Tristram J. Cheer said the following:

> 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
>