SearchSearch   ProfileProfile   Log inLog in   RegisterRegister 

CFirstSpotSQL::connect: Connecting to Database failed

 
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum
View previous topic :: View next topic  
Author Message
fsuser



Joined: 09 Nov 2007
Posts: 3

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: 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

PostPosted: Fri Feb 22, 2008 5:08 am    
Post subject:

Refer to http://patronsoft.com/forum/viewtopic.php?p=7355#7355 for a fix to alleviate the situation in v5
_________________
~ Patronsoft Limited ~
Back to top
Display posts from previous:   
Post new topic   Reply to topic    FirstSpot Forum Index -> Pre-sales Support Forum All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group