Hi Hugues,
1- You have to convert the received MO message from "ISO-8859-1" to "utf-8":
from_to($data, "iso-8859-1", "utf8");
2- Insert the received mo into a mysql table filed uses "utf-8" charset.
3- posting some relevant log entries showing what you receive.
Also check this document ( written by Mr. Julien Buratto ) :
http://www.linkas.it/docs/kannel/
Regards.
--
Benaiad
On Wed, Dec 9, 2009 at 6:20 PM, Hugues NAGOBA <[email protected]> wrote:
> (my english is no the best...)
> Hi all,
> I'm a newbe in kannel seting up.
> I've install it on a ubuntu server.
> I set up correctely a SMPP connection with an GSM operator.
> I can receive SMS and I use a perl script to store it in a mysql database.
> all that work correctly with french or english MO sms.
> but the problem is about arabic MO SMS.
> they are not correctly store in my database (â †â
> †âœ†â¼†â°€â€†ä„†ãœ†ä˜†â¼€â€†â¼†â †â¼†â°†âœ†ãŒ..)..
>
> this is my smskannel.conf
> ----------------------------------------------------------------------------
>
>
> #CORE
>
> group = core
> admin-port = 13000
> smsbox-port = 13001
> admin-password = bar
> status-password = foo
> log-file = "/var/log/kannel/bearerbox.log"
> #admin-deny-ip = ""
> #admin-allow-ip = ""
> log-level = 0
> box-deny-ip = "*.*.*.*"
> box-allow-ip = "127.0.0.1"
> access-log = "/var/log/kannel/access.log"
> sms-resend-retry = 5
> sms-resend-freq = 30
>
>
>
>
> #---------------------------------------------
> #SMSC CONNECTION MATTEL
>
> group = smsc
> smsc = smpp
> interface-version=34
> smsc-id = xxxx
> #allowed-smsc-id = radio
> host = xxx..xxx.xxx.xxx
> port = xxxx
> transceiver-mode = 1
> smsc-username = "xxxxxx"
> smsc-password = "xxxxxx"
> system-type = "xxxxxx"
> source-addr-npi = 0
> dest-addr-ton = 5
> #log-file = "/var/log/kannel/mattel1.log"
> log-level = 0
> alt-charset = UTF-8
>
> #---------------------------------------
> # SMSBOX SETUP
>
> group = smsbox
> bearerbox-host = 127.0.0.1
> sendsms-port = 13013
> mo-recode=true
> global-sender = "eeeee"
> log-file = "/var/log/kannel/smsbox.log"
> log-level = 0
> access-log = "/var/log/kannel/access.log"
>
>
>
>
> #---------------------------------------------
> # SEND-SMS USERS
>
> group = sendsms-user
> username = tester
> password = foobar
> #user-deny-ip = ""
> #user-allow-ip = ""
>
>
>
> #---------------------------------------------
> # SERVICES
>
> group = sms-service
> keyword = default
> #text = "No service specified"
> #get-url = "
> http://localhost/smsphp/smsin.php?sender=%p&text=%a&date=%t&charset=%C";
> exec = "/scripts/mosms.pl %p %a %t %b"
> omit-empty = true
> max-messages = 0
> accept-x-kannel-headers = true
>
>
>
> this is my perl script
> -----------------------------------------------------------------------------
>
>
> #!/usr/bin/perl -w
> use utf8;
> use strict;
> use DBI;
> use URI::Escape;
> use Encode;
>
>
> my $database="xxxxx";
> my $hostname="localhost";
> my $login ="xxxx";
> my $mdp ="xxxxxxxxxx";
>
> my $dsn = "DBI:mysql:database=$database;host=$hostname";
> my $dbh = DBI->connect($dsn, $login, $mdp) or die "Connecting from PHP to
> MySQL database failed: $DBI::errstr";
>
> #my $str = encode_utf8(uri_unescape($ARGV[1]));
> my $str = $ARGV[1];
> $str =~ s/\%([A-Fa-f0-9]{2})/pack('C', hex($1))/seg;
>
>
>
> my $sSQL = "INSERT INTO smsin (num, text, date, destinat) VALUES
> ('$ARGV[0]','$str','$ARGV[2]','$ARGV[3]')";
> my $st = $dbh->prepare($sSQL)
> or die "Preparing MySQL query failed: $DBI::errstr";
>
> $st->execute()
> or die "The execution of the MySQL query failed: $DBI::errstr";
>
> $dbh ->disconnect();
>
>
> --------------------------------------------------------------------------------------
>
>
> thanks for your help.
>
>
> *Hugues Dah-ton NAGOBA*
> *INGENIEUR RESEAUX ET TELECOMMUNICATIONS
> **00222 737 20 81
>
> *
>
>
>
>
