MYSQL Extensions

[adonias]

Call Logs x Day

How to generate report for day?

Any sugst?

 

[Mirzab]

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.

 

[adonias]

work ok..

other problem.

need take this dates, and insert in mysql table.

When i using msql_conect say:

Fatal error: Call to undefined function mysql_connect()

??????? :shock:

 

[adonias]

Try copy "php_mysql.dll" in "\3CX PhoneSystem\Bin\Php\extensions".

Apache logs error says:

PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\Archivos de programa\\3CX PhoneSystem\\Bin\\Php\\extensions\\php_mysql.dll' - No se puede encontrar el m\xf3dulo especificado.\r\n in Unknown on line 0

Edit mi php.ini in:

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

 

[Mirzab]

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

 

[webguyz]

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?

 

[adonias]

Well.

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

My web site support only mysql.

Thxx men

 

[BendyMetal]

Have you thought about allowing access to the 3cx server remotely - either ssh/vnc/https/something similar?

 

[adonias]

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