On 11 Lip, 14:02, W-Mark Kubacki <
wm...@hurrikane.de> wrote:
>
> >i have:
> >Fatal error: Uncaught exception 'ConfigurationErrorException' with
> >message 'Login failed. Check your connection data.' [...]
>
> After a first browse-through the data you provided I cannot tell what
is wrong.
>
> Please try following and post what the results are:
> 1. Is the administrative user in users' table?
> SELECT * FROM user;
Hello,
SELECT * FROM user;
+------------+----------------+------------+------------------------+----------------------------------+---------+--------+------------+------------+-----------+------------+-----------------+--------------+---------+
| mbox | person | pate | canonical |
password | domains | active | created |
last_login | max_alias | max_regexp | a_admin_domains | a_admin_user |
a_super |
+------------+----------------+------------+------------------------+----------------------------------+---------+--------+------------+------------+-----------+------------+-----------------+--------------+---------+
| postmaster | Admin John Doe | postmaster |
postm...@example.com |
559******************************* | all | 1 | 1215696303
| 0 | 10000 | 100 | 2 | 2
| 2 |
| cyrus | cyrus | cyrus | --@
example.com |
559****************************** | none | 1 | 1215696303
| 0 | 0 | 0 | 0 | 0
| 1 |
+------------+
> 2. If, did you chose the right encryption method for passwords?
> (crypt=3 should be MD5 as far as I remember)
I chose:
hashed with <MD5>
> 3. What does $(ldd pam_mysql.so) say? Is it really linked to
openssl*.so*?
> (Could fail if you static-linked pam_mysql.)
yes, it looks like:
ldd pam_mysql.so
linux-gate.so.1 => (0xffffe000)
libmysqlclient.so.15 => /usr/lib/libmysqlclient.so.15 (0xb7d91000)
libcrypto.so.0.9.8 => /usr/lib/i686/cmov/libcrypto.so.0.9.8 (0xb7c57000)
libssl.so.0.9.8 => /usr/lib/i686/cmov/libssl.so.0.9.8 (0xb7c18000)
libcrypt.so.1 => /lib/tls/libcrypt.so.1 (0xb7bea000)
libc.so.6 => /lib/tls/libc.so.6 (0xb7ab8000)
libpthread.so.0 => /lib/tls/libpthread.so.0 (0xb7aa6000)
libnsl.so.1 => /lib/tls/libnsl.so.1 (0xb7a8f000)
libm.so.6 => /lib/tls/libm.so.6 (0xb7a6a000)
libz.so.1 => /usr/lib/libz.so.1 (0xb7a56000)
libdl.so.2 => /lib/tls/libdl.so.2 (0xb7a52000)
/lib/ld-linux.so.2 (0x80000000)
> 4. Try logging in directly by cyradm [1].
cyradm> auth
authenticate: no connection to server
...