FOP2 Community Forum

removed for now

This will work as long as your using the context from-internal

# SCCP EXTENSIONS

mysql -ENB -u $DBUSER -p$DBPASS -h $DBHOST $DBNAME -e "select concat('SCCP/',extension) as channel,extension,name as label,concat(s1.id,'@default') as mailbox,'from-internal' as context,concat('*',s1.id,'@default') as extenvoicemail from users as u left join devices as s1 on u.extension=s1.id and s1.tech='custom' left join devices as s2 on u.extension=s2.id where s2.dial LIKE 'SCCP/%' order by extension" | sed '/\*\*/d' | sed 's/: /=/g' | while read LINEA
do
echo $LINEA | sed 's/channel=\(.*\)/\n[\1]\ntype=extension/g'
done

You could build the buttons from the "Table devices in database asterisk" the tech feild will = custom and dial will = SCCP/EXTNUMBER

Did anything ever come of this Nicolás?

Not sure about the instructions but heres the [url=http://www.fop2.com/forum/View Post 179#p697:1qifp0rn]beta[/url:1qifp0rn]

#PARKSLOT=/usr/sbin/asterisk -rx "dialplan show parkedcalls" | grep "=>" | cut -d= -f1 | sed s/\'//g | sed 's/ //g'
#if [ "X${PARKSLOT}" != "X" ]; then
#echo
#echo "[PARK/default]"
#echo "extension=${PARKSLOT}"
#echo "context=parkedcalls"
#echo "type=park"
#echo "Label=Park ${PARKSLOT}"
#echo
#fi

The parking lot seems to be commented out in autoconfig-buttons-freepbx.sh for some reason, maybe its not ready yet.

Think this would be perfect for your phonebook as you could pull all the orginisations data in one go, not sure how big a job this would be so I may even look at doing it myself.

That fixed it for the most part, with the exception of one remaining error:

"notice
/var/www/html/fop2/lib/dblib.php (line 233)

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource"

I am going to use the fix posted by Thomas in a previous forum post

View Post 143&p=545&hilit=supplied+argument+is+not+a+valid+MySQL+result+resource#p545

But wanted to give a head's up.

I wouldn't do that because all I did in that post was give it a condition that it could never match, just switch debugging off and report it as a bug to Nicolas.

The visual_phonebook table structure in the beta changed. You are using the old structure. In the beta tarball there is a mysql-update.db file with the alter commands to add the missing fields. Best regards,

That would answer that bad result Happy New Year.

Are you sure the config.php is setup properly?

Thanks for clearing that up Nicolas.

I read on the forums that the swf file looks to connect on 4445 and cannot be changed at this time(although i would wait on Nicolas to confim it)

I suppose you could do something like

public function fetch_assoc($query = false) {
        $this->res_type($query);
	 if($query and !is_bool($query)) { 
  		return mysql_fetch_assoc($query); 
	 } 
 }

But my PHP isn't very good so if Nicolas could confirm that this isn't going to bork anything

I've updated my post in the installation and setup forum for you to read over, for some reason the import didn't work as expected, I've tested and re-tested the import as per the FOP2 Documentation and it works everytime :? anyhoo there is a workaround in the other forum

Hows about

mysql -u root -proot
use fop2;

copy all and paste to console screen

CREATE TABLE `visual_phonebook` (
  `id` int(11) NOT NULL auto_increment,
  `firstname` varchar(50) default NULL,
  `lastname` varchar(50) default NULL,
  `company` varchar(100) default NULL,
  `phone1` varchar(25) default NULL,
  `phone2` varchar(25) default NULL,
  `picture` varchar(100) default NULL,
  PRIMARY KEY  (`id`)
) ENGINE=MyISAM;

and then

show columns from visual_phonebook;
+-----------+--------------+------+-----+---------+----------------+
| Field     | Type         | Null | Key | Default | Extra          |
+-----------+--------------+------+-----+---------+----------------+
| id        | int(11)      | NO   | PRI | NULL    | auto_increment |
| firstname | varchar(50)  | YES  |     | NULL    |                |
| lastname  | varchar(50)  | YES  |     | NULL    |                |
| company   | varchar(100) | YES  |     | NULL    |                |
| phone1    | varchar(25)  | YES  |     | NULL    |                |
| phone2    | varchar(25)  | YES  |     | NULL    |                |
| picture   | varchar(100) | YES  |     | NULL    |                |
+-----------+--------------+------+-----+---------+----------------+
7 rows in set (0.00 sec)

for testing

insert into visual_phonebook(firstname, lastname, phone1) values('john', 'doe', '0141123456');
select * from visual_phonebook;
+----+-----------+----------+---------+------------+--------+---------+
| id | firstname | lastname | company | phone1     | phone2 | picture |
+----+-----------+----------+---------+------------+--------+---------+
|  1 | john      | doe      | NULL    | 0141123456 | NULL   | NULL    |
+----+-----------+----------+---------+------------+--------+---------+
1 row in set (0.00 sec)

I'm sure thats by design.

I think it would need to be the freepbx guys that done this request or you would have to change the engine file every time you update freepbx, looking at the file it shouldn't be to hard for them to do

[added]
here is something to get you started

reload_fop2() {
	ps -C "fop2_server" >& /dev/null
	if [[ $? -eq 0 ]]; then
    		/etc/rc.d/init.d/fop2 restart
		echo "FOP2 was restarted"
	else 
		/etc/rc.d/init.d/fop2 start
		echo "FOP2 was started"
	fi
}

you could call this via reload_fop2 in the engine reload script

In regards to the multi tennant is 1000 a real extension? You could also post the details for 1000 in you button conf.

Log-in to mysql and then

use fop2;
select * from visual_phonebook;

do you see the picture column?

also goto

/var/www/html/fop2/

edit config.php

Change

define('DEBUG',false);

to

define('DEBUG',true);

save and upload, goto http://YOUR_SERVER_IP/fop2/phonebook.php
and paste the output here

The visual phonebook requires php and mysql to be installed and running. You need to create a database and a table and give proper mysql credentials to the php application so it can read and write to the table. You also have to configure the language for the php application. In order to start, be sure to create a database for mysql using the proper password (replace XXXXX with your mysql root password

And [url=http://www.somacon.com/p109.php:dyl6jse3]This[/url:dyl6jse3]