Forum

Benvenuto!

Questo è il forum ufficiale dell'Associazione Odoo Italia. Dopo esserti registrato potrai partecipare ponendo domande o rispondendo a quelle esistenti. Non scordarti di compilare il tuo profilo e consultare le linee guida prima di iniziare a scrivere.

0

[12.0] Creare due o più database

Avatar
ToBeSmart

Ragazzi, non riesco a creare un nuovo database.

Dal web/database/create, quando creo un database ottengo sempre l'errore Database creation error: Access denied
Ho verificato che la Master password nel file odoo12.conf sia quella impostata in admin_passwd

Il campo è impostato su db_password = False

Qualche idea?

Avatar
Abbandona
5 Risposte
3
Avatar
Alex Comba
Migliore risposta

Ciao,

dallo stacktrace che hai postato si evince che la causa della mancata creazione di un nuovo database è:

File "/opt/odoo/odoo12/addons/web/views/webclient_templates.xml", line 375
lxml.etree.XMLSyntaxError: Opening and ending tag mismatch: t line 350 and div, line 375, column 19
Questo errore ti sta dicendo che nel file "/opt/odoo/odoo12/addons/web/views/webclient_templates.xml", alla riga 375, colonna 19, il tag, aperto alla riga 350, non risulta chiuso.
Avatar
Abbandona
0
Avatar
ToBeSmart
Migliore risposta

Effettivamente il problema era lì. Ho modificato il file ed il problema è stato risolto.

Grazie del tuo prezioso supporto

Avatar
Abbandona
0
Avatar
Alex Comba
Migliore risposta

Ciao,

puoi postare il traceback e il file di configurazione della tua istanza Odoo?

Avatar
Abbandona
0
Avatar
ToBeSmart
Migliore risposta

Per sbaglio ho postato la risposta come commento al post generico e non come risposta al tuo reply... 

Avatar
Abbandona
0
Avatar
ToBeSmart
Migliore risposta

Credo che per traceback intendi il file log, giusto?

eccolo

2020-09-29 20:07:30,267 2031 INFO online2 odoo.modules.loading: loading 9 modules... 

2020-09-29 20:07:30,682 2031 INFO online2 odoo.modules.registry: module web: creating or updating database tables 

2020-09-29 20:07:31,710 2031 INFO online2 odoo.modules.loading: loading web/security/ir.model.access.csv 

2020-09-29 20:07:31,723 2031 INFO online2 odoo.modules.loading: loading web/views/webclient_templates.xml 

2020-09-29 20:07:31,730 2031 WARNING online2 odoo.modules.loading: Transient module states were reset 

2020-09-29 20:07:31,731 2031 ERROR online2 odoo.modules.registry: Failed to load registry 

Traceback (most recent call last):

  File "/opt/odoo/odoo12/odoo/modules/registry.py", line 86, in new

    odoo.modules.load_modules(registry._db, force_demo, status, update_module)

  File "/opt/odoo/odoo12/odoo/modules/loading.py", line 421, in load_modules

    loaded_modules, update_module, models_to_check)

  File "/opt/odoo/odoo12/odoo/modules/loading.py", line 313, in load_marked_modules

    perform_checks=perform_checks, models_to_check=models_to_check

  File "/opt/odoo/odoo12/odoo/modules/loading.py", line 222, in load_module_graph

    load_data(cr, idref, mode, kind='data', package=package, report=report)

  File "/opt/odoo/odoo12/odoo/modules/loading.py", line 68, in load_data

    tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report)

  File "/opt/odoo/odoo12/odoo/tools/convert.py", line 802, in convert_file

    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

  File "/opt/odoo/odoo12/odoo/tools/convert.py", line 848, in convert_xml_import

    doc = etree.parse(xmlfile)

  File "src/lxml/lxml.etree.pyx", line 3427, in lxml.etree.parse (src/lxml/lxml.etree.c:81110)

  File "src/lxml/parser.pxi", line 1832, in lxml.etree._parseDocument (src/lxml/lxml.etree.c:118109)

  File "src/lxml/parser.pxi", line 1852, in lxml.etree._parseFilelikeDocument (src/lxml/lxml.etree.c:118392)

  File "src/lxml/parser.pxi", line 1747, in lxml.etree._parseDocFromFilelike (src/lxml/lxml.etree.c:117180)

  File "src/lxml/parser.pxi", line 1162, in lxml.etree._BaseParser._parseDocFromFilelike (src/lxml/lxml.etree.c:111907)

  File "src/lxml/parser.pxi", line 595, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:105102)

  File "src/lxml/parser.pxi", line 706, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:106810)

  File "src/lxml/parser.pxi", line 635, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:105664)

  File "/opt/odoo/odoo12/addons/web/views/webclient_templates.xml", line 375

lxml.etree.XMLSyntaxError: Opening and ending tag mismatch: t line 350 and div, line 375, column 19

2020-09-29 20:07:31,735 2031 ERROR online2 odoo.service.db: CREATE DATABASE failed: 

