| View previous topic :: View next topic |
| Author |
Message |
mcsalud
Joined: 28 Sep 2010
Posts: 28
|
 Posted: Thu Oct 14, 2010 11:52 pm
Post subject: Extract Data of online users status |
|
|
The test was successful and were able to authenticate users up to RODOPI billing system. Is there a way we can extract the data from your STATUS: Users online tab so we can upload it to our separate monitoring system? Regarding the fail over features of FirstSpot, can we do the testing using the trial version we have?
_________________
Marv |
|
| Back to top |
|
 |
alan
Forum facilitator
Joined: 26 Sep 2003
Posts: 4435
|
Posted: Fri Oct 15, 2010 3:11 am
Post subject: |
|
|
1) To query online user status, you can use FirstSpot API call "queryloginduration". Refer to chapter 10 of firstspot_guide.pdf for details.
2) The trial version contains all the features including Load Balancing/Failover. But currently, Load Balancing/Failover does not support RADIUS Authentication Mode.
_________________
~ Patronsoft Limited ~ |
|
| Back to top |
|
|
mcsalud
Joined: 28 Sep 2010
Posts: 28
|
Posted: Fri Oct 15, 2010 4:52 am
Post subject: |
|
|
Is it possible to extract the whole info reflected on the User Online Status (Online Users, MAC, IP, Login Time, Login Duration, Data Download, Data Upload)? The script provided by the queryloginduration only extract the Onliine Users and login Duration.
_________________
Marv |
|
| Back to top |
|
|
alan
Forum facilitator
Joined: 26 Sep 2003
Posts: 4435
|
Posted: Fri Oct 15, 2010 8:00 am
Post subject: |
|
|
Some of the data are actually in the ODBC table fsusr directly. They are:
1) reserved1 is not null : online
2) reserved2 is the login time (use PHP function data to decode)
3) login duration : current time - login time
_________________
~ Patronsoft Limited ~ |
|
| Back to top |
|
|
mcsalud
Joined: 28 Sep 2010
Posts: 28
|
Posted: Fri Oct 15, 2010 8:07 am
Post subject: |
|
|
How about the (Online Users, MAC,IP,DataDownload and Data Upload)?
_________________
Marv |
|
| Back to top |
|
|
alan
Forum facilitator
Joined: 26 Sep 2003
Posts: 4435
|
Posted: Fri Oct 15, 2010 8:45 am
Post subject: |
|
|
For online user, if the reserved1 is not null. It means that it is online. The value in reserved1 is client MAC address (assuming MAC-based Session Handling, you need to use our PHP function make_mac_name found in common_functions.php to convert).
For data download/upload, you can use the below sample PHP code:
| Code: | $myobj = new COM('FSAUTH.Authserv') or die('info.php FSAUTH.Authserv object cannot be created!');
$bwUseAll=$myobj->QueryBW($reserved1);
list($bwUse, $bwUseUL,$bwUseSHA) = split('[,]', $bwUseAll);
// bwUse: data download, bwUseUL: data upload, bwUseSHA: total
$myobj = null |
_________________
~ Patronsoft Limited ~ |
|
| Back to top |
|
|
alan
Forum facilitator
Joined: 26 Sep 2003
Posts: 4435
|
Posted: Fri Oct 22, 2010 11:28 am
Post subject: |
|
|
Any good news on your evaluation?
_________________
~ Patronsoft Limited ~ |
|
| Back to top |
|
|
|
Search
Profile
Log in
Register
