#You can easily hide or remove fields from odoo filter by inheriting function fields_get()
@api.model
def fields_get(self, fields=None):
show = ['file_name','partner_id','line_partner_ids','common_message','state','upload_type']
group = ['partner_id','state','upload_type']
res = super(SendDocument, self).fields_get()
for field in res:
res[field]['selectable'] = False
res[field]['sortable'] = False
for field in show:
res[field]['selectable'] = True
for field in group:
res[field]['sortable'] = True
return res
Category: odoo
How to drop database(PostgreSQL) if there are active connections to it(PostgreSQL database is being accessed by other users)?
- PostgreSQL 9.2 and above:
SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name' -- ← change this to your DB
AND pid <> pg_backend_pid();
OR
- PostgreSQL 9.1 and below:
SELECT pg_terminate_backend(pg_stat_activity.procpid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name' -- ← change this to your DB
AND procpid <> pg_backend_pid();
sudo su postgres
psql
drop database database_name;
Get product.template ids from sale.order product.product
sale_order = self.env[‘sale.order’].browse(id)
products = sale_order.mapped(‘order_line.product_id.product_tmpl_id’)
Get product.template ids from sale.order
sale_order = self.env[‘sale.order’].browse(id)
products = sale_order.mapped(‘order_line.product_id.product_tmpl_id’)
Backup/Export Odoo postgres database
mkdir “/opt/odoo/backup/”
chown -R postgres:postgres /opt/odoo/backup
sudo su postgres
pg_dump -E UTF-8 -p 5432 -F p -b -f /opt/odoo/backup/backupfile.sql databasename
Start Odoo service on system startup
<!-- wp:paragraph -->
<p> sudo vim /etc/systemd/system/odoo.service</p>
<!-- /wp:paragraph -->
<!-- wp:paragraph -->
<p><code>[Unit]<br>Description=Odoo<br>Documentation=<a href="http://www.odoo.com/" target="_blank" rel="noreferrer noopener">http://www.odoo.com/</a><br>[Service]<br># Ubuntu/Debian convention:<br>Type=simple<br>User=odoo<br>ExecStart=/opt/odoo/odoo-10.0/odoo-bin -c /etc/odoo.conf<br>[Install]<br>WantedBy=default.target</code></p>
<!-- /wp:paragraph -->
<!-- wp:paragraph -->
<p><code>sudo mkdir /var/lib/odoo<br>sudo chown odoo:root /var/lib/odoo -R</code></p>
<!-- /wp:paragraph -->
<!-- wp:paragraph -->
<p>sudo systemctl enable odoo.service (Enable service)</p>
<!-- /wp:paragraph -->
<!-- wp:paragraph -->
<p>sudo systemctl start odoo.service (starts service)<br>sudo systemctl stop odoo.service (stops service)<br>sudo systemctl restart odoo.service (restarts Service)<br>sudo systemctl status odoo.service (status of service)<br>sudo systemctl enable odoo.service (starts service at boot)<br>sudo systemctl disable odoo.service (disables service at boot) </p>
<!-- /wp:paragraph -->
Run Odoo from terminal using addons path
sudo su – odoo -s /bin/bash
$ cd /opt/odoo/
$ ./odoo-bin –addons-path=/odoo/odoo-server/addons/,/odoo/odoo-server/odoo/addons/,/odoo/custom/addons
Reset Odoo admin password to ‘admin’.
Login to the Postgres.Select Odoo database.
Run the below query
UPDATE res_users
SET password='$pbkdf2-sha512$6400$1HovZUzJOQdgTElJCYFwrg$3duyQnYOKKVKZ34iK54tKy.OxrfJM2SnJnDlGgqAmrF.suA73gaESJkCoPcIC6vB2.NwBYAUGvD9/6ZjEexn/w' WHERE login='admin';
Login PostgreSQL using SSH
To connect using the psql client , use the following command.
psql -h server_ip -U psql_user_name database_name
Peer authentication failed for user – postgresql pgadmin
- Edit the below line in pg_hba.conf.
sudo vim /etc/postgresql/9.3/main/pg_hba.conf
host all all 127.0.0.1/32 md5 to host all all all md5
# "local" is for Unix domain socket connections only local all postgres trust
2. Edit the below line in postgresql.conf.
sudo vim/etc/postgresql/9.3/main/postgresql.conf
# - Connection Settings - listen_addresses = '*'