Hi !

We have Kannel open source SMS gateway with SMPP protocol in our company.
Is there any way to send SMS through FOP2 + Kannel SMPP gateway ?

Best regards,
Sergio.

Answering myself with Nicolas live chat help.

We have to look at two files showcdr.php and phonetabs.php. In both files it must be set the correct name of DB.table of CDR storage.

So if we have
$grid->set_table('asterisk.cdr'); in showcdr.php
we must have
$res = $db->consulta("DESC asterisk.cdr");
in phonetabs.php

Best regards,
Sergio.

How can i activate "Call history" button in Phonebook.

I can see CDRs by http:// /showcdr.php but there is no "call history" button in Phonebook page.

Standalone asterisk 1.4 installation. 2.27j version of fop2.

Best regards,
Sergio.

There is nothing impossible in this world !
I did it with some asterisk routing manipulating.
If we can't filter traffic we must create trunk only for proper user.
So i created SIP/trunk_user1 duplicated SIP/trunk_1, created user1 context in asterisk with outgoing rule routing to this
new trunk_user1. After we have to add channel=SIP/trunk_user1 in extension button and... we can monitor and record remote users on the other PBX !

P.S. I still think it's possible to filter trunk channels by called numbers. We have field 'extension' in AMI channel definition, so
we can announce this variable and have something like Channel=SIP/trunkxxx&exten=xxx or Channel=SIP/trunkxxx||yyy where yyy dialed extension.

P.P.S. I noticed that only one extension in all buttons can display channel=SIP/trunk_1 information. i want to say If we add record channel=SIP/trunk_1 to SIP/user1 and to SIP/user2 extensions in button.cfg file than only one extension will show status of trunk_1. Is there a possibility to see status on both extensions ?

Best regards,
Sergio.

Thnks for live help proposal, but it's a little bit difficult because of time zone difference - when you're up, It's a night in Moscow and viceversa !
On the current moment i solved my problem by migrating to Linux SuSe 11.4 and FOP works well with it. The last post just FYI and for some other SuSe based Linux users.

Best regards,
Sergio.

I have to PBXs connected via SIP trunks to asterisk. And the users of these PBXs have the ability to call each other through asterisk by fop. When the user1 of PBX-1 makes a call to user2 0f PBX-2, asterisk makes two legs over SIP/trunk1 and SIP/trunk2. And after user's answer bridged them. I can see these channels in fop2 trunk button with called extension note like:

SIP/trunk1 1xxxx ( call to user1 ) and
SIP/trunk2 2xxx. ( call to user2)

Is there some variants to record voice from these trunks ( these remote users ) ?
I tried to add channel=SIP/trunk1 to user1 extension button, but in this case it indicates all calls through SIP/trunk1 not only for 1xxx number. How to filter outgoing trunks by dialed extensions ?

I tried to use Local channels, but for some reason i cant bridge two local channels and record them...

Any advise ?

Best regards,
Sergio.

What permission should i give to the user for group chat and notification ?

Just "chat" not enough.

Best regards,
Sergio.

Ok, i spent some time to investigate the problem.

It was tested on Linux (x64) 11.1, 11.4 and 12.1 opensuse releases. Normal situation was only on 11.4 with apache 2.2.17 and mysql 5.1.63 with the same configuration of LAMP server components. And such problem has apeared only on last versions of 2.27 release.( 10 november and last ) I don't know the correct reason, maybe some php or apache bug with new java implementation...

P.S.Recording with script recording_fop2.pl didn't work for long time while i found out that it depends on perl-DBD-mysql driver which was not installed by default with perl package in suse. I didn't see this recommendation in oficial docs... is there a reason to add ?

Best regards,
Sergio.

We have two kind of FOP2 users - without contexts and with contexts. And they have different time to access Phonebook interface in FOP2.

For users without contexts the phonebook opens almost instantly - about 1-2 sec, and the users with contexts have to wait for 40-50 seconds before interface will open. But if the user opened it first time, then closed and will open again there is no problem - it's opening without delay.

In mysql log i can see messages

Connect
INIT DB FOP2
Query Select keyword,parameter,value FROM fop2setup
Quit

and only after 5-6 these messages i see

Query DESC Visual Phonebook
Query Set Names UTF8 ... and so on. In this moment interface is coming up and the user can see records.

