CODEWITHSUNDEEP
databasealfresco
Kader Moulay Ely
Kader Moulay Ely

Reputation: 31

How to access Alfresco database via url?

in my alfresco-global.properties file it says:

 db.url=jdbc:postgresql://localhost:5432/${db.name}

I want to know how to access this database in the browser?

Upvotes: 0

Views: 1539

Answers (3)

Oussama Werfelli
Oussama Werfelli

Reputation: 513

To connect to alfresco data base you can use any Postgresql client, by the way, alfresco install pgAdmin client.

To use this client you shoud open {alfresco_install_directory}/postgresql/bin/pgAdmin3, add new server and type database credentials(host, port ...) from alfresco-global.properties.

Edit

This is an example of configuration, you can find all what you need in alfresco-global.properties.

enter image description here

Upvotes: 1

user9455968
user9455968

Reputation:

The default PostgreSQL client application is psql. If you can't install this or if you want to use a GUI client, the PostgreSQL community maintains a list of GUI clients.

Every client either asks you for credentials or will present you a form where you can enter them.

The JDBC URL from your question is

jdbc:postgresql://localhost:5432/${db.name}

My guess is that db.name is equal to alfresco. So the complete JDBC URL would be

jdbc:postgresql://localhost:5432/alfresco

If you have installed Alfresco only your local computer, this would be the JDBC URL to use with a client that uses JDBC. If you have installed Alfresco on a different computer, you would have to replace localhost with the host name of this computer.

Upvotes: 1

Adrián Álvarez
Adrián Álvarez

Reputation: 41

In case you have made the default installation(postgresql), you cant. If you have switched the database to mysql you could use something like php admin or similar. Hope it helps.

Upvotes: 0

Related Questions