TetraWiki - User contributions [en]

Mail migration from send mail to Qmail prime-pci

2013-04-06T05:02:50Z

Subhash: Created page with "Price-pci wanted transferred sent item of sendmail server to qmail server. this has been done by this command First mount sendmail home directory to qmail server with nfs wi..."

Price-pci wanted transferred sent item of sendmail server to qmail server.

this has been done by this command

First mount sendmail home directory to qmail server with nfs with proper permission and ownership
/mb2md-3.20.pl -s /mnthome/rajendrababu/ -R -d /home/vmail/prime-pci.com/rajendrababu/Maildir/

After this there will be created some extra folders in webmail (inbox sentitem etc.)

this is a script can download from net /mb2md-3.20.pl

Righ now it is downloaded at /root/mailbox_to_maildir/mb2md-3.20.pl location in Qmail server

Delete mail queue In Qmail

2013-02-18T12:48:16Z

Subhash: Created page with "==Objective== Sometimes we get spam issue with Qmail. In that case thousands of mail will be in queue. First stop qmail vim /etc/inittab SV:123456:respawn:/command/svsc..."

==Objective==

Sometimes we get spam issue with Qmail. In that case thousands of mail will be in queue.

First stop qmail

vim /etc/inittab

SV:123456:respawn:/command/svscanboot

# out above line end of file

init q

For get help of qmHandle

qmHandle -h

To know which user account has been compromised. this command shows which user sending maximum mail.

qmHandle -l |grep From:|sort|uniq -c|sort -nr|head

Or can use below for same purpose

qmHandle -l|less

get message ID

qmHandle -m'message ID'|less

Please check in header file which user account compromised.

Change password for it first and delete mail in queue.

You can delete mail from queue using defference option to from qmHandle -h (help)

For example

qmHandle -h'Subject: limited offer'

above command will delete all messages in queue that have Subject: limited offer

'''Note:->''' Please never apply above commands before stop qmail(mentioned above).

Mail delete in Qmail

2013-02-18T10:51:31Z

Subhash: Created page with "==Objective== Sometimes we need to remove mail from mail box in Qmail for/till date. For example I have mail box containing 100G size.I want to remove all mails except leave ..."

==Objective==

Sometimes we need to remove mail from mail box in Qmail for/till date.
For example I have mail box containing 100G size.I want to remove all mails except leave last 10 days mails.

Just run a command with careful.

find /path/to/files* -mtime +5 -exec rm {} \;

'''find''' ------------> command

'''/path/to/files*''' -> path of your file

'''-mtime''' ---------> command

'''+5''' -------------> leave 5 day mails from current date & remove rest of the mails

'''rm {} \;''' -------> files remove command.

Add relay IP zimbra orientbell

2013-02-15T09:10:49Z

Subhash: Created page with "==Objective== In postfix when we need change/add relay IP. Just run below commmand. su - zimbra zmprov modifyServer mail.orienttiles.com zimbraMtaMyNetworks '127.0.0.0/8 ..."

==Objective==

In postfix when we need change/add relay IP. Just run below commmand.

su - zimbra

zmprov modifyServer mail.orienttiles.com zimbraMtaMyNetworks '127.0.0.0/8 182.18.187.41/32'

postfix reload

zmmtactl reload

Spam mark orientbell

2013-02-14T06:19:46Z

Subhash: /* Objective */

==Objective==

When any mail id and domain to blacklist/whitelist in orinetbell follow below steps

1.)su - zimbra

cd /opt/zimbra/conf
vi salocal.cf.in

2.)Add below keyword for blacklist and whitelist

to block whole domain

blacklist_from *@irs.gov

block a mail id only

blacklist_from subhash@irs.gov

3.)and follow same step for white list replacing word whitelist_from instead of blacklist_from

save file

4.)restart below serivce to update above changes

zmmtactl restart && zmamavisdctl restart

Spam mark orientbell

2013-02-14T06:18:29Z

Subhash: /* Objective */

==Objective==

When any mail id and domain to blacklist/whitelist in orinetbell follow below steps

#su - zimbra

cd /opt/zimbra/conf
vi salocal.cf.in

#Add below keyword for blacklist and whitelist

to block whole domain

blacklist_from *@irs.gov

block a mail id only

blacklist_from subhash@irs.gov

#and follow same step for white list replacing word whitelist_from instead of blacklist_from

save file

restart below serivce to update above changes

zmmtactl restart && zmamavisdctl restart

Spam mark orientbell

2013-02-14T06:17:38Z

Subhash: /* Objective */

==Objective==

When any mail id and domain to blacklist/whitelist in orinetbell follow below steps

#su - zimbra

