mysql.jorge at decimal
Jan 20, 2009, 8:07 AM
Post #8 of 9
(800 views)
Permalink
|
Ops,
You're right, I mean to say crypt, I was thinking on the "shadow" file.
Sorry for the mistake.
> -----Original Message-----
> From: dbmail-bounces[at]dbmail.org [mailto:dbmail-bounces[at]dbmail.org] On
> Behalf Of Jesse Norell
> Sent: terça-feira, 20 de Janeiro de 2009 15:58
> To: DBMail mailinglist
> Subject: RE: [Dbmail] problem with user importing
>
> Hello,
>
> On Mon, 2009-01-19 at 23:55 -0800, wojtek_z wrote:
> > hi
> > after importing users using script:
> > dbmail-users -a $i -P shadow -m 100M;
> > and making sql update
> > update dbmail_users set encryption_type='shadow';
>
> I've never heard of 'shadow' being a valid encryption_type. We're
> running an old dbmail version, so maybe it is nowadays, but the man
> page
> doesn't mention it either so I'd stay clear of that myself. Stick with
> 'crypt' or 'md5-hash'.
>
> You might also try specifying the password hash yourself, if for some
> reason there's a problem copying it. Something like:
>
> for i in `cut -d: -f1 passwd`
> do
> pw=`grep ^${i}: shadow | cut -d: -f2`
> dbmail-users -v -a "$i" -p md5-hash -w "$pw" -m 100M
> done
>
> I don't remember any similar problems with importing users like that
> offhand, though ... it doesn't explain what the actual issue is with
> using dbmail-users. Maybe you can turn up debugging on it? (I don't
> know how much debugging that utility has.)
>
>
>
> > i still can't autenticate using pop3d.
> > In mysql i have dbmail_users.password - yY and
> > dbmail_users.encryption_type - shadow
> >
> >
> > Jorge Bastos wrote:
> > >
> > > Don't do that.
> > >
> > > dbmail-users -v -a $i -p md5-hash -P shadow -m 100M;
> > >
> > > replace with:
> > >
> > > dbmail-users -a $i -P shadow -m 100M;
> > >
> > > and after the import run:
> > >
> > > update dbmail_users set encryption_type='shadow';
> > >
> > >
> > > in the dbmail-users command, you are missing the alias (the -s
> option)
> > >
> > >
> > >
> > >> -----Original Message-----
> > >> From: dbmail-bounces[at]dbmail.org [mailto:dbmail-bounces[at]dbmail.org]
> On
> > >> Behalf Of wojtek_z
> > >> Sent: segunda-feira, 19 de Janeiro de 2009 22:38
> > >> To: dbmail[at]dbmail.org
> > >> Subject: RE: [Dbmail] problem with user importing
> > >>
> > >>
> > >>
> > >> password from /etc/shadow $1$4YIoXI1y$sSJh3Z7JwEUEl7fUbvHSQ.
> > >> password from dbmail_users.password yY when encryption_type is set
> to
> > >> crypt
> > >> when encryptiony_type is set to md5 passwod's look like $1$\yY
> > >>
> > >> i import users and passwords using script:
> > >>
> > >> for i in `cat passwd | awk -F: '{print $1}'`;
> > >> do
> > >> dbmail-users -v -a $i -p md5-hash -P shadow -m 100M;
> > >> done
> > >>
> > >>
> > >>
> > >>
> > >>
> > >>
> > >> Jorge Bastos wrote:
> > >> >
> > >> > That is strange.
> > >> > How are you transporting the values from the shadow file to the
> > >> database?
> > >> > 3 years ago when I moved to DBMail, I was using system users
> with
> > >> crypt
> > >> > and
> > >> > had no problem.
> > >> >
> > >> > Also, In the dbmail_users table, are setting the encryption_type
> to
> > >> crypt?
> > >> >
> > >> >
> > >> >> -----Original Message-----
> > >> >> From: dbmail-bounces[at]dbmail.org [mailto:dbmail-
> bounces[at]dbmail.org]
> > >> On
> > >> >> Behalf Of wojtek_z
> > >> >> Sent: segunda-feira, 19 de Janeiro de 2009 21:41
> > >> >> To: dbmail[at]dbmail.org
> > >> >> Subject: [Dbmail] problem with user importing
> > >> >>
> > >> >>
> > >> >> Hi,
> > >> >> I have a strange problem. I will migrate to dbmail 2.2.10. When
> i do
> > >> >> test
> > >> >> with import users and passwords password from /etc/shadow in
> format
> > >> >> $xxx$xxxxx$ presents in dbmail db like $1\yY . And after
> migrating i
> > >> >> have
> > >> >> problem with user autentication.
> > >> >> --
> > >> >> View this message in context: http://www.nabble.com/problem-
> with-
> > >> user-
> > >> >> importing-tp21540210p21540210.html
> > >> >> Sent from the dbmail users mailing list archive at Nabble.com.
> > >> >>
> > >> >> _______________________________________________
> > >> >> DBmail mailing list
> > >> >> DBmail[at]dbmail.org
> > >> >> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > >> >
> > >> > _______________________________________________
> > >> > DBmail mailing list
> > >> > DBmail[at]dbmail.org
> > >> > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > >> >
> > >> >
> > >>
> > >> --
> > >> View this message in context: http://www.nabble.com/problem-with-
> user-
> > >> importing-tp21540210p21553188.html
> > >> Sent from the dbmail users mailing list archive at Nabble.com.
> > >>
> > >> _______________________________________________
> > >> DBmail mailing list
> > >> DBmail[at]dbmail.org
> > >> https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > >
> > > _______________________________________________
> > > DBmail mailing list
> > > DBmail[at]dbmail.org
> > > https://mailman.fastxs.nl/mailman/listinfo/dbmail
> > >
> > >
> >
> --
> Jesse Norell
> Kentec Communications, Inc.
> jesse[at]kci.net
> _______________________________________________
> DBmail mailing list
> DBmail[at]dbmail.org
> https://mailman.fastxs.nl/mailman/listinfo/dbmail
_______________________________________________
DBmail mailing list
DBmail[at]dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail
|
