I have to login TWICE to get to the Internet

Guest

I am running Firstspot on a Windows XP Pro system using ODBC authentication to a SQL database. Whenever a customer tries to logon they get the same login screen again. When they enter the user id and password the second time - they get on. Is there something I am doing to cause this?

timwil · Joined: 12 Aug 2005 Posts: 13

The previous post was from me

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

Have you changed the default datasource (i.e. dbf)? Is it located in the remote site?
_________________
~ Patronsoft Limited ~

timwil · Joined: 12 Aug 2005 Posts: 13

I am using a SQL database (Microsoft SQL Server 2000) and everything works except i have to login in twice to get on the internet

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

So every end-user needs to login twice to get access every single time? Or if one user login once (during one FirstSpot session) and then everything is fine afterwards? If it is the latter case, it might be due to the slow performance of the SQL response. As you login once, the SQL query is cached and everything goes faster.

If you still have difficulties, please mail your debug log firstspot_gw_srv_[timestamp].log under subdirectory FirstSpot\log to firstspot@patronsoft.com for further analysis.
_________________
~ Patronsoft Limited ~

timwil · Joined: 12 Aug 2005 Posts: 13

Every user has to log on twice - i will get the log and mail it to you

jason · Posted: Thu Aug 18, 2005 4:24 am **Post subject:**

Hi Timwil

We received your log file. Thank you

>I have Firstspot running against a Microsoft SQL Server 2000 database and each user has to log on twice before they can access the Internet

It should be a database problem. Some of the SQL statments failed in the log.

Can you post your dsn that is used to connect to Microsoft SQL Server 2000? and make sure that the ODBC connection has correct permission to access to your database.

Did you turn on Scenario2? (under Authentication Tab in Configuration Manager). If so, what is your network topology (you do not have to turn on scenario2 in normal case, refer to http://patronsoft.com/firstspot/topologies.html for more detail)?

Did you try to use our default databse (DBF) that comes with Firstspot?

Jason
_________________
~ Patronsoft Limited ~

timwil · Joined: 12 Aug 2005 Posts: 13

Here is the dsn file

[ODBC]
DRIVER=SQL Server
UID=system
pwd=metsys
DATABASE=wisp
WSID=PROS-GAS
APP=Microsoft Data Access Components
SERVER=192.168.1.10

I will look at Scenerio #2

I tried the original dbf file and i have no problem with signing on - only once does it. I think you are right that it is a SQL problem but I cant figure out exactly what is the problem.

timwil · Joined: 12 Aug 2005 Posts: 13

As far as scenerio two goes I dont think it applies.

My network is bridged and all the access points can see and get back to my firstspot gateway access controller.

They can all see the FirstSpot machine with no problem. I also seem to be getting drop outs at the client side when they are already logged on. I can see where the SQL database problem could be causing this also.

My configuration on the Gateway machine is Pentium 4 3.2GHz with 1 G RAM and a 127G Hard Disk Drive running a completely up to date version of Windows XP Pro

The SQL Server is a dual Xeon 3GHz system with 2G RAM running on a SATA 80G Raptor high speed drive with a completely updated Windows 2000 Advanced Server.

They are connected on a private 100M ethernet hub with very little other traffic.

jason · Posted: Fri Aug 19, 2005 3:03 am **Post subject:**

1) Your dsn file looks ok.

2) so please make sure scenerio 2 is off in this case.

3) Your log showed us there were few clients spamming on your network, either they were infected by spyware/virus or they were using p2p software.

The interesting thing was that not all the SQL statments failed in the log, few of them succeed. Here is my guess:
1) The connection between SQL server and Firstspot lost in the middle of executing
2) UID "System" did not have enough permission to execute some of the SQLs

I suggest you to disconnect all clients on your network first, then use a "clean" client to test your DB again. (only Firstspot, MSSQL server, and test client on the network)

Let me know the result

Jason
_________________
~ Patronsoft Limited ~

timwil · Joined: 12 Aug 2005 Posts: 13

How do I determine if Scenerio 2 is off?

How do I tell if a client is spamming or using p2p?

jason · Posted: Fri Aug 19, 2005 2:03 pm **Post subject:**

1) Scenerio 2 is under the Authentication Server Tab in configuration manger.

2) You might use Ethereal to sniff packets on your network.
_________________
~ Patronsoft Limited ~

timwil · Joined: 12 Aug 2005 Posts: 13

I have checked and Scenerio 2 is not on.

I wanted to know how you could tell that there was spamming/p2p from the log file - but I will try Etherreal

timwil · Joined: 12 Aug 2005 Posts: 13

I am also noticing something else - I have a custom application that runs with no problem over the connection but frequently I get web pages failing often. Note that msn messenger is running also - no problem.

How can I check to determine exactly what is causing SQL to fail? My machines are fast enough.

alan · **Forum facilitator** Joined: 26 Sep 2003 Posts: 4435

What browser and version are you using? Do you have any browser toolbar/add-on (e.g. MSN toolbar, Yahoo Companion, etc...)?

Also, make sure your browser allows session cookies.
_________________
~ Patronsoft Limited ~