cd /opt/zimbra/conf
vi salocal.cf.in

Add below keyword for blacklist and whitelist

to block whole domain

blacklist_from *@irs.gov

block a mail id only

blacklist_from subhash@irs.gov

and follow same step for white list replacing word whitelist_from instead of blacklist_from

save file

restart below serivce to update above changes

zmmtactl restart && zmamavisdctl restart

Spam mark orientbell

2013-02-14T06:14:48Z

Subhash: Created page with "==Objective== When any mail id and domain to blacklist/whitelist in orinetbell follow below steps cd /opt/zimbra/conf vi salocal.cf.in Add below keyword for blacklist and..."

==Objective==

When any mail id and domain to blacklist/whitelist in orinetbell follow below steps

cd /opt/zimbra/conf
vi salocal.cf.in

Add below keyword for blacklist and whitelist

to block whole domain

blacklist_from *@irs.gov

block a mail id only

blacklist_from subhash@irs.gov

and follow same step for white list replacing word whitelist_from instead of blacklist_from

save file

restart below serivce to update above changes

zmmtactl restart && zmamavisdctl restart

Download mail from a particular date into pop a/c orientbell

2013-02-14T04:48:45Z

Subhash: /* Objective */

==Objective==
When client ask to download mails for particular account from a date.
Just run below command with mail id.
'''zmprov ma''' ---> command

'''yogesh.sambherwal@orientbell.com''' ---> user mail id

'''zimbraPrefPop3DownloadSince''' ---> commmand

'''20130205000000Z''' ---> date from download mail into pop account

zmprov ma yogesh.sambherwal@orientbell.com zimbraPrefPop3DownloadSince 20130205000000Z

Download mail from a particular date into pop a/c orientbell

2013-02-14T04:47:57Z

Subhash: /* Objective */

Download mail from a particular date into pop a/c orientbell

2013-02-14T04:40:45Z

Subhash: Created page with "==Objective== When client ask to download mails for particular account from a date. Just run below command with mail id. zmprov ma ---> command yog..."

==Objective==
When client ask to download mails for particular account from a date.
Just run below command with mail id.
zmprov ma ---> command
yogesh.sambherwal@orientbell.com ---> user mail id
zimbraPrefPop3DownloadSince ---> commmand
20130205000000Z ---> date from download mail into pop account

zmprov ma yogesh.sambherwal@orientbell.com zimbraPrefPop3DownloadSince 20130205000000Z

File:Block-encrypted-archives.png

2013-02-12T08:31:37Z

Subhash: uploaded a new version of "File:Block-encrypted-archives.png"

File:Block-encrypted-archives.png

2013-02-12T08:28:24Z

Subhash:

How To Block Encrypted Archives In Zimbra alpha(Natiion Today)

2013-02-12T08:27:06Z

Subhash: Created page with " == ISSUE == Mail was not delivered and it was flagged as virus, Due to pdf attached with it. '''By default Zimbra will block encrypted archives such as ZIP or PDF that can..."

== ISSUE ==

Mail was not delivered and it was flagged as virus, Due to pdf attached with it.

'''By default Zimbra will block encrypted archives such as ZIP or PDF that cannot be scanned. You can disable this function from the Global Settings.
'''

== Solution ==

Block encrypted archives from GUI

You can disable this function from the Global Settings by unchecking Block encrypted archives from the AS/AV tab.

[[File:/home/subhash/Desktop/block-encrypted-archives.png]]

Block encrypted archives from command line

vi /opt/zimbra/clamav-0.97.5/etc/clamd.conf

In this file you can set ArchiveBlockEncrypted to NO or comment it out because NO is the default value

# Mark encrypted archives as viruses (Encrypted.Zip, Encrypted.RAR).
# Default: no
# ArchiveBlockEncrypted no

HOW TO PERMITE USER AS SENDER IN MAILING GROUP IN ZIMBRA ORIENTBELL

2013-02-12T07:53:12Z

Subhash: Created page with " # su - zimbra $ cd /opt/zimbra/postfix/conf Open permitted_senders_allstaff in vi enter the user kumar.ashutosh@orientbell.com as below kumar.ashutosh@orientbell.com ..."

# su - zimbra

$ cd /opt/zimbra/postfix/conf

Open permitted_senders_allstaff in vi

enter the user kumar.ashutosh@orientbell.com as below

kumar.ashutosh@orientbell.com OK

save it

and then

$ /opt/zimbra/postfix/sbin/postmap /opt/zimbra/postfix/conf/permitted_senders_allstaff

and then

$ postfix reload

File:Permited sender.txt

2013-02-12T06:55:10Z

Subhash:

