Archive for the ‘kalkun’ Category

Kalkun: Inbox multipart support

March 21, 2011 19 comments

There are some user complaining with Kalkun behavior with multipart/long messages in the inbox, the message is split up and it’s quite hard to read it.

I quite believe gammu-smsd already handle it, since the TextDecoded field on inbox table become text, not varchar(160). But, somehow it’s not running as expected. The multipart/long message record split up each other, have different ID, but the key is on the UDH. This is how we managed to merge the message and it’s implemented on commit #1204938

But, it’s not highly tested, you can download the latest code via snapshot or directly on github and help with the test.


Categories: kalkun Tags: ,

Kalkun: New demo server and contribute page

After a long time looking for hosting provider that support git, finally there is some help by idforge (part of id-x project), kudos for them, especially Mr. Akhmat Safruddin for the quick response.

Now, the demo consist of 2 part, the latest released version and latest development version. The latest released version is the stable version that have been released to public. And the latest development version is contain code from git repository and it’s updated every midnight, so it contains latest code that we working on.

For more information about the demo you can visit Kalkun demo page.

I’ve also made the server to make code snapshot, which run every midnight that contain latest code from git repository. User who don’t have git on their system can easily use this snapshot to test the latest code.

Last, i’ve add Contribute Page on Kalkun homepage to get more feedback from more user/developer.

Categories: kalkun Tags:

Kalkun: Russian translation added

Just added Russian translation on commit #3a722c87046e0edd0d9e

Thanks to Denis Polkovnikov for the effort.

So, there is now 5 language available, English, Bahasa, Czech, Portuguese, and Russian. Way to go! 😀
If you want to add your language, it’s very easy, everyone is welcome, what the instruction how to add translation.

Categories: kalkun Tags: ,

Kalkun 0.2.9 is released

March 3, 2011 27 comments

This is testing version before we release the 0.3.

Full list of changes:

If you upgrading from previous version (0.2.1), just need to delete install folder and change database column names:

  • pbk.id_pbk become pbk.ID
  • pbk_groups.GroupName become pbk_groups.Name

IMPORTANT: Since this version. you have to configure “daemon” that manage inbox and autoreply, you also have to configure gammu-smsd with runonreceive directive. For more detail read Kalkun Installation, especially the Configure Daemon section.

Categories: kalkun Tags:

Using Kalkun and gammu-smsd with SQLite3

February 28, 2011 19 comments

It’s been a long time ago since i’ve started to thinking adding other database backend support besides MySQL. The problem is CodeIgniter (Kalkun is developed using CodeIgniter) and gammu-smsd both must support the database engine used, for example if CodeIgniter support PostgreSQL, than gammu-smsd must support PostgreSQL too, and so on. To make this dream comes true, i’ll have to “convert” all native SQL query to Codeigniter Active Record to make the query independent to all database engine because it’s handled by database driver.

Imagine that you want to install a software, but you only have SQLite3/PostgreSQL on your server, installing MySQL just for that can be huge problem. That’s the basic idea to support all database engine.

OK, for the first time, i’ve added SQLite3 support to Kalkun. But, it’s not as easy as i imagine to implement it. First, CodeIgniter doesn’t have official support for SQLite3, the driver only compatible with SQLite2, fortunately there’s community contribution that add SQLite3 through PDO (PHP Data Objects). So, you need pdo_sqlite extension on your PHP installation. Second, gammu-smsd also doesn’t have native support for sqlite3, otherwise it use libdbi.

Now let’s configure gammu-smsd to works with SQLite3 first. FYI, i’m using Mac OS X and gammu 1.29.0. Let’s install SQLite3 and libdbi drivers, i’m installing it using MacPorts.

$ sudo port install sqlite3
$ sudo port install libdbi
$ sudo port install libdbi-drivers

Next, compiling gammu with libdbi support. Make sure you get “Found libdbi: …” when running configure otherwise you can’t run gammu-smsd with SQLite3.

Create Kalkun database and import gammu database schema
Because of Kalkun New Installation, gammu database schema is not included on Kalkun source, now you’ve to import gammu database schema on your own (it’s included on gammu source eg. docs/sql/sqlite.sql). You can do the import using sqlite3 console:

$ sqlite3 kalkun.sqlite < docs/sql/sqlite.sql

or, if somehow it’s throw error “Error: near “/”: syntax error“, use this:

$ cat docs/sql/sqlite.sql | sqlite3 kalkun.sqlite

Or you can the import using SQLite3 client with GUI. I’m using SQLite Manager Firefox add-ons, off course you can use other SQLite client.

Next is import Kalkun database schema to the database, you can import it using your SQLite3 client or by Kalkun Installation. I’ll show you how to import using Kalkun installation. But before that you have to config the database first (it’s located on /application/config/database.php)

$db[‘default’][‘username’] = “”;
$db[‘default’][‘password’] = “”;
$db[‘default’][‘database’] = “sqlite:/path/to/database/kalkun.sqlite”;
$db[‘default’][‘dbdriver’] = “pdo”;

You only need to change the database path, SQLite doesn’t need username and password, and the driver should be pdo. It’s recommended to place your SQLite3 database outside your web root folder because of security issue.

Setting database permission, before launch Kalkun installation make sure the database is writable by web server user, you can give it world writable.

$ chmod 666 /path/to/sqlite3_db/
$ chmod 666 kalkun.sqlite

Next fire up Kalkun installation and choose SQLite3 on Database Setup.

Kalkun installation with SQLite3

Kalkun installation with SQLite3

Next, let’s configure gammu-smsd, open up your gammu-smsd configuration file a.k.a smsdrc

Service = SQL
Driver = sqlite3
database = kalkun.sqlite
dbdir = /path/to/sqlite3_db/

That’s all, now run your gammu-smsd, check logs and see if it’s working (no error). You can try sending SMS using gammu-smsd-inject:

$ gammu-smsd-inject TEXT 123456 -text “Hi, this is gammu sending using sqlite3”

Next, try sending SMS using Kalkun 😀


PS: SQLite is famously knows for it’s liteness, but it’s may slower with network access and lots of activity/user using the same resource. So make sure you know what are you doing before using it.

Implemented on commit #fa845a4

Categories: kalkun Tags: , ,

Kalkun: New installation

February 28, 2011 2 comments

To make Kalkun works with all gammu version i’ve decided to remove gammu database schema from kalkun installation, now you have to import gammu database schema on your own, gammu database schema is included on gammu source, usually located /docs/sql/mysql.sql, but it’s may be different depends on gammu installer you used (source, windows binary, debian packages, etc).

Now the summary of Kalkun installation should be:

  1. Download and extract Kalkun to web root directory
  2. Create database named kalkun and setup database permission (optional)
  3. Import gammu database schema (you can do it using mysql console or phpmyadmin)
  4. Launch Kalkun installation, if you don’t have gammu database schema, it will throw error “Cannot find gammu database schema“.

That’s all 😀

Implemented on commit #fa845a4

Categories: kalkun Tags:

Kalkun Database Schema

February 25, 2011 Leave a comment

Just added Database Schema page on Wiki.

It’s for developer who want to know about database tables description and relationship.

Kalkun Database Schema

Kalkun Database Schema

Created with MySQL Workbench.

Categories: kalkun Tags: ,