Traceback (most recent call last):

  File "/opt/odoo/odoo12/odoo/service/db.py", line 62, in _initialize_db

    registry = odoo.modules.registry.Registry.new(db_name, demo, None, update_module=True)

  File "/opt/odoo/odoo12/odoo/modules/registry.py", line 86, in new

    odoo.modules.load_modules(registry._db, force_demo, status, update_module)

  File "/opt/odoo/odoo12/odoo/modules/loading.py", line 421, in load_modules

    loaded_modules, update_module, models_to_check)

  File "/opt/odoo/odoo12/odoo/modules/loading.py", line 313, in load_marked_modules

    perform_checks=perform_checks, models_to_check=models_to_check

  File "/opt/odoo/odoo12/odoo/modules/loading.py", line 222, in load_module_graph

    load_data(cr, idref, mode, kind='data', package=package, report=report)

  File "/opt/odoo/odoo12/odoo/modules/loading.py", line 68, in load_data

    tools.convert_file(cr, package.name, filename, idref, mode, noupdate, kind, report)

  File "/opt/odoo/odoo12/odoo/tools/convert.py", line 802, in convert_file

    convert_xml_import(cr, module, fp, idref, mode, noupdate, report)

  File "/opt/odoo/odoo12/odoo/tools/convert.py", line 848, in convert_xml_import

    doc = etree.parse(xmlfile)

  File "src/lxml/lxml.etree.pyx", line 3427, in lxml.etree.parse (src/lxml/lxml.etree.c:81110)

  File "src/lxml/parser.pxi", line 1832, in lxml.etree._parseDocument (src/lxml/lxml.etree.c:118109)

  File "src/lxml/parser.pxi", line 1852, in lxml.etree._parseFilelikeDocument (src/lxml/lxml.etree.c:118392)

  File "src/lxml/parser.pxi", line 1747, in lxml.etree._parseDocFromFilelike (src/lxml/lxml.etree.c:117180)

  File "src/lxml/parser.pxi", line 1162, in lxml.etree._BaseParser._parseDocFromFilelike (src/lxml/lxml.etree.c:111907)

  File "src/lxml/parser.pxi", line 595, in lxml.etree._ParserContext._handleParseResultDoc (src/lxml/lxml.etree.c:105102)

  File "src/lxml/parser.pxi", line 706, in lxml.etree._handleParseResult (src/lxml/lxml.etree.c:106810)

  File "src/lxml/parser.pxi", line 635, in lxml.etree._raiseParseError (src/lxml/lxml.etree.c:105664)

  File "/opt/odoo/odoo12/addons/web/views/webclient_templates.xml", line 375

lxml.etree.XMLSyntaxError: Opening and ending tag mismatch: t line 350 and div, line 375, column 19

2020-09-29 20:07:31,740 2031 INFO online2 odoo.modules.loading: loading 1 modules... 

2020-09-29 20:07:31,755 2031 INFO online2 odoo.modules.loading: 1 modules loaded in 0.01s, 0 queries 

2020-09-29 20:07:31,928 2031 INFO online2 odoo.modules.loading: Modules loaded. 

2020-09-29 20:07:31,934 2031 INFO online2 odoo.addons.base.models.res_users: Login failed for db:online2 login:info@tobesmart.net from 79.22.55.177 

2020-09-29 20:07:32,009 2031 INFO online2 odoo.sql_db: ConnectionPool(used=1/count=4/max=64): Closed 1 connections to 'user=odoousr sslmode=prefer dbname=online' 

2020-09-29 20:07:32,010 2031 INFO online2 odoo.sql_db: ConnectionPool(used=1/count=3/max=64): Closed 1 connections to 'user=odoousr sslmode=prefer dbname=online2' 

2020-09-29 20:07:32,014 2031 INFO test2 werkzeug: 79.22.55.177 - - [29/Sep/2020 20:07:32] "POST /web/database/create HTTP/1.1" 200 - 21136 10.039 10.949

2020-09-29 20:07:57,949 2042 WARNING ? odoo.addons.base.models.ir_cron: Skipping database online2 because of modules to install/upgrade/remove. 

2020-09-29 20:07:57,949 2042 INFO ? odoo.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 1 connections to 'user=odoousr sslmode=prefer dbname=online2' 

2020-09-29 20:07:57,962 2042 INFO ? odoo.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 1 connections to 'user=odoousr sslmode=prefer dbname=test2' 

2020-09-29 20:07:57,975 2042 WARNING ? odoo.addons.base.models.ir_cron: Skipping database online because of modules to install/upgrade/remove. 

2020-09-29 20:07:57,975 2042 INFO ? odoo.sql_db: ConnectionPool(used=0/count=0/max=64): Closed 1 connections to 'user=odoousr sslmode=prefer dbname=online' 

mentre il file odoo12.conf è questo
[options]
; This is the password that allows database operations:
admin_passwd = PASSWORD
db_host = False
db_port = False
db_user = odoousr
db_password = False
addons_path = /opt/odoo/odoo12/addons,/opt/odoo/odoo12-custom-addons/
logfile = /var/log/odoo12/odoo.log

limit_memory_hard = 1677721600
limit_memory_soft = 629145600
limit_request = 8192
limit_time_cpu = 600
limit_time_real = 1200
max_cron_threads = 1
workers = 8


Avatar
Abbandona
-1
Avatar
ToBeSmart
Migliore risposta

La cosa che non mi torna è che riesco ad eliminare i database, ma non a crearli...

Avatar
Abbandona