The Unconscious Mind

Free g.729 and g.723.1 codecs

2008-10-21T15:47:00.001+08:00

Download the codecs from http://asterisk.hosting.lv. Separate codecs are available for both g.729 and g.723.1.

Because the free ones are pre-compiled, we'll need to download the correct codec for the Asterisk box. Run cat /proc/cpuinfo and note the output. Look specifically at the model name and the flags, such as:

Process: 0
vendor_id: Genuine Intel
cpu family: 6
model: 8
model name: Pentium III (Coppermine)
stepping: 3
cpu MHz: 648.110
cache size: 256 KB
fdiv_bug: no
hlt_bug: no
f00f_bug: no
coma_bug: no
fpu: yes
fpu_exception: yes
cpuid level: 2
wp: yes
flags: fpu vme de pse tsc msr pae mce cx8 mtrr pge mca cmov pat pse36 mmx fxsr sse
bogomips: 1297.41

From this information we can see that it is a Pentium III processor and it is using sse. This is the 2 bits of required information that we need. If you don’t see sse in your flag then the file you need must contain the words no-sse.

So from the information above to obtain the G729 codec we need to get the file codec_g729-gcc-pentium3.so and for the G723 codec we need to get the file g723-gcc-pentium3.so.

After downloading the codec, store it in /usr/lib/asterisk/modules.

Note: if Asterisk doesn't start, you may need to download the icc versions instead of the 'gcc' ones.

Slimming down Asterisk

2008-10-21T15:45:00.000+08:00

Use the following as a starting point:

[modules]
autoload=no

load => res_indications.so
load => res_features.so
load => res_agi.so
load => res_crypto.so
load => res_musiconhold.so

load => pbx_functions.so
load => pbx_spool.so
load => pbx_loopback.so
load => pbx_config.so

;load => chan_zap.so
load => chan_local.so
load => chan_features.so
load => chan_sip.so

;load => cdr_manager.so
;load => cdr_pgsql.so
load => cdr_addon_mysql.so
load => cdr_csv.so

load => codec_adpcm.so
load => codec_gsm.so
load => codec_a_mu.so
load => codec_ulaw.so
load => codec_alaw.so
load => codec_g726.so

load => format_gsm.so
load => format_wav_gsm.so
load => format_g723.so
load => format_g726.so
load => format_g729.so
load => format_pcm_alaw.so
load => format_pcm.so
load => format_sln.so
load => format_wav.so

load => func_callerid.so

load => app_playback.so
load => app_softhangup.so
load => app_setcidname.so
load => app_milliwatt.so
load => app_macro.so
load => app_verbose.so
load => app_setcdruserfield.so
load => app_read.so
load => app_dial.so
load => app_cdr.so
load => app_cut.so
load => app_echo.so
load => app_setcallerid.so
load => app_readfile.so
load => app_setcidnum.so
load => app_db.so

[global]
chan_modem.so = no

Storage calculation for Recordings

2008-10-21T15:43:00.000+08:00

Basic calculation
Based on self-generated white noise file of 30 seconds, sampled at 8KHz in GSM format:

30 secs requires 49KB space
1 min -> 100KB
1 hr -> 6MB

Assumptions

Operating hours: 9 hours a day, 26 days a month
Phone lines are 100% saturated 100% of the time:
Total hours a month = 30 * 9 * 26 = 7,020 hours of recording
Total server storage capacity = 600GB
OS and applications consume 100GB. Remaining space = 500GB
7,020 hrs -> 42GB, e.g. 1 month requires 42GB storage space

Storage capacity approximations

60GB = 10,000 hours = 416 days' worth of recordings
80GB = 13,333 hours = 555 days' worth of recordings
100GB = 16,666 hours = 695 days' worth of recordings
120GB = 20,000 hours = 832 days' worth of recordings
160GB = 26,666 hours = 1,111 days' worth of recordings
200GB = 33,333 hours = 1,388 days' worth of recordings

Zimbra : Spam & AV

2008-10-21T15:34:00.003+08:00

http://www.zimbra.com/forums/administrators/5286-spam-problems-print.html
http://sietse.net/exoops/modules/Zimbra/#tt030
http://www.howtoforge.com/adding-and-updating-spamassassin-rulesets-with-rulesdujour
http://www.zimbra.com/forums/administrators/2877-spam-accounts-auto-training-error-print.html
http://www.zimbra.com/forums/administrators/1015-solved-howto-update-clamav.html
http://www.zimbra.com/forums/administrators/3743-clamav-upgrade.html#post21195
http://www.clamav.net/download/sources
http://wiki.zimbra.com/index.php?title=Updating_CLAMAV

