Well, there's something wrong ..
I've tried to switch on mysql log and I've obtained the same error (error
13, access denied) when I create an archive log and add it to my.cnf . I
also obtain the messages :
/usr/libexec/mysqld: File '/var/log/mysql/mysql-access.log' not found
(Errcode: 13)
[ERROR] Could not use /var/log/mysql/mysql-access.log for logging (error
13). Turning logging off for the whole duration of the MySQL server process.
To turn it on again: fix the cause, shutdown the MySQL server and restart
it.
... and /var/log/mysql/mysql-access.log exists :
-rw-r--r-- 1 mysql mysql 0 ago 5 12:05 mysql-access.log
OK. No problem (#&&%""!!!!). I will re-install all mysql. The same error
:-( .
I change the line in my.cnf and write this:
log=/var/log/mysql/mysql-err.log , that is the same thing under
[mysqld_safe] (err-log=/var/log/mysql/mysql-err.log) . Now access log
works fine . What's hapenning????
I run web-cyradm and try to add an account .. Error 13, access denied ..
:-( but I have a log now. I look at .. :
a.- Insert user admin and password ..
55 Connect [EMAIL PROTECTED] on
55 Init DB mail
55 Init DB mail
55 Query SELECT password FROM adminuser WHERE
username ='admin'
56 Connect [EMAIL PROTECTED] on
56 Init DB mail
56 Init DB mail
56 Query SELECT * FROM domainadmin WHERE
adminuser='admin'
56 Init DB mail
56 Query SELECT * FROM adminuser WHERE
username='admin'
56 Init DB mail
56 Init DB mail
56 Query SELECT * FROM domain ORDER BY
domain_name
(All seems OK, list of domains is displayed)
b.- Click on accounts link ..
57 Connect [EMAIL PROTECTED] on
57 Init DB mail
57 Init DB mail
57 Query SELECT * FROM domainadmin WHERE
adminuser='admin'
57 Init DB mail
57 Query SELECT * FROM adminuser WHERE
username='admin'
(A query like SELECT * FROM accountuser OREDER BY username seems missed.
Error 13 is showed in web browser but not in the login. It stops here)
c.- Click on alias link ..
59 Connect [EMAIL PROTECTED] on
59 Init DB mail
59 Init DB mail
59 Query SELECT * FROM domainadmin WHERE
adminuser='admin'
59 Init DB mail
59 Query SELECT * FROM adminuser WHERE
username='admin'
59 Init DB mail
59 Query SELECT domain_name FROM accountuser
WHERE username='' AND domain_name='domain.es.maind.com'
59 Init DB mail
59 Init DB mail
59 Query SELECT COUNT( DISTINCT( alias ) ) FROM
virtual WHERE username = 'domain.es.maind.com'
59 Init DB mail
59 Query SELECT DISTINCT( alias ) FROM virtual
WHERE username = 'domain.es.maind.com' LIMIT 0, 10
(All seems OK here too. I can create alias perfectly and displayed OK) .
Things that I have do:
I connect mysql with mail user and passwor and execute the query [SELECT *
FROM adminuser WHERE username='admin'] (I don't know if the error is here or
not). Query execute OK. No problem.
I try to add some users manually to accouuntuser table. No problem.
Here I'm absolutely missing. PLEASE HELP!! .
I think, like Giovani, that error is an authentication problem. And I think
that perhaps there's something wrong in some library, file, ... Maybe a
problem with pam or imapd .. but I don't know where the problem is .. I
don't want to install distribution again .. no, please, no .. :-(((
Regards.,
--- Original Message -----
From: "Giovani Moda - MR Informática" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[email protected]>
Sent: Friday, August 05, 2005 2:25 AM
Subject: Re: [Web-cyradm] Error No. 13
Ok, this is an authentication problem. Have you configured pam to search
for users/passwords at the mysql database?!
If not, check the files smtp, pop, imap and sieve at /etc/pam.d. They
should all look the same and contain the configurations to search mysql
database for users.
Here's a sample, in case you haven't changed those yet:
auth sufficient pam_mysql.so user=mail passwd=secret host=localhost
db=mail table=accountuser usercolumn=username passwdcolumn=password
crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user
loghostcolumn=host logpidcolumn=pid logtimecolumn=time
account required pam_mysql.so user=mail passwd=secret host=localhost
db=mail table=accountuser usercolumn=username passwdcolumn=password
crypt=1 logtable=log logmsgcolumn=msg logusercolumn=user
loghostcolumn=host logpidcolumn=pid logtimecolumn=time
Make sure that the user= and password= settings reflects the ones you have
configured in your system. In case you haven't changed anything from the
default config, those should work fine.
Another thing. If I'm not mistaken, mysql changed encryption from 3.23 to
4.11 (wich is the mysql version present on FC4), so it *could* be and
encryption problem you're facing. The mysql logs would *REALLY* help you
now. I've checked, and all I did to add logs to mysql is
log=/var/log/filename at /etc/my.cnf. Google around and see if you can
find why your mysql isn't starting with that option at my.cnf.
Best of luck.
Giovani
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Thursday, August 04, 2005 8:31 PM
Subject: Re: [Web-cyradm] Error No. 13
I'm a little missed ..
First, I believed that the problem was with something over mysql, then
I've tried to start mysql with logs on. I changed /etc/my.cnf and added
log=/var/log/mysql.log under [mysqld] section, but mysql hangs with no
error in /var/log/mysql-error.log. If I delete the line, mysql runs fine.
Is something wrong in mysql installation? I don't know .. I think there
is nothing wrong, but ... (I can create dbs, tables, execute queries, etc
without problems) .
So I don't know how I can activate logs in mysql.
Another thing I've tried is execute the cyradm and imtest commands ..
These are the results :
imtest -a cyrus -v localhost
S: * OK fixmad01.subdomain.es.domain.com Cyrus IMAP4
v2.2.12-Invoca-RPM-2.2.12-6.fc4 server ready
C: C01 CAPABILITY
S: * CAPABILITY IMAP4 IMAP4rev1 ACL QUOTA LITERAL+ MAILBOX-REFERRALS
NAMESPACE UIDPLUS ID NO_ATOMIC_RENAME UNSELECT CHILDREN MULTIAPPEND
BINARY SORT THREAD=ORDEREDSUBJECT THREAD=REFERENCES ANNOTATEMORE IDLE
STARTTLS LISTEXT LIST-SUBSCRIBED X-NETSCAPE
S: C01 OK Completed
Please enter your password:
C: L01 LOGIN cyrus {9}
S: + go ahead
C: <omitted>
S: L01 NO Login failed: generic failure
Authentication failed. generic failure
Security strength factor: 0
user cyrus don't login an /var/log/maillog ...
imap[3144]: badlogin: fixmad01.subdomain.es.domain.com [127.0.0.1]
plaintext cyrus SASL(-1): generic failure: checkpass failed
And ..
cyradm --user cyrus localhost
IMAP Password:
Login failed: generic failure at
/usr/lib/perl5/site_perl/5.8.6/i386-linux-thread-multi/Cyrus/IMAP/Admin.pm
line 118
cyradm: cannot authenticate to server with as cyrus
and the same error on /var/log/maillog .
I've read in mailing list that this error (cyradm) is caused in Fedora
because /etc/sysconfig/saslauthd don't contain MECH=pam into it. I
changed /etc/sysconfig/saslauthd some time ago, so this error is caused
by another thing that I don't know ..
Obviusly, There's something wrong on my system, but now I'm very confused
and need help. :-((
Thanks everybody in advance.
----- Original Message -----
From: "Giovani Moda - MR Informática" <[EMAIL PROTECTED]>
To: <[email protected]>
Sent: Friday, August 05, 2005 12:50 AM
Subject: Re: [Web-cyradm] Error No. 13
That's for who is compiling cyrus. FC4 has rpm's package for
cyrus-imapd. The locations for the folders are /var/spool/imap and
/var/lib/imap. Check out the owner of /var/lib/imap, but that should not
be your problem. I've installed cyrus-imapd on several FC (2 and 3)
boxes, and never had this specific problem. Never tried FC4, but as far
as I can see, that's not very different.
Can you feed us with some message and maillog log's from when the error
occurs?!
I'm thinking permission at mysql database. Try runnig mysql with logs
on. Change /etc/my.cnf and add log=/var/log/mysqlaccess.log at [mysqld]
section. Create /var/log/mysqlaccess.log, give it some writting
permission (666 should be fine, only for testing), restart the service
and see what happens. The answers are always in the logs.
Cheers,
Giovani
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
_______________________________________________
This mailing list is hosted and supported
by bit-heads GmbH | http://www.bit-heads.ch
_______________________________________________
Web-cyradm mailing list
[email protected]
http://www.web-cyradm.org/mailman/listinfo/web-cyradm
