Problem with Login option

[tuanna.1984@yahoo.com]

Authorcation Server --> Login Option : User and Password.

I want to a free user for all(public password this user). This user is public and all people use it to connect to firstspot. Proplem One User have mutil login in mutil client at the same time.
And beside a free user , other user is private and if you known password of private user you con connect to FirstSpot from any clients.But these users pay fee .

Help me ! How to solve this problem with FirstSpot ?

Thanks.(Sorry because I am not good at English)

[alan]

Not sure I understand your requirements accurately.

If you know the "free user" client MAC in advance, you can simply add their MAC addresses as Passive Login users (under Configuration Manager -> Users). For other users, they can just login and pay as usual.
_________________
~ Patronsoft Limited ~

[tuanna.1984@yahoo.com]

Hi alan !

Why does a user alow only one login ?

I want a free user(as anonymous) --> you can join FristSpot from any client with free user and password.

Example : Plan 1 : Free connect to FirstSpot
Plan 2 : 2$ connect to FirstSpot

User : user1 in Plan 1 ,public for all people. You can login every client s(as anonymous)
use2 in Plan 2 may be you can login every clients(as anonymous) or have one login (as user and password mode)

Do you undestand my problem ?How to solve this problem with FirstSpot?
I think I want to use all anonymous mode and user and password mode.

[alan]

Currently, username/password and anonymous option cannot coexist.

I suggest you experiment with the new v7 feature "Free Access". Please refer to http://patronsoft.com/firstspot/v7beta.html for more details (you can also download a trial there).
_________________
~ Patronsoft Limited ~

[tuanna.1984@yahoo.com]

Thanks alan,I will try it.
But if you have document guide FirstSpot v7, you can send it to me ?
My mail : tuanna.1984@yahoo.com

[alan]

The 2 documentation files firstspot_guide.pdf and readem.rtf are within the v7 trial zip file.
_________________
~ Patronsoft Limited ~

[tuanna.1984@yahoo.com]

Hey alan.
I think why firstspot support a user alow multil login ? Can You repare code for me trial ?
I think only disble some code check exist user!

[alan]

FirstSpot username/password or scratch code allows one simultaneous login only.

For multiple logins, you need to use Anonymous Option with Shared Secret.
_________________
~ Patronsoft Limited ~

[tuanna.1984@yahoo.com]

Hi alan,
If use Anonymous Option with Shared Secret,User is disible and some functions is disible too. Firstspot alway free,no people pay fee . Don't solve my business.

And credit card , I am in vietnam I don't know papal.com .You can explain ???

[alan]

If you need to use FirstSpot credit card (shopping cart) interface, you need to use username/password mode.

Regarding payment gateway, can you use other gateway like Google Checkout?
_________________
~ Patronsoft Limited ~

[tuanna.1984@yahoo.com]

hi alan.
I creat a new database, but start FS not successful.
I don't find fsRadius table struct. You can give me struct table fsRadius

Thanks

[tuanna.1984@yahoo.com]

