Not able to connect postgresql with odoo
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
python-3.x odoo
asked Nov 23 '18 at 17:15
codercoder
315
add a comment |
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
python-3.x odoo
asked Nov 23 '18 at 17:15
codercoder
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
add a comment |
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
python-3.x odoo
asked Nov 23 '18 at 17:15
codercoder
315
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
python-3.x odoo
python-3.x odoo
asked Nov 23 '18 at 17:15
codercoder
315
asked Nov 23 '18 at 17:15
codercoder
315
edited Nov 23 '18 at 17:43
coder
asked Nov 23 '18 at 17:15
codercoder
315
asked Nov 23 '18 at 17:15
codercoder
315
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
add a comment |
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
add a comment |
1 Answer
1
active
oldest
votes
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:
- Create sample DB with different name initial 4 characters different completely and check
- 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!
answered Nov 23 '18 at 23:20
JameelJameel
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 baseand 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
add a comment |
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
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
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:
- Create sample DB with different name initial 4 characters different completely and check
- 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!
answered Nov 23 '18 at 23:20
JameelJameel
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 baseand 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
add a comment |
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:
- Create sample DB with different name initial 4 characters different completely and check
- 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!
answered Nov 23 '18 at 23:20
JameelJameel
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 baseand 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
add a comment |
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:
- Create sample DB with different name initial 4 characters different completely and check
- 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!
answered Nov 23 '18 at 23:20
JameelJameel
234
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:
- Create sample DB with different name initial 4 characters different completely and check
- 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!
answered Nov 23 '18 at 23:20
JameelJameel
234
answered Nov 23 '18 at 23:20
JameelJameel
234
answered Nov 23 '18 at 23:20
JameelJameel
234
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 baseand 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
add a comment |
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 baseand 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
add a comment |
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.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
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
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
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
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