PDA

View Full Version : FC9 Setup Postfix Dovecot MySQL Squirrel Mail



jmbiram
25th May 2008, 12:40 AM
:mad: I get this error trying to get Dovecot to authenticate with Postfix using MySQL.
More info on the problem! Fedora 9
### /var/log/mail.log
### The mail Error Log Shows:
dovecot: May 25 08:39:52 Info: Dovecot v1.0.13 starting up
dovecot: May 25 08:39:52 Error: Auth process died too early - shutting down
dovecot: May 25 08:39:52 Error: auth(default): Unknown database driver 'mysql'
dovecot: May 25 08:39:52 Error: child 17805 (auth) returned error 89

:confused: The 89 refers to postfix uid and the mysql refers to the dovecot-mysql.conf files thats about all I know. I have no idea why the Auth process dies too early.

#### dovecot-mysql.conf ###
# The mysqld.sock socket may be in different locations in different systems
driver = mysql
connect = host=/var/lib/mysqld/mysqld.sock dbname=mails user=postfix password=xxxxx
# Alternatively you can connect to localhost as well:
#connect = host=localhost dbname=mails user=postfix password=xxxxx
password_query = SELECT concat(userid, '@', domain) AS user, password FROM users WHERE userid = '%n' AND domain = '%d'
user_query = SELECT home, uid, gid FROM users WHERE userid = '%u'

:) I would appreciate any help :?

####dovecot.conf ###
auth_verbose = yes
mail_debug = yes

base_dir = /var/run/dovecot/
protocols = imap imaps pop3 pop3s
listen = *

shutdown_clients = yes
log_path = /var/log/mail.log
info_log_path = /var/log/mail.log
log_timestamp = "%b %d %H:%M:%S "
syslog_facility = mail
disable_plaintext_auth = no
ssl_disable = no
ssl_cert_file = /etc/postfix/ssl/smtpd.crt
ssl_key_file = /etc/postfix/ssl/smtpd.key
login_chroot = yes
login_user = postfix
login_process_per_connection = yes
login_processes_count = 2
login_max_processes_count = 128
login_max_connections = 256
login_greeting = Welcome to JB's Mail Server.
login_log_format_elements = user=<%u> method=%m rip=%r lip=%l %c
login_log_format = %$: %s
default_mail_env = maildir:/var/spool/postfix/virtual/%d/%n
first_valid_uid = 89 # REMEBER THIS MUST BE CHANGED TO YOUR UID FOR "postfix" FROM /etc/passwd
pop3_uidl_format = %08Xu%08Xv
auth default {
mechanisms = PLAIN
userdb sql {
args = /etc/dovecot-mysql.conf
}
passdb sql {
args = /etc/dovecot-mysql.conf
}
user = root
count = 2
}
mail_access_groups = mail
mail_debug = yes

Dan
28th May 2008, 12:35 AM
Hmmmm.

Welcome aboard!

I don't have a solution for you, but I'm sure someone will come along soon who will. (The closest I get to squirrel mail has a lot to do with a long lens on a camera and the denizens of an oak tree in the park across the street.) <..:p..>


Dan

jmbiram
28th May 2008, 09:36 AM
Could not include PEAR database functions required for the database backend.
Is PEAR installed, and is the include path set correctly to find DB.php?
Please contact your system administrator and report this error.

PEAR installed, MySQL is working with Postfix & Dovecot is also installed and running. I am sure it is something very small that I overlook. I just can seem to locate the problem.

jmbiram
28th May 2008, 10:17 AM
SOLVED IT...

installed rpm dovecot-mysql for fc9 and it works !!! :)

leigh123linux
28th May 2008, 10:37 AM
PEAR installed, MySQL is working with Postfix & Dovecot is also installed and running. I am sure it is something very small that I overlook. I just can seem to locate the problem.


Thread merged ! Please don't double post about the same problem again !



Did you install any pear packages ?




