LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (https://www.linuxquestions.org/questions/linux-server-73/)
-   -   Regarding squirrel mail global address book (https://www.linuxquestions.org/questions/linux-server-73/regarding-squirrel-mail-global-address-book-873037/)

ghpradeep 04-05-2011 02:02 AM

Regarding squirrel mail global address book
 
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


All times are GMT -5. The time now is 12:53 PM.