Please help with Cisco 7940...Please

xenoscion

Joined
Aug 5, 2009
Messages
2
Likes
0
Points
0
#1
I am testing Elastix to replace Thirdlane. I am experienced with Asterisk, Trix and Thirdlane. Now I am really excited about possibly rolling out Elastix for our 8 office PBX, but I cannot get the endpoint to recognize all but 5 phones (cisco 7940). I think the issue is, is that they are old. I have tried adding this line :"insert into mac (id_vendor,value,description) values (2,'00:0A:41','Cisco 7940'); to add it to the DB with no luck.

Is there a command i need to right after that like vim and :wq for it to save. All i get after i enter that command is > . Is there a way I can edit them like in MS access?

I have also looked at http://www.elastix.org/index.php?option ... ac_address

and my mac is not even in there. I assume it is the first 3 octets. My mac for this phone is 00:0A:41:2B:7B:71

There has to be a way to do this and i would really appreciate the help.
 

Megabyte

Joined
Mar 28, 2009
Messages
327
Likes
0
Points
0
#2
I think we help you in the irc channel right, i think this is solved if not please tell us where you are stuck
 

xenoscion

Joined
Aug 5, 2009
Messages
2
Likes
0
Points
0
#3
Yes you solved my problem Alfio, thank you again. To recap I will post what you told me and the command I entered into the database. Alfio directed me to download SQLite2009 Pro here : http://link.osenxpsuite.net/?uid=homepa ... 009pro.zip

Then I opened the endpoints.db that i copied out of /var/www/endpoints.db once that was open select the "mac" table and what i entered was the following, this will vary of course depending on your vendor and the first 3 octets of your mac.




Code:
INSERT INTO mac(id_vendor,value,description)
VALUES(2,'00:0A:41','Cisco 7940')
Ok everything in red did not work actually, it did discovery my phone but since i copy pasted the database i think it did not like how i did so instead I modified the database with these commands.

Code:
Sqlite3 /var/www/db/endpoint.db

VIEW MAC TABLE
>select * from mac;

INSERT ROW TO MAC
>insert into mac values(2,'00:0A:41','Cisco - 7940');

FIX ROW IN MAC
>update mac set description='Cisco - 7940' where id=[39 or other id];

DELETE ROW FROM MAC
>delete mac where id= [39 or other id];
I am still going to work on attaching the database remotely and seeing how that goes because a pretty GUI is always nice :)
 

Members online

No members online now.

Latest posts

Forum statistics

Threads
30,902
Messages
130,887
Members
17,566
Latest member
Fpino
Top