fsusr on ms-sql

[osbertv]

Hi,

i've used ms-sql as the datasource for firstspot.
first i've exported the existing dbf files to sql-tables.

i've successfully connected firstspot to mssql and normal user-login works fine. but MAC passive login is not working, its always asking for password.

here is fsusr table structure
CREATE TABLE [fsusr] (
[NAME] [varchar] (40) NOT NULL ,
[PWD] [varchar] (40) NULL ,
[TIMELEFT] [numeric](20, 5) NULL ,
[BTUL] [numeric](20, 5) NULL ,
[BTDL] [numeric](20, 5) NULL ,
[RESERVED1] [varchar] (40) ,
[RESERVED2] [numeric](20, 5) NULL ,
[RESERVED3] [numeric](20, 5) NULL ,
[RESERVED12] [numeric](20, 5) NULL ,
[RESERVED13] [numeric](20, 5) NULL ,
[RESERVED14] [numeric](20, 5) NULL ,
[ACCUMBW] [numeric](20, 5) NULL ,
[BWQUOTA] [numeric](20, 5) NULL ,
[BWCOUNT] [numeric](20, 5) NULL ,
[ACCUMBWUL] [numeric](20, 5) NULL ,
[BWQUOTAUL] [numeric](20, 5) NULL ,
[BWCOUNTUL] [numeric](20, 5) NULL ,
[STATUS] [numeric](20, 5) NULL ,
[ATTEMPT] [numeric](20, 5) NULL ,
[STARTMOD] [numeric](20, 5) NULL ,
[EDATE] [varchar] (40) NULL ,
[SDATE] [varchar] (40) NULL ,
[LOGINS] [numeric](20, 5) NULL ,
[EMINUTES] [numeric](20, 5) NULL ,
[AUTO_DEL] [numeric](20, 5) NULL ,
[BWRMETHOD] [varchar] (10) NULL ,
[BWRPERIOD] [numeric](20, 5) NULL ,
[LASTRBW] [numeric](20, 5) NULL ,
[BWRDATE] [numeric](20, 5) NULL ,
[ANONYMOUS] [char] (1) NULL ,
[MACASUSR] [char] (1) NULL ,
[GROUPNAME] [varchar] (40) NULL ,
[PAGENUM] [numeric](20, 5) NULL ,
[REQSIGNUP] [char] (1) NULL ,
[ACL] [char] (1) NULL ,
[SIGNUPTIME] [numeric](20, 5) NULL ,
[SIGNUPMAC] [varchar] (40) NULL ,
[SIGNUP01] [varchar] (40) NULL ,
[SIGNUP02] [varchar] (40) NULL ,
[SIGNUP03] [varchar] (40) NULL ,
[SIGNUP04] [varchar] (40) NULL ,
[SIGNUP05] [varchar] (40) NULL ,
[SIGNUP06] [varchar] (40) NULL ,
[SIGNUP07] [varchar] (40) NULL ,
[SIGNUP08] [varchar] (40) NULL ,
[SIGNUP09] [varchar] (40) NULL ,
[SIGNUP10] [varchar] (40) NULL ,
CONSTRAINT [PK_fsusr] PRIMARY KEY CLUSTERED
(
[NAME]
) ON [PRIMARY]
) ON [PRIMARY]
GO


here is the sample user data:
NAME 00-0C-6E-6B-5A-AE
PWD NULL
TIMELEFT NULL
BTUL NULL
BTDL NULL
RESERVED1 NULL
RESERVED2 NULL
RESERVED3 NULL
RESERVED12 NULL
RESERVED13 NULL
RESERVED14 NULL
ACCUMBW NULL
BWQUOTA NULL
BWCOUNT 0
ACCUMBWUL NULL
BWQUOTAUL NULL
BWCOUNTUL 0
STATUS 0
ATTEMPT 0
STARTMOD 0
EDATE NULL
SDATE NULL
LOGINS NULL
EMINUTES NULL
AUTO_DEL NULL
BWRMETHOD NULL
BWRPERIOD NULL
LASTRBW NULL
BWRDATE NULL
ANONYMOUS NULL
MACASUSR Y
GROUPNAME NULL
PAGENUM 0
REQSIGNUP NULL
ACL NULL
SIGNUPTIME NULL
SIGNUPMAC NULL
SIGNUP01 NULL
SIGNUP02 NULL
SIGNUP03 NULL
SIGNUP04 NULL
SIGNUP05 NULL
SIGNUP06 NULL
SIGNUP07 NULL
SIGNUP08 NULL
SIGNUP09 NULL
SIGNUP10 NULL


Thank You.
_________________
-osbertv-

[chrisli]

Hi~

At this stage, you need to run the program "QueryPassiveLogin.exe" which located in [FirstSpot Directory]\dispatcher\ after you import the user table with MAC passive login user.

Hope it solves your problem.

We will improve it in the future version.
_________________
~ Patronsoft Limited ~