I upgraded (a new machine) to SQL 7.0 where I am running platypus. I
installed the hotfix from Microsoft's side, and the isql program is working
great as well as php3 scripts, so I know the connectivity is good. However,
my AuthBy Platypus routine locks up when it does the select to check to see
if the user is valid. The strange thing is that with numerous testing, I
found that sometimes it will validate 1 login before it freezes. If I
change my data source back to the 6.5 server it works great. I also tryed
scrapping the AuthBy Platypus, and replacing it with an AuthBy SQL, since
the SQL radiator stuff seems to get updated much more frequently than Plat,
but same result.. heres the auth portion of my config and a trace level 5.
btw, for those that are like me and had a terrible time locating the hotfix
for mssql 7.0 ctlibs, heres how to get it. call microsoft IT support at
800-936-4900. Its a paid support line, but there is NO CHARGE for a hot
fix. just be sure to reference this Q# from Microsoft's support database.
They'll open you a ticket, and a tech will email you the files. The Q# is
Q239883. btw, the error you get is Unexpected EOF, and this hot fix fixes
it.
anyway, here are the config and trace:
<AuthBy SQL>
DBSource dbi:Sybase:PLATSERV
DBUsername platuser
DBAuth mypassword
AuthSelect select password, active from customer where username='%n' and
active='Y'
</AuthBy>
and heres the level 5 trace...
Mon Oct 25 11:00:40 1999: DEBUG: Reading users file /usr/local/etc/users
Mon Oct 25 11:00:40 1999: INFO: Server started
Mon Oct 25 11:00:51 1999: DEBUG: Packet dump:
*** Received from 127.0.0.1 port 4410 ....
Packet length = 72
01 60 00 48 31 32 33 34 35 36 37 38 39 30 31 32
33 34 35 36 01 0a 64 65 72 65 6b 73 61 6e 06 06
00 00 00 02 04 06 cb 3f 9a 01 05 06 00 00 04 d2
3d 06 00 00 00 00 02 12 98 f8 3b cb af 5c 04 f6
bc 38 09 a0 d8 7d 78 99
Code: Access-Request
Identifier: 96
Authentic: 1234567890123456
Attributes:
User-Name = "dereksan"
Service-Type = Framed-User
NAS-IP-Address = 203.63.154.1
NAS-Port = 1234
NAS-Port-Type = Async
User-Password = "<152><248>;<203><175>\<4><246><188>8<9><160><216>}x<153>"
Mon Oct 25 11:00:51 1999: DEBUG: Handling request with Handler
'Realm=DEFAULT'
Mon Oct 25 11:00:51 1999: DEBUG: Deleting session for dereksan,
203.63.154.1, 1234
Mon Oct 25 11:00:51 1999: DEBUG: Handling with Radius::AuthGROUP
Mon Oct 25 11:00:51 1999: DEBUG: Handling with Radius::AuthSQL
Mon Oct 25 11:00:51 1999: DEBUG: Handling with Radius::AuthSQL
Mon Oct 25 11:00:51 1999: DEBUG: Query is: select password, active from
customer where username='dereksan' and active='Y'
and it just hangs there til you kill the process, and of course sends no
reply to the client.
please let me know something asap... if i have to go back to 6.5 i need to
do it before much of today has passed or else ill have to reenter a days
worth of payments, signups, and deacts.. i have it doing an authby file
temporarily until this can be resolved.
thanks
Derek Sanderson
Boone Online, Inc.
===
Archive at http://www.thesite.com.au/~radiator/
To unsubscribe, email '[EMAIL PROTECTED]' with
'unsubscribe radiator' in the body of the message.