For user without contexts only one message
++++++++
Connect
INIT DB FOP2
Query Select keyword,parameter,value FROM fop2setup
++++++
appears.
If we try to open phonebook directly from phonebook.php - it opens well, without delay.

P.S. It doesn't matter how many records in BD, even empty BD opens so for "contexts" users.
Tested on several hosts with different versions of Linux, apache,mysql,php...

What does the request to "fop2setup" mean ? Do we have to create this table in fop2 DB and fill in with some info ?

Best regards,
Sergio.

Ok, problem with russian letters was solved !

But i have found another issue.
If we have several extensions ( ext1,ext2,ext3) and they are members of any group defined in button.cfg (group=test or group=тест ( in doesn't matter what language )) group chat and group note don't work. When we press group chat button The chat window appears with note "To grp0", we can put some notes there, but users of this group don't get it.

If some extensions are not included in group ( just common "extensions" window) group chat and notification work well.

P.S. When we have several groups ( button.cfg) with names - test1,test2,test3 and try to make group chat, we have note in group chat window - to grp0,to grp1,to grp2 and so on... but not "to test1, to test2,to test3" and group chat don't work. But when we use config whithout groups and press group chat button we have note "To extensions" in chat windows and chat works.

So if the chat/notification group function works at all ?

Any ideas ?

Best regards,
Sergio.

When i try to execute "make" I have the following in my console output

=============================
/bin/sh: line 3: server/fop2_server: Permission denied

Upgrade Aborted. License reactivation failed.

Be sure you have internet access from this server,
and that your code is not older than a year.

If your license has expired, you must renew it in order to upgrade,
but you can still use your current FOP2 version for as long as you want.

If you already bought an upgrade code please run the following command:

server/fop2_server --upgrade

If the upgrade is successful run make again to retry the installation.

Contact us at <!-- e --><a href="mailto:sales@asternic.biz">sales@asternic.biz</a><!-- e --> for more information.
Done!

Is there a possibility not to upgrade everything by "make" but only change any new css/js files ?
The reason i've made a lot of modifications in css,js,php files and it would be better not to do it again.

Best regards,
Sergio.

any news?

It doesn't separate the contexts in this way , it separates by originate exten. So if the call was made from "user1" exten, than the "ownerexten=user1" and only "user1" can see these recordings. No need to add ${FOP@CONTEXT} in monitor_exec file name...

My system work as the following - I have about 100 users and every user can make recordings, can see them and can delete ( add a button "delete" to the page ). Every night the script cleans /var/spool/asterisk/monitor/fop2 folder and mysql table so Users who need their records, must download them and store on local hosts. On my opinion it's the best way to give the ability to record and to keep server clean.

Best regards,
Sergio.

Oh ! I saw what you need - i use 64 bit distro centOS ( http://download.fop2.com/fop2-2.27-centos-x86_64.tgz) for my SuSe 11.4 OS installed on 64bit platform !

Best regards,
Sergio.

SuSe 11.4 - Asterisk 1.4

Yes, i had the same. I solved it very easy - just cut

if($allowed <> "yes") {
die("You do not have permissions to access this resource.");
}

from phonebook.php and recordings.php and Bam ! - everythins Ok !

Best regards,
Sergio.

Hi !

Can't understand the situation.

When i try to use russian letters in group definition in buttons.cfg - it doesnt work.

For example, group = test - ok, but group = тест - this group just doesn't appear...

Version 2.27, IE,Opera,Firefox.

Best Regards,
Sergio.

Well, it's really add context in mysql table, but it didn't solve the problem. The recordings are still visible to everybody from different contexts.

But i found the solution. I cut OR $admin=1 part from recordings.php
$grid->set_condition("(ownerextension='$extension' OR $admin=1)");

and now only owner of current extension can see these recordings.

By the way, what kind of "admin" was here ?

Best regards,
Sergio.

Hi !

We have several users with own contexts. If the "user 1" with context "user1" make record of his call, he can see it in VisualPhonebook - Recordings, but the "user2" with context "user2" can also see it. Is it a bug or a future ?

The records in mysql table come with empty "context" field... But if i fill this field with context name "user1" or "user2" nothing changes - all recoring are visible to all users.

2.27 version - asterisk 1.4

Any ideas ?

Hi!
Is there any way not to display extension numbers on buttons but only names...

It seems i saw topic about it, but can't find now

With best regards,
Sergio.