Archive

Archive for July, 2010

Upgrading Kalkun 0.1.4 to 0.2

July 30, 2010 6 comments

On Kalkun 0.2 current release, there’s no way to upgrade from previous version (0.1.4).
Because there is lots of change, and my file management is really bad :(, i can’t remember what changes on it.

But, somehow, i need to upgrade my previous Kalkun installation on the client side. And some users (including me) really need this upgrade feature, so i’ve create patch based on 0.2 version. But it’s not highly tested, need your feedback, if everything goes fine, i’ll add it to current release.

So, here it is.

WARNING: I suggest to backup kalkun app and database before do this upgrade in case something bad happen.

Download Upgrade-0.1.4-to-0.2 patch file, place it on the top of your Kalkun folder.

Then, go to Kalkun root folder, and run the patch:

$ patch -p1 < Upgrade-0.1.4-to-0.2.patch

If, everything goes fine, you should see this message:

patching file media/db/upgrade.sql
patching file system/application/controllers/install.php
patching file system/application/views/main/install/database_setup.php
patching file system/application/controllers/install.php

Finally, open up your browser and go to Kalkun, install as usual, but on Database setup phase you should see like this one, choose Upgrading from 0.1.4 button:

That’s it, have fun with Kalkun 🙂

Advertisements
Categories: kalkun, Tips 'n trick Tags:

Using gammu-smsd with multiple phone

July 27, 2010 57 comments

This mini tutorial will show you how to use gammu-smsd with multiple modem.

The idea of using multiple modem is you want to have backup on your system, or you want to use some scheduler where the first modem work on the day and the second one works on the night, or anything else, it’s depends on your need.

In this implementation, i’m using gammu 1.28 (compilled with MySQL support) and my modem is Sierra Wireless Aircard 881 and Wavecom Fasttrack Supreme WM20392.

OK, now let’s create smsdrc config for these two modem. You can put it anywhere, i’m choosing /etc/.smsdrc-sierra and /etc/.smsdrc-fasttrack.

This is /etc/.smsdrc-sierra configuration:

[gammu]
device = /dev/tty.sierra05
connection = at115200

[smsd]
service = MYSQL
PIN = 1234
logfile = /etc/.smsdlog-sierra
debuglevel = 255
phoneid = sierra

user = root
password = password
pc = localhost
database = kalkun

And /etc/.smsdrc-fasttrack configuration:

[gammu]
device = /dev/tty.PL2303-0000101D
connection = at115200

[smsd]
service = MYSQL
PIN = 1234
logfile = /etc/.smsdlog-fasttrack
debuglevel = 255
phoneid = fasttrack

user = root
password = password
pc = localhost
database = kalkun

Now, you can run each daemon by passing configuration parameter on it:

$ gammu-smsd -c /etc/.smsdrc-sierra

and

$ gammu-smsd -c /etc/.smsdrc-fasttrack

As you can see, the configuration for this two modem is almost the same, except for one thing, phoneid. phoneid is the key, it’s unique string for every modem you’ve configured. So, if you want to send sms through the first modem (in this case, it’s sierra), you have to specified this in your CreatorID and SenderID field on outbox parameter, for example the SQL statement should be something like this:

INSERT INTO outbox (DestinationNumber, TextDecoded, SenderID, CreatorID, Coding) VALUES (‘123456’, ‘Hi, this is sierra.’, ‘sierra’, ‘sierra’, ‘Default_No_Compression’);

Or you can easily do that with gammu-smsd-inject:

$ gammu-smsd-inject -c /etc/.smsdrc-sierra TEXT 123456 -text “Hi, this is sierra.”

Where 123456 is your destination number, you’ve to change it.

So, if you want to send sms over the second modem (in this case, fasttrack), it’s should be like this:

INSERT INTO outbox (DestinationNumber, TextDecoded, SenderID, CreatorID, Coding) VALUES (‘123456’, ‘Hi, this is fasttrack.’, ‘fasttrack’, ‘fasttrack’, ‘Default_No_Compression’);

Or, if you are using gammu-smsd-inject:

$ gammu-smsd-inject -c /etc/.smsdrc-fasttrack TEXT 123456 -text “Hi, this is fasttrack.”

OK, now sending sms over multiple modem is works like a charm.

Now, you may ask, how to detect incoming sms comes from which modem? sierra or fasttrack?

The answer is look at the RecipientID from the inbox table, it’s show which modem has the incoming sms. Quick SQL code to get incoming sms from specific modem:

SELECT * FROM inbox where RecipientID=’sierra’;

Or, if you want to get incoming sms from fasttrack:

SELECT * FROM inbox where RecipientID=’fasttrack’;

That’s all for multiple modem 😀
Kalkun should have this feature in the future 🙂

New logo for Kalkun

July 26, 2010 3 comments

This is the new logo for Kalkun, will be included on next release.

All credit goes to this man: Rudi Setiawan and Ihsan Rama

Tell me what do you think? 🙂

Categories: kalkun Tags:

Kalkun failed on INAICTA 2010

July 24, 2010 5 comments

No luck this time 🙂

Kalkun only reach the big five a.k.a nominee on INAICTA 2010, and that’s it, no further phase. Kalkun was beaten by other open source software that’s more mature and greatly tested, i must admit it.

And i think i got lesson from this competition, how to makes an application become mature, ’cause kalkun is just still baby application by now, create an API would be my priority right now, because if kalkun can communicate to other application like Point Of Sale (POS), ERP, and others, it will be very nice.

That’s it, i hope i can get new motivation from this failures, and getting more serious on this project. 🙂

Categories: kalkun Tags: , ,

Kalkun 0.2 released

July 21, 2010 3 comments

Hi
Kalkun 0.2 is out, you can download it from:
http://sourceforge.net/projects/kalkun/files/kalkun/0.2/kalkun_0.2.tar.gz/download

New features:

  • Multiuser, user now can have it’s own inbox, sentitems, folder, and phonebook.
  • SMS content/member
  • Language localization, added Bahasa Indonesia
  • Performance issue, now all javascript library use compressed/minified version

Please look at the CHANGELOG for more details.

===============================================================

Alternate download

You can download the 0.2 version on alternate location here:
http://back2arie.capungriders.com/kalkun/source/kalkun_0.2.tar.gz

=====================================================================================

(24 July 2010)

Add user bugs

If you cannot login after add user, that’s must be bugs, updated on last upload.
http://sourceforge.net/projects/kalkun/files/kalkun/0.2/kalkun_0.2.tar.gz/download

Categories: kalkun Tags:

Installing gammu on Mac OS X

July 16, 2010 48 comments

This mini tutorial will explain howto install gammu on Mac OS X, i’m using Mac OS X 10.5.8 and gammu 1.28.0.
To install gammu, you need cmake, and i’m using cmake 2.8.2, i installed it using Homebrew package manager.

To install Homebrew:

$ ruby -e "$(curl -fsS http://gist.github.com/raw/323731/install_homebrew.rb)"

Then, you can install cmake with:

$ brew install cmake
Download gammu 1.28.0 here
Next, extract and install it:
$ ./configure
$ make
If you got errors like this:
Scanning dependencies of target array-test
[ 35%] Building C object tests/CMakeFiles/array-test.dir/array-test.o
Linking C executable array-test
[ 35%] Built target array-test
Scanning dependencies of target at-charset
[ 35%] Building C object tests/CMakeFiles/at-charset.dir/at-charset.o
Linking C executable at-charset
Undefined symbols:
“_iconv_open”, referenced from:
_IconvDecode in libGammu.a(coding.o)
_IconvEncode in libGammu.a(coding.o)
“_iconv_close”, referenced from:
_IconvDecode in libGammu.a(coding.o)
_IconvEncode in libGammu.a(coding.o)
“_iconv”, referenced from:
_IconvDecode in libGammu.a(coding.o)
_IconvEncode in libGammu.a(coding.o)
ld: symbol(s) not found
collect2: ld returned 1 exit status
make[3]: *** [tests/at-charset] Error 1
make[2]: *** [tests/CMakeFiles/at-charset.dir/all] Error 2
make[1]: *** [all] Error 2
make: *** [all] Error 2
Then you’ve to configure cmake build to disable libiconv
$ mkdir build
$ cd build
$ cmake -DWITH_Iconv=OFF ..
$ make
$ sudo make install
Now, let’s connect the modem, i’m using Sierra USB Connect 881, and i got this information on /var/log/system.log:
Jul 16 22:34:10 macbooks-macbook kernel[0]: SierraSwitch: Version number – 1.2.1
Jul 16 22:34:10 macbooks-macbook kernel[0]: SierraSwitch: Driver Mode is 2 (Force Modem)
Jul 16 22:34:10 macbooks-macbook kernel[0]: SierraSwitch: Device version information for Mac OS:
Jul 16 22:34:10 macbooks-macbook kernel[0]: SierraSwitch: Revision = 0, SIPC = 24577(6001), SI Version = 1(1), CDPC = 0, CD Version = 0.0.0
Jul 16 22:34:10 macbooks-macbook kernel[0]: USBF:    41970.457    IOUSBInterface[0x418a700]::joinPMtree – could not find the hub device
Jul 16 22:34:13 macbooks-macbook kernel[0]: 0        0 SierraSupport: start – Default, suspend enabled for this device
Jul 16 22:34:13 macbooks-macbook kernel[0]: SierraSupport: Version number – 1.4.7, Input buffers 16, Output buffers 24
Unfortunately, it does not show where the modem attached on /dev/, because we need it to gammu configuration. So, i search it manually:
$ ls -la /dev | grep sierra
And it shows:
crw-rw-rw-   1 root   wheel      17,   9 Jul 16 22:34 cu.sierra001
crw-rw-rw-   1 root   wheel      17,  13 Jul 16 22:34 cu.sierra05
crw-rw-rw-   1 root   wheel      17,  11 Jul 16 22:34 cu.sierracntl
crw-rw-rw-   1 root   wheel      17,   8 Jul 16 22:34 tty.sierra001
crw-rw-rw-   1 root   wheel      17,  12 Jul 17 01:04 tty.sierra05
crw-rw-rw-   1 root   wheel      17,  10 Jul 17 01:04 tty.sierracntl
Now, let’s create gammu config:
$ cp /usr/local/share/doc/gammu/examples/config/gammurc ~/.gammurc
Mine is something like this:
[gammu]
device = /dev/tty.sierra05
connection = at115200
Finally, test the connection:
===============================
Add MySQL support
===============================
For example, i’ve smsdrc (gammu-smsd config file) like this:
[gammu]
device = /dev/tty.sierra05
connection = at115200
[smsd]
service = MYSQL
PIN = 1234
logfile = /Users/White/.smsdlog
debuglevel = 255
Then i run gammu-smsd and it throws error:
macbooks-macbook:~ White$ gammu-smsd -c /Users/White/.smsdrc
Log filename is “/Users/White/.smsdlog”
gammu-smsd[97218]: MYSQL service was not compiled in!
gammu-smsd[97218]: Failed to setup SMSD service: Desired functionality has been disabled on compile time. (DISABLED[62])
Failed to run SMSD: Desired functionality has been disabled on compile time.
gammu-smsd[97218]: MYSQL service was not compiled in!
It’s because gammu can’t find mysql header library when you compile it.
To add MySQL support to gammu-smsd you need mysql installed, for example i use xampp for Mac OS X, and i’m using 1.7.3 version. All you need to do is download and install the XAMPP itself and the Developer package, cause it contains the header library we need.
.
Now, let’s compile gammu with mysql support, extract gammu as usual, edit cmake/FindMySQL.cmake, add your XAMPP mysql path, it should be look like this:
find_program(MYSQL_CONFIG mysql_config
${MYSQL_CONFIG_PREFER_PATH}
/usr/local/mysql/bin/
/usr/local/bin/
/usr/bin/
/Applications/XAMPP/xamppfiles/bin/
)
Then, let’s configure cmake:
$ mkdir build
$ cd build
$ cmake -DMYSQL_LIBRARIES=/Applications/XAMPP/xamppfiles/lib/mysql/libmysqlclient_r.dylib ..
If everything OK, then it should be show something like this one:
— Configuring Gammu 1.28.0
— Could NOT find Doxygen  (missing:  DOXYGEN_EXECUTABLE)
— Using mysql-config: /Applications/XAMPP/xamppfiles/bin/mysql_config
— Found MySQL: /Applications/XAMPP/xamppfiles/include/mysql, /Applications/XAMPP/xamppfiles/lib/mysql/libmysqlclient_r.dylib
— Could not find PostgreSQL
Then make and make install:
$ make
$ sudo make install
Finally, run gammu-smsd again, if it doesn’t throw errors, then you’ve succeded, congrats 🙂
Have fun with gammu and gammu-smsd  😀
Categories: Open Source Tags: ,

Kalkun is nominee for INAICTA 2010

Good fortune continues. Kalkun is passes the second phase of INAICTA 2010 and it’s now on the final a.k.a big five of the competition. The final will be an exhibition on JCC (Jakarta Convention Center) and will be held on 23-24 July 2010.

Hope i’ll finishing more features before the exhibition.

Wish me luck again and thanks for all your support 😀

Categories: kalkun Tags: , ,