search

FreePBX / superfecta

Provides simultaneous use of, and complete control over multiple caller id data sources.
http://www.freepbx.org
GNU General Public License v2.0
56 stars 92 forks source link

Superfecta special character error (ä,ö,ü) #203

Closed ghost closed 9 years ago

ghost commented 10 years ago

Launched AGI Script /var/www/html/admin/modules/superfecta/agi/superfecta.agi

/var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta is Answering the Channel /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: Scheme is ALL /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: The DID passed from Asterisk is: 06XXXXX /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: The number passed from Asterisk is: 015XXXXXX /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: The CID name passed from Asterisk is: 0152XXXXXX /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: Executing Scheme.. /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: Matched CID Rule: '0.X' with '0152XXXXX' /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: CID Determined to be: 'Schfer' /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: Attempting to set lookupcid /var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: Success!

AGI Script /var/www/html/admin/modules/superfecta/agi/superfecta.agi completed, returning 0

The name is incorrectly displayed "Schfer" -->>> Schäfer

(Test a phone number against the selected sources.) On the website in the tests ä appears

Website Output:

Debug Level:NONEINFOWARNALL

Debug is on and set at level 1 The Original Number: 064XXXXX The Scheme: default Scheme Type: SINGLEFECTA SPAM Destination: is CLI: false Debugging Enabled, will not stop after first result. Scheme Variables:Array ( [SPAM_Text_Substitute] => N [SPAM_Text] => SPAM [multifecta_timeout] => 1.5 [processor] => superfecta_single.php [Curl_Timeout] => 3 [Prefix_URL] => [spam_destination] => [spam_interceptor] => N [DID] => [CID_rules] => 0.X 9|.X [SPAM_threshold] => 3 [order] => 1 [sources] => Asterisk_Phonebook,DeTeMedien_DE,Klicktel_DE )

Trunk Variables:Array ( [channel] => NA [language] => NA [type] => NA [uniqueid] => 1133292843 [callerid] => 06XXXXXXX [calleridname] => unknown [did] => [context] => from-superfecta )

Matched CID Rule: '0.X' with '064XXXXX' Searching Asterisk Phonebook ... 'Schäfer XXXXX' result took 0.0013 seconds.

Searching http://www.detemedien.de/ for 064XXXXXX... 'Schäfer XXXXX ' result took 0.3510 seconds.

Searching http://www.klicktel.de for 064XXXXX... 'Schäfer, XXXXX' result took 0.1997 seconds.

Post CID retrieval processing. Returned Result would be: Schäfer XXXX result took 0.5536 seconds.

MySQL Conf:

[mysqld] datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock user=mysql symbolic-links=0 character-set-server=utf8 collation-server=utf8_unicode_ci big-tables

[mysqld_safe] log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid

[client] default-character-set=utf8

[mysql] default-character-set=utf8

PHP Conf:

default_charset = "utf-8"

Data Source Name:

DeTeMedien DE Klicktel DE

Asterisk (Ver. 11.10.0) FreePBX Framework 2.11.0.37 CID Superfecta 2.11.12 Operating system CentOS Linux 6.5 Apache version 2.2.15 MySQL version 5.1.73

On SNOM and CDR-Rep. th ä,ö,ü not displayed. On CDR-Rep "Sch�fer XXXXX" On SNOM Schfer

ghost commented 10 years ago

If you need further information please write

lgaetz commented 10 years ago

I have tested exhaustively and can't reproduce your bug in Superfecta ver. 2.11.12.

/var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: CID Determined to be: 'Schäfer,XXXXX'

Is it possible the bad CNAM is cached which accounts for different results?

lgaetz commented 10 years ago

Re reading again, it looks like Superfecta works but your phone can't display special chars? Is this a Superfecta issue?

tm1000 commented 10 years ago

Lorne I'm pretty certain it's a phone display issue.

Sent from my iPhone

On Jun 1, 2014, at 6:50 AM, Lorne Gaetz notifications@github.com wrote:

Re reading again, it looks like Superfecta works but your phone can't display special chars? Is this a Superfecta issue?

— Reply to this email directly or view it on GitHub.

ghost commented 10 years ago

CDR Reports : CallerID: "Schäfer "<14> -- OK

Account: Sch�fer -- (Outbound CallerID Name)

/var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: CID Determined to be: 'Schfer'

All entries in the database are OK

