CFirstSpotSQL::connect: Connecting to Database failed

[fsuser]

We have a pretty much simple Firstspot v.5 (advanced edition) configuration.Radius authentication is being used though.
On our testings it has worked right with a few users but on real scenario with maybe one hundred users at a time it has been logging some errors which keeps firstspot from running so we have to restart the services.This repeats every hour and a half approximately.

These are the errors firstspot is logging:

13:15:48 ** CFirstSpotSQL::connect: Connecting to Database failed [2]try
13:15:51 ** StopFirstSpot: Waiting RRAS Service
13:15:51 ** CFirstSpotSQL::connect: Re-connecting Database [3]try
13:15:51 ** CFirstSpotSQL::connect: Connect to data source failed [3]try
13:15:51 >--- ERROR -- RetCode [-1] Reported------------
13:15:51 Total Number of diagnostic records: 1
13:15:51 SQLSTATE: 08004
13:15:51 Native Error Code: -1036
13:15:51 Message: [Microsoft][ODBC dBase Driver] Too many client tasks.

Any help?

Thanks

[alan]

So is there a surge of login/logout activities in a particular period? Also, did the client PC refresh the InfoBox often?
_________________
~ Patronsoft Limited ~

[fsuser]

Hi Alan.
We presume there's certainly a high ammount of login attempts.Is there any way of fix this? mayble disabling user actions logging at all?
We need to fix this very soon since at the time firstspot has had to be stopped.

Thank you

[alan]

We are still working on the issue. As a workaround, please:

1) Use "Maximum number of concurrent users" to limit for the number of users.

2) turn off URL tracking (if it is on)
_________________
~ Patronsoft Limited ~

[fsuser]

We'll try those settings.
Please let us know when a fix is available.

Thank you

[alan]

Your problem should be due to high login/logout activity at a small timeframe. A more long-term fix are:

1) setup MySQL or MS SQL server either in the FirstSpot machine or remotely (refer to readme.rtf)

2) use the following SQL statement to create the local temp data table:

create table fsRadius
(
name varchar(40),
timeleft integer,
btul integer,
btdl integer,
reserved1 varchar(40),
reserved2 integer,
reserved3 integer,
reserved12 integer,
accumbw numeric,
bwquota numeric,
bwcount integer,
accumbwUL numeric,
bwquotaUL numeric,
bwcountUL integer,
accumbwSha numeric,
bwquotaSha numeric,
bwcountSha integer,
status integer,
attempt integer,
startmod integer,
edate varchar(40),
sdate varchar(40),
logins integer,
days integer,
auto_del integer,
sessionID integer,
pagenum integer,
acl varchar(1),
reserved5 numeric(10),
macmap integer,
loginmac varchar(40),
ipmap integer,
primary key (name)
);

2) create the corresponding File DSN (refer to readme.rtf again if you are using MySQL).

3) set the parameter "File DSN for local temp data (.dsn)" (under Authentication Server -> Authentication Mode -> click RADIUS) to this new File DSN.
_________________
~ Patronsoft Limited ~

[alan]

Refer to http://patronsoft.com/forum/viewtopic.php?p=7355#7355 for a fix to alleviate the situation in v5
_________________
~ Patronsoft Limited ~