Member
Last active 15 years ago
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
/**
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
--------------------------------------------------------------------------