LinuxMCE Forums

General => Developers => Topic started by: tschak909 on October 14, 2007, 08:41:57 am

Title: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: tschak909 on October 14, 2007, 08:41:57 am
------------------------------------------------------
Cisco XML Directory Patch for Pluto/LinuxMCE Web Admin
------------------------------------------------------

== Synopsis ==

This set of files adds a working Directory for your Cisco IP phone. It has been tested on my Cisco 7970 phone, but does not use any additional features, so it should work on any of the other Cisco IP phones that support XML services, such as the Cisco 7960.

It adds the following Features:

* Directory button now works!
* Works with Contacts from the Pluto phone directory
* Paginates them based on # of entries in phone book
* Shows the phone type.

Nice and simple.

== Installing this Patch ==

* Unpack the files to the pluto-admin directory. (/var/www/pluto-admin/)
* edit the file /tftpboot/SEPDefault7970.cnf.xml (it just needs to be the default xml for your cisco phone, adjust as needed.)
** Find the <directoryURL></directoryURL> tags, and place '''http://192.168.80.1/pluto-admin/directory.php''' between them.
* Reboot the phone by pressing the settings button, and pressing the following button sequence '''**#**'''

Once the phone boots, try the directory by pressing the Directory button!

If there are any problems, let me know --~~~~

Thom Cherryhomes - UNIT-E
thom.cherryhomes at gmail.com

Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: PeteK on October 14, 2007, 09:36:25 pm
That's great!  Thanks for doing this.  Can you submit it to mantis so the devs can track the update.  I think that's the best system we've got right now.
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: tschak909 on November 14, 2007, 09:41:22 pm
bump, has anyone tried this besides the guy who wrote it? :P

-Thom
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: Zaerc on November 15, 2007, 02:57:13 am
If I had the hardware I would have, but it seems that these are pretty expensive.  :-\
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: Matthew on November 19, 2007, 11:20:51 am
bump, has anyone tried this besides the guy who wrote it? :P

-Thom

I have tests of this SW scheduled for the first week in December.
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: hari on November 20, 2007, 02:01:25 pm
bump, has anyone tried this besides the guy who wrote it? :P

-Thom

looked at the code, seems reasonable. What i see messing is some kind of a search functionality. Let's see if i find the time to implement it. I'll test the code these days.
The 7970 has some nice additional features. It plays/sends RTP streams, it should be easy to implement intercom, burglar voice bashing, announcements and so on..

regards,
Hari
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: tschak909 on November 20, 2007, 02:05:45 pm
I deliberately didn't implement the Search functionality. But if someone wishes to implement it, cool. I wanted to avoid the stupidity of having the search feature be the primary way to use the system, especially from the telephone. This is not an enterprise services directory, and should not be searched as such.

-Thom
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: hari on November 20, 2007, 02:11:29 pm
I deliberately didn't implement the Search functionality. But if someone wishes to implement it, cool. I wanted to avoid the stupidity of having the search feature be the primary way to use the system, especially from the telephone. This is not an enterprise services directory, and should not be searched as such.
you are absolutely right for a few entries. But my personal addressbook alone has at about 120 contacts. If i dig into this i will do some option switches or put the search function in the services menu...

best regards,
Hari
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: tschak909 on November 20, 2007, 02:15:11 pm
we could add a search to the main menu, in addition to the pagination that already happens.. have you tried it yet? It should split entries by 32.

-Thom
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: hari on November 20, 2007, 03:51:04 pm
we could add a search to the main menu, in addition to the pagination that already happens.. have you tried it yet? It should split entries by 32.

-Thom

i'll try it this evening.. YIPPPE, my DSL is back *ggg*

regards,
hari
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: Matthew on November 20, 2007, 03:55:27 pm
I already have an LDAP server running with a directory of contacts in it. Can I use this patch to connect to that existing directory?
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: tschak909 on November 20, 2007, 03:59:58 pm
nope, this was meant to use the Pluto contacts database.

-Thom
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: Matthew on November 20, 2007, 04:05:13 pm
nope, this was meant to use the Pluto contacts database.
Aha, well, my LDAP is just a front to a Postgres DB (via DB-link). Maybe another argument for porting LMCE from MySQL to Postgres. Or perhaps a better argument for setting up a MySQL datamart for Postgres data (perhaps via DB-link). I'm not dropping Postgres, because too many other existing apps depend on it.
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: hari on November 20, 2007, 04:10:15 pm
I already have an LDAP server running with a directory of contacts in it. Can I use this patch to connect to that existing directory?
not this patch but the modifications are minor: simply exchange the mysql select with some kind of ldap_search and iterate through the result entries.

regards,
hari
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: Matthew on November 20, 2007, 06:21:37 pm
I already have an LDAP server running with a directory of contacts in it. Can I use this patch to connect to that existing directory?
not this patch but the modifications are minor: simply exchange the mysql select with some kind of ldap_search and iterate through the result entries.
Or perhaps change the MySQL select to a Postgres select. Or the ldap_search call you mention, as a start down the road towards a hybrid Postgres/MySQL glued together with the existing DB-link between LDAP and Postgres.

