[freeside] Issues with Freeside and Radius
Shivkumar
shivkumar at outbackwifi.com
Wed May 11 06:32:15 PDT 2005
just one word- RTFM
but this once , type in the command
#tail -f /usr/local/etc/freeside/queuelog.DBI:Pg:dbname=freeside
it should show you queued transactions in realtime
type ctl-c to exit
Regards,
Shivkumar
Tristram J. Cheer said the following:
>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