Hi everyone;

Well, after hours of testing, I've determined this problem to be on the
VPOPMail side.  I am migrating from an AIX platform to Linux.  I exported
the data from the MySQL 3.22.32 on AIX with the command mysqldump -p
vpopmail > vpopmail.dump.  I then installed MySQL 3.22.32 on Linux 2.2.16
(RedHat 7) and imported the database with mysql vpopmail -p <
vpopmail.dump.  I then tar'ed up the /home/vpopmail/domains structure from
the AIX box to the Linux box.  

This all seemed to go just fine.  Now, the problem that I'm having is I
wanted to test authentication.  So, telnet localhost 110, enter the
user%domain and password:

[root@isis /root]# telnet localhost 110
Trying 127.0.0.1...
Connected to loopback.
Escape character is '^]'.
+OK <[EMAIL PROTECTED]>
USER test%test.com
+OK
PASS test
-ERR authorization failed
Connection closed by foreign host.

Now, if I go into the ~vpopmail/bin directory and run vpasswd on
test%test.com and change the password to test2 for example:

[root@isis /root]# cd ~vpopmail/bin
[root@isis bin]# ./vpasswd test%test.com
Please enter password for test%test.com: test2
enter password again: test2

[root@isis bin]# telnet localhost 110
Trying 127.0.0.1...
Connected to loopback.
Escape character is '^]'.
+OK <[EMAIL PROTECTED]>
USER test%test.com
+OK
PASS test2
-ERR authorization failed
Connection closed by foreign host.

Now, I have gone into the MySQL console as I did the change of password
and saw that it was indeed changing the password:

mysql> select pw_passwd from test_com where pw_name="test";
+---------------+
| pw_passwd     |
+---------------+
| K5quUNHql83zk |
+---------------+
1 row in set (0.00 sec)

(This was with the test password.  I then change it with the vpasswd
command to test 2)

mysql> select pw_passwd from test_com where pw_name="test";
+---------------+
| pw_passwd     |
+---------------+
| xflmRFjDlKQNQ |
+---------------+
1 row in set (0.00 sec)

So it is updating the password.  And for the real annoyance, if I just add
a new domain (blah.com in this case) I can authenticate just fine.

[root@isis bin]# telnet localhost 110
Trying 127.0.0.1...
Connected to loopback.
Escape character is '^]'.
+OK <[EMAIL PROTECTED]>
USER blah%blah.com
+OK
PASS blah
+OK
LIST
+OK
.

mysql> select pw_passwd from blah_com where pw_name="blah";
+---------------+
| pw_passwd     |
+---------------+
| F7gb4/VIQPuI. |
+---------------+
1 row in set (0.00 sec)

I have no idea why this is happening.  I guess I can delete and re-enter
all of the domains on my server and re-enter every single user, but I'd
prefer not to do that.  Why can I not authenticate on the domains I
imported?

I apologise for the length of this post, but I wanted to make sure I
included all information.

Thanks in advance,

Tren.

=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
- Tren Blackburn - Owner                mailto:[EMAIL PROTECTED]  =
= End of Time Networks                  http://www.theendoftime.net  -
- (403) 269-2122                                                     =
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-

Reply via email to