3CX database?

[iperez_genius]

Is it possible to access and view the 3cx database?
if so how...

where can i find the DB name, username and password?


Ilan

 

[Anonymous]

http://docs.google.com/View?docid=dqnz5cc_59cb9jn8hp

 

[francesco]

you can use pgadmin III

 

[Henk]

5.1 Accessing the 3CX Database
To access the database from another server than the localhost or the server where the software is installed on you have to make some changes to the PostgreSQL configuration.

<3CX install dir>\Data\DB\pg_hba.conf

In the # IPv4 local connections: section

Type Database User CIDR-address Method
Host All All 127.0.0.1/32 Password
Host All All <your IP range like eg 192.168.0.0 >/24 password

The IPv6 stuff is not supported by 3CX as yet so leave that for the time being.


<3CX install dir>\Data\DB\ postgresql.conf:

# - Connection Settings -

listen_addresses = '*'
# SDP allowed any IP address to be listened for!
# was restricted to 'localhost'
port = 5480
max_connections = 250

This can be troublesome.. after any changes stop and start the 3cx Database service and then check your postgresql log for any issues (located at: C:\Program Files\3CX PhoneSystem\Data\DB\pg_log)

Now on your client PC:
Download the psqlodbc Win 32 version from here:
http://www.postgresql.org/ftp/odbc/versions/msi/ (get latest release - from the bottom!) and install it.
Add an ODBC Connection (Start/Control Panel/Administrative Tools/Data Sources (ODBC), choose at Add under the System DSN TAB and choose the Psqlodbc driver, the details entered should be as follows:

 

[Henk]

MS Access? ( walking away head shaking).

But lets not start a discussion about that ....... /

 

[Henk]

,

I know it works, just kidding with ya.

Personally I do not like MSAccess to much as a DB but that is just a personal thing.

H

 

[Thona]

The DB is not access....
....just the reporting utility, if i unerstood that right.

A funny choice, but understandable.

 

[cyclone76]

Can i install and use phpmyadmin to see sql database ?