Notes – Cheat Sheet

ACT to MP3 converter:

http://code.google.com/p/amv-codec-tools/

[wine] ffmpeg.exe -f act -i input.act -ar 48000 output.mp3


Fast index on MyISAM tables.

1) $ mysqladmin flush-tables -u a_db_user -p
2) sudo myisamchk –keys-used=0 -rq /var/lib/mysql/dbName/tblName
3) Adat betőltése INSERT / LOAD DATA INFILE stb
4) Indexek újraépítése : sudo myisamchk –key_buffer_size=1024M –sort_buffer_size=1024M -rq /var/lib/mysql/dbName/tblName
5) mysqladmin flush-tables -u a_db_user -p

Forrás: https://wiki.rice.edu/confluence/display/~as43/Make+LOAD+DATA+INFILE+run+even+faster+for+a+MyISAM+table


php5-curl final url after redirect or post:
$final_url curl_getinfo($ch, CURLINFO_EFFECTIVE_URL);


Asterisk 1.6.2.9 + Mysql Install

apt-get -y install build-essential automake autoconf bison flex libtool libncurses5-dev libssl-dev subversion svn-buildpackage cvs libncurses5-dev libssl-dev libgsm1 libgsm1-dev sysvinit-utils libmysqlclient-dev lamp-server^ phpmyadmin libmysqld-dev curl libcurl4-openssl-dev php5-curl nano libmysqlclient16 mysql-common libbluetooth-dev

wget http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-1.6.2.9.tar.gz

./configure –disable-xmldoc
make
make install

wger http://downloads.asterisk.org/pub/telephony/asterisk/releases/asterisk-addons-1.6.2.4.tar.gz
./configure
make menuselelct
make
make install

BT : chan_mobile.c
BUG FIX
— chan_mobile.c (revision 283172)
+++ chan_mobile.c (working copy)
@@ -1381,7 +1381,7 @@
memset(&addr, 0, sizeof(addr));
addr.rc_family = AF_BLUETOOTH;
bacpy(&addr.rc_bdaddr, &src);
- addr.rc_channel = (uint8_t) 1;
+ addr.rc_channel = (uint8_t) 0;
if (bind(s, (struct sockaddr *)&addr, sizeof(addr)) < 0) {
ast_debug(1, "bind() failed (%d).\n", errno);
close(s);

!!! FONTOS !!!

Context nem DB name

extconfig.conf
----------------------------------------
extensions => mysql,general,extensions ; SIP extensions

res_mysql.conf
—————————————-
[general]
.
dbstuff
.

MINDEN VÉLEMÉNY SZÁMÍT!

Email cím (nem tesszük közzé) A kötelezően kitöltendő mezőket * karakterrel jelöljük

A következő HTML tag-ek és tulajdonságok használata engedélyezett: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>