7 messages in net.sourceforge.lists.courier-usersRe: [courier-users] adding accounts i...
FromSent OnAttachments
PavelMar 2, 2003 7:22 pm 
Josh TrutwinMar 3, 2003 10:49 am 
George SzekelyMar 3, 2003 12:23 pm 
Jack ZieglerMar 3, 2003 1:06 pm 
Sam VarshavchikMar 3, 2003 2:49 pm 
PavelMar 3, 2003 4:01 pm 
Jesse CablekMar 3, 2003 9:34 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] adding accounts information in MySQL database.Actions...
From:George Szekely (gm@captainnet.net)
Date:Mar 3, 2003 12:23:17 pm
List:net.sourceforge.lists.courier-users

Hi All,

I'm want use the authmysql module for stored a list of mail accounts in an external MySQL database. I create the database, and create the table. All is clock-work, all is order. But I have a small problem: How can I add the information of users accounts in my database.

Do you want to know how to insert the data into the MySQL table?

Use something like:

INSERT INTO myTable (id, crypt, clear, name, uid, gid, home) VALUES ('user1', ENCRYPT('password'), '', 'User Number 1', '501', '502', '/home/user1');

this package is based on "id, crypt, clear, name, uid, gid, home"

http://maxo.captainnet.net/installs/mailAdmin.tar.gz with a demo to see what it looks like: http://maxo.captainnet.net/mailAdmin/index.php

You would of course replace the field names and values with whatever is appropriate for your configuration.

Or, you could download something like phpMyAdmin and use the graphical client to add data to the table.