Ed Leafe wrote:
> On Jun 14, 2007, at 2:22 PM, Bill Witherspoon wrote:
>
>> When I drop the same user/pass into the connection dialog it doesn't
>> work. That's when I noticed that the password is being hashed in the
>> .cnxml file.
>
> That 'hashing' is actually a pretty weak obscuring technique. It is
> not considered secure, but is simply a placeholder for developers to
> add their own security - preferably something not openly published!
>
> Would you try something to see if we can figure this out? Below is
> code from dbMsSQL.py. The line numbers are the lines from the current
> version of the file; the lines without numbers are the debugging code
> I want you to insert.
>
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
> 24 port = str(connectInfo.Port)
> 25 if not port or port == "None":
> 26 port = 1433
> 27 host = "%s:%s" % (connectInfo.Host, port)
> 28 user = connectInfo.User
> 29 password = connectInfo.revealPW()
> 30 database = connectInfo.Database
> 31
> 32 # hack to make this work. I am sure there is a better way.
> 33 self.database = database
> 34
> print "host:", host
> print "user:", user
> print "password:", password
> print "database:", database
> print "kwargs:", kwargs
> 35 self._connection = pymssql.connect(host=host, user=user,
> password=password,
> 36 database=database, **kwargs)
> 37 return self._connection
> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
>
> Now try running the dialog that isn't working, and post what gets
> printed out. If that's not the correct connection parameters, then we
> can figure out why.
>
The output from the above is:
host: 192.168.51.26:1433
user: plant_user
password: emseal01
database: testing
kwargs: {}
Looks good to me! About all I can add is that the other hand coded
sample returns with records into about 2 seconds. The connection dialog
takes a solid 30-40 seconds before it returns with an error.
Bill.
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/dabo-users/[EMAIL PROTECTED]
