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.

1)

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=2203:1234:all
user=2204:1234:all
user=100:1234:all
user=101:1234:all
user=102:1234:all
user=103:1234:all
user=104:1234:all
user=105:1234:all
user=106:1234:all
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=105:1234:all
;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

--------------------------------------------------------------------------