Dismiss Notice
We would like to remind you that we’re updating our login process for all 3CX forums whereby you will be able to login with the same credentials you use for the Partner or Customer Portal. Click here to read more.

MYSQL Extensions

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

Thread Status:
Not open for further replies.
  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
     
Thread Status:
Not open for further replies.