File:Test123.png

2012-09-29T12:00:49Z

Subhash: Test File

Test File

Spam config files

2012-09-29T11:12:49Z

Subhash: Created page with "'''''DELETE SPAM MESSAGES''''' /var/qmail/bin/qmail-scanner-queue.pl sa-delete=20 SPAM MARKE SCORE vim /etc/mail/spamassassin/local.cf /usr/share/spamassassin/ SPAM LOGS ..."

'''''DELETE SPAM MESSAGES'''''
/var/qmail/bin/qmail-scanner-queue.pl

sa-delete=20
SPAM MARKE SCORE

vim /etc/mail/spamassassin/local.cf

/usr/share/spamassassin/

SPAM LOGS QMAIL

/var/spool/qmailscan/qmail-queue.log

RESTART SPAMASSASSING SERVICE FROM /SERVICE
svc -d /service/spamassassin/

svc -u /service/spamassassin/

Configuration files of spamassassin

/usr/share/spamassassin

/etc/mail/spamassassin directories.

We can blacklist and whitelist a user or a domain in below file

/etc/mail/spamassassin/local.cf
-----
whitelist_from d.cary@sparkingwire.com

blacklist_from *@example.com
------

--[[User:Subhash|Subhash]] 16:42, 29 September 2012 (IST)

CCAT DOCS

2012-09-29T10:45:46Z

Subhash: Created page with "Pls see our server login and ip details as below. myslq -uroot for 96(NO PASSWORD) 2 Main servers and 1 Zimbra server. 1) Zimbra Server details. IP : 210.17.247.36 User: roo..."

Pls see our server login and ip details as below.

myslq -uroot for 96(NO PASSWORD)
2 Main servers and 1 Zimbra server.

1) Zimbra Server details.
IP : 210.17.247.36
User: root
Pass: HR6DJheP
ssh port: 22

2) For 2 main servers.
IP : 210.17.247.96 website server
IP : 210.17.247.97
User: root
ssh port: 8989
pass sys_481_ccat
Need to use SSH Auth type connection. SSHKey file iam attaching with this
mail.
SSHKEY pass is : dot com coins

3) Second Zimbra Server details.
ip : 113.28.42.81
username : root
passwd : cpqS%^V

we used the below links for webmail access.
https://rathsworld.com:8889
https://pibl.com.hk:8889

for the domain piblhk.com they are using exchange server hosting outside.
Admin panel for Zimbra is as below.
https://113.28.42.81:7071
OR
https://rathsworld.com:7071
user : admin
passwd : Admin4Ma!l

Zimbra tetratesting account:
e-mail id: tetratest@rathsworld.com
password : sysop0603

Other 2 server details i will send you soon. For all the servers and
domains 210.17.247.96 & 97 is the name server.

We dont have any standrad control panel. We use the below link for domain
controls.

http://ccatsrv1.ccatgroup.com/vhsadmin
http://ccatsrv2.ccatgroup.com/vhsadmin

Username : postmaster
Passwd : ccdnap

***************************************************************************************************************
gmail account for testing:
tetra.ccat@gmail.com
sysop0603
***************************************************************************************************************

look into this ticket: 2011090110001174 ] CCAT : Need to configure domain pacificexcel.net in CCATSRV1[..]

domain added in

cd /service/tinydns/root/
578 ls
579 ls -l
580 ./add-ns e-lflash.com 210.17.247.96
581 ./add-ns e-lflash.com 210.17.247.97
582 cat data
583 ls -l
584 cat data
585 ls -l
586 cat data
587 ls
588 ./add-mx e-lflash.com 210.17.247.96
589 ./add-mx e-lflash.com 210.17.247.97
590 ./add-alias www.e-lflash.com 210.17.247.96
592 ./add-alias pop.e-lflash.com 210.17.247.96
593 ./add-alias e-lflash.com 210.17.247.96
594 ./add-alias mailadmin.e-lflash.com 210.17.247.96

RCA .

rcpthosts.cdb was created on both the server by \

/var/qmail/bin/qmail-cdb rcpthosts.cdb rcpthost.tmp < rcpthosts

CCAT CONFIGURE NEW DOMAIN IN CCAT SERVER 1 FOR MAIL SERVER:
===============================================================================
QUERY:
Need to configure the domain e-lflash.com in ccatsrv1. Pls do the
necessery setting for this doman in the server and send us the details. We
will change the name server setting in the register.
===============================================================================

SOLUTION:

RCA:

********************************************************************************************
Note:Firstly take backup of all files which you want to edit.

1. Create directory "www.e-lflash.com" in "/var/www/vhosts/"

