Hi,
I'was delegated to this forum after having up and running my dbman. Now it's the point to import my 1000 address records ( no problem ) , but how can I set the 1000 UserID and passwords ? cause there is an encryption, it will not work to build a simple default.pass
And after that, if there is a solution for that, how is it possible to autogenerate the userid/password combination for new address entries which can be send to the user, cause its only the admin who enters new entries.

regards, godie

The best idea I have is to use WordPad or EditPlus to create the 1,000 user accounts in the .pass file. You can use the same encrypted password for all users (to make it easier).

Then you can use the Secure Password Lookup Mod, which will allow users to get a new password.

This mod is located at:

www.jpdeni.com/dbman/mods.html

Regards,

------------------
Eliot Lee
Anthro TECH,L.L.C
www.anthrotech.com
----------------------

Thank you very much, that's an idea, I will think about how to use it,
but it will not hit exactly what I intend to do.
Here are the features the database should have:
- worldwide membership database with about 4000 records, for use in all
national dependances.
- User can only modify not input their dates.(members should be responsible
for their address updates)
- 1 admin, about 15-20 users(national secretaries) with rights to
input/modify and delete records.
- mass mail funktion out of the database ( I have two fields with email
addresses ??? (normal and email to fax))
- Import/Export to Excel/Access ( The Excel Mod will still run very good
with the help of this forum)
- Cause only a few members of our organisation will self register, and get
an account(that's the reality), the user's should have a predefined
id/password. I need that also for verified ballots. Also members who have no
online access shall have the id/password. So they can use their id/password
for a fax or mail ballot.
- for every new record entered, there shall be an autogenerate id/password.
- Ask for id/password (I read there's a mod and will integrate this later,
when all is running ?)

I hope you can now imagine my plans. I readed in the forum that there
exist's an older version of default.pass without encryption. Is it a
possibility to use it for pre defining the id/password combination, cause
it's really a must, that the admin sets this for the start of the database.
He need an easy possibility to do it with the first 1000 records. Later
records will be no problem.

Please don't think we're an commercial organization. All organisation work
(also mine) will be done beside our normal job and without any payment,
cause we're enthusiasts of our racing sport. We're one of the greatest sail
class association in the world. The IDNIYRA
(InternationalDNIceYachtRacingAssociation). Here is my 2nd hobby, the german
website http://www.eissegeln.de
Have a look, when interested.

regards, godie

It may be a solution, to switch off the password encryption. Then you can predefine
the userid/password combination in the *.pass . Cause the database is for a closed membership.
I switched off the encryption as follows:

########## Changes and outcommenting in db.cgi ############
------------------------------------------------------------
line 557 ###NEW switch off encryption "encrypted" placed by "password" #### my $encrypted = crypt($in{'password'}, $salt);
line 558 print PASS "$in{'new_username'}:$in{'password'}:$in{'per_view'}:$in{'per_add'}:$in{'per_del'}:$in{'per_mod'}:$in{'per_admin'}\n";
------------------------------------------
line 610 ###NEW switch off encryption "encrypted" placed by "password" #### $password = crypt($in{'password'}, $salt);
line 611 }
line 612 print PASS "$in{'username'}:$in{'password'}:$in{'per_view'}:$in{'per_add'}:$in{'per_del'}:$in{'per_mod'}:$in{'per_admin'}\n";
------------------------------------------
line 703 ###NEW switch off encryption ####### my $encrypted = crypt($in{'pw'}, $salt);
line 704 my $permissions = join (":", @auth_signup_permissions);
line 705 print PASS "$in{'userid'}:$in{'password'}:$permissions\n"; ###NEW switch off encryption "encrypted" placed by "password" ####
line 706 close PASS;
------------------------------------------


-----------------------------------------------------------------
############# Changes and outcommenting in auth.pl #############
-----------------------------------------------------------------

line 63 ################ if (($in{'userid'} eq $userid) && (crypt($in{'pw'}, $pw) eq $pw)) {
line 64 ################ srand( time() ^ ($$ + ($$ << 15) # Seed Random Number
line 65 if (($in{'userid'} eq $userid) && ($in{'pw'} eq $pw)) #### NEW changed by godie switch off encryption #####
-----------------------------------------
This will work, I hope their will be no interdependencies with other functions.

regards, godie