Not able to connect postgresql with odoo












0















i configured odoo in aws ec2 and connecting postgresql from rds . when i run the comman ./odoo-bin --config=/etc/odoo.conf and try to access from the browser , i am getting the below error.



postgresql version : 9.6.5

odoo verson : 12

ERROR odoo_db odoo.modules.loading: Database odoo_db not initialized, you can force it with `-i base`

File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in __getitem__
return self.models[model_name]
KeyError: 'ir.http' - - -


and getting this error as well
enter image description here










share|improve this question

























  • This is not a connection error, I think the message is that you selected a database that the base module is not installed on it. If it's not a valid database just drop it manually. or force odoo to go to db selection link ` /web/database/manager` and create a valid database

    – EasyOdoo
    Nov 23 '18 at 18:00











  • @EasyOdoo ..still getting this error File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in getitem return self.models[model_name] KeyError: 'ir.http' - - -

    – coder
    Nov 23 '18 at 18:31











  • @EasyOdoo .When i changed odoo12 to odoo11 .everything is fixed .. but not i am getting this error Logged into database odoo_test, but dbfilter rejects it; logging session out.. actually in my odoo-wsgi file the actual database is shtech

    – coder
    Nov 24 '18 at 16:38


















0















i configured odoo in aws ec2 and connecting postgresql from rds . when i run the comman ./odoo-bin --config=/etc/odoo.conf and try to access from the browser , i am getting the below error.



postgresql version : 9.6.5

odoo verson : 12

ERROR odoo_db odoo.modules.loading: Database odoo_db not initialized, you can force it with `-i base`

File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in __getitem__
return self.models[model_name]
KeyError: 'ir.http' - - -


and getting this error as well
enter image description here










share|improve this question

























  • This is not a connection error, I think the message is that you selected a database that the base module is not installed on it. If it's not a valid database just drop it manually. or force odoo to go to db selection link ` /web/database/manager` and create a valid database

    – EasyOdoo
    Nov 23 '18 at 18:00











  • @EasyOdoo ..still getting this error File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in getitem return self.models[model_name] KeyError: 'ir.http' - - -

    – coder
    Nov 23 '18 at 18:31











  • @EasyOdoo .When i changed odoo12 to odoo11 .everything is fixed .. but not i am getting this error Logged into database odoo_test, but dbfilter rejects it; logging session out.. actually in my odoo-wsgi file the actual database is shtech

    – coder
    Nov 24 '18 at 16:38
















0












0








0


2






i configured odoo in aws ec2 and connecting postgresql from rds . when i run the comman ./odoo-bin --config=/etc/odoo.conf and try to access from the browser , i am getting the below error.



postgresql version : 9.6.5

odoo verson : 12

ERROR odoo_db odoo.modules.loading: Database odoo_db not initialized, you can force it with `-i base`

File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in __getitem__
return self.models[model_name]
KeyError: 'ir.http' - - -


and getting this error as well
enter image description here










share|improve this question
















i configured odoo in aws ec2 and connecting postgresql from rds . when i run the comman ./odoo-bin --config=/etc/odoo.conf and try to access from the browser , i am getting the below error.



postgresql version : 9.6.5

odoo verson : 12

ERROR odoo_db odoo.modules.loading: Database odoo_db not initialized, you can force it with `-i base`

File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in __getitem__
return self.models[model_name]
KeyError: 'ir.http' - - -


and getting this error as well
enter image description here







python-3.x odoo






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 23 '18 at 17:43







coder

















asked Nov 23 '18 at 17:15









codercoder

315