internal calls are displayed correctly (On SNOM and freepbx CDR Page)

ghost commented 10 years ago

I have the problem not only on the SNOM Phone. In the Console, it will not display correctly and on the freepbx website (CDR report).

tm1000 commented 10 years ago

The asterisk cli might not support displaying those characters but if they are in the cdr the same thing is passed to your phone. So it's definitely your phone.

Sent from my iPhone

On Jun 1, 2014, at 11:50 AM, tsk7mde notifications@github.com wrote:

CDR Reports : CallerID: "Schäfer " -- OK

Account: Sch�fer -- (Outbound CallerID Name)

/var/www/html/admin/modules/superfecta/agi/superfecta.agi: CID Superfecta: CID Determined to be: 'Schfer'

All entries in the database are OK

internal calls are displayed correctly (On SNOM and freepbx CDR Page)

— Reply to this email directly or view it on GitHub.

tm1000 commented 10 years ago

Ok. Please re clarify. You just said it shows correctly in the cdr then your next message says it doesn't.

Sent from my iPhone

On Jun 1, 2014, at 11:55 AM, tsk7mde notifications@github.com wrote:

I have the problem not only on the SNOM Phone. In the Console, it will not display correctly and on the freepbx website (CDR report).

— Reply to this email directly or view it on GitHub.

lgaetz commented 10 years ago

Im testing on Asterisk 11 and putty. Accented chars are showing up fine in asterisk CLI and in the full log. Characters do not display properly in the CDR.

This is not a superfecta problem, but perhaps there's a superfecta solution. An optional feature that preg_replace's accent characters with plain letters before passing CNAM back to Asterisk.

ghost commented 10 years ago

Internal telephone calls are not handled by Superfecta. For internal phone calls, the special characters are displayed correctly.

External phone calls is the problem. External telephone calls are handled by Superfecta.

tm1000 commented 10 years ago

For external calls is your cdr correct or not?

Sent from my iPhone

On Jun 1, 2014, at 1:06 PM, tsk7mde notifications@github.com wrote:

Internal telephone calls are not handled by Superfecta. For internal phone calls, the special characters are displayed correctly.

External phone calls is the problem. External telephone calls are handled by Superfecta.

— Reply to this email directly or view it on GitHub.

ghost commented 10 years ago

For external calls is your cdr correct or not? NO, it is not correct.

ghost commented 10 years ago

here is a Picture: https://onedrive.live.com/redir?resid=EBA129459A70447D!22287&authkey=!AMm7p67RfMPSDjw&v=3&ithint=photo%2c.PNG

Call:

  1. external (In) Plugin superfecta 2.11.12
  2. internal
  3. internal
  4. external (Out) Plugin outcnam 0.0.2
  5. external (Out) Plugin outcnam 0.0.2
  6. external (In) Plugin superfecta 2.11.12
lgaetz commented 10 years ago

Confirmed. Purely internal calls using accented characters in the CNAM are properly displayed in the CDR and also on my Aastra phone display.

ghost commented 10 years ago

what can I do to resolve the problem? Thank you for the help.

tm1000 commented 9 years ago

The solution is stated in this thread: http://issues.freepbx.org/browse/FREEPBX-8137

But it relies upon mb_* functions, which requires you install another php-* package. Which IMHO is bad.

ghost commented 9 years ago

It works. Thank you.

tm1000 commented 9 years ago

This issue needs to remain open as the contributor refused to fill out the CLA so this must be done by someone with a CLA on file. Sorry.

lorn10 commented 9 years ago

Hi to all Little question, - what's the status of this error? I use FreePBX 5.211.65-21 with CID Superfecta 2.11.16 and this problem is still present. --> Letter ü is displayed as eA, letter ä is displayed eO, etc. Note, all internal calls are working properly.

At first I thought the problem was in the firmware of my Yealink T32G & T38G phones. But Yealink Support was not able to reproduce this issue. Therefore, this Superfecta error seems to be still present. Exist there any workaround? Thanks for any hints.

lgaetz commented 9 years ago

This issue is fixed, but requires the php mbstring module to be installed. At the CLI, if you type: php -m is mbstring listed as an installed module? If not, you need to enable it.

lorn10 commented 9 years ago

Thanks for this fast answer! Yes, php mbstring was not installed. Installed it with "yum install php-mbstring" and then make http restart with "service httpd restart". It seems to work now. Thanks!