Any of the possible combinations among the three seem an equal balance of interface function and kluge :). I wish there were an app that generically synced different schemas in each of MySQL and Postgres, allowing queries on one to reach the other, without building the glue for each different schema.
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: hari on November 20, 2007, 08:21:42 pm
i am to lazy to import all my contacts atm but the first impression is good. Went through the sources, very clean. Kudos to Thom! Maybe we can get this in 0710? If i find the time i'll throw some 4000 contacts at it tonight.

best regards,
hari
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: dragon_788 on April 12, 2008, 09:28:17 pm
Looks like I'm always late to the party, the attachment has gone AWOL/404. Got a 7971 recently that I'm fighting tooth and nail to get up and working with LinuxMCE, and the directory would be another nice feature.
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: hari on April 12, 2008, 11:28:18 pm
the code is in svn.

best regards,
Hari
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: tschak909 on April 15, 2008, 06:56:52 am
dragon_788: you need to add your MAC address to the Plug'n'Play table for the Cisco 7970 device template.. this is described in detail on the Wiki page... but for the case of the 7971, the MAC range for it isn't in there.... we do need to add it....

-Thom
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: dragon_788 on April 26, 2008, 05:48:47 am
Alo again hari, and tschak909. Thanks for the info on locating the code, I'll hafta grab that soon. I did get the MAC added to the devices template and I can navigate to the services button and open the orbiter (or I could til I updated my firmware). The main issue I've been having since updating the firmware (and even before) is getting the phone registered and working with asterisk. The reason I updated is that I'd like to use SIP vs SCCP and I've been exploring doing that through trixbox and other Asterisk based solutions, but so far not having much luck. I couldn't seem to find anything in the template on changing the device type to SIP if I use the Cisco template, do I just have to add it as a generic SIP device then? I think I tried that but I haven't been doing it in VMware so changes after that might have mucked something up further.
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: hari on April 26, 2008, 10:35:30 am
not all SIP firmwares work flawlessly with asterisk. The later ones have problems registering. SIP70.8-0-2SR1S works.

best regards,
Hari
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: bulek on November 08, 2008, 02:27:57 pm
not all SIP firmwares work flawlessly with asterisk. The later ones have problems registering. SIP70.8-0-2SR1S works.

best regards,
Hari
Hi,

two quick questions :
1. where can I find the code (there's link in the first post and also on wiki, but both are dead) ?

2. is code in svn already with search feature ?

BTW, have found this interesting project (it seems that it also has search capability and notes, memos, etc...)...

http://sourceforge.net/projects/open79xxdir/ (http://sourceforge.net/projects/open79xxdir/)

Anyone tried this ?

Update: have just tried it and it seems really usefull (ver 1.2). Also search works in similar way as on cellular phones... I guess it worth of effort... We could only generate whole tree automatically from informations in LMCE database...


Thanks in advance,

regards,

Bulek.
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: tschak909 on November 08, 2008, 03:39:48 pm
The code is now in our SVN, and can be gotten there.

-Thom
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: dlewis on November 08, 2008, 04:01:52 pm
not all SIP firmwares work flawlessly with asterisk. The later ones have problems registering. SIP70.8-0-2SR1S works.

best regards,
Hari
Hi,

two quick questions :
1. where can I find the code (there's link in the first post and also on wiki, but both are dead) ?

2. is code in svn already with search feature ?

BTW, have found this interesting project (it seems that it also has search capability and notes, memos, etc...)...

http://sourceforge.net/projects/open79xxdir/ (http://sourceforge.net/projects/open79xxdir/)

Anyone tried this ?

Update: have just tried it and it seems really usefull (ver 1.2). Also search works in similar way as on cellular phones... I guess it worth of effort... We could only generate whole tree automatically from informations in LMCE database...


Thanks in advance,

regards,

Bulek.


Bulek, can you add what you did with the Sourceforge project to the wiki? Thanks!
Title: Re: NEW PATCH: Directory Button on Cisco 7970 DOES SOMETHING NOW!
Post by: bulek on November 08, 2008, 05:12:21 pm
not all SIP firmwares work flawlessly with asterisk. The later ones have problems registering. SIP70.8-0-2SR1S works.

best regards,
Hari
Hi,

two quick questions :
1. where can I find the code (there's link in the first post and also on wiki, but both are dead) ?

2. is code in svn already with search feature ?

BTW, have found this interesting project (it seems that it also has search capability and notes, memos, etc...)...

http://sourceforge.net/projects/open79xxdir/ (http://sourceforge.net/projects/open79xxdir/)

Anyone tried this ?

Update: have just tried it and it seems really usefull (ver 1.2). Also search works in similar way as on cellular phones... I guess it worth of effort... We could only generate whole tree automatically from informations in LMCE database...


Thanks in advance,

regards,

Bulek.


Bulek, can you add what you did with the Sourceforge project to the wiki? Thanks!
Hi,

out of my memory :
Code: [Select]
Openxmldir_1.2
wget http://ovh.dl.sourceforge.net/sourceforge/open79xxdir/openxmldir_1.2.tar.gz
tar zxvf http://ovh.dl.sourceforge.net/sourceforge/open79xxdir/openxmldir_1.2.tar.gz
cd /openxmldir_1.2
chmod a+w -R *
mysql --verbose --user=root -p xmldir < ./db.sql


mybe you can revise it and put it on Wiki...

regards,

Bulek.