ms-sql problem in 2.1.8

[xnp]

i am testing the 2.18 version and i am encountering the same type of problem with firstspot. i have the firstspot server running on a win 2000 server working with ms sql.

i used a laptop to log in and log out. then when i try to log in again, it won't log into the hotspot. we took a look at the reserved1 and reserved2 data in ms sql and it contains some value. we <null> the both reserved1 and reserved2 and tried to log back in and it works. i am assuming that firstspot is not clearing out the values in reserved1 and reserved2 in ms sql after a user logs out of it.

when i set firstspot to work with the bundled db management system it works fine logging in and logging out at as many times as we want with the laptop.

how can i fix this problem?

[kevin]

ver 2.1.8 has your mentioned problem that was fixed in version 2.1.9:

http://www.patronsoft.com/forum/viewtopic.php?p=412#412

Please download the latest version (currently 2.1.11).
_________________
~ Patronsoft Limited ~

[xnp]

i am still having the same problem and i don't exactly know where to find the offloading option to disable the network adapters. please help. i am using win 2000 server as the OS. thank you.

[kevin]

Have you dropped all FirstSpot tables and re-create them in MS-SQL?
_________________
~ Patronsoft Limited ~

[xnp]

i've recreated the tables that karl ma has sent me via email in ms sql. i have added a few fields of my own.

create table fsusr
(
name VARCHAR(40) primary key,
pwd VARCHAR(40),
timeleft INTEGER,
dob smalldatetime,
gender VARCHAR(8),
zip VARCHAR(40),
device VARCHAR(40),
btul INTEGER,
btdl INTEGER,
reserved1 VARCHAR(40),
reserved2 INTEGER,
reserved3 INTEGER,
reserved12 INTEGER
);
create table fsusrlog
(
name varchar(40),
logintime varchar(40),
logouttime varchar(40),
duration integer,
ipormac varchar(40),
reserved10 integer,
reserved11 integer
);
create table fsa
(
reserved4 varchar(40) primary key,
reserved5 integer,
reserved6 integer
);

create table fsalog
(
ipormac varchar(40),
logintime varchar(40),
logouttime varchar(40),
duration integer,
reserved8 integer,
reserved9 integer
);
create table fsinst
(
ipormac varchar(40), firstspotm varchar(40)
);
create table ppal
(
invoice numeric(20), username varchar(127), item_name varchar(127),
amount varchar(127), minute varchar(254), quantity varchar(127),
order_date numeric(20), curr varchar(127), pay_status varchar(127),
pendreason varchar(127), pay_date varchar(127), txn_id varchar(17),
pay_type varchar(127), first_name varchar(127), last_name varchar(127),
payeremail varchar(127), payer_id varchar(127)
);

i don't know exactly what you mean by drop, but i did change the datasource location of the dsn file in the config manager under authentication server to access the tables in ms sql. if that is what you mean, i have done that.

i can't find anything on offloading for win 2000 server, but i uninstalled firstspot, disabled IPSEC Policy Agent, and reinstalled FS 2.1.11 and i am still having the same probrlems

can you figure out what is wrong?

[kevin]

As a way to isolate the problems, can you tell me if the same problem happens when you're *not* using MS-SQL?
_________________
~ Patronsoft Limited ~

[xnp]

yes, i can log in, log out, and log back in if i'm not using ms sql and just go with FS default datasource dsn

[kevin]

Very good; so the problem seems to be relating to MS-SQL - which further eliminates the need to tweak the checksum offloading setting. Please do not modify your system services as this may affect FirstSpot's normal operation.

We will create a similar environment as yours in our testing lab to see if we can duplicate the problem at our end.

We'll let you know how it goes.
_________________
~ Patronsoft Limited ~

[xnp]

Thank you!

[kevin]

We've done a very extensive test on ver 2.1.11 using MS-SQL as datasource and it works without any problem.

If you still have problems, please let us know.
_________________
~ Patronsoft Limited ~