315













  • This is not a connection error, I think the message is that you selected a database that the base module is not installed on it. If it's not a valid database just drop it manually. or force odoo to go to db selection link ` /web/database/manager` and create a valid database

    – EasyOdoo
    Nov 23 '18 at 18:00











  • @EasyOdoo ..still getting this error File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in getitem return self.models[model_name] KeyError: 'ir.http' - - -

    – coder
    Nov 23 '18 at 18:31











  • @EasyOdoo .When i changed odoo12 to odoo11 .everything is fixed .. but not i am getting this error Logged into database odoo_test, but dbfilter rejects it; logging session out.. actually in my odoo-wsgi file the actual database is shtech

    – coder
    Nov 24 '18 at 16:38





















  • This is not a connection error, I think the message is that you selected a database that the base module is not installed on it. If it's not a valid database just drop it manually. or force odoo to go to db selection link ` /web/database/manager` and create a valid database

    – EasyOdoo
    Nov 23 '18 at 18:00











  • @EasyOdoo ..still getting this error File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in getitem return self.models[model_name] KeyError: 'ir.http' - - -

    – coder
    Nov 23 '18 at 18:31











  • @EasyOdoo .When i changed odoo12 to odoo11 .everything is fixed .. but not i am getting this error Logged into database odoo_test, but dbfilter rejects it; logging session out.. actually in my odoo-wsgi file the actual database is shtech

    – coder
    Nov 24 '18 at 16:38



















This is not a connection error, I think the message is that you selected a database that the base module is not installed on it. If it's not a valid database just drop it manually. or force odoo to go to db selection link ` /web/database/manager` and create a valid database

– EasyOdoo
Nov 23 '18 at 18:00





This is not a connection error, I think the message is that you selected a database that the base module is not installed on it. If it's not a valid database just drop it manually. or force odoo to go to db selection link ` /web/database/manager` and create a valid database

– EasyOdoo
Nov 23 '18 at 18:00













@EasyOdoo ..still getting this error File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in getitem return self.models[model_name] KeyError: 'ir.http' - - -

– coder
Nov 23 '18 at 18:31





@EasyOdoo ..still getting this error File "/opt/odoo/odoo/odoo/modules/registry.py", line 176, in getitem return self.models[model_name] KeyError: 'ir.http' - - -

– coder
Nov 23 '18 at 18:31













@EasyOdoo .When i changed odoo12 to odoo11 .everything is fixed .. but not i am getting this error Logged into database odoo_test, but dbfilter rejects it; logging session out.. actually in my odoo-wsgi file the actual database is shtech

– coder
Nov 24 '18 at 16:38







@EasyOdoo .When i changed odoo12 to odoo11 .everything is fixed .. but not i am getting this error Logged into database odoo_test, but dbfilter rejects it; logging session out.. actually in my odoo-wsgi file the actual database is shtech

– coder
Nov 24 '18 at 16:38














1 Answer
1






active

oldest

votes


















0














The first glance issue is though the DB has created in Postgres but it has not the required odoo related setup records i.e. base setup. You can verify by directly accessing the DB and see the number of tables or browsing some tables.



It happens sometimes that you create the DB [specifically giving similar DB names as you have already created before and deleted later [its dropped from PG but still has traces in session or DB location path], it will not get initialized properly.



Solution:




  1. Create sample DB with different name initial 4 characters different completely and check

  2. Initialize the DB from odoo.conf file add db_name = < Your DB Name > {for experiment purpose put completely different name} and restart odoo services and check


Hope it will help. Njoy troubleshooting!






share|improve this answer
























  • thanks for helping me.. i created a new db with name odoo_db3 . now i am getting this error now . odoo.modules.loading: Database odoo_db3 not initialized, you can force it with -i base and also getting all the same errors

    – coder
    Nov 24 '18 at 7:48











  • this is issue with odoo 12 and odoo11 is working fine

    – coder
    Nov 24 '18 at 8:21











  • not i am getting this error Logged into database 'odoo_test', but dbfilter rejects it; logging session out. actually in my odoo-wsgi file the actual database is 'shtech'

    – coder
    Nov 24 '18 at 16:37











  • Just for testing purpose remove "shtech" and add say 'test_db' and restart server. It should work.

    – Jameel
    Nov 25 '18 at 10:29











Your Answer






StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});