I create database VT1_wifi (SQL server)
I excute script to create table
I think not enough table. You can give a full script.
create table fsusr
(
name varchar(40),
pwd varchar(40),
timeleft integer,
btul integer,
btdl integer,
reserved1 varchar(40),
reserved2 integer,
reserved3 integer,
reserved4 integer,
reserved5 numeric(10),
reserved12 integer,
reserved13 integer,
reserved14 integer,
reserved17 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,
eminutes integer,
auto_del integer,
bwrmethod varchar(10),
bwrperiod integer,
lastrbw integer,
bwrdate integer,
anonymous varchar(1),
MACasUsr varchar(1),
groupname varchar(40),
pagenum integer,
ReqSignUp varchar(1),
acl varchar(1),
signuptime integer,
signupmac varchar(40),
signup01 varchar(40),
signup02 varchar(40),
signup03 varchar(40),
signup04 varchar(40),
signup05 varchar(40),
signup06 varchar(40),
signup07 varchar(40),
signup08 varchar(40),
signup09 varchar(40),
signup10 varchar(40),
roption integer,
rsdate varchar(40),
redate varchar(40),
weeksch integer,
resetopt integer,
macmap integer,
loginmac varchar(40),
ipmap integer,
siteID varchar(40),
iBMsg_glo varchar(40),
iBMsg_per varchar(40),
primary key (name)
);
create table fsusrlog
(
name varchar(40),
logintime varchar(40),
logouttime varchar(40),
duration integer,
ipormac varchar(40),
reserved10 integer,
reserved11 integer,
bwusage numeric,
bwusageUL numeric,
bwusageSha numeric,
siteID varchar(40)
);
create table fsplans
(
pname varchar(40),
timeleft integer,
btul integer,
btdl integer,
bwquota numeric,
bwcount integer,
bwquotaUL numeric,
bwcountUL integer,
bwquotaSha numeric,
bwcountSha integer,
status integer,
startmod integer,
edate varchar(40),
sdate varchar(40),
logins integer,
eminutes integer,
auto_del integer,
bwrmethod varchar(10),
bwrperiod integer,
bwrdate integer,
ReqSignUp varchar(1),
pagenum integer,
acl varchar(1),
roption integer,
rsdate varchar(40),
redate varchar(40),
weeksch integer,
resetopt integer,
macmap integer,
ipmap integer,
primary key (pname)
);
create table ppal
(
invoice numeric,
username varchar(127),
item_name varchar(127),
amount varchar(127),
planname varchar(254),
quantity varchar(127),
order_date numeric,
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),
txn_type varchar(127),
subscrdate varchar(127),
subscr_id varchar(127),
method varchar(50),
timeleft integer,
btul integer,
btdl integer,
bwquota numeric,
bwcount integer,
bwquotaUL numeric,
bwcountUL integer,
bwquotaSha numeric,
bwcountSha integer,
sdate varchar(40),
edate varchar(40),
logins integer,
eminutes integer,
status integer,
startmod integer,
auto_del integer,
bwrmethod varchar(10),
bwrperiod integer,
lastrbw integer,
bwrdate integer,
pagenum integer,
primary key (invoice)
);
create table aExLog
(
aExMAC varchar(40),
SignUpTime varchar(40),
aEx01 varchar(40),
aEx02 varchar(40),
aEx03 varchar(40),
aEx04 varchar(40),
aEx05 varchar(40),
aEx06 varchar(40),
aEx07 varchar(40),
aEx08 varchar(40),
aEx09 varchar(40),
aEx10 varchar(40)
);
create table fssecret
(
groupname varchar(40),
secret varchar(40),
btul integer,
btdl integer,
bwcount integer,
accumbw numeric(20),
bwquota numeric(20),
reserved15 numeric(20),
bwcountUL integer,
accumbwUL numeric(20),
bwquotaUL numeric(20),
reserved16 numeric(20),
bwcountSha integer,
accumbwSha numeric(20),
bwquotaSha numeric(20),
reserved18 numeric(20),
bwrmethod varchar(10),
bwrperiod integer,
lastrbw integer,
bwrdate integer,
sdate varchar(40),
primary key (groupname),
CONSTRAINT SecretUniqueKey UNIQUE (secret)
);
create table printlog
(
refid varchar(20),
username varchar(127),
logtime varchar(30),
page numeric,
stat varchar(20),
price numeric,
jobtype varchar(20),
cover varchar(10),
size varchar(20),
format varchar(50),
port varchar(50),
destid varchar(80),
sysid varchar(20),
intid varchar(20),
primary key (refid)
);
create table tmpurl
(
name varchar(40),
url varchar(254),
reserved1 integer,
destip varchar(15),
destport integer
);
create table ibmsg
(
ibmsgID integer,
ibmsgType integer,
ibmsgTime integer,
conRefID integer,
name varchar(40),
reserved1 varchar(40),
siteID varchar(40),
CONSTRAINT IBMsgKey UNIQUE (ibmsgID, ibmsgType, ibmsgTime)
);
insert into fsusr (name, pwd, timeleft) values ('alice', 'a03af780c0f2959f26512a2cc8c2efb6',
100);
insert into fsusr (name, pwd, btul, btdl, bwquota, bwcount, bwquotaul, bwcountul,
bwrmethod, bwrperiod, bwrdate) values ('bruce', 'a03af780c0f2959f26512a2cc8c2efb6', 50,
100, 51200, 2, 51200, 2, 'month', 1, 1);
insert into fsusr (name, pwd, btul, btdl, bwcount, bwcountul, bwquotasha, bwcountsha,
eminutes, bwrmethod, bwrperiod, bwrdate) values ('cat',
'a03af780c0f2959f26512a2cc8c2efb6', 0, 0, 0, 0, 102400, 2, 1440, 'month', 1, 1);
insert into fsusr (name, pwd, bwcount, bwcountul, bwrmethod, bwrperiod, bwrdate) values
('sample', 'a03af780c0f2959f26512a2cc8c2efb6', 1, 1, 'month', 1, 1);
insert into fsplans (pname, timeleft, bwquota, bwcount, bwquotaul, bwcountul, status,
startmod) values ('Plan A', 1440, 51200, 2, 51200, 2, 0, 1);
insert into fsplans (pname, bwquotasha, bwcountsha, status, startmod, eminutes) values
('Plan B', 102400, 2, 0, 1, 1440);
insert into fsplans (pname, timeleft, status, startmod) values ('Shopping Cart Plan 1', 100, 0,
1);
insert into fsplans (pname, bwquotasha, bwcountsha, status, startmod) values ('Shopping
Cart Plan 2', 102400, 2, 0, 1);

[tuanna.1984@yahoo.com]

Add warning

Warning: odbc_fetch_row(): supplied argument is not a valid ODBC result resource in C:\Program Files\FirstSpot\cfgmgr\c_Auth.php on line 579

[alan]

You don't need the create table statement for table fsRadius. It will always use the local one.

Please double-check your create table process. Also, make sure the security and connection between FirstSpot and your SQL database is okay (check the DSN file).
_________________
~ Patronsoft Limited ~

[tuanna.1984@yahoo.com]

Hi alan !
You can give me your email. I have some problem.

In Scenario 3 (Centralized Network Topology).

Laptop <--> ADSL device <--> Switch <--> Router <--> FirstSpot, Database .

In my company want to use 3G.

ADSL device : Example 3G Router ADSL consit of Sim mobile,genarate ADSL .

FirstSpot hava a statis IP : Example 10.0.86.5
Every 3G Router can ping 10.0.86.5 and data tranfer 10.0.86.5.

but firstspot i don't know run

please help me