Regarding squirrel mail global address book

ghpradeep · 04-05-2011, 02:02 AM

I have configured qmaill with mysql database and i am using squirrel mail as a webbase client. I have used qmailadmin to create users email id. user which are create using qmailadmin or vpopadmin are able to login into squirrel mail webbase client. But I am not see those user in squirrel mail global address book. please help and provide me prodedure to create global addres book where i can see all user created using qmailadmin or vpopmail.

bathory · 04-05-2011, 04:26 AM

Hi,

Since squirrelmail addressbook use a csv file format, accrding to this, you can use phpmyadmin to export your users table from mysql in csv format.
Then you can move this file in the data directory of squirrelmail and run conf.pl to specify that file as global addressbook.

Regards

ghpradeep · 04-05-2011, 05:39 AM

Hi,

currently I am using mysql to store information like addressbook. I am creating user using vqadmin in qmail but that created user not refelecting inm mysql database. I have created rtscmail.mysql in ~vpopadmin/etc/ folder.

please suggest how to use mysql as backend database to store vqadmin user information....

Thanks in advance...

bathory · 04-05-2011, 06:33 AM

I'm not using mysql to store users data, but if you bother searching, I guess you can find lots of answers.
First hit on google is this. There is also a qmailrocks specific setup (if you use QMR), but currently the site is down.
Or you can have a look here (written for debian), but the configuration is the same regardless distro.

ghpradeep · 04-05-2011, 09:28 AM

hi,

I have followed the procedure as per the giving site. i have created database vpopmail. but when i created user using vqadmin. User information like email address and name are not showing in vpopmail databse.

any thing i need to create table for that.

Help me on this...

bathory · 04-05-2011, 10:42 AM

Quote from the 1st link above:

Quote:

To add a mailbox:

/home/vpopmail/bin/vadduser someone@yourdomain.com apassword

(Or you can do it via qmailadmin)

ghpradeep · 04-06-2011, 04:59 AM

Hi

i have ran above command use are showing in qmailadmin and vqadmin. but not in vpopmail database which i have created during installation. Is there any tables need to be create in vpopmail database so qmailadmin or vqadmin can write info in vpopmail database....

bathory · 04-06-2011, 05:15 AM

Why don't you read the documentation. Again from the 1st link above:

Quote:

# log into MySQL as the MySQL root user
# and then create the database for vpopmail to use
# and then setup the appropriate permissions on this database

/usr/local/mysql/bin/mysql --password="mysql-root-pwd"

CREATE DATABASE vpopmail;

GRANT select,insert,update,delete,create,drop ON vpopmail.*
TO vpopmailuser@localhost IDENTIFIED BY 'vpoppasswd';

quit