new trixbox app [trixboxGraph]
A trixbox user contributed a cool little app that makes a flow chart out of your dial plan. You can see how all your IVR menus fit together. Even exports to PDF very cool.
Install the trixboxGraph package using the package manager and go the URL
http://yourtrixbox/trixboxGraph
it doesn’t have a link in the control panel yet.
Pretty nice utility to have, however I am experiencing some issues with it:
1. Queues, they show up but they are not attached to the callplan in a form I would expect them. On my dialplan diagram it shows that call comes into an IVR and has two options, but both the options link to ext-queues and not the actual queue for that option. Normal or busted?
2. The image file should actually be renamed to .php or something and then having the headers set to display it as an image, as it sits at the moment with it being .png or .gif it gets cached and won't update after making changes.
Hello,
I installed trixboxGraph using the yum install.
However, is there a trick to get it to display anything? When I go to it, I get some options I guess but no way to display it.
Does it display automatically?
I do notice then on lower right side "select * from ringgroups => Table 'asterisk.ringgroups' doesn't exist"
What does that mean and how do I fix it?
I do not have ringgroups enabled on my box....
This is very nice and I think this could be a valuable tool for TB users. I was waiting for someone to do this :) I was using Switchvox for a few years until I heard about TB. I Installed TB and haven't gone back :) But there were a few things that I liked about the user interface with the "other guys"... was the ability to have a nice GUI so you can easily look at your Asterisks records/extensions, IP's, calls in/out, who's is talking now and more.
Could we make a "Wish List" for functions :)
BTW, has anybody had issues with the new TB2.0 menu not closing properly when you mouse-out of the menu?
What's up with all the html br?
Hi all,
I'll answer all the questions in one post (I'm a pretty busy guy ;) ).
- You cannot use the app on a non-trixbox system. It reads the trixbox database, not the dialplan itself.
- Likewise, not "seeing" IAX, ZAP trunks and so on, either I didn't find them in the database (I do not have IAX active myself) or I could not figure out how they link. I just spend a day or so on this, like I said I don't have much spare time. I am hoping for someone else to pick up the source and maintain it.
- Editting the image and feeding it back to the dialplan is several magnitudes more complex than this utility... guess what: no time :(
- Image update issue (output PHP): Yes, good plan! An easier solution is to set your browser to check for updates on each visit to a page, in my experience this fixes many problems (like this one).
Thanks for all the feedback, it's nice to have ones efforts appreciated :)
Thanks for all the praise (*blush*)
Two new questions:
- License: Basically GPL: you may use it as you wish but if you expand/change things in a generally useful way I really would like you to submit your updated version here. Be aware that the core functionality is provide by GraphViz, which has its own licensing, of course.
- Security: my original version required you to provide a valid MySQL login. Andrew told me he'd removed that so probably it picks up your login from Trixbox itself? Andrew, any comments?
Regards,
Walter.
When I downloaded this and installed it i thought it would be good but when we printed out the pdf and showed it to the powers that be and explained that if there is the occasional glitch this is what we are up against, they were amazed at how complicated a simple system is. They say a picture is worth a thousand words - this is priceless.
Simon
wglenncamp wrote:
I noticed that there really isn't any sort of security to access this site. So, anyone on the network can view the dial/routing plan.
Is there anything that I can add to this that will require a login to view it?
You can use basic http auth. Google that, but the basics are:
<Directory /path/to/directory/in/filesystem>
AuthType Basic
AuthName "Authorization Required"
AuthUserFile /etc/httpd/htpasswd
Require valid-user
</Directory>
then you'll need to do (the first time):
htpasswd -c /etc/httpd/htpasswd username
users after that you just use:
htpasswd /etc/httpd/htpasswd username
HTH.
Recently, I have been looking for graphical tools to manage & support trixbox systems. I came across trixboxGraph and this thread. I tried trixboxGraph on a tb2.0 CE system and was impressed.
I have put together some notes on how-to install the old and only version of trixboxGraph under the current versions of tb running under Centos5. The details are here http://cat24.net/trixboxGraph.html
Basically you need to satisfy a variety of dependancies and once this is done trixboxGraph can be downloaded from the trixbox - centos 4 repo and manually installed. The installation seems to be OK and as long as you do not want to display queues trixboxGraph seems to work. The table defining queues in current trixbox CE appears to have changed from 'queues' into two tables queues_config and queues_details.
Consequently running the old trixboxGraph under tb CE 2.6.x gives rise to the error
"select distinct id from queues => Table 'asterisk.queues' doesn't exist"
The following hack seems to provide a work around. In the file /var/www/html/trixboxGraph/index.php about halfway down there is a section
if ($showQueues) {
$sql = "select distinct id from queues";
and a few lines further on
mysql_free_result ($res);
$sql = "select id,data from queues where keyword='member'";
the two references to the variable 'queues' needs to be changed to 'queues_details' to fit the new asterisk sql database table definitions. So the lines should be as follows:
if ($showQueues) {
$sql = "select distinct id from queues_details";
and
mysql_free_result ($res);
$sql = "select id,data from queues_details where keyword='member'";
Changing the code above removes the queue error and displays queues in the same way as they were with earlier tb ce version. I have not gone through the code in detail and more than likely there are thngs that I may have missed. HTH
Hey anchor85, cheers for your post :)
Kerry how are things comming along with getting trixboxGraph in as standard to save people the above config effort?
Also are there any plans for the talented trixbox team to develop trixboxGraph any further than it is?
Also when is the next tb build due, and will it have trixboxGraph and Asterisk 1.4.19 in it?
Cheers All.
We have no plans to develop trixboxgraph as we didn't develop it in the first place. Since nobody has mentioned it in months we didn't feel there was any demand for it.
The next build is due Friday, it will not have trixboxgraph built in and I do not know yet if it will have asterisk 1.4.19 as there have been problems compiling it.
Hey Kerry, cheers for the quick response.
Ok how about this, maybe you could setup a voting post where people could vote on whether they would like to see the trixbox team take trixboxGraph further and make it part of the trixbox interface?
I know you say no one has mentioned it in months, but then again I have only just come across it for the first time and talk about a great missing feature!
Little work for great gains in my eyes :)
Cheers All.
Kerry
My post above gives a solution that gets trixboxgraph working. I am happy to contribute more, but as far as I can see there is no build info available and 'wstroebel' above appears to be inactive on this site & there is no PM link on his account.
However, since this is a noarch.rpm it should be possible to start from scratch, I think the only custom files needed are the two php files installed under the trixboxGraph directory. The libraries etc needed are given in my how-to I assume. I think the trixboxgraph app is a set of libraries and two php files.
So subject to any other suggestions I will try to build an rpm from scratch. What do you think?
Hi Keery,
I hv upgraded my system to 2.6.0.7. Everything works fine.
I wanted to check the Graph module with the system. I tried to install it through Packages, its failing with dependancy errors. I tried to install it manually as well. However, the dependancy list is growing everytime i try to install a new one.
Can we get that module installed through yum?
It is true that trixbox graph is now included in the trixbox package manager. However,
1. If you have 'trixbox stable' and trixbox addons' selected as the repositories then as kulman points out the install fails when you use the package manager, you get dependancy failures with ghostscript and urw-fonts missing. Perhaps selecting more repos will cure that I have not tried.
2. The simple / quick solution is to use yum to install the package.
yum install tb-trixboxgraph
This works fine without changing any of the repo settings. This command will install 13 packages and all the dependancies are satisfied.
However, the trixbox team have changed the package name so that now to run trixboxgraph you need to use the url
http://your-trix-ip/tb-trixboxgraph
NOTE that originally the package had capital G for Graph now its all lowercase and tb- is added as well.
3. Additionally the trixbox team do NOT seem to have updated the index.php file inline with my earlier post so the current index.php file that I have just installed fails to work if you select queues because the queue definition has changed in the latest release of the mysql database.
If you read my post of Mon, 04/07/2008 - 11:49pm above you need to change the occurrence of
queues
to
queues_details
twice in the file
/var/www/html/tb-trixboxgraph/index.php
as I mention above and then queues will work.
hth
EXCELLENT! i JUST found out about this today.
Several feature requests-
-some sort of wrapper script, perhaps, which would let one generate flowcharts from a shell session
-export to html, maybe even pdf directly (i.e. render directly to a file output) (doing this via the htmldoc software should be viable).
This has been really useful for myself and Chris (chrism2) in documenting the dialplans for the trixbox systems we install. Like kspare, there were a few things I thought it'd be nice to have, so I had a look at adding them.
As an example a simple dialplan with the original version might produce http://www.eccentricwombats.com/trixbox/display/trixboxgraph-orig.png but the same dialplan will produce http://www.eccentricwombats.com/trixbox/display/trixboxgraph-new.png with the additions I made.
The code I now have can be found http://www.eccentricwombats.com/trixbox/. Hopefully it'll be useful to other people too.
First I want to thank anchor85, his process worked perfectly.
@pbeaton: You should put some instructions on your site on how to install this. It took me a lot of trial and error to get it working. Once I did get it working though, it was GREAT, the extra info, and the way it creates more of a flow chart, makes this a awesome addition.
Instructions for installation of pbeatons mod of the script
2.4 or using anchor85 method of getting it working
- Install trixboxGraph by # yum install trixboxGraph if using 2.4 or using anchor85's method above for 2.6
- cd in to /var/www/html/trixboxGraph # cd /var/www/html/trixboxGraph
- empty the /var/www/html/trixboxGraph directory # rm -r *.*
- wget the following files
- # wget http://www.eccentricwombats.com/trixbox/files/index-2.4.phps
- # wget http://www.eccentricwombats.com/trixbox/files/functions.phps
- # wget http://www.eccentricwombats.com/trixbox/files/settings.phps
- now rename the files to their proper names
- # mv index-2.4.phps index.php
- # mv functions.phps functions.php
- # mv settings.phps settings.php
- browse to http://TRIXBOX_IP/trixboxGraph and enjoy
Using any current version of Trixbox > 2.6
- install the app with # yum install tb-trixboxgraph
- go to http://TRIXBOX_IP/tb-trixboxgraph and run the app. It will NOT work (at least per the current release in the repo), you need to do this to create the image files. It seems that pbeaton's mod for Trixbox > 2.6 will complain about them not being there (It should auto generate them if it needs them, or just skip it if they aren't there)
- cd in to /var/www/html/tb-trixboxgraph # cd /var/www/html/tb-trixboxgraph
- delete all the files inside this directory, except
- trixboxGraph.eps
- trixboxGraph.gif
- trixboxGraph.pdf
- now this is where it gets a little weird. since the files to download on pbeaton's site seem to link to the wrong files, you will need to use the show file link on his site to view the file, copy the contents, and create them yourself inside the ../tb-trixboxgraph directoy. The files you will need are
- index.php - http://www.eccentricwombats.com/trixbox/display/show_index-2.6.ph... - # nano index.php - paste and save
- functions.php - http://www.eccentricwombats.com/trixbox/display/show_functions-2.... - # nano functions.php - paste and save
- settings.php - http://www.eccentricwombats.com/trixbox/display/show_settings-2.6... - # nano settings.php - paste and save
- styles.css - http://www.eccentricwombats.com/trixbox/display/show_styles-2.6.p... - # nano styles.css - paste and save
- browse to http://TRIXBOX_IP/tb-trixboxgraph and enjoy
No matter what version you are installing, if you have changed your MYSQL user and or password, you must change it in the functions.php file
nano functions.php
On the second line, you'll see
$mcon = mysql_connect ("localhost", "root", "passw0rd");
Change root and passw0rd with the appropriate username/password.
I assume 2.2 would be the same as the 2.4 instructions, but I don't have a 2.2 box to test that on.
pbeaton matched the layout of this app in the 2.6 version to the same color scheme Trixbox uses. Now all we need to do is edit the maint page, and add it to the System menu. Then add http auth using KodaK's method above, using the same user access as /maint/ has, and boom, fully integrated and (as) secure (as trixbox's maint login is)


Member Since:
2006-05-30