Senarai Player

2008-06-04T10:33:00.000+08:00

http://www.euro2008.uefa.com/tournament/teams/index.html

Jadual Perlawanan EURO 08

2008-05-26T12:04:00.000+08:00

http://uk.eurosport.yahoo.com/football/euro/2008/fixtures-results/

Syarat & Terma EURO 2008 Yahoo Fantasy Football

2008-05-25T04:54:00.004+08:00

Aku dah menterjemahkan syarat dan terma untuk permainan fantasi ini kepada kurang memahami Bahasa London. Ye la kan, karang kalau dapat point kurang mula la nak bagi alasan, tak tahu syarat la, cikgu bahasa inggeris mati la, sibuk bercinta masa kelas bahasa inggeris la, berangan nak masuk pertandingan raja lawak la dan mcm2 lagi.
Jadi inilah dia:

Syarat dan Terma

THE GAME

Pilih skuad anda dengan membelanjakan badget sebanyak 200 juta pound.
Kami telah menetapkan harga tertentu kepada setiap pemain.
Pasukan anda akan diberi mata bergantung kepada kecemerlangan pemain pada akhir setiap perlawanan.
Anda boleh ganti pemain atau merombak skuad anda selepas itu.

Permainan ini adalah mengikut perlawanan sebenar. Banyak hadiah menanti anda sepanjang berlangsungnya EURO.

SKUAD ANDA

Pembetukkan skuad
Telitikan senarai pemain-pemain yang telah disenaraikan terlebih dahulu dan bentuk skuad anda dengan syarat-syarat yang ditetapkan:

Badget anda ialah 200 juta pound.

Skuad mestilah mempunyai seramai 14 pemain dan tidak melebihi 21 pemain.

Barisan pemain di dalam skuad:
Anda boleh menukar barisan pemain diantara perlawanan, dimana timbulnya isu kurang perform, injured dan sebagainya dengan pencaturan skuad yang sedia ada.
Andainya lebih dari satu pemain yang digugurkan, anda boleh membeli pemain baru dari Transfer Market.
Anda boleh menukar barisan skuad 15 minit sebelum sepak mula. Mata akan diberikan pada setiap akhir perlawanan.

Jadual perlawanan:
Perlawanan ini dibahagikan kepada 6 fasa. Penukaran pemain boleh dibuat pada bila-bila masa.

Fasa 1 : June 07-10, 2008 - Group phase I
Fasa 2 : June 11-14, 2008 - Group phase II
Fasa 3 : June 15-18, 2008 - Group phase III
Fasa 4 : June 19-22, 2008 - Quater final
Fasa 5 : June 25-26, 2008 - Semi final
Fasa 6 : June 29, 2008 - Final

Pilihan Formasi:
Anda boleh memilih formasi formasi yang telah ditetapkan seperti berikut:
* 3-4-3
* 4-3-3
* 3-5-2
* 4-4-2

Pengiraan mata:
Penjumlahan mata akan dibuat pada setiap keesokan pagi selepas akhir perlawanan pada hari itu.

Kapitan:
Anda boleh menentukan salah seorang pemain sebagai kapten dari kotak di sebelah kanan iaitu diatas senarai pemain simpanan anda.
Anda boleh menukar kapten anda pada bila-bila masa. Mata yang diperolehi oleh kapten akan digandakan.

Transfer market:
Anda boleh membentuk dan membeli pemain dari Transfer Market tanpa had.

Liga Persendirian:
Perbezaan mata bagi 5 pemain terbaik yang dikumpulkan oleh pemain didalam liga persendirian akan diambil kira dan dijumlahkan untuk menetapkan ranking keseluruhan liga-liga persendirian.
Jadi sama-sama la kita berjuang untuk liga kita iaitu liga Malaysia Gemilang.

Pengiraan Mata:
Attacking:
Gol : 7 (+3 untuk Shot on Target = 10)
Assist : 4
Gol Kemenangan : +2
Set-Piece Gol : +3
Shot on Target : 3
Cross yang berjaya : 1
Perolehan Foul : 1
Perolehan Corner : 1
Kegagalan Penalti/Save : -5

Defending/Disiplin:
Blocked Shot : 2
Mencelah passing : 1
Tackle yang berjaya : 1
Permainan Bersih : 4
Last-man Saving Tackle : 2
Foul : -1
Bagi Penalti : -3
Own Gol : -3
Kad kuning : -3
Kad merah : -6