2. Add domain alias "e-lflash.com" in /etc/squirrelmail/apache.conf on ccatsrv1
add this line in file:
"ServerAlias pop.e-lflash.com"

for website

cd /etc/apache2/sites-available/
create file domain.com
<VirtualHost *:80>
ServerName blmintl.com
ServerAlias www.blmintl.com
DocumentRoot /var/www/vhosts/www.blmintl.com/www
CustomLog /var/log/apache2/vhosts/blmintl.com.log combined
ErrorLog /var/log/apache2/vhosts/blmintl.com-error
</VirtualHost>

ln -s /etc/apache2/sites-available/blmintl.com /etc/apache2/sites-enabled/blmintl.com

reload apache2

3. This steps applies on ccatsrv1 and ccatsrv2:
cd /service/tinydns/root/
./add-ns e-lflash.com 210.17.247.96
./add-ns e-lflash.com 210.17.247.97
./add-mx e-lflash.com 210.17.247.96
./add-mx e-lflash.com 210.17.247.97
./add-alias www.e-lflash.com 210.17.247.96
./add-alias pop.e-lflash.com 210.17.247.96
./add-alias e-lflash.com 210.17.247.96
./add-alias mailadmin.e-lflash.com 210.17.247.96

after this step execute "make" command to compile "data" file.

4. rcpthosts.cdb was created on both servers:
add domain "e-lflash.com" in /var/qmail/control/rcpthosts
#/var/qmail/bin/qmail-cdb rcpthosts.cdb rcpthost.tmp < rcpthosts

add into locals files in which server mailbox is exist.
#/var/qmail/bin/qmail-cdb locals.cdb locals.tmp < locals

5. add domain in "/var/qmail/control/smtproutes" file: (check mail box of e-lflash.com on both server before this step.)
e-lflash.com:210.17.247.96:25

6. Restart apache2 service.
#/etc/init.d/apache2 restart|reload
********************************************************

./add-ns indiadesk.com.hk 210.17.247.96
./add-ns galaxymarine.com.hk 210.17.247.97

@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

210.17.247.39

Bee.Dee#@!mc
beedeemc.com

Please find the vqadmin login Details.

URL: <http://ccatindia.in/cgi-bin/vqadmin/vqadmin.cgi>
http://beedeemc.com/cgi-bin/vqadmin/vqadmin.cgi
User Name: admin
Password: Vqadmin-2.3.7

<http://ccatindia.in/cgi-bin/qmailadmin>
http://beedeemc.com/cgi-bin/qmailadmin

Domain: <http://beedeemc.com/> beedeemc.com
Password: MailBee.Dee#2!
----------------------------------------------------------
SKYPE DETAILS
tetra.service
sysop0603
--[[User:Subhash|Subhash]] 16:15, 29 September 2012 (IST)

Mysql root passwd

2012-09-29T07:22:29Z

Subhash: Created page with " Category:'''FORGET MYSQL ROOT PASSWORD''' 1.Stop the mysql server. /etc/init.d/mysqld stop 2.Start the mysql daemon with –skip-grant-tables option. -- mysqld_saf..."

[[Category:'''FORGET MYSQL ROOT PASSWORD''' ]]

1.Stop the mysql server.

/etc/init.d/mysqld stop

2.Start the mysql daemon with –skip-grant-tables option.
--
mysqld_safe --skip-grant-tables&

3.Login to the server as root user.

[root@alpha ~]# mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.
our MySQL connection id is 1
Server version: 5.0.77 Source distribution
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
4.Reset the mysql root password using the following commands.
--
mysql> use mysql;
mysql> update user set password=PASSWORD("New root pass") where User='root';
mysql> flush privileges;
mysql> quit
--
« Dispersed Storage
Adding multiple virtual network interfaces in Ubuntu »
Reset mysql root password

Sometimes in some situations we forget some important things in their life LOL.So today I’m gonna share how to reset the reset the mysql root password.The steps are here.

1.Stop the mysql server.

/etc/init.d/mysqld stop

2.Start the mysql daemon with –skip-grant-tables option.

mysqld_safe --skip-grant-tables&

3.Login to the server as root user.

[root@alpha ~]# mysql -u root

Welcome to the MySQL monitor. Commands end with ; or \g.

our MySQL connection id is 1

Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>

4.Reset the mysql root password using the following commands.

mysql> use mysql;

mysql> update user set password=PASSWORD("New root pass") where User='root';

mysql> flush privileges;

mysql> quit

5.Stop the mysql daemon and start it again.
/etc/init.d/mysqld stop

/etc/init.d/mysqld start

--[[User:Subhash|Subhash]] 12:52, 29 September 2012 (IST)