Thursday, January 27, 2011

Roundcube webmail passwod plugin

 

Configure plugin password roundcube with ispconfig3 postfix

Please refers to http://www.nixnux.or.id/2010/06/05/howto-configure-plugin-password-roundcube-with-vpopmailmysql-qmailtoaster/
If you want to install roundcube as your webmail interface, please goto http://www.nixnux.or.id/2010/06/05/howto-install-roundcubemail-from-svn-on-ubuntu-lucid-10-04/
This same step with my last article. go…

1. enable it (plugin password)

~]# cd /var/www/roundcube/config
~]# vim main.inc.php

[...]
$rcmail_config['plugins'] = array('password');
[...]

2. Configure it

~]# cd /var/www/roundcube/plugins/password
~]# cp config.inc.php.dist config.inc.php
~]# vim config.inc.php

[...]
$rcmail_config['password_driver'] = 'sql';
$rcmail_config['password_db_dsn'] = 'mysql://ispconfig:$PASSWORD@localhost/dbispconfig';
[...]
$rcmail_config['password_query'] = 'UPDATE mail_user SET password=%c WHERE email=%u LIMIT 1';
[...]

 Database username, password-oo зөв хийх шаардлагатай шүү залуусаа.

Good Luck.

Tuesday, January 25, 2011

Roundcube webmail суулгах

Roundcube webmail суулгах болон өмнө нь суусан вэб  мэйл дээр суулгах 2 жаахан ялгаатай гэхдээ ойролцоо. Энэ удаад ISPConfig дагалдаад суудаг squirrelmail -ийг Roundcube болгох заавар болон зарим нэг анхаарууштай зүйлүүдийг өөрийхөөрөө оруулахыг хичээлээ.

Changing From SquirrelMail To RoundCube On Your ISPConfig3 Server

Step 1.

Дараах командуудыг shell дээр бичнэ.
cd /usr/share
wget http://downloads.sourceforge.net/project/roundcubemail/roundcubemail/0.3.1/roundcubemail-0.3.1.tar.gz?use_mirror=ignum
tar -vxf roundcubemail-0.3.1.tar.gz
rm -fr roundcubemail-0.3.1.tar.gz
cd roundcubemail-0.3.1
rm -fr installer
chmod 755 temp logs
cd config
cp db.inc.php.dist db.inc.php
cp main.inc.php.dist main.inc.php


Step 2.

Бааз үүсгэнэ.
Database name: roundcubedb
Database user: roundcubeuser
Database pass: 12345

Step 3.

Баазаа үүсгэсэн бол roundcube суулгасан байрлалд очиж дараах файлыг нээн баазын тохиргоог хийж өгнө. Жишээ нь:  shell дээр ~$  /usr/share/roundcubemail-0.5/config

Дараах файл нь вэб мэйлын config фолдерт байдаг.

vi db.inc.php
Энэ мөрийг олж дараах байдлаар сольно:
[...]
$rcmail_config['db_dsnw'] = 'mysql://roundcube:pass@localhost/roundcubemail';
[...]
to: энд өөрийн үүсгэсэн баазын нэр, нууц үгийг оруулна.
[...]
$rcmail_config['db_dsnw'] = 'mysql://dbuseName:dbPass@localhost/dbname'; 
[...]

Одоо дараах тохиргооны файлд тохиргоо хийнэ. main.inc.php:
vi main.inc.php
Дараах мөрүүдийг олж засна:
[...]
$rcmail_config['message_cache_lifetime'] = '10d';
[...]
$rcmail_config['default_host'] = '';
[...]
$rcmail_config['smtp_server'] = '';
[...]
$rcmail_config['session_lifetime'] = 10;
[...]
$rcmail_config['create_default_folders'] = FALSE;
[...]
to: default_host -энэ нь таны хостын нэр байна. Үүнийг буруу оруулвал вэб майл чинь IMAP сервертэйгээ холбогдохгүй.
[...]
$rcmail_config['message_cache_lifetime'] = '30m'; 
[...]
$rcmail_config['default_host'] = 'localhost';
[...]
$rcmail_config['smtp_server'] = 'localhost'; 
[...]
$rcmail_config['session_lifetime'] = 30; 
[...]
$rcmail_config['create_default_folders'] = TRUE;
[...]

Step 4.