Golkeeper:
Menang : 4
Kalah : -2
Seri : 1
Save : 2
Save Penalti : 6
Permainan Bersih : 5
Gol Bolos : -3
Lompat 1 inci macam Ayen : -10

Sesi Soal Jawab:

S: Berapa bayaran yang dikenakan untuk penyertaan?
J: Penyertaan adalah PERCUMA.

S: Adakah harga bagi pemain akan meningkat sepanjang waktu pertandingan?
J: Tidak

S: Berapakah harga bagi pemain bila saya menjualnya?
J: Anda akan menjual pada harga yang sama seperti yang dibeli.
Bermakna anda tidak akan untung atau rugi sewaktu sesi jual beli.
Contohnya: Kalau anda beli Eddie pada harga 38juta pound anda akan
menerima 38juta pound juga jika anda menjualnya. Tapi rugi jual dia,
sebab dia terer giler.

S: Adakah saya akan menerima duit tambahan sepanjang waktu pertandingan?
J: Tidak

S: Adakah pemain simpanan akan mendapat mata?
J: Mungkin. Anda perlu membeli pemain untuk setiap posisi (Goli,
Defender, Midfield, Attack). Seandainya salah seorang pemain kesebelasan utama tidak mendapat mata, pemain simpanan akan mengambil alih dan diberikan mata.

S: Bagaimana nak tahu berapakah mata yang diperolehi oleh pemain saya?
J: Pilih "Previous Match Day" apabila anda melihat skuad anda.

S: Bolehkah saya memerhatikan mata bagi perlawanan?
J: Ya, boleh. Boleh blah!! Klik sini: http://uk.eurofantasyfootball.yahoo.net/app/wertung.jsp

S: Apa akan terjadi apabila ada pasukan yang terkeluar?
J: Tiada apa-apa. Cuma, tiada mata selanjutnya bagi pemain pasukan itu. Jika anda memiliki pemain sedemikian, cepat-cepat la gantikan pemain itu.

S: Adakah saya akan mendapat mata tambahan kalau pemain cuma memperagakan jersey dan gaya rambut tanpa berlari sewaktu perlawanan?
J: Sudah tentu TIDAK. Cepat-cepat la jual pemain seperti itu.

S: Adakah Gol keeper akan mendapat mata tambahan jika baju masuk dalam dan memakai jersey yang terang?
J: Sudah tentu.

S: Bolehkah pemain membawa masuk beg plastik beras cap masjid ke padang?
J: Sudah tentu. Beras mahal sekarang ni.

HP Embedded G5 SATA RAID Controller Driver Diskette for SUSE LINUX Enterprise Server 10 (AMD64/EM64T)

2008-03-31T14:25:00.001+08:00

This driver diskette image provides the binary driver modules pre-built for SUSE LINUX Enterprise Server 10 (AMD64/EM64T) to enable the HP Embedded G5 SATA RAID Controller.
Download the driver at HP's website here:

Installation:

To install SUSE Linux Enterprise Server 10 (AMD64/EM64T), use 'aarahci.sles10.x86_64.img' file.

To install SUSE Linux Enterprise Server 10 SP1 (AMD64/EM64T), use 'aarahci.sles10sp1.x86_64.img' file.

CREATING THE DISKETTE

Save the "aarahci.{distro}.{buildtype}.img" file into a temporary directory.

To make a diskette under Linux (or any other Linux-like operating system), you must have permission to write to the device representing a 3.5-inch diskette drive (known as /dev/fd0 under Linux).

First, label a blank, formatted diskette appropriately. Insert the diskette into the floppy drive, but DO NOT issue the mount command:

# dd if=aarahci.sles10sp1.x86_64.img of=/dev/sda bs=1440k

This command creates a diskette containing the image of the input file (Driver Diskette image) to an output file (Floppy Diskette). To make another diskette run the same "dd" command again.

INSTALLATION

To install Linux using this driver diskette, follow the below instructions:

Boot from the SUSE LINUX Enterprise Server 10 disc 1.
A list of options will appear in a menu list for 20 seconds. You must
select Installation, press F6 for Driver Update and then press Enter.
Insert the driver diskette when prompted. Press Enter.
A dialog will be presented with the message
Please choose the Driver Update Medium.
From the menu list, select fd0 (floppy), select the OK button and
press Enter.
The driver diskette will be scanned and you will see the following messages -
Reading the Driver Update...
Driver Update OK.
Press Enter.
The dialog in step 4 will reappear. Select Back and press Enter.

mpg123 compile error on 64bit system

2008-03-31T14:00:00.004+08:00

