Davidin

Member

Last active 15 years ago

  1. 15 years ago
    Wed Oct 14 08:38:42 2009

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

  2. Wed Oct 14 08:15:48 2009

    OK THANKS!!!

  3. Wed Oct 14 08:01:42 2009

    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
    }
    ------------------------------------------------------------

  4. Tue Oct 13 11:10:54 2009

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

  5. Tue Oct 13 10:03:54 2009

    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

  6. Fri Oct 9 10:09:29 2009
    Davidin started the conversation An error has ocurried Unknown field :picture.

    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";

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

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

  7. Wed Oct 7 09:04:16 2009
    Davidin started the conversation An error has ocurried Unknown field :picture.

    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";

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

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

  8. Mon Oct 5 10:24:08 2009
    Davidin started the conversation Connecting to server, attempt number : 1.

    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

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