User Activation and Shopping Cart issue

[tristan]

I have been testing your beta version for possible purchase, and have not been able to get any new user accounts to work. When I attempt to login, it says the account has not been activated, even though I have set it to be activated now in the configuration. Is this a limitation of the trial version? If so, what other limitations should I expect to encounter?

[alan]

We are still investigating the issue.

For the time being, make sure when you create a new user account (or Plan), don't select "Conditions to suspend this account: When airtime credit is used up". We suspect that under some specific situation, it will cause the "not activated" problem.

Please give us feedback once you try the above suggestion. Thank you.
_________________
~ Patronsoft Limited ~

[tristan]

I was not using that option at all. I was only selecting Never. I did find out that if I checked none of the boxes it seems to work fine (and it checks the never box later). So it appears this issue occurs with the 'never' checkbox as well. I was able to set it to only expire after one day (and unchecking the never box) and it worked fine.

Is the trial version fully functional? I get errors trying to sign up for an account through Paypal :

These are the minimum fields you have to post to this php file:
-plan: the plan being purchased
Auto-redirection to Paypal is aborted.

If it is not fully functional, what is disabled?


SDM

[alan]

1) Please give us a bit more information on your exact flow of creating the user account. Do you use self sign-up, or you add user using Configuration Manager? What option do you pick? Do you use a Plan when you add the user?

At the moment you encounter the problem, please zip the whole "datasource" subdirectory and send it to firstspot@patronsoft.com for further analysis.

We really want to resolve this issue, so your help is much appreciated.

2) For the PayPal issue, make sure you create a "Shopping Cart Item". Since "Shopping Cart Item" will utilize a Plan, you need to create the corresponding Plan as well.

BTW, the trial version has all the features available with some limitations. See http://www.patronsoft.com/firstspot/editions.html for details.
_________________
~ Patronsoft Limited ~

[tristan]

I used the Add function in the Configuration Manager. No plan, selected just the Never checkbox for expiration. This gave me the account not activated error when I tried to log on. I basically left all the defaults for everything else except the username and password.

I found that clearing the never checkbox basically assigns the condition, so just make sure all the checkboxes are clear if you want never, and that makes it work correctly. It's almost as if it is adding an extra entry into the database, and pushing the rest over one field. If I get a chance to reproduce it, I will send you those files. I was able to get self sign up to work, but had to implement the same thing when creating the plan or the issue came back.