[root@localhost leigh]# yum list |grep pear
lxappearance.x86_64 0.2-1.fc9 updates
php-pear.noarch 1:1.7.1-2.fc9 fedora
php-pear-Auth-SASL.noarch 1.0.2-4.fc6 fedora
php-pear-Benchmark.noarch 1.2.7-1.fc8 fedora
php-pear-Cache.noarch 1.5.5-0.2.RC4.fc8 fedora
php-pear-Console-Color.noarch 1.0.2-1.fc7 fedora
php-pear-Console-Getargs.noarch 1.3.4-1.fc8.1 fedora
php-pear-Console-Table.noarch 1.1.1-1.fc9 updates
php-pear-Crypt-CHAP.noarch 1.0.1-1.fc7 fedora
php-pear-DB.noarch 1.7.13-1.fc8 fedora
php-pear-DB-DataObject.noarch 1.8.8-1.fc9 fedora
php-pear-DB-DataObject-FormBuilder.noarc 1.0.0-0.5.RC7.fc7 fedora
php-pear-DB-QueryTool.noarch 1.1.2-1.fc9 fedora
php-pear-Date.noarch 1.4.7-2.fc7 fedora
php-pear-Date-Holidays.noarch 0.17.4-1.fc9 fedora
php-pear-File.noarch 1.3.0-1.fc8 fedora
php-pear-File-Find.noarch 1.3.0-1.fc9 fedora
php-pear-File-Passwd.noarch 1.1.6-2.fc7 fedora
php-pear-File-SMBPasswd.noarch 1.0.2-1.fc7 fedora
php-pear-HTML-Common.noarch 1.2.4-1.fc8 fedora
php-pear-HTML-QuickForm.noarch 3.2.10-1.fc9 fedora
php-pear-HTML-QuickForm-ElementGrid.noar 0.1.1-1.fc7 fedora
php-pear-HTML-QuickForm-advmultiselect.n 1.4.1-1.fc9 updates
php-pear-HTML-Table.noarch 1.8.2-1.fc9 fedora
php-pear-HTTP.noarch 1.4.0-8.fc8 fedora
php-pear-HTTP-Request.noarch 1.4.2-1.fc9 fedora
php-pear-HTTP-Upload.noarch 0.9.1-2.fc9 fedora
php-pear-Image-Canvas.noarch 0.3.1-1.fc8 fedora
php-pear-Image-Color.noarch 1.0.2-3.fc7 fedora
php-pear-Image-Graph.noarch 0.7.2-2.fc7 fedora
php-pear-Image-Graph-roman.noarch 0.7.2-2.fc7 fedora
php-pear-Image-Graph-words.noarch 0.7.2-2.fc7 fedora
php-pear-Image-GraphViz.noarch 1.2.1-2.fc7 fedora
php-pear-Log.noarch 1.10.1-1.fc9 updates
php-pear-MDB2.noarch 2.4.1-2.fc9 fedora
php-pear-MDB2-Driver-mysql.noarch 1.4.1-3.fc9 fedora
php-pear-MDB2-Driver-mysqli.noarch 1.4.1-3.fc9 fedora
php-pear-Mail.noarch 1.1.14-2.fc8 fedora
php-pear-Mail-Mime.noarch 1.5.2-3.fc9 fedora
php-pear-Mail-mimeDecode.noarch 1.5.0-3.fc9 fedora
php-pear-Math-Stats.noarch 0.9.0-0.1.beta3.fc7 fedora
php-pear-Net-Curl.noarch 1.2.3-2.fc6 fedora
php-pear-Net-DIME.noarch 0.3-1.fc7 fedora
php-pear-Net-FTP.noarch 1.3.4-1.fc9 fedora
php-pear-Net-POP3.noarch 1.3.6-2.fc7 fedora
php-pear-Net-Ping.noarch 2.4.3-1.fc9 fedora
php-pear-Net-SMTP.noarch 1.3.0-1.fc9 updates
php-pear-Net-Sieve.noarch 1.1.5-2.fc7 fedora
php-pear-Net-Socket.noarch 1.0.8-1.fc7 fedora
php-pear-Net-Traceroute.noarch 0.21.1-2.fc8 fedora
php-pear-Net-URL.noarch 1.0.15-1.fc8 fedora
php-pear-Net-URL-Mapper.noarch 0.9.0-2.fc9 fedora
php-pear-Net-UserAgent-Detect.noarch 2.4.0-1.fc8 fedora
php-pear-Numbers-Roman.noarch 1.0.2-2.fc9 fedora
php-pear-Numbers-Words.noarch 0.15.0-2.fc7 fedora
php-pear-PEAR-Command-Packaging.noarch 0.1.2-5.fc6 fedora
php-pear-PHP-CodeSniffer.noarch 1.0.1-1.fc9 fedora
php-pear-PHP-Compat.noarch 1.5.0-1.fc6 fedora
php-pear-PHP-CompatInfo.noarch 1.7.0-1.fc9 updates
php-pear-PHPUnit.noarch 3.2.15-1.fc9 fedora
php-pear-Pager.noarch 2.4.4-1.fc8 fedora
php-pear-Payment-Process.noarch 0.6.5-1.fc6 fedora
php-pear-Phlickr.noarch 0.2.7-2.fc8 fedora
php-pear-PhpDocumentor.noarch 1.4.1-2.fc9 fedora
php-pear-PhpDocumentor-docs.noarch 1.4.1-2.fc9 fedora
php-pear-SOAP.noarch 0.11.0-1.fc8 fedora
php-pear-Services-Weather.noarch 1.4.2-1.fc7 fedora
php-pear-Structures-DataGrid.noarch 0.9.0-2.fc9 fedora
php-pear-Structures-DataGrid-DataSource- 0.1.4-1.fc9 fedora
php-pear-Structures-DataGrid-DataSource- 0.2.1-1.fc9 fedora
php-pear-Structures-DataGrid-DataSource- 0.1.11-1.fc9 fedora
php-pear-Structures-DataGrid-DataSource- 0.1.1-1.fc7 fedora
php-pear-Structures-DataGrid-Renderer-Pa 0.1.3-1.fc9 fedora
php-pear-Structures-DataGrid-Renderer-Sm 0.1.4-1.fc9 fedora
php-pear-Validate.noarch 0.8.1-1.fc9 fedora
php-pear-Validate-Finance-CreditCard.noa 0.5.2-1.fc6 fedora
php-pear-XML-Beautifier.noarch 1.1-2.fc7 fedora
php-pear-XML-Parser.noarch 1.2.8-2.fc8 fedora
php-pear-XML-RSS.noarch 0.9.10-3.fc7 fedora
php-pear-XML-Serializer.noarch 0.18.0-3.fc7 fedora
php-pear-XML-Util.noarch 1.1.4-2.fc7 fedora
php-pear-creole.noarch 1.1.0-5.fc8 fedora
php-pear-pake.noarch 1.1.4-3.fc9 fedora
php-pear-phing.noarch 2.3.0-1.fc9 fedora
[root@localhost leigh]#

jmbiram
28th May 2008, 11:04 AM
Yes I did 'pear upate pear' which loaded the latetest version... I then checked PHP.ini about the squirrelmail error. I found the include_path which was disabled so I added


include_path = ".:/php/includes:/usr/share/pear"

which I followed with :


pear install DB