[freeside] Issues with Freeside and Radius

Tristram J. Cheer tristramc at uberpc.co.nz
Wed May 11 01:56:57 PDT 2005


Well I looked in the pending job and saw all the jobs, so I run this

# freeside-queued Tristram

And the went away, trouble is now I don't see any connection attempt to
the DB, I can see the connection when I look into the DB but I cant see
any attempt by this program to access the DB? Any ideas? Any way to get
freeside-queued to output all its going to the screen?


Cheers

-----Original Message-----
From: Shivkumar [mailto:shivkumar at outbackwifi.com] 
Sent: Wednesday, 11 May 2005 1:27 p.m.
To: ivan-freeside at sisd.com
Subject: Re: [freeside] Issues with Freeside and Radius

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
>





More information about the freeside-users mailing list