Үүсгэсэн баазруугаа дараах бичлэгүүдийг нэмнэ. Ингээд table -үүд нь үүснэ.
Дараах файл нь SQL фолдерт байдаг. mysql.initial.sql
ЖНЬ: roundcubemail-0.3.1/SQL/mysql.initial.sql
-- RoundCube Webmail initial database structure
/*!40014  SET FOREIGN_KEY_CHECKS=0 */;
-- Table structure for table `session`
CREATE TABLE `session` (
 `sess_id` varchar(40) NOT NULL,
 `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `ip` varchar(40) NOT NULL,
 `vars` mediumtext NOT NULL,
 PRIMARY KEY(`sess_id`),
 INDEX `changed_index` (`changed`)
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
-- Table structure for table `users`
CREATE TABLE `users` (
 `user_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `username` varchar(128) NOT NULL,
 `mail_host` varchar(128) NOT NULL,
 `alias` varchar(128) NOT NULL,
 `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `last_login` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `language` varchar(5),
 `preferences` text,
 PRIMARY KEY(`user_id`),
 INDEX `username_index` (`username`),
 INDEX `alias_index` (`alias`)
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
-- Table structure for table `messages`
CREATE TABLE `messages` (
 `message_id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
 `del` tinyint(1) NOT NULL DEFAULT '0',
 `cache_key` varchar(128) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL,
 `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `idx` int(11) UNSIGNED NOT NULL DEFAULT '0',
 `uid` int(11) UNSIGNED NOT NULL DEFAULT '0',
 `subject` varchar(255) NOT NULL,
 `from` varchar(255) NOT NULL,
 `to` varchar(255) NOT NULL,
 `cc` varchar(255) NOT NULL,
 `date` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `size` int(11) UNSIGNED NOT NULL DEFAULT '0',
 `headers` text NOT NULL,
 `structure` text,
 PRIMARY KEY(`message_id`),
 INDEX `created_index` (`created`),
 INDEX `index_index` (`user_id`, `cache_key`, `idx`),
 UNIQUE `uniqueness` (`user_id`, `cache_key`, `uid`),
 CONSTRAINT `user_id_fk_messages` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`)
   /*!40008
     ON DELETE CASCADE
     ON UPDATE CASCADE */
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
-- Table structure for table `cache`
CREATE TABLE `cache` (
 `cache_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `cache_key` varchar(128) /*!40101 CHARACTER SET ascii COLLATE ascii_general_ci */ NOT NULL ,
 `created` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `data` longtext NOT NULL,
 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY(`cache_id`),
 INDEX `created_index` (`created`),
 INDEX `user_cache_index` (`user_id`,`cache_key`),
 CONSTRAINT `user_id_fk_cache` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`)
   /*!40008
     ON DELETE CASCADE
     ON UPDATE CASCADE */
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
-- Table structure for table `contacts`
CREATE TABLE `contacts` (
 `contact_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `changed` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
 `del` tinyint(1) NOT NULL DEFAULT '0',
 `name` varchar(128) NOT NULL,
 `email` varchar(128) NOT NULL,
 `firstname` varchar(128) NOT NULL,
 `surname` varchar(128) NOT NULL,
 `vcard` text NULL,
 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY(`contact_id`),
 INDEX `user_contacts_index` (`user_id`,`email`),
 CONSTRAINT `user_id_fk_contacts` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`)
   /*!40008
     ON DELETE CASCADE
     ON UPDATE CASCADE */
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
-- Table structure for table `identities`
CREATE TABLE `identities` (
 `identity_id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
 `del` tinyint(1) NOT NULL DEFAULT '0',
 `standard` tinyint(1) NOT NULL DEFAULT '0',
 `name` varchar(128) NOT NULL,
 `organization` varchar(128) NOT NULL DEFAULT '',
 `email` varchar(128) NOT NULL,
 `reply-to` varchar(128) NOT NULL DEFAULT '',
 `bcc` varchar(128) NOT NULL DEFAULT '',
 `signature` text,
 `html_signature` tinyint(1) NOT NULL DEFAULT '0',
 `user_id` int(10) UNSIGNED NOT NULL DEFAULT '0',
 PRIMARY KEY(`identity_id`),
 CONSTRAINT `user_id_fk_identities` FOREIGN KEY (`user_id`)
   REFERENCES `users`(`user_id`)
   /*!40008
     ON DELETE CASCADE
     ON UPDATE CASCADE */
) /*!40000 ENGINE=INNODB */ /*!40101 CHARACTER SET utf8 COLLATE utf8_general_ci */;
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
За ингээд вэб мэйл бэлэн болно. 

Step 5.

Одоо дараах өөрчлөлтийн хийгээд боллоо.
cd /usr/share
mv squirrelmail squirrelmail.bak
mv roundcubemail-0.3.1 squirrelmail

Step 6.

Finally go to http://www.yourdomain.tld:/webmail and sign in to enjoy this cute Webmail.


Goodluck

Tuesday, January 11, 2011

Ubuntu boot startup error fix

Ubuntu server нь зарим шалтгааны улмаас шууд force байдлаар унтраасан тохиолдолд
асааахад зарам нэг алдаа гараад зогсчихдог тал бий.
Үүний нэг тохиолдлыг засах талаар доор өгүүлье.

Ubuntu 9.10 server - дээр дараах алдаа гарав.
I passed from 9.4 to ubuntu 9.10 to the beginning been all right
everything, but when I restart the pc i found this:
mount of filesystem failed
4c291a-bc0f-49ab-8936-a6e222d5065
A MAITENANCE SHELL WILL NOW BE STARTED
CONTROL-D will terminate this shell and re-try

Үүнийг засах нь:

1. Root - passwordoo оруулаад shell-руугээ орно.
2. fdisk -l
3. fsck командыг сонгоод "yes or y" гэж оруулна.
4. shutdown -r now

за ингээд reboot хийхэд асуудал шийдэгдэнэ гэж найдаж байна.

GOODLUCK

Tuesday, January 4, 2011

IШинэ жилийн баярын мэнд хүргэе.

HAPPY NEW YEAR.

Charlie Bit Me

Эхлээд энийг үзээрэй. Дараа нь доод талынх нь бичлэгийг ккк ... :))