Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

How do I find out the name of the database to use to connect over XMLRPC?

By
Kasper Souren
on 7/23/14, 6:03 AM 863 views

I'm trying to use an XMLRPC connection but I don't know which database to connect to. I can log in to the system, but it doesn't show me which db it is using. How can I find out?

import xmlrpclib

user = 'admin'
password = 'PASSWORD'
host = 'localhost:8069'
db = 'test'  # How do I find out what database to connect to?

sock = xmlrpclib.ServerProxy('http://%s/xmlrpc/common' % host)
uid = sock.login(db, user, password)

HI Kasper, You can select the database by geting in with this URL: www.*YOURDOMAIN*.com/web/database/selector Regards, Juan José - Ing ADHOC

Juan José Scarafía
on 7/29/14, 8:40 AM
1

Ben Bernard

--Ben Bernard--
1083
| 4 3 6
Jakarta, Indonesia
--Ben Bernard--
Ben Bernard
On 7/23/14, 10:16 PM

db_serv_url = 'http://{}/xmlrpc/db'.format(host)

sock = xmlrpclib.ServerProxy(db_serv_url)

dbs = sock.list()

print dbs

 

1

Ray Carnes

--Ray Carnes--
15717
| 9 7 9
Greater Los Angeles, United States
--Ray Carnes--

Senior Odoo Analyst

OpenERP 6.1, 7.0 and Odoo 8.0, 9.0 (Since 2012)

Completed Functional and Technical Training.

Major Skills:

  • Needs Discovery and Requirements Analysis;

  • Function and Technical Specifications;

  • Project Planning;

  • Prototyping and Proof of concepts;

  • Data migration;

  • Configuration & Customization (UI and modules);

  • Integration - data, business logic and service levels;

  • Training and Knowledge transfer;

  • Go Live support;

  • Help desk;

  • Version Migration.

I have over 20 years of experience empowering and enabling users with enterprise information systems that make a real and measurable difference in their ability to proactively manage their businesses and organizations. 

Ray Carnes
On 7/23/14, 10:48 PM

Use your browser to navigate to http://localhost:8069.

You will either see a list of databases in a dropdown in the top right corner, or (if there is only a single database) will need to click the link 'Manage Databases', then 'Drop' to see the name of the database.

Alternatively, look in the URL when you have logged into the system via the web for the db= parameter.

Bista Solutions US, Ray Carnes
on 7/23/14, 10:49 PM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 7/23/14, 6:03 AM
Seen: 863 times
Last updated: 3/16/15, 8:10 AM