MYSQL Extensions

Discussion in '3CX Phone System - General' started by adonias, Oct 13, 2007.

  1. adonias

    Joined:
    Oct 13, 2007
    Messages:
    7
    Likes Received:
    0
    Call Logs x Day

    How to generate report for day?

    Any sugst?
     
  2. Mirzab

    Mirzab Member

    Joined:
    Jul 22, 2007
    Messages:
    400
    Likes Received:
    0
    Generate monthly, export to Excel (CSV), sort by date will give you daily, and you can all sorts of great stuff with it. Just selecting CSV will open a new tab (in Firefox, why use IE?) to view the CSV file. You can copy and paste data by date if you wish, if just looking for data in a simple format. Can be run daily. Hope this helps.
     
  3. adonias

    Joined:
    Oct 13, 2007
    Messages:
    7
    Likes Received:
    0
    work ok..

    other problem.

    need take this dates, and insert in mysql table.

    When i using msql_conect say:

    ??????? :shock:
     
  4. adonias

    Joined:
    Oct 13, 2007
    Messages:
    7
    Likes Received:
    0
    Try copy "php_mysql.dll" in "\3CX PhoneSystem\Bin\Php\extensions".

    Apache logs error says:

    Edit mi php.ini in:

    Code:
    ;extension=php_interbase.dll
    ;extension=php_ldap.dll
    ;extension=php_mcrypt.dll
    ;extension=php_mhash.dll
    ;extension=php_mime_magic.dll
    ;extension=php_ming.dll
    ;extension=php_mssql.dll
    ;extension=php_msql.dll
    extension=php_mysql.dll        <----- add
    ;extension=php_oci8.dll
    ;extension=php_openssl.dll
    ;extension=php_oracle.dll
    extension=php_pgsql.dll
    extension=php_pdo.dll
    extension=php_pdo_pgsql.dll
    
    Any idea ?
     
  5. Mirzab

    Mirzab Member

    Joined:
    Jul 22, 2007
    Messages:
    400
    Likes Received:
    0
    I have very little knowledge in this area I am afraid. I am hoping another Forum member will be able to provide help and I am tracking this thread so I can learn as well :oops:
     
  6. webguyz

    webguyz New Member

    Joined:
    Jul 19, 2007
    Messages:
    126
    Likes Received:
    0
    3CX uses Postgres as the database and not MySQL. Are you trying to create a new MySQL db? What db are you trying to do a msql_connect to?
     
  7. adonias

    Joined:
    Oct 13, 2007
    Messages:
    7
    Likes Received:
    0
    Well.

    i need export all call logs to my web site for remote admin.

    My web site support only mysql. :p :p

    Thxx men
     
  8. BendyMetal

    Joined:
    Oct 8, 2007
    Messages:
    36
    Likes Received:
    0
    Have you thought about allowing access to the 3cx server remotely - either ssh/vnc/https/something similar?
     
  9. adonias

    Joined:
    Oct 13, 2007
    Messages:
    7
    Likes Received:
    0
    It is much more complicated, because I have three businesses, and would be a folly to be reviewed individually. The best way is to check across a single domain
     

Share This Page