OpenForum RSS: �� Dovecot+MySQL �� CentOS 6.4

�� Dovecot+MySQL �� CentOS 6.4 (demon.molo)

Mon, 25 Mar 2013 14:41:30 GMT

>[�� ]
> | password
>
> |
> +------------------+----------------------------------+
> | postmaster@da.rs | cbbf5567f695d9e8e3c2a8af6ec98ba5 |
> | info@da.rs | 8d07927bf341290b5589321883bc2545 |
> +------------------+----------------------------------+
> 2 rows in set (0.00 sec)
> mysql> SELECT email as user, password FROM view_users WHERE email LIKE 'info';
> Empty set (0.00 sec)

)))
WHERE email LIKE 'info%';
��
WHERE email='info@da.rs';

�� Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

Mon, 25 Mar 2013 12:02:55 GMT

> �� ))

��, �� .

mysql> select * from view_users;
+------------------+----------------------------------+
| email | password |
+------------------+----------------------------------+
| postmaster@da.rs | cbbf5567f695d9e8e3c2a8af6ec98ba5 |
| info@da.rs | 8d07927bf341290b5589321883bc2545 |
+------------------+----------------------------------+
2 rows in set (0.00 sec)

mysql> SELECT email as user, password FROM view_users WHERE email LIKE 'info';
Empty set (0.00 sec)

�� Dovecot+MySQL �� CentOS 6.4 (demon.molo)

Mon, 25 Mar 2013 05:39:33 GMT

>[�� ]
> 1 | postmaster | cbbf5567f695d9e8e3c2a8af6ec98ba5 |
> | 2 |
> 1 | info | 8d07927bf341290b5589321883bc2545
> |
> +----+-----------+------------+----------------------------------+
> 2 rows in set (0.00 sec)
> mysql> SELECT email as user, password FROM view_users WHERE email LIKE 'info';
> Empty set (0.00 sec)
> ��, � �� . �ӣ
> � �� .

;D - �� )))
mysql> select * from virtual_users;
mysql> SELECT email as user, password FROM view_users WHERE email LIKE 'info';

�� ))

�� Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

Sun, 24 Mar 2013 21:38:57 GMT

�� Dovecot+MySQL �� CentOS 6.4 (demon.molo)

Sun, 24 Mar 2013 21:22:27 GMT

>[�� ]
>
> |
> +------------+----------------------------------+
> | info@da.rs | 8d07927bf341290b5589321883bc2545 |
> +------------+----------------------------------+
> 1 row in set (0.00 sec)
> mysql> SELECT home, uid, gid FROM users WHERE username = 'info' AND
> domain = 'da.rs';
> ERROR 1146 (42S02): Table 'mailserver.users' doesn't exist
> �� table 'mailserver.users'?

��, �� . � �� users??
� �� :
mysql> show tables;
+----------------------+
| Tables_in_mailserver |
+----------------------+
| view_aliases |
| view_users |
| virtual_aliases |
| virtual_domains |
| virtual_users |
+----------------------+
5 rows in set (0.00 sec)

�.�. � �� FROM users �� FROM virtual_users, �� WHERE username = 'info' �� WHERE username LIKE 'info%'

�� Dovecot+MySQL �� CentOS 6.4 (demon.molo)

Sun, 24 Mar 2013 21:03:42 GMT

>[�� ]
>
> |
> +------------------+----------------------------------+
> | postmaster@da.rs | cbbf5567f695d9e8e3c2a8af6ec98ba5 |
> | info@da.rs | 8d07927bf341290b5589321883bc2545 |
> +------------------+----------------------------------+
> � �� mysql> SELECT email as user, password FROM view_users WHERE
> email='info';
> Empty set (0.00 sec)
> �� ?

�� WHERE email LIKE 'info%'

�� Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

Sat, 23 Mar 2013 06:55:35 GMT

>>view_users WHERE email='info';
> �� , �� email=info@da.rs ?

��, �� degug_dovecotlog �� 'info' �� 'info@da.rs'

2013-03-23 06:24:59 auth: Debug: Loading modules from directory: /usr/lib/dovecot/modules/auth
2013-03-23 06:24:59 auth: Debug: Module loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
2013-03-23 06:24:59 auth: Debug: auth client connected (pid=1466)
2013-03-23 06:24:59 auth: Debug: client in: AUTH 1 PLAIN service=imap secured session=5W4Hy5DYiwBtXTEY lip=78.47.11.221 rip=109.93.49.24 lport=143 rport=60299
2013-03-23 06:24:59 auth: Debug: client out: CONT 1
2013-03-23 06:25:00 auth: Debug: client in: CONT 1 AGluZm8AS2lMX1MtMTUuaW5mbw==
2013-03-23 06:25:00 auth-worker(1471): Debug: Loading modules from directory: /usr/lib/dovecot/modules/auth
2013-03-23 06:25:00 auth-worker(1471): Debug: Module loaded: /usr/lib/dovecot/modules/auth/libdriver_mysql.so
2013-03-23 06:25:00 auth-worker(1471): Debug: sql(inf

�� Dovecot+MySQL �� CentOS 6.4 (Vladimir)

Sat, 23 Mar 2013 05:51:52 GMT

>view_users WHERE email='info';

�� , �� email=info@da.rs ?

�� Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

Sat, 23 Mar 2013 05:43:30 GMT

OpenForum RSS: �������� � ������������ � Dovecot+MySQL �� CentOS 6.4

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (demon.molo)

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (demon.molo)

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (demon.molo)

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (demon.molo)

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (Vladimir)

�������� � ������������ � Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

OpenForum RSS: �� Dovecot+MySQL �� CentOS 6.4

�� Dovecot+MySQL �� CentOS 6.4 (demon.molo)

�� Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

�� Dovecot+MySQL �� CentOS 6.4 (demon.molo)

�� Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

�� Dovecot+MySQL �� CentOS 6.4 (demon.molo)

�� Dovecot+MySQL �� CentOS 6.4 (demon.molo)

�� Dovecot+MySQL �� CentOS 6.4 (Konstantin124)

�� Dovecot+MySQL �� CentOS 6.4 (Vladimir)

�� Dovecot+MySQL �� CentOS 6.4 (Konstantin124)