FOP2 Community Forum

OKKKKKK !!!!! tHANKS tHOMAS.Error solved.

OK THANKS!!!

Ok Thanks!!!

But not everything is correct.
This error has not been solved.

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

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

---

dblib.php

/**
 * Fetch results by associative array
 *
 * @param mixed $query Select query or database result
 * @return array Row
 */
public function fetch_assoc($query = false) {
    $this->res_type($query);
    return mysql_fetch_assoc($query);  <<<<<<<<----------LINE 233
}

---

I think the problem is that doesn't generates automaticaly the table visual_phonebook in fop2.
I don't understand this.

mysql> use fop2;
Database changed
mysql> select * from visual_phonebook;
ERROR 1146 (42S02):Table 'fop2.visual_phonebook' doesn´t exist

2)edit config.php

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

mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource
notice
/var/www/html/fop2/lib/dblib.php (line 233)

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

An error has occurred

Unknown field: picture
notice
/var/www/html/fop2/lib/dblib.php (line 344)

mysql_num_fields(): supplied argument is not a valid MySQL result resource
notice
/var/www/html/fop2/lib/dblib.php (line 333)

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

No records found
notice
/var/www/html/fop2/lib/dblib.php (line 244)

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

After configuring the visual phonebook in the paragraph : Configuring Visual phonebook,the error continued.

((((my MYSQL root password is 'root')))

[root@centos init.d]# service mysqld start
Iniciando MySQL: [ OK ]

[root@centos fop2]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| fop2 |
| mysql |
| test |
+--------------------+
4 rows in set (0.01 sec)

mysql> use fop2
Database changed

mysql> show tables;
Empty set (0.00 sec)

[root@centos fop2]# mysql -u root -proot < mysql.db

mysql> GRANT ALL on fop2.* TO fop2@localhost IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye.

[root@centos fop2]# service fop2 restart
Shutting dows Flash Operator Panel 2: [ OK ]
Starting Flash Operator Panel 2: [ OK ]

---

config.php

<?
// Database connection details
$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'fop2';
$DBPASS = 'root';

$language="en";

---

---

After configuring the visual phonebook in the paragraph : Configuring Visual phonebook,the error continued.

((((my MYSQL root password is 'root')))

[root@centos init.d]# service mysqld start
Iniciando MySQL: [ OK ]

[root@centos fop2]# mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 5
Server version: 5.0.77 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> show databases;
+--------------------+
| Database |
+--------------------+
| information_schema |
| fop2 |
| mysql |
| test |
+--------------------+
4 rows in set (0.01 sec)

mysql> use fop2
Database changed

mysql> show tables;
Empty set (0.00 sec)

[root@centos fop2]# mysql -u root -proot < mysql.db

mysql> GRANT ALL on fop2.* TO fop2@localhost IDENTIFIED BY 'root';
Query OK, 0 rows affected (0.00 sec)

mysql> exit
Bye.

[root@centos fop2]# service fop2 restart
Shutting dows Flash Operator Panel 2: [ OK ]
Starting Flash Operator Panel 2: [ OK ]

---

config.php

<?
// Database connection details
$DBHOST = 'localhost';
$DBNAME = 'fop2';
$DBUSER = 'fop2';
$DBPASS = 'root';

$language="en";

---

---

HELP ME PLEASE!!!!! MY CONFIGURATION IS CORRECT BUT IS IMPOSSIBLE LOGIN .
HERE MY CONFIGURATION AND SOME TESTS.

---

centos*CLI> manager show users

username

admin

1 manager users configured.

---

centos*CLI> manager show connected
Username IP Address
admin 192.168.1.200

---

[root@centos fop2]# ./fop2_server --test
Flash Operator Panel 2 - No valid license found. Demo Mode
Connection to manager OK!

---

[root@centos fop2]# ./autoconfig-users-freepbx.sh
user=2203all
user=2204all
user=100all
user=101all
user=102all
user=103all
user=104all
user=105all
user=106all
buttonfile=autobuttons.cfg

---

[root@centos fop2]# pgrep fop2_server
16520

[root@centos fop2]# netstat -nta
Active Internet connections (servers and established)
Proto Recv-Q Send-Q Local Address Foreign Address State
tcp 0 0 0.0.0.0:868 0.0.0.0:* LISTEN
tcp 0 0 192.168.1.200:5038 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:111 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:2000 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:631 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:1720 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 0.0.0.0:4445 0.0.0.0:* LISTEN
tcp 0 0 192.168.1.200:43885 192.168.1.200:5038 ESTABLISHED
tcp 0 0 192.168.1.200:49597 200.61.177.8:80 ESTABLISHED
tcp 0 0 192.168.1.200:5038 192.168.1.200:43885 ESTABLISHED
tcp 0 0 :::80 :::* LISTEN
tcp 0 0 :::22 :::* LISTEN
tcp 0 0 :::443 :::* LISTEN

[root@centos fop2]# iptables -vnL
Chain INPUT (policy ACCEPT 28094 packets, 28M bytes)
pkts bytes target prot opt in out source destination

Chain FORWARD (policy ACCEPT 0 packets, 0 bytes)
pkts bytes target prot opt in out source destination

Chain OUTPUT (policy ACCEPT 20406 packets, 2819K bytes)
pkts bytes target prot opt in out source destination

---

fop.cfg

[general]
; AMI definitions
manager_host=192.168.1.200
manager_port=5038
manager_user=admin
manager_secret=amp111
;event_mask=call,agent

; Daemon definitios
;listen_port = 4445
;restrict_host = www.asternic.org
;web_dir = /var/www/html/operator/fop2

; Global Config
language = en
poll_interval = 86400
poll_voicemail = 1
monitor_ipaddress = 0

;master_key = 1234

user=105all
;buttonfile=autobuttons.cfg
;#exec autoconfig-users-freepbx.sh

---

manager.conf

;
; AMI - The Asterisk Manager Interface
;
[general]
enabled = yes
port = 5038
bindaddr = 192.168.1.200

[admin]
secret = amp111
deny = 0.0.0.0/0.0.0.0
permit = 192.168.1.200/255.255.255.0
read = system,call,command,agent,user,originate
write = system,call,command,agent,user,originate

---