Multiple logins change code once a day

[odd70]

I want to use multiple logins (all users uses same password), and I want this password to change every day automatically (ex 05:00), so I can display this password on a public monitor.
Is this possible?
_________________
Odd

[alan]

Are you using Multiple Logins username, scratch code, or Anonymous Option Shared Secret?
_________________
~ Patronsoft Limited ~

[odd70]

Thanks for your answer.

We have not started using it yet, but the easiest way is prefered.
As I understand, the Anonymous Option Shared Secret is the easiest option. The administrator will try to avoid much administration. The security is less important.
_________________
Odd

[alan]

Yes, Anonymous Option Shared Secret seems to be suitable for you.

To change the shared secret daily, simply write a script to perform the following and run it daily in Windows Task Scheduler:

1) stop FirstSpot
2) change the field secret in table fssecret using SQL ( see http://patronsoft.com/forum/viewtopic.php?t=1514 )
3) start Firstspot
_________________
~ Patronsoft Limited ~

[odd70]

Thanks!
I'll try that
_________________
Odd

[alan]

More hints:

- To start / stop FirstSpot in command line, please check out readme.rtf -> other issues -> point 5.

- you can use php.exe to run any SQL statement written using PHP.
_________________
~ Patronsoft Limited ~

[odd70]

Hi again.
Is there a written script available to change the SECRET field in the fssecret.dbf database.
I have only one record in the db.

Odd
_________________
Odd

[alan]

The SQL script will be like:

[odd70]

Sorry about the nag, and thanks for the code provided.
Is there any complete example for this available.
We have tried to copy/paste from php-files that we think is relevent for this sql command, but we're struggeling.
_________________
Odd

[alan]

Well, for that part, you probably need to check out the PHP ODBC documentation. E.g. http://www.ibm.com/developerworks/opensource/library/os-php-odbc/index.html
_________________
~ Patronsoft Limited ~