draft saved

draft discarded


















StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53450720%2fnot-able-to-connect-postgresql-with-odoo%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown

























1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









0














The first glance issue is though the DB has created in Postgres but it has not the required odoo related setup records i.e. base setup. You can verify by directly accessing the DB and see the number of tables or browsing some tables.



It happens sometimes that you create the DB [specifically giving similar DB names as you have already created before and deleted later [its dropped from PG but still has traces in session or DB location path], it will not get initialized properly.



Solution:




  1. Create sample DB with different name initial 4 characters different completely and check

  2. Initialize the DB from odoo.conf file add db_name = < Your DB Name > {for experiment purpose put completely different name} and restart odoo services and check


Hope it will help. Njoy troubleshooting!






share|improve this answer
























  • thanks for helping me.. i created a new db with name odoo_db3 . now i am getting this error now . odoo.modules.loading: Database odoo_db3 not initialized, you can force it with -i base and also getting all the same errors

    – coder
    Nov 24 '18 at 7:48











  • this is issue with odoo 12 and odoo11 is working fine

    – coder
    Nov 24 '18 at 8:21











  • not i am getting this error Logged into database 'odoo_test', but dbfilter rejects it; logging session out. actually in my odoo-wsgi file the actual database is 'shtech'

    – coder
    Nov 24 '18 at 16:37











  • Just for testing purpose remove "shtech" and add say 'test_db' and restart server. It should work.

    – Jameel
    Nov 25 '18 at 10:29
















0














The first glance issue is though the DB has created in Postgres but it has not the required odoo related setup records i.e. base setup. You can verify by directly accessing the DB and see the number of tables or browsing some tables.



It happens sometimes that you create the DB [specifically giving similar DB names as you have already created before and deleted later [its dropped from PG but still has traces in session or DB location path], it will not get initialized properly.



Solution:




  1. Create sample DB with different name initial 4 characters different completely and check

  2. Initialize the DB from odoo.conf file add db_name = < Your DB Name > {for experiment purpose put completely different name} and restart odoo services and check


Hope it will help. Njoy troubleshooting!






share|improve this answer
























  • thanks for helping me.. i created a new db with name odoo_db3 . now i am getting this error now . odoo.modules.loading: Database odoo_db3 not initialized, you can force it with -i base and also getting all the same errors

    – coder
    Nov 24 '18 at 7:48











  • this is issue with odoo 12 and odoo11 is working fine

    – coder
    Nov 24 '18 at 8:21











  • not i am getting this error Logged into database 'odoo_test', but dbfilter rejects it; logging session out. actually in my odoo-wsgi file the actual database is 'shtech'

    – coder
    Nov 24 '18 at 16:37











  • Just for testing purpose remove "shtech" and add say 'test_db' and restart server. It should work.

    – Jameel
    Nov 25 '18 at 10:29














0












0








0







The first glance issue is though the DB has created in Postgres but it has not the required odoo related setup records i.e. base setup. You can verify by directly accessing the DB and see the number of tables or browsing some tables.



It happens sometimes that you create the DB [specifically giving similar DB names as you have already created before and deleted later [its dropped from PG but still has traces in session or DB location path], it will not get initialized properly.



Solution:




  1. Create sample DB with different name initial 4 characters different completely and check

  2. Initialize the DB from odoo.conf file add db_name = < Your DB Name > {for experiment purpose put completely different name} and restart odoo services and check


Hope it will help. Njoy troubleshooting!






share|improve this answer













The first glance issue is though the DB has created in Postgres but it has not the required odoo related setup records i.e. base setup. You can verify by directly accessing the DB and see the number of tables or browsing some tables.



It happens sometimes that you create the DB [specifically giving similar DB names as you have already created before and deleted later [its dropped from PG but still has traces in session or DB location path], it will not get initialized properly.



Solution:




  1. Create sample DB with different name initial 4 characters different completely and check

  2. Initialize the DB from odoo.conf file add db_name = < Your DB Name > {for experiment purpose put completely different name} and restart odoo services and check


Hope it will help. Njoy troubleshooting!







share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 23 '18 at 23:20









JameelJameel

234




234













  • thanks for helping me.. i created a new db with name odoo_db3 . now i am getting this error now . odoo.modules.loading: Database odoo_db3 not initialized, you can force it with -i base and also getting all the same errors

    – coder
    Nov 24 '18 at 7:48











  • this is issue with odoo 12 and odoo11 is working fine

    – coder
    Nov 24 '18 at 8:21











  • not i am getting this error Logged into database 'odoo_test', but dbfilter rejects it; logging session out. actually in my odoo-wsgi file the actual database is 'shtech'

    – coder
    Nov 24 '18 at 16:37











  • Just for testing purpose remove "shtech" and add say 'test_db' and restart server. It should work.

    – Jameel
    Nov 25 '18 at 10:29



















  • thanks for helping me.. i created a new db with name odoo_db3 . now i am getting this error now . odoo.modules.loading: Database odoo_db3 not initialized, you can force it with -i base and also getting all the same errors

    – coder
    Nov 24 '18 at 7:48











  • this is issue with odoo 12 and odoo11 is working fine

    – coder
    Nov 24 '18 at 8:21











  • not i am getting this error Logged into database 'odoo_test', but dbfilter rejects it; logging session out. actually in my odoo-wsgi file the actual database is 'shtech'

    – coder
    Nov 24 '18 at 16:37











  • Just for testing purpose remove "shtech" and add say 'test_db' and restart server. It should work.

    – Jameel
    Nov 25 '18 at 10:29

















thanks for helping me.. i created a new db with name odoo_db3 . now i am getting this error now . odoo.modules.loading: Database odoo_db3 not initialized, you can force it with -i base and also getting all the same errors

– coder
Nov 24 '18 at 7:48





thanks for helping me.. i created a new db with name odoo_db3 . now i am getting this error now . odoo.modules.loading: Database odoo_db3 not initialized, you can force it with -i base and also getting all the same errors

– coder
Nov 24 '18 at 7:48













this is issue with odoo 12 and odoo11 is working fine

– coder
Nov 24 '18 at 8:21





this is issue with odoo 12 and odoo11 is working fine

– coder
Nov 24 '18 at 8:21













not i am getting this error Logged into database 'odoo_test', but dbfilter rejects it; logging session out. actually in my odoo-wsgi file the actual database is 'shtech'

– coder
Nov 24 '18 at 16:37





not i am getting this error Logged into database 'odoo_test', but dbfilter rejects it; logging session out. actually in my odoo-wsgi file the actual database is 'shtech'

– coder
Nov 24 '18 at 16:37













Just for testing purpose remove "shtech" and add say 'test_db' and restart server. It should work.

– Jameel
Nov 25 '18 at 10:29





Just for testing purpose remove "shtech" and add say 'test_db' and restart server. It should work.

– Jameel
Nov 25 '18 at 10:29


















draft saved

draft discarded




















































Thanks for contributing an answer to Stack Overflow!


  • Please be sure to answer the question. Provide details and share your research!

But avoid



  • Asking for help, clarification, or responding to other answers.

  • Making statements based on opinion; back them up with references or personal experience.


To learn more, see our tips on writing great answers.




draft saved


draft discarded














StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53450720%2fnot-able-to-connect-postgresql-with-odoo%23new-answer', 'question_page');
}
);

Post as a guest















Required, but never shown





















































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown

































Required, but never shown














Required, but never shown












Required, but never shown







Required, but never shown







Popular posts from this blog

Berounka

Sphinx de Gizeh

Different font size/position of beamer's navigation symbols template's content depending on regular/plain...