Silkie

For those of you trying to get squirrel mail installed to offer your members email, here is a simple way to do it. I almost pulled all my hair out figuring this out so hopefully it helps someone.

INSTALLING SQUIRRELMAIL:
note: items in bold require you to modify to match your own info

1. Download a stable version from http://www.squirrelmail.org/download.php

2. Unpack and upload the contents to /public_html/squirrelmail

3. Create a folder in your ftp root called .mysqmail (if you are using cute ftp you will have to have your filteres enabled to see the file. to enable filters, edit your account, click on "enable filters" then click on the filters button. in the next box, make sure that these are ticked:
1. apply filters to local directory listing
2. apply filters to remote directory listing
3. Enable local filters (let cutepftp do the filtering
4. Enable remote filters (server applied filters)

in the box for enable remote filters type -a
You should now be able to see the .mysqmail folder.)

4. Create a data and tmp folder inside .mysqmail
(i.e. /.mysqmail/data & /.mysqmail/tmp)

5. Using File Manager from cPanel does not seem to hold the permissions so be sure to continue using your ftp program to set the permissions for the three folders you made as follows:
.mysqmail (chmod 777)
data (chmod 770)
tmp (chmod 730)

6. Make sure and copy the default_pref from the data folder that came with your squirrelmail package over to your new data folder that you made in step 5.

7. in Cpanel go to mysql and create a new database. then using phpmyadmin go to the new database and then to the sql tab and enter the following commands:

CREATE TABLE address (
owner varchar(128) DEFAULT '' NOT NULL,
nickname varchar(16) DEFAULT '' NOT NULL,
firstname varchar(128) DEFAULT '' NOT NULL,
lastname varchar(128) DEFAULT '' NOT NULL,
email varchar(128) DEFAULT '' NOT NULL,
label varchar(255),
PRIMARY KEY (owner,nickname),
KEY firstname (firstname,lastname)
);
CREATE TABLE global_abook (
owner varchar(128) DEFAULT '' NOT NULL,
nickname varchar(16) DEFAULT '' NOT NULL,
firstname varchar(128) DEFAULT '' NOT NULL,
lastname varchar(128) DEFAULT '' NOT NULL,
email varchar(128) DEFAULT '' NOT NULL,
label varchar(255),
PRIMARY KEY (owner,nickname),
KEY firstname (firstname,lastname)
);
CREATE TABLE userprefs (
user varchar(128) DEFAULT '' NOT NULL,
prefkey varchar(64) DEFAULT '' NOT NULL,
prefval BLOB DEFAULT '' NOT NULL,
PRIMARY KEY (user,prefkey)
);


8. Go to your squirrelmail files that you extracted and uploaded to /public_html/squirrelmail and go the config directory. Copy config_default.php and rename to config.php then edit this config.php file to match the items below. Make sure and change the bold items to match your info as well as any other items you wish to configure.

in the config.php, edit the DSN Lines to point to the database
$addrbook_dsn = 'mysql://userspass[at]hostname/dbname

$domain = 'companyname.com';
$useSendmail = true;
$smtpServerAddress = 'localhost';
$smtpPort = 25;
$sendmail_path = '/usr/sbin/sendmail';
$imapServerAddress = 'localhost';
$imapPort = 143;
$imap_server_type = 'uw';
$use_imap_tls = false;
$use_smtp_tls = false;
$smtp_auth_mech = 'none';
$imap_auth_mech = 'login';
$optional_delimiter = 'detect';
$pop_before_smtp = false;
$default_folder_prefix = '';
$show_prefix_option = false;
$default_move_to_trash = true;
$default_move_to_sent = true;
$default_save_as_draft = true;
$trash_folder = 'INBOX.Trash';
$sent_folder = 'INBOX.Sent';
$draft_folder = 'INBOX.Drafts';
$auto_expunge = true;
$delete_folder = false;
$use_special_folder_color = true;
$auto_create_special = true;
$list_special_folders_first = false;
$default_sub_of_inbox = false;
$show_contain_subfolders_option = false;
$default_unseen_notify = 2;
$default_unseen_type = 1;
$noselect_fix_enable = false;
$default_charset = 'iso-8859-1';
$data_dir = SM_PATH . 'data/';
$attachment_dir = $data_dir;
$dir_hash_level = 0;
$default_left_size = '150';
$force_username_lowercase = true;
$default_use_priority = true;
$hide_sm_attributions = true;
$default_use_mdn = true;
$edit_identity = false;
$edit_name = true;
$allow_thread_sort = false;
$allow_server_sort = false;
$allow_charset_search = true;
$uid_support = true;
$session_name = 'SQMSESSID';
YOUR DONE!

you should now be able to log into your new squirrelmail.

__________________
~Miracle Juicer, Perfection Slicer~

Dum Vivamus, vivimus
Silkie

www.vampirecommunity.com
www.bloodyfiction.com
www.kellispies.com

Tracer Round

I'm just curious but how is this different than using the Squirellmail that is already in cPanel?

Tracer

__________________
2005 Surpassies: Winner of Most Skilled Wordsmith

SH129 - Power
SH81 - OC5

Silkie

well for me the difference is that one of hte websites I'm working on wants their employees to be able to retrieve email however they are very limited with using the internet. this way they can access squirrelmal without having to type in the cpanel password or even knowing it exists. Each department receives "tickets' from a feedback system that does directly to each departments email address. this way the only password they have to type in is to log in and read email.

here's the url of it set up this way.

http://www.redrino.com/squirrelmail/

p.s. be kind, lol the site is just getting underway and so it's very bare.

__________________
~Miracle Juicer, Perfection Slicer~

Dum Vivamus, vivimus
Silkie

www.vampirecommunity.com
www.bloodyfiction.com
www.kellispies.com

Tracer Round

Oh, ok. I see what you mean. Since they cant access http://www.yourdomain.com:2095 that would solve that problem.

By the way, that is a very nice tut.

Tracer

__________________
2005 Surpassies: Winner of Most Skilled Wordsmith

SH129 - Power
SH81 - OC5

Silkie

exactly. the company doesn't want it's employees to be able to access the cpanel and this eliminates that problem. Trust me I don't want them in there either. LOL it's a nice solution to be able to offer your members free email accounts without givign them access to areas they don't belong in.


and thanks. LOL I've read other posts from people trying to install this. it took me forever to grasp this process so I thought I'd share. it only takes a few minutes to set it up this way. the installation instructions that come with squirrelmail are very vague for the user that doesn't have SSH/telnet access. the way I have it posted you don't need to understand all that.

__________________
~Miracle Juicer, Perfection Slicer~

Dum Vivamus, vivimus
Silkie

www.vampirecommunity.com
www.bloodyfiction.com
www.kellispies.com

andymaung

Thank you Silkie. This is very nice of your post "Squirrel Mail Installation" as it is very helpful to me and I've learnt from your config.php setting and MySQL setting.

I am not an advanced programmer, but I learnt from test of everything and found that your config.php got one error you'll see when you forward mail with attachment. (Sorry my English is also not very good.) I mean mail you receive with attachment and if you click forward then error comes up!

I found that correction to this error as follow:

First, you should creat a new attachment folder, anywhere you like.
CHMOD 733 to this folder.
In the config.php change as below:

$attachment_dir = '/home/user/path/to/folder/attachment/';

This fixed my error.
If I am wrong in somewhere, please tell me.

Happy surpassers!

But, some are not very happy for this moment with server problems... Me too...

Steve.H

Hi Silkie!

Nice post you got in here, about installing a separated SquirrelMail.
It was just what I was looking for...

Ok, i've followed all your instructions above, but It's not "working" very fine.
Since you do handle SquirrelMail very well, i thought you could give me a little help, of course, if you don't mind...

Can you take a look at this:
http://www.imeex.com.br/squirrelmail/src/login.php

I have no idea of what i've done wrong so far...
Many thanks in advance for your help.

__________________
There are 10 kind of people in this world.
Those who understand binary and those who don't.

Server: Serenity x.x.40.51
Dog: a 'bad ass' Bull Terrier

Steve.H

Hi SILKIE.

I've followed all your instructions (GREAT TUTORIAL by the way), and everything is FINE!
I've tested it, and i can Login, Recieve mails with no problem.

But i can't COMPOSE MAIL, and it gives me this error:
http://www.imeex.com.br/errors/sqmailerror.gif

I thought you could help me, because i don't understand a lot of 'scripting'.
Of corse, only you have some spare time.

Anyway, Thanks in advance!

__________________
There are 10 kind of people in this world.
Those who understand binary and those who don't.

Server: Serenity x.x.40.51
Dog: a 'bad ass' Bull Terrier

Silkie

I haven't been here in ages and I thought I'd check in...did you all get your issues solved or do you still need help? if you still need help give me a holler.

__________________
~Miracle Juicer, Perfection Slicer~

Dum Vivamus, vivimus
Silkie

www.vampirecommunity.com
www.bloodyfiction.com
www.kellispies.com