decode_i586.s:44: Error: suffix or operands invalid for `push'

The mpg123 patch for amd64 can be found here: www.lanvik-icu.com/mpg123-0.59r-amd64.diff.txt

Download it into a clean mpg123-0.59r directory.
cd into the directory

Code:

user@box: patch < mpg123-0.59r-amd64.diff
user@box: make linux-x86_64

MySql >= 4.1 Client does not support authentication protocol

2008-03-07T12:49:00.002+08:00

If you upgrade your MySql server to >= 4.1 you might get the following error:
- Client does not support authentication protocol requested by server; consider upgrading MySQL client

This happens because the latest versions of MySql uses a new format for the password (it's a longer hash). In order for old clients to continue to use the newer server, you have to set the passwords on the server to their old format or upgrade your client. Because upgrading the client can sometimes be a pain, it's often easier to just update the passwords to the old format on the server.

Run mysql and login as root:

mysql -u root -p

Then, paste the following command, editing as necessary, to change the password of the user to the old format.

UPDATE mysql.user
SET password=OLD_PASSWORD('somepassword')
WHERE user='someuser'
AND host='somehost';

After you have set the passwords to the old format, flush the tables.
flush privileges;

Then exit the mysql client with "quit" and you are set.

Samba PDC without roaming profiles

2008-02-13T16:57:00.004+08:00

To disable roaming profiles so that client pc's don't take a long time to login & logoff on a Samba PDC network:

Start/Run/gpedit.msc
Local Computer Policy/Computer Configuration/Administrative Templates/System/User Profiles

Enable both the "Prevent Roaming Profile changes from propagating to the server" setting and the "Only allow local user profiles" setting.

Note: If enabled, user profiles won't be copied to the Samba PDC server.

Setting Up a Secure Apache 2 Server

2007-12-10T15:04:00.000+08:00

http://www.informit.com/articles/article.aspx?p=30115&seqNum=1

Requirements
openssl-0.9.7g-2.12
openssl-devel-0.9.7g-2
httpd-2.0.58

Configuring Apache
#./configure --enable-module=so --enable-ssl --with-ssl=/usr/include/openssl
#make
#make install
#/usr/local/apache2/bin/httpd -l (to list available modules

Creating a Key Pair
#openssl req -new -key www.example.com.key -out www.example.com.csr
#openssl genrsa -des3 -out www.example.com.key 1024

to backup key (optional):
#./usr/local/ssl/bin/openssl rsa -noout -text -in www.example.com.key

Creating a Self-Signed Certificate
#openssl x509 -req -days 30 -in www.example.com.csr -signkey www.example.com.key -out www.example.com.cert

# chmod 400 www.example.com.key

Edit /usr/local/apache2/conf/ssl.conf
Listen 80
Listen 443
ServerName http://www.example.com
SSLEngine on
SSLCertificateFile \
/etc/ssl/certs/www.example.com.cert
SSLCertificateKeyFile \
/etc/ssl/certs/www.example.com.key

Starting the server
#/usr/local/apache2/bin/apachectl startssl

asterisk + mySQL table = refined

2007-12-06T16:16:00.000+08:00

You have two options in /usr/src/asterisk-addons:
1. Add CFLAGS+=-DMYSQL_LOGUNIQUEID to the Makefile.
2. Add a #define MYSQL_LOGUNIQUEID to the top of cdr_addon_mysql.c.

- perform the usual make clean, make, make install.

Table definitions for Asterisk cdr_mysql

Create the database
mysql --user=root --password=password -h dbhost

CREATE DATABASE asterisk;

GRANT INSERT
ON asterisk.*
TO asterisk@localhost
IDENTIFIED BY 'yourpassword';

(Remote MySQL server permissions)
GRANT INSERT
ON asterisk.*
TO asterisk@localhost
IDENTIFIED BY 'yourpassword';

USE asterisk;

CREATE TABLE `cdr` (
`calldate` datetime NOT NULL default '0000-00-00 00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`dcontext` varchar(80) NOT NULL default '',
`channel` varchar(80) NOT NULL default '',
`dstchannel` varchar(80) NOT NULL default '',
`lastapp` varchar(80) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`duration` int(11) NOT NULL default '0',
`billsec` int(11) NOT NULL default '0',
`disposition` varchar(45) NOT NULL default '',
`amaflags` int(11) NOT NULL default '0',
`accountcode` varchar(20) NOT NULL default '',
`uniqueid` varchar(32) NOT NULL default '',
`userfield` varchar(255) NOT NULL default ''
);

ALTER TABLE `cdr` ADD INDEX ( `calldate` );
ALTER TABLE `cdr` ADD INDEX ( `dst` );
ALTER TABLE `cdr` ADD INDEX ( `accountcode` );

/etc/asterisk/cdr_mysql.conf
[global]
hostname=192.168.10.5
dbname=asterisk
table=cdr
password=asterisk
user=asterisk
port=3306
sock=/var/lib/mysql/mysql.sock
;userfield=1

/etc/asterisk/modules.conf
load => cdr_addon_mysql.so
[global]

genksyms not found on 64bit kernel

2007-12-06T16:12:00.000+08:00

http://folk.uio.no/oeysteio/orinoco-usb/building.html

$ cd /lib/modules/$(uname -r)/
$ rm build
$ ln -s source build
$ cd build/
$ su
(root password)
$ make mrproper
$ make cloneconfig
$ make prepare-all

Important: You must change

make prepare-all

make prepare scripts


if you get an error similar to:
/bin/sh: scripts/genksyms/genksyms: No such file or directory

Required CPAN Modules for Mon

2007-10-17T12:59:00.000+08:00

#perl -MCPAN -e shell
cpan>install Time::Period
cpan>install Time::HiRes
cpan>install Convert::BER
cpan>install Mon::Protocol
cpan>install Mon::SNMP
cpan>install Mon::Client

And, depending upon what you want to monitor, you may also wish to install the following optional modules:
cpan>install Filesys::DiskSpace
cpan>install Net::Telnet
cpan>install Net::LDAPapi
cpan>install Net::DNS
cpan>install SNMP

Creating GSM files with SOX

2007-09-28T13:46:00.000+08:00

# sox inputfile.wav -r 8000 -c 1 output.gsm resample -ql

Null Modem for High Availability

2007-09-26T15:07:00.000+08:00

Null modem cable pin mapping
This is one very common mapping which will work with software that relies on proper assertion of the CD signal.

Signal Name	DB-25 Pin	DE-9 Pin		DE-9 Pin	DB-25 Pin
FG (Frame Ground)	1	-	X	-	1	FG
TD (Transmit Data)	2	3	-	2	3	RD
RD (Receive Data)	3	2	-	3	2	TD
RTS (Request To Send)	4	7	-	8	5	CTS
CTS (Clear To Send)	5	8	-	7	4	RTS
SG (Signal Ground)	7	5	-	5	7	SG
DSR (Data Set Ready)	6	6	-	4	20	DTR
CD (Carrier Detect)	8	1	-	4	20	DTR
DTR (Data Terminal Ready)	20	4	-	1	8	CD
DTR (Data Terminal Ready)	20	4	-	6	6	DSR

#Use 1-4 & 4-1 for 9 pin HA null modem.

File Descriptors vs Linux Performance

2007-09-26T15:01:00.001+08:00

To increase OS system-wide file descriptors limit

http://bloggerdigest.blogspot.com/2006/10/file-descriptors-vs-linux-performance.html

Set both the hard limit and soft limit of file descriptors, to as maximum as possible, to either all (the asterisk in first column) or individual user login account (replace the asterisk in the first column to the user login account)

Modify /etc/security/limits.conf by appending or amending these line

@root soft nofile 1024

@root hard nofile 4096
to
@root soft nofile 100000
@root hard nofile 102400

Zimbra: Daily mail report always reports "No messages found"

2007-09-21T15:06:00.000+08:00

http://www.zimbra.com/forums/installation/3332-daily-mail-report-always-reports-no-messages-found.html
http://www.zimbra.com/forums/27508-post20.html

zmloggerinit is probably not what you wanted to do. In either case you'll most likely need to run it again, but first remove the logger db files.

Code:

% su - zimbra
% rm -rf logger/db
% zmloggerinit

That will get you back to a functioning state.
The logger db was either not competely initialized or the database got corrupted somehow (did your disk fill up?). You can reset it with the above commands or try to recover the raw_logs table by logging into the logger db and running repair table raw_logs; You'll need the logger_root_passwd from zmlocalconfig.

Ghostscript

2007-08-10T12:28:00.000+08:00

Most Linux users have Ghostscript, and Ghostscript is supposed to be
able to append PDFs. The way it works is that it "prints" the files in
sequence, but directs them to a loopback type of printer driver that
actually generates a new PDF. Here's the command:

gs -q -sPAPERSIZE=letter -dNOPAUSE -dBATCH -sDEVICE=pdfwrite
-sOutputFile=out.pdf in1.pdf in2.pdf in3.pdf ...

Make appropriate substitutions for different paper sizes (apparently
nobody in North America has ever wanted to do this, because other
examples on the Web invariably specify A4 paper), filenames, etc. I've
found this technique to work quite well. Unfortunately, it caused
Ghostscript to die with a segfault on some of the input I wanted to run
it with, and nothing I could do would get it to process some of those files.

Cannot Load Zaptel module because crc_ccitt table not found

2007-08-02T15:00:00.000+08:00

This is because you are missing the crc_ccitt library routine.
Go to /lib/modules/$(uname -r)/build
type:

#>make menuconfig

In the ncurses utility,
Go to Library routines
Include:
CRC-CCITT functions
(save) and (exit)

to build modules, type:
make modules

This will rebuild all your modules, including crc-ccitt. After you are done, the crc-ccitt module will be located in ./lib

copy the crc-ccitt.ko (for 2.6 kernels) or crc-ccitt.o (for 2.4 kernels)to /lib/modules/$(uname -r)/kernel/lib/

Installing Wanpipe on SuSe

2007-08-02T14:56:00.000+08:00

(Only for the version before 10.1)
http://sangoma.editme.com/wanpipe-linux-asterisk-appendix#WanpipeOnSuse

The wanpipe drivers assume the kernel source is located in /lib/modules/$(uname -r)/build. and in SuSe, this symbolic link points to the headers only. There is a symbolic link in /lib/modules/$(uname -r)/source that points to the kernel source.

To compile on SuSe:

1. Apply the current kernel configuration.
Copy .config file from headers to source

#>cp /lib/modules/$(uname -r)/build/.config /lib/modules/$(uname -r)/source/.config

Set the symbolic link in /lib/modules/$(uname -r)/build to point to the kernel source
#>cd /lib/modules/$(uname -r)
#>mv build build_old
Find the location of your source:
#>ls -al source
It will look like this: source -> /usr/src/linux-2.6.11.4-20a (adjust for your current kernel version)
Create a symbolic link toyour kernel source with name build
#>ln -s /usr/src/linux-2.6.11.4-20a build
Update current configurations from the .config file
#>cd build
#>make menuconfig
#>make prepare-all

SIPp

2007-07-13T14:36:00.000+08:00

SIPp is a free Open Source test tool / traffic generator for the SIP protocol.
http://sipp.sourceforge.net/

Run:
sipp -sn type -d duration(sec) -s test number SIP Server -l calls -i Local IP
sipp -sn uac -d 30000 -s 500 192.168.10.229 -l 5 -i 192.168.10.5

Building Apache + PHP4

2007-07-13T11:38:00.000+08:00

Apache2:
./configure --enable-module=so
make
make install

PHP:
./configure --with-apxs2=/usr/local/apache2/bin/apxs --with-pgsql --with-mysql --with-zlib --enable-calendar
make
make install

Set up environment and apache:
cp php.ini-dist /usr/local/lib/php.ini
cd /usr/local/apache2/conf
vi httpd.conf

add:
AddType application/x-httpd-php .php

Unique ID in asterisk & mySQL

2007-07-13T11:01:00.000+08:00

Storing the Unique ID

Q: It would appear that the "uniqueid" field is not being populated in the MySQL CDR DB. Is this an obsolete field or is a bug?

A: You need to define MYSQL_LOGUNIQUEID at compile time for it to use that field.

You have two options in /usr/src/asterisk-addons:
1. Add CFLAGS+=-DMYSQL_LOGUNIQUEID to the Makefile.
2. Add a #define MYSQL_LOGUNIQUEID to the top of cdr_addon_mysql.c.

Finally perform the usual make clean, make, make install. Be sure to check the Makefile for the presence of this flag after having done a CVS update! You will most probably also want to index the uniqueid field in your cdr table to improve performance.

You will also have to add a `uniqueid` column in your mysql database after the `accountcode` column:
ALTER TABLE `cdr` ADD `uniqueid` VARCHAR(32) NOT NULL default '' after `accountcode`;

What would I need all this for? For example you are running an AGI script and would like to be able to related AGI data with the CDR table. The problem is that the AGI script will lose connection to the call as soon as the caller hangs up, so you'll need a way to find the correct cdr entry (that'll also be created only after the call has been completed).

Asterisk + MySQL

2007-07-11T16:38:00.000+08:00

http://www.voip-info.org/wiki-Asterisk+cdr+mysql

Asterisk can store CDR records in a MySQL database, as an alternative to CSV text files and other database formats.

Due to Mysql client libraries licensing, the Mysql billing application is no longer an integrated part of the Asterisk standard distribution. It is now located in the asterisk-addons CVS directory.

You must have mysql and mysql-devel packages installed.

Compile

# cd asterisk-addons-1.2
# make clean
# make
# make install

A sample configuration file, can be found on the cdr_mysql.conf page.

Copy the sample configuration file to /etc/asterisk/cdr_mysql.conf and edit it according to your requirements. Then edit your modules.conf to load cdr_addon_mysql.so and finally restart asterisk; before the restart you should, however, check that your cdr table has been created correctly and is accessible to the username and password you specified.

Table definitions for Asterisk cdr_mysql

Create the database
mysql --user=root --password=password -h dbhost

CREATE DATABASE asterisk;

GRANT INSERT
ON asterisk.*
TO asterisk@localhost
IDENTIFIED BY 'yourpassword';

(Remote MySQL server permissions)
GRANT INSERT
ON asterisk.*
TO asterisk@localhost
IDENTIFIED BY 'yourpassword';

USE asterisk;

CREATE TABLE `cdr` (
`calldate` datetime NOT NULL default '0000-00-00 00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`dcontext` varchar(80) NOT NULL default '',
`channel` varchar(80) NOT NULL default '',
`dstchannel` varchar(80) NOT NULL default '',
`lastapp` varchar(80) NOT NULL default '',
`lastdata` varchar(80) NOT NULL default '',
`duration` int(11) NOT NULL default '0',
`billsec` int(11) NOT NULL default '0',
`disposition` varchar(45) NOT NULL default '',
`amaflags` int(11) NOT NULL default '0',
`accountcode` varchar(20) NOT NULL default '',
`userfield` varchar(255) NOT NULL default ''
);

ALTER TABLE `cdr` ADD INDEX ( `calldate` );
ALTER TABLE `cdr` ADD INDEX ( `dst` );
ALTER TABLE `cdr` ADD INDEX ( `accountcode` );

/etc/asterisk/cdr_mysql.conf
[global]
hostname=192.168.10.5
dbname=asterisk
table=cdr
password=asterisk
user=asterisk
port=3306
sock=/var/lib/mysql/mysql.sock
;userfield=1

/etc/asterisk/modules.conf
load => cdr_addon_mysql.so
[global]

SuSE display grub loader

2007-05-17T15:24:00.000+08:00

/boot/grub/menu.lst

###Don't change this comment - YaST2 identifier: Original name: linux###
title openSUSE 10.2
root (hd0,1)
kernel /boot/vmlinuz-2.6.18.2-34-default root=/dev/hda2 vga=0x314 resume=/dev/hda1 splash=silent showopts
initrd /boot/initrd-2.6.18.2-34-default

Change to:
vga=0x317

How do I set up my themes to run automatically on startup?

2007-04-27T17:34:00.000+08:00

[Desktop Entry]
Exec=superkaramba {location of theme file}.theme
Name={theme name}
Type=Application
X-KDE-StartupNotify=false

Then save it as {theme}.desktop into /home/{user}/.kde/Autostart/.

Backup Solution

2007-04-24T13:28:00.000+08:00

Bacula® - The Network Backup Solution
Amanda - The Advanced Maryland Automatic Disk Archiver

Split DNS

2007-04-24T10:41:00.000+08:00

Installations of Zimbra behind a firewall often require the creation of some form of split DNS. This is because the Postfix mail system used by Zimbra performs a DNS lookup when attempting to route email to the back-end message store. Frequently, this is the same physical host as Postfix. The DNS server frequently returns the external address of the mail host, not the internal address. Depending on how the firewall and network are configured, the external address may not even be reachable from the mail host, and mail will not be delivered.

A Split DNS avoids this problem by providing an internal DNS server that can be used to resolve the internal address of the server. This guide will detail how to set up a very specific, single-host DNS server that can be installed on the Zimbra host itself so that it can resolve its own address. This should not be used for a multi-node Zimbra installation, and should not be used as the DNS server for any other hosts on your network.

http://wiki.zimbra.com/index.php?title=Split_dns

Zimbra Docs

2007-04-24T10:36:00.000+08:00

Wiki
Documentation Links
Forum

Verify Zimbra Server Operation

2007-04-18T16:41:00.000+08:00

To verify that the server is running:

1.	Type su - zimbra.

2.	Type zmcontrol status. The services status information is displayed. All services should be running.

Note: If services are not started, type zmcontrol start.

See the CLI Command appendix in the Administration Guide for more zmcontrol commands.

dvd burning

2007-04-09T14:05:00.000+08:00

Burn data file to DVD:
growisofs -Z /dev/dvdrecorder -R -J /home/file-name

Merge a new session to an existing one:
growisofs -M /dev/dvdrecorder -R -J /home/file-name

Blanking a rewritable DVD:
growisofs -Z /dev/dvdrecorder=/dev/zero

enabling xgl

2007-04-05T17:11:00.000+08:00

Xgl is not activated automatically when we install it. To turn it on, run the "Desktop Effects" control panel. (Available from the Control Center in GNOME, or by running the command "gnome-xgl-settings" from a terminal or the Run dialog in KDE.)

http://en.opensuse.org/Using_Xgl_on_SUSE_Linux#Using_and_Configuring_Compiz

ISP Server Setup - OpenSUSE 10

2007-04-03T16:30:00.000+08:00

http://www.howtoforge.com/perfect_setup_suse_10.0

ISPConfig

2007-04-03T16:27:00.000+08:00

ISPConfig is an open source hosting control panel for Linux. ISPConfig is licensed under BSD license.
http://www.ispconfig.org

How do I change my MySQL password?

2007-03-28T15:19:00.000+08:00

At the "mysql>" prompt, type:

set password = password("yournewpassword");

How to install perl module

2007-03-28T15:10:00.000+08:00

# export LANG=en_US
# perl -MCPAN -e shell
cpan> o conf prerequisites_policy ask
cpan> install Mail::SpamAssassin
cpan> q

MYSQL Installation & Configuration

2007-03-27T12:16:00.000+08:00

Taken from : http://www.postfixvirtual.net/mysqlinstall.html

# cd /usr/local/src
#wget -c http://mysql.he.net/Downloads/MySQL-4.0/mysql-4.0.24.tar.gz
Create mysql user and group
#groupadd mysql
#useradd -g mysql mysql
Unpack mysql archive
# tar -zxf mysql-4.0.24.tar.gz
#cd mysql-4.0.24/
Configure mysql with /usr/local/mysql base directory
#./configure --prefix=/usr/local/mysql
Build source files
#make
Install compiled files to the directory specified in prefix
#make install
Mysql uses a configuration file to determine some parameters on startup. It must be modified depending on your machine's capacity. Copy mysql configuration file and startup script for a medium sized system to /etc/my.cnf . Read my-*.cnf files for your own system on the untarred location of MySQL. Those files allow you to chose which file to use for your system.
#mkdir /etc/mysql/
#cp support-files/my-medium.cnf /etc/mysql/my.cnf
#cp support-files/mysql.server /etc/init.d/
#chmod 755 /etc/init.d/mysql.server
Go to base directory and create MySQL grant tables with mysql user (If this MySQL is your second
MySQL installation in your linux, defaults-file variable can be set to your new conf file)
#cd /usr/local/mysql
#bin/mysql_install_db --user=mysql
Change ownership of binaries to root and ownership of data directory to mysql user
#chown -R root .
#chown -R mysql var
#chgrp -R mysql .
Introduce new libraries to our Linux
#echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf
#ldconfig Start MySQL daemon
#/etc/init.d/mysql.server start
Connect to the MySQL server and give mysql root password. Since, there is no default root password
Please pay attention to this part, I have seen many who don't give any root password to their servers.
#/usr/local/mysql/bin/mysql -u root

SET MYSQL PASSWORD

mysql> use mysql;
mysql> update user set password=Password('1234') where user='root';
mysql> flush privileges;
mysql>\q

CREATE PATH VARIABLES

#PATH=$PATH:/usr/local/mysql/bin
#export PATH
#echo "PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile
#echo " export PATH" >> /etc/profile

MySQL is ready congratulations...

create multiple directories in one step

2007-03-26T16:41:00.000+08:00

#mkdir -p /usr/local/bind/{etc,namedb,dev,var/run}

(The above command creates all necessary directories in one step - You can use curly brackets for this purpose)

Backup and Restore Mysql Database using Mysqldump

2007-03-26T11:08:00.001+08:00

Below are mysqldump commands for backup and restore mysql database:

UNIX / LINUX

Backup:
mysqldump --opt --user=username --password database > dumpfile.sql

Restore:
mysqldump --opt --user=username --password database < dumpfile.sql
Notes:
- dumbfile.sql contains SQL command for creating tables and data. (CREATE,INSERT,DROP etc.)

Picasa Web Album

2007-03-23T16:23:00.000+08:00

Created web album:

http://picasaweb.google.com/galasura/

1st Entry

2007-03-22T11:42:00.000+08:00

I created this blog so I can keep track the things which cross over my mind and works I'm working on.