4 messages in net.sourceforge.lists.courier-usersRE: [courier-users] Courier Question
FromSent OnAttachments
FS...@aol.comDec 9, 2003 8:40 pm 
David GomillionDec 10, 2003 8:12 am 
Mitch (WebCob)Dec 10, 2003 10:01 am 
Alan InghamDec 11, 2003 6:13 pm 
Actions with this message:
Paste this link in email or IM:
Paste this link in email or IM:
Atom feed for this thread
Paste this URL into your reader:
Subject:RE: [courier-users] Courier QuestionActions...
From:Alan Ingham (ala@shaw.ca)
Date:Dec 11, 2003 6:13:39 pm
List:net.sourceforge.lists.courier-users

Is the UID Field and the GID not supposed to match the actual name of the field in the MySQL table? So

MYSQL_UID_FIELD '101' MYSQL_GID_FIELD '103'

Should perhaps be MYSQL_UID_FIELD Uid MYSQL_GID_FIELD Gid

My users table has the a column name of Uid and Gid to store the Uid and Gid that Courier uses to manipulate the home dir. I believe. :) Still figuring things out.

alan

-----Original Message----- From: cour@lists.sourceforge.net [mailto:cour@lists.sourceforge.net]On Behalf Of FS@aol.com Sent: Tuesday, December 09, 2003 8:41 PM To: cour@lists.sourceforge.net Subject: [courier-users] Courier Question

Hello Everyone,

I have a very simple question today for you guys, I hope. I just recently decided to setup courier so I instlaled all the software and I build the rpm. I am using MySQL with it and amd using courier for my virtual users only, not real system users. I have a database called mail in mysql, and three tables, aliases, domains, and mailboxes. Since aliases and domains aren't apart of my problem, the layout of mailboxes only is username,password,name,maildir,quota,domain,create_date,change _date,active. Everything is working fine. I installed courier-imap and then courier-imap-mysql just find by the rpms i built. After I installed those two packages I edited authdaemonrc to:

authmodulelist="authmysql" authmodulelistorig="authcustom authcram authuserdb authldap authpgsql authmysql authpam" daemons=5 version="authdaemond.mysql"

with everything else default. Then i proceeded to change authmysqlrc to:

MYSQL_SERVER localhost MYSQL_USERNAME root MYSQL_PASSWORD mypwd # MYSQL_SOCKET /var/mysql/mysql.sock #MYSQL_PORT 0 MYSQL_OPT 0 MYSQL_DATABASE mail #MYSQL_CRYPT_PWFIELD crypt MYSQL_CLEAR_PWFIELD password MYSQL_UID_FIELD '101' MYSQL_GID_FIELD '103' MYSQL_LOGIN_FIELD username MYSQL_NAME_FIELD name MYSQL_MAILDIR_FIELD maildir DEFAULT_DOMAIN fast-build.com

and everything else default (i think i got eerything though). Note for maildir I keep all my virtual mail in /mail/virtual with folders under the actual mail address, like te@fast-build.com. And lastly I edited my imapd file with the following values changed:

ADDRESS=127.0.0.1 AUTHMODULES="authdaemon"

Those are the only two things worth nothing in that file I believe. Now heres my problem. Since I'm on windows and my server is hooked up to my network I can access it two ways. I can go directly through the network to the server by using the routers assigned IP, or I can use my IP assigned to the route and have the signal sent to the server cus I have it setup to forward all requests on port 143 to the server. When I connect through the network I can connect just find, and log in as a user so Mysql is setup correctly and everything, but when i try and use my actual IP address, 63.127.45.55, I can't connect, and it just times out. I have tried playing around with the ip setting in imapd but i keeps giving me errors if i don't set it to the loopback ip or 0, whatever that means. I would read logs but I'm not sure what log the info is in that pertains to this problem. My server is setup as follows. It's redhat linux 7.3 with postfix 2.0.16 and courier-imap 2.2.1. If anyone could help me out with this, give me some pointers on how to make it let me connect outside my home network, that would be great.

Thanks again, Dan

NHµŠ²²užº‰ç(™æ§{^®Ø§,ƒT^ŠãºËl yªçz÷«ÊØbžë¢kay¶¬†È^–[h³+vh§ Xœ’z0†Ûiÿö²‹Ê&ý§bt ïƖ‡tïrº®®Š‚µ®º²¶º~zRn‰¶ÿ²¢y·²–Šý®º