[OpenSIPS-Users] OPENSIPS_CP DIALPLAN

[Jeff Wilkie]

Got this from a var dump on $link when i process if !is_resource.  Not sure
if this actually provides any information that may help.  I'm digging
online to see why the $link is not connecting as a resource in this portion
for whatever reason:

Warning: mysql_real_escape_string() expects parameter 2 to be resource,
object given in /var/www/opensips_cp/web/tools/system/dialplan/dialplan.php
on line 288

array(0) { }
object(MDB2_Driver_mysql)#2 (36) {
   ["string_quoting"]=> array(4) {
        ["start"]=> string(1) "'"
        ["end"]=> string(1) "'"
        ["escape"]=> string(1) "\"
        ["escape_pattern"]=> string(1) "\" }
   ["identifier_quoting"]=> array(3) {
        ["start"]=> string(1) "`"
        ["end"]=> string(1) "`"
        ["escape"]=> string(1) "`" }
   ["sql_comments"]=> array(3) {
        [0]=> array(3) {
            ["start"]=> string(3) "-- "
            ["end"]=> string(1) " "
            ["escape"]=> bool(false) }
        [1]=> array(3) {
            ["start"]=> string(1) "#"
            ["end"]=> string(1) " "
            ["escape"]=> bool(false) }
        [2]=> array(3) {
            ["start"]=> string(2) "/*"
            ["end"]=> string(2) "*/"
            ["escape"]=> bool(false) } }
    ["start_transaction"]=> bool(true)
    ["varchar_max_length"]=> int(65532)
    ["db_index"]=> int(1)
    ["dsn"]=> array(10) {
         ["phptype"]=> string(5) "mysql"
         ["dbsyntax"]=> string(5) "mysql"
         ["username"]=> string(10) "xxxxxxxx"
         ["password"]=> string(12) "xxxxxxxx"
         ["protocol"]=> string(3) "tcp"
         ["hostspec"]=> string(9) "localhost"
         ["port"]=> bool(false)
         ["socket"]=> bool(false)
         ["database"]=> bool(false)
         ["mode"]=> bool(false) }
    ["connected_dsn"]=> array(10) {
         ["phptype"]=> string(5) "mysql"
         ["dbsyntax"]=> string(5) "mysql"
         ["username"]=> string(10) "xxxxxx"
         ["password"]=> string(12) "xxxxxx"
         ["protocol"]=> string(3) "tcp"
         ["hostspec"]=> string(9) "localhost"
         ["port"]=> bool(false)
         ["socket"]=> bool(false)
         ["database"]=> bool(false)
         ["mode"]=> bool(false) }
    ["connection"]=> resource(16) of type (mysql link)
    ["opened_persistent"]=> bool(false)
    ["database_name"]=> string(10) "xxxxxxxxx"
    ["connected_database_name"]=> string(10) "xxxxxxxxx"
["connected_server_info"]=> string(10) "5.1.73-log"
["supported"]=> array(19) {
["sequences"]=> string(8) "emulated"
["indexes"]=> bool(true)
["affected_rows"]=> bool(true)
["summary_functions"]=> bool(true)
["order_by_text"]=> bool(true)
["transactions"]=> bool(true)
["savepoints"]=> bool(true)
["current_id"]=> string(8) "emulated"
["limit_queries"]=> bool(true)
 ["LOBs"]=> bool(true)
["replace"]=> bool(true)
["sub_selects"]=> bool(true)
["auto_increment"]=> bool(true)
["primary_key"]=> bool(true)
["result_introspection"]=> bool(true)
["prepared_statements"]=> bool(true)
["identifier_quoting"]=> bool(true)
["pattern_escaping"]=> bool(true)
["new_link"]=> bool(true) }
["options"]=> array(30) {
["ssl"]=> bool(false)
["field_case"]=> int(0)
["disable_query"]=> bool(false)
 ["result_class"]=> string(14) "MDB2_Result_%s"
["buffered_result_class"]=> string(22) "MDB2_BufferedResult_%s"
["result_wrap_class"]=> bool(false)
["result_buffering"]=> bool(true)
["fetch_class"]=> string(8) "stdClass"
["persistent"]=> bool(false)
["debug"]=> int(0)
["debug_handler"]=> string(23) "MDB2_defaultDebugOutput"
["debug_expanded_output"]=> bool(false)
["default_text_field_length"]=> int(4096)
["lob_buffer_length"]=> int(8192)
["log_line_break"]=> string(1) " "
["idxname_format"]=> string(6) "%s_idx"
["seqname_format"]=> string(6) "%s_seq"
 ["savepoint_format"]=> string(17) "MDB2_SAVEPOINT_%s"
["statement_format"]=> string(24) "MDB2_STATEMENT_%1$s_%2$s"
["seqcol_name"]=> string(8) "sequence"
["quote_identifier"]=> bool(false)
["use_transactions"]=> bool(true)
["decimal_places"]=> int(2)
["portability"]=> int(127)
["modules"]=> array(6) {
["ex"]=> string(8) "Extended"
["dt"]=> string(8) "Datatype"
 ["mg"]=> string(7) "Manager"
["rv"]=> string(7) "Reverse"
["na"]=> string(6) "Native"
["fc"]=> string(8) "Function" }
["emulate_prepared"]=> bool(false)
["datatype_map"]=> array(0) { }
["datatype_map_callback"]=> array(0) { }
["nativetype_map_callback"]=> array(0) { }
["default_table_type"]=> string(0) "" }
["wildcards"]=> array(2) {
[0]=> string(1) "%"
[1]=> string(1) "_" }
["as_keyword"]=> string(4) " AS "
["warnings"]=> array(0) { }
["debug_output"]=> string(0) ""
["in_transaction"]=> NULL
["nested_transaction_counter"]=> NULL
["has_transaction_error"]=> bool(false)
["offset"]=> int(0) ["limit"]=> int(0)
["phptype"]=> string(5) "mysql"
["dbsyntax"]=> string(5) "mysql"
["last_query"]=> NULL
["fetchmode"]=> int(2)
["modules"]=> array(0) { }
["destructor_registered"]=> bool(true)
["_debug"]=> bool(false)
["_default_error_mode"]=> NULL
["_default_error_options"]=> NULL
["_default_error_handler"]=> string(0) ""
["_error_class"]=> string(10) "PEAR_Error"
["_expected_errors"]=> array(0) { } }

Jeff
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.opensips.org/pipermail/users/attachments/20160829/982399ec/attachment-0001.htm>