I had created plans, and added items to the shopping cart, but I am getting the error I mentioned before. I would click 'sign up' then select an item (for instance the "Daily" item based on my '1 Day' plan) and hit the button (I can't recall if it says puchase or continue), and it gives that error. I didn't look too deeply into the issue as I thought it may have been disabled. I had not modyfied the cart at that point, but I can take a look and see if the form is returning the plan variable when I get a chance this evening. I have IPN on at Paypal, and am forwarding the proper port from my firewall to the FirstSpot server.

I found what may be a bug last night. While connected and logged in with a laptop, I put the computer into suspend mode without logging off or closing the windows. I allowed the user to get logged off by the system after 10 minutes. When I came back up, as long as I left the Toolbox open (even though it said "Page Not Found") I was able to browse freely, without being logged on, and without using any time on the account.

On another note I'm somewhat befuddled as to why the Standard version wouldn't support Windows 2000 Server, as it is basically the same OS as Professional.

[tristan]

After looking at cart.php, I noticed this line:

<input type=\"radio\" name=\"radiobutton\" value=\"radiobutton\" onClick=\"fnSetValue('".$description[$i]."',".$price[$i].",'".$plan[$i]."','".$recurring_enable[$i]."','".$interval[$i]."','".$interval_unit[$i]."','".$recurring_method[$i]."','".$fixed_number[$i]."') \">


I noticed that the .$price[$i]. field was the only one without single quotes ('). I added those in and now Paypal comes right up. Here is how it reads now:

<input type=\"radio\" name=\"radiobutton\" value=\"radiobutton\" onClick=\"fnSetValue('".$description[$i]."','".$price[$i]."','".$plan[$i]."','".$recurring_enable[$i]."','".$interval[$i]."','".$interval_unit[$i]."','".$recurring_method[$i]."','".$fixed_number[$i]."') \">


SDM

[alan]

one more thing tristan, please post your config.ini in the forum. Thanks.
_________________
~ Patronsoft Limited ~

[Craig Hastings]

I have seen the same sort of thing but only, after adding minutes to a account that has by the minute billing. after adding time to the user from the admin interface. The user gets the message "account not active....contact admin..." This seems to clear it self after a while.

Users who are Online when I add time see there updated time in the info box. However if they log out and log back in they may hit that message. It does seem to clear its self after a peroid of time and the user can log in.

And it does not seem to happen every time. It does not appear to be a file locking problem as restarting the server has no effect.

[tristan]

;
; Description : FirstSpot Setup INF file
;
; Filename : config.ini
;
; Copyright (c) 2002-2004, PatronSoft Limited
;

; Note: use a slash to separate directories and files, those lines starting with
; a semi-colon are considered as comments.
;
; Warning : please don't change this file without supervision of a PatronSoft Engineer
; It is highly recommended that you change the FirstSpot setting in the Web-based Configuration Manager

[version]
version=Trial
versionDesc=3.0.0 (Beta 2)

[MNS]
; number of return paths
num_return_path=0
return_path0=

[DHCP]
leasetime=2880
num_ignored_addr=1
ignore_addr0=10.20.7.2

[Client Pass]
num_mac_addr=0
mac_0=
num_ip_addr=0
ip_0=

;
; Redirect Login Page php file
;
[loginPhp]
Login_enable0=
Login_php_Num0=

;
; Gateway Settings
;
[gateway]

;redirect user to cart.php when login fails
redirect_cart=1

;Client Isolation, NetBIOS over TCP/IP, Default is Disabled
netbios=1

;Scenario 2 (Distributed Network Topology)
scenario2=0

; Post-Startup Batch File Path Name
batch_filePath =

; lan's subnet mask (please change this through Configuration Manager only)
;
subnet_mask =255.255.255.0

; domain name server IP address
;
DNS =0.0.0.0

; domain name server IP address
;
preferred_DNS =0.0.0.0

; domain name server IP address
;
alternate_DNS =0.0.0.0

; username
;
user =xxxxxxx

; password
;
pass =xxxxxxx

;Number of maximum administrator account
max_admin_account = 10

;Administrator username
admin_username0 =
admin_username1 =
admin_username2 =
admin_username3 =
admin_username4 =
admin_username5 =
admin_username6 =
admin_username7 =
admin_username8 =
admin_username9 =

;Administrator password
admin_password0 =
admin_password1 =
admin_password2 =
admin_password3 =
admin_password4 =
admin_password5 =
admin_password6 =
admin_password7 =
admin_password8 =
admin_password9 =

;Administrator parameter
admin_parameter0 =
admin_parameter1 =
admin_parameter2 =
admin_parameter3 =
admin_parameter4 =
admin_parameter5 =
admin_parameter6 =
admin_parameter7 =
admin_parameter8 =
admin_parameter9 =

; network interface card connected to Internet (after modify this, need to restart FirstSpot)
;
publicNIC=Local Area Connection 2

; network interface card connected Hotspots or visitor-based networks (after modify this, need to bind the FirstHop driver
; to this new card and unbind the FirstHop driver from ALL other cards, then reboot Windows)
;
privateNIC=Local Area Connection

; data source for user login
;
Datasource =D:\FirstSpot\datasource\firstspot.dsn

; datasource table for user login
;
Datasource_Tablename =fsusr

; datasource table for user login
Datasource_Plans_Tablename =fsplans

; enable session logging into the datasource log table
session_log =ON

; datasource table for user session logging
;
Datasource_Log_Tablename =fsusrlog

; datasource table for PayPal
;
Datasource_PayPal_Table=ppal

; port used by Gateway Service
;
port =5786

; port used by Authentication Server
;
auth_port =5788

; port used by ssl site
;
ssl_port =5789

; Greeting message displayed in login page
;
greeting_msg =Welcome to our Hotspot!

; Enable to show InfoBox
;
show_infobox =ON

; Login page picture (filename)
;
loginpage_pic_name=paradise.JPG

; authentication server IP address (please change this through Configuration Manager only)
; Note: different from gateway_IP when it is not installed in gateway (not officially supported in this version)
;
auth_IP =10.20.7.1

; login page filename which dispatcher will call
;
loginpage =login_select.php

; login form filename which login_select.php will call
;
loginform =login_form.php

; anonymous login form filename which login_select.php will call
;
a_loginform =alogin_form.php

; authentication form filename which authentication.php will call
;
reauthenticationform =reauth_form.php

; anonymous authentication form filename which authentication.php will call
;
a_reauthenticationform =alogout_form.php

; idle time (minutes) allowed for authenticated users
;
idle_timeout =10

; private network (please change this through Configuration Manager only)
;
private_IP =10.20.7.0

; gateway IP address (please change this through Configuration Manager only)
;
gateway_IP =10.20.7.1

; allow access to config manager from private network?
;
access_from_private =off

; allow access to config manager from public network?
;
access_from_public =off

; license file path
;
licensepath =D:\FirstSpot\

; session handling mode, 0 for MAC-based, 1 for IP-based
session_handling =0

; path for dhcp config
dhcppath =D:\FirstSpot\dhcp\dhcpservice.ini

; dhcp mode, 0 = auto, 1 = static, 2 = disabled
dhcpmode =0

; for static dhcp only, path of the Ip MAC mapping list
static_dhcp_path =D:\FirstSpot\StaticDHCP.txt

; anonymous login
anonymous_login =off

; secret enable
secret_enable=off

; secret code
secret_code=0aed120c6f7090a5b26a4c93df382b21

; anonymous login user table name
Datasource_Anonymous_Tablename =fsa

; anonymous login log table name
Datasource_Anonymous_Log_Tablename =fsalog

; password offloading mode
pwd_offload =off

; password encryption directory path
encrypt_path =D:\FirstSpot\dispatcher\encrypt_pwd.exe

; initial air time in minutes for self signup users
self_sign_up_credit=5

; self signup filtering
self_signup_filter=0

;allow self-signup without an ip/mac, 0=yes, 1=no
self_signup_no_mac=1

; null=no filter, 0 = signup once, >0 after x mins
self_signup_period=0

;use 3 party ssl cert 0=yes 1=no
ssl_cert=1

;secure socket layer for authentication
;443 for enabled SSL, auth_port=ssl_auth_port for disabled ssl
ssl_auth_port=5788

;rewrite engine for http to https redirection
rewrite_engine=off

;NAT
nat=0

;maximum fail attempt allowed
max_attempt=

; Allowed Hosts Settings
;
[allowed hosts]
; allowed hosts keywords file path
;
hosts_keywords_path =D:\FirstSpot\AllowedHostsKeywords.txt

; allowed hosts IPs file path
;
hosts_ips_path =D:\FirstSpot\AllowedHostsIps.txt


; Bandwidth Throttle Settings
[bw_throttle]
; Bandwidth Throttle Mode
bt_mode =0

; Overall Upload Limit (at least 20KB/s recommended)
bt_ul_limit =0

; Overall Download Limit (at least 20KB/s recommended)
bt_dl_limit =0

; low, medium and high definition
bt_low=100
bt_medium=50
bt_high=20
bt_drop_period=2

[bwreset]
bwresetmethod=
bwresetperiod=
lastresetbw=

[creditcard]
payment_method=ppal

[paypal]
; Business id
;
ppal_business=xxxxxxx

; URL for successful transactions
;
ppal_return=http://10.20.7.1:5788/cart.php

; URL for cancelled transactions
;
ppal_cancal_return=http://10.20.7.1:5788/cart.php

; trust "Pending"=="Complete"?
;
ppal_pending_release=no

; the settlement currency
;
ppal_base_currency=USD

; URL for notify
;
ppal_notify_url=http://fixed_ip:5789

; Starting number for invoice
;
ppal_invoice_start=1

[worldpay]
; Installation id
;
wpay_instID=your_installation_ID

; the settlement currency
;
wpay_base_currency=USD

; URL for notify
;
wpay_notify_url=http://fixed_ip:5789

; Test Mode
; 100 : test mode - always successful validation
; 101 : test mode - always failed validation
; 0 : test mode - live mode, not testing
;
wpay_testmode=0

[lang]
lang_pack_file=custom_lang.php
cmlang_pack_file=custom_cmlang.php
last_logout=logout
this_logout=logout
last_info=infobox
this_info=infobox
last_cart=cart
this_cart=cart
key_0=
url_0=
signup01=on
signup02=on
signup03=on
signup04=off
signup05=off
signup06=off
signup07=off
signup08=off
signup09=off
signup10=off

; Setting of cart description
[cart]
max_slot_open=6
description0=
price0=
plan0=
recurring_enable0=
interval0=
interval_unit0=
recurring_method0=
fixed_number0=
description1=
price1=
plan1=
recurring_enable1=
interval1=
interval_unit1=
recurring_method1=
fixed_number1=
description2=1 Day Access
price2=$5.00
plan2=1 Day
recurring_enable2=0
interval2=
interval_unit2=
recurring_method2=
fixed_number2=
description3=
price3=
plan3=
recurring_enable3=
interval3=
interval_unit3=
recurring_method3=
fixed_number3=
description4=1 Hour Access
price4=$1.00
plan4=1 Hour
recurring_enable4=0
interval4=
interval_unit4=
recurring_method4=
fixed_number4=
description5=
price5=
plan5=
recurring_enable5=
interval5=
interval_unit5=
recurring_method5=
fixed_number5=

[radius]
use_radius=false
ServerIP=10.20.7.1
AuthPort=1812
AccPort=1813
Secret=secret
FSVendorID=2004
Datasource=D:\FirstSpot\datasource\radius.dsn
Datasource_Tablename=fsRadius
Acc_Start=true
Acc_Stop=true
;Acc_FSLogin=true
;Acc_FSLogout=true
;Acc_FSWriteLog=true

[radiusAuthentication]
NAS_IDENTIFIER=FirstSpot
;NAS_IP_ADDRESS=the private nic ip, this can be edited.
;CALLING_STATION_ID=client nic mac or ip, depends on the Firstspot setting, this can not be edited.
;CALLED_STATION_ID=firstspot private nic mac, this can not be edited.

[radiusCustomAttribute]
;Vendor spec type for Firstspot
;fixed value can not be changed.
;
;FS_AUTH_TIMELEFT=1
;FS_AUTH_ACCUMBW=2
;FS_AUTH_BWQUOTA=3
;FS_AUTH_BWCOUNT=4
;FS_AUTH_ULLIMIT=5
;FS_AUTH_DLLIMIT=6
;FS_AUTH_LOGINTIME=7
;FS_AUTH_LOGOUTTIME=8
;FS_AUTH_TIMEDIFF=9
;FS_AUTH_BWUSAGE=10

;Account Status Type Attributes, can be changed.
;
;default ACCT_STATUS_FSLOGIN=217
;default ACCT_STATUS_FSLOGOUT=218
;default ACCT_STATUS_FSWRITELOG=219

[misc]
show_cart=yes
enable_chgpwd=1
block_icmp=off
block_udp=on
_debug=1
oem=C:\WINNT\INF\oem3.inf
PublicAdapterIP=192.168.0.14
PublicAdapterIpMask=255.255.255.0
PrivateMAC=00a0c9fbb01a

[hans]

tristan, Craig Hastings:

could you send your zipped datasource folder and log folder to us(firstspot@patronsoft.com) for analysis?

[alan]

Also, we confirm the cart.php problem. Thanks for the report and we will fix it in the v3 final release.
_________________
~ Patronsoft Limited ~

[tristan]

hans:

I have not been able to reproduce the error since the first day of testing. If I run into the activation error again, I will zip that folder up and send it.

[alan]

tristan, I want to further discuss the cart.php problem.

Actually, you should only enter number in the unit price setting within the Shopping Cart tab. We suspect the you enter some special character (e.g. a $ sign) which causes the whole problem. Please confirm whether this is the case.
_________________
~ Patronsoft Limited ~

[tristan]

Yes, when I entered the price on the shopping cart tab, I entered it as such:

$1.00

$5.00

etc.

[alan]

Okay, that explains it.

To fix this shopping cart issue in v3 final release, we will add a validation check to the "Unit price" parameter in the Shopping cart, so that it will only accept number and decimal point (i.e. $ sign is not accepted).

Note that if you want to change the column heading in the shopping cart, you can go to the UI Customization tab

Also note that the cart.php file will remain unchanged.
_________________
~ Patronsoft Limited ~