View previous topic :: View next topic |
Author |
Message |
fsuser
Joined: 09 Nov 2007 Posts: 3
|
Posted: Fri Nov 09, 2007 10:13 pm Post subject: CFirstSpotSQL::connect: Connecting to Database failed |
|
|
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 |
|
Back to top |
|
|
alan Forum facilitator
Joined: 26 Sep 2003 Posts: 4435
|
Posted: Mon Nov 12, 2007 11:26 am Post subject: |
|
|
So is there a surge of login/logout activities in a particular period? Also, did the client PC refresh the InfoBox often? _________________ ~ Patronsoft Limited ~ |
|
Back to top |
|
|
fsuser
Joined: 09 Nov 2007 Posts: 3
|
Posted: Mon Nov 12, 2007 5:45 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
alan Forum facilitator
Joined: 26 Sep 2003 Posts: 4435
|
Posted: Tue Nov 13, 2007 4:36 am Post subject: |
|
|
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 ~ |
|
Back to top |
|
|
fsuser
Joined: 09 Nov 2007 Posts: 3
|
Posted: Tue Nov 13, 2007 5:34 pm Post subject: |
|
|
We'll try those settings.
Please let us know when a fix is available.
Thank you |
|
Back to top |
|
|
alan Forum facilitator
Joined: 26 Sep 2003 Posts: 4435
|
Posted: Wed Nov 14, 2007 9:54 am Post subject: |
|
|
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 ~ |
|
Back to top |
|
|
alan Forum facilitator
Joined: 26 Sep 2003 Posts: 4435
|
|
Back to top |
|
|
|