LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 04-05-2011, 02:02 AM   #1
ghpradeep
LQ Newbie
 
Registered: Mar 2011
Posts: 29

Rep: Reputation: 0
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.
 
Old 04-05-2011, 04:26 AM   #2
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 12,663

Rep: Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818
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
 
Old 04-05-2011, 05:39 AM   #3
ghpradeep
LQ Newbie
 
Registered: Mar 2011
Posts: 29

Original Poster
Rep: Reputation: 0
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...
 
Old 04-05-2011, 06:33 AM   #4
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 12,663

Rep: Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818
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.
 
Old 04-05-2011, 09:28 AM   #5
ghpradeep
LQ Newbie
 
Registered: Mar 2011
Posts: 29

Original Poster
Rep: Reputation: 0
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...
 
Old 04-05-2011, 10:42 AM   #6
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 12,663

Rep: Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818
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)
 
Old 04-06-2011, 04:59 AM   #7
ghpradeep
LQ Newbie
 
Registered: Mar 2011
Posts: 29

Original Poster
Rep: Reputation: 0
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....
 
Old 04-06-2011, 05:15 AM   #8
bathory
LQ Guru
 
Registered: Jun 2004
Location: Piraeus
Distribution: Slackware
Posts: 12,663

Rep: Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818Reputation: 1818
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
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
squirrel mail address book kishorerhce508 Linux - Server 6 09-17-2009 11:30 PM
How to set up a global address book using LDAP? coolamit78 Linux - Networking 1 04-04-2005 01:42 AM
exchange global address book in kmail newyearsk Linux - Software 0 08-22-2004 03:33 AM
share global address book ythevenot Linux - Software 0 04-21-2004 06:21 AM
mail server w/ global address book stroh78 Linux - General 1 07-07-2001 04:01 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 02:43 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration