Database / passwords

[Sam]

Trying to create a more user freindly database form for reception purposes. ODBC connectivity with mySQL database worked great.

Would like to create a largely populated user table with predifined 'dummy' usernames and password that can be printed out and handed to wireless customers.

However, the encryption of the password is roadblock, and I was wondering it there was a way to
1. Get the encrypted password to display the 'friendly' password on the form or webpage
2. create a script that autogenerated a bunch of usernames/passwords using the 'encrypt_pwd.exe' that is bundled with FirstSpot.

Any help... Thanks.

Sam

[contact removed]

[kevin]

Hello Sam!

1. FirstSpot stores the hash (encrypted) values of user passwords in the database (i.e. can't convert back to its 'friendly' form using the hash). If you want to retrieve its 'friendly' form, you'll have to create a new field in the table and store that separately while creating a user.

2. You are correct, you can use the 'encrypt_pwd.exe' to achieve the purpose. It takes the 'friendly' form as the input parameter and gives the hash value as output.

We are in the progress of consolidating some sample scripts that can act as a base for your further customization. Will post them out when ready. Stay tunned.

~ Patronsoft Limited ~

[Sam Cayze]

Thanks for answering my post in such a short time, your reply was very helpful.

What I want to setup is having say, hotel reception, being able to add a user/pass to the database when a new customer checks in and requests wireless access.

However, I do not like the fact that in order to enter a password - reception would have to log into the FirstSpot configuration page to do so. That page has way to many settings exposed that I would hate to have changed accidentaly.

I know the firstspot web page uses some php commands to cipher the password into the database, so there should be a way to create our own php/html page to do the same.

Has anybody been successful at this yet???

I am not to concerned with a webpage being able to display a 'friendly' password, just the ability to change the password.

Thanks,

Sam

[CyberiaWiFi]

I aggree, it would begreat to have a simple, easy to use, customer interface where one could have the employees, cashiers, etc log in and add/edit/view customer accounts without the ability to change any settings within firspot. maybe also let them see a indicator as to whether or not the service was running okay or started. Best yet would be also a button for them to one-click restart it too, or maybe not.
_________________
www.cyberiachicago.com

[Sam Cayze]

I have created a script that will autogenerate TONS of UIDs/Passwords that can be imported into the FirstSpot Database.

This is a great solution if people want to creat PrePaid vouchers or scratch cards.

For Documentation: Go to:

http://www.sbcayze.com/firstspot/passgen.htm

Also, how to:

Create random passwords using the system clock
Create random usernames
Import an Excel or CSV file into the database
Create Mail Merge to print of labels with usernames and passwords on them.

Sam Cayze

[kevin]

Sam, thanks for your contribution!

The scripts and documentations look great!

We'll also post out some php sample scripts soon.

~ Patronsoft Limited ~

[megabijt]

Hi,

For some reason the batch file is not working.
the normal passwords and encrypted passwords don't match.

this is the batch file which is working for me ( on windows XP en server 2003)

*******************
@echo off

rem :: Create temporary helper batch file to
rem :: store hundredths of seconds in variable
echo set random=%%9>>enter.bat
rem :: Store current time in temporary batch file
ver | time | date | find "Current" | find ")" > temp.bat
rem :: Store current time's hundredths of seconds in variable
call temp.bat
rem :: Remove helper files
del temp.bat
del enter.bat
rem :: Display result

set number=%random%

echo %number%

echo %number% >> fpass.txt

call e:\users\encrypt_pwd.exe %number% >>output.txt

echo , >> output.txt

:: Loop

call call.bat
*******************

In the original the var. random is changed each time the command echo %random% is used.

[Sam Cayze]

Sorry about that error.

I must have been a little copy/paste crazy and copied something wrong.

Thanks for the input and I hope my info was useful to you.

Sam