Build Open3D From Source

Posted on 2022-08-04 Edited on 2024-09-28 In Coding , HowTo

I tried to build Intel Open3D from source, using GCC/G++ ONLY. Of course, I used ALL 3rdparty libraries either from default Ubuntu repository, or manually installed the newest version, rather than using the 3rdparty libraries coming with Open3D itself.

Today, May 9, 2024, I had this annoying Open3D successfully built again, with my PR 6788.

Build Filament From Source

Posted on 2022-08-03 Edited on 2024-09-28 In Coding , HowTo

I tried to build Google Filament from source, mostly using GCC/G++, ONLY except its main library Filament’s filament which is built with Clang/Clang++. Of course, I used ALL 3rdparty libraries either from default Ubuntu repository, or manually installed the newest version, rather than using the 3rdparty libraries coming with Filament itself.

How to Use MongoDB with Go?

Posted on 2022-06-25 Edited on 2024-09-28 In Coding , HowTo

How to use MongoDB with Go

PyTorch Generator

Posted on 2022-06-19 Edited on 2024-09-28 In AI , DeepLearning

A detailed example of how to generate your data in parallel with PyTorch

CMake

Posted on 2022-06-19 Edited on 2024-09-28 In Coding , HowTo

1. CMake External From Git

How to clone and integrate external (from git) cmake project into local one

Let's Encrypt Certbot with Nginx

Posted on 2022-06-04 Edited on 2024-09-28 In Coding , HowTo

Default Nginx Sites-Available Configuration File Contents

Let's Encrypt + Nginx - Definitive Guide for SSL (Production Ready)

How to Start Nginx on Linux?

Nginx Let's Encrypt

How to Run PostgreSQL Server and Database?

Posted on 2022-06-03 Edited on 2024-09-28 In Coding , HowTo

1. Online Tutorials

2. Issues

2.1 `psycopg2.OperationalError: could not connect to server: Connection refused`

Relevant resource:

Solution:

Just modify this file /etc/postgresql/12/main/pg_hba.conf:

local all postgres peer => local all postgres trust
local all all peer => local all all md5

2.2 `Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?`

Relevant resource:

Solution:

find the folder containing the file postmaster.pid, and remove it:
- rm /var/lib/postgresql/12/main/postmaster.pid
edit file /etc/postgresql/12/main/postgresql.conf, in which, set:
- listen_addresses = '*'
- port = 5432
- unix_socket_directory = '/var/run/postgresql'

2.3 CREATE EXTENSION in PostgreSQL

Relevant resource:

Solutions:

Please make sure postgresql-contrib has been installed.

2.4 Deal With GinIndex

Relevant resource:

Solutions:

Please make sure btree_gin and pg_trgm EXTENSIONs have been CREATEed for the user username in PostgreSQL database. Namely, you need to \c database username before CREATE EXTENSION btree_gin and CREATE EXTENSION pg_trgm.

2.5 `django.db.utils.ProgrammingError: syntax error at or near "FUNCTION"`

Solutions:

Use PROCEDURE instead of FUNCTION.

2.6 `django.db.migrations.exceptions.InconsistentMigrationHistory: Migration site.0001_initial is applied before its dependency account.0003_initial on database 'default'.`

Relevant resource:

django.db.migrations.exceptions.InconsistentMigrationHistory

Solutions:

Please make sure \c database username is run from within psql.

2.7 `LOG: SSL is not supported by this build`

Relevant resource:

How to check if PostgreSQL installation supports SSL?

Solutions:

1 2	⋊> ~ sudo su - postgres postgres=# postgres -D /usr/local/pgsql/data

3. Process

Step 1. Install `postgresql` and `postgresql-contrib`

⋊> ~ apt list --installed | grep postgresql                                                                                                                                                                                                                                  22:46:41

WARNING: apt does not have a stable CLI interface. Use with caution in scripts.

postgresql-12/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 amd64 [installed,automatic]
postgresql-all/focal-updates,focal-security,now 12+214ubuntu0.1 all [installed]
postgresql-client-12/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 amd64 [installed,automatic]
postgresql-client-common/focal-updates,focal-security,now 214ubuntu0.1 all [installed,automatic]
postgresql-common/focal-updates,focal-security,now 214ubuntu0.1 all [installed,automatic]
postgresql-contrib/focal-updates,focal-security,now 12+214ubuntu0.1 all [installed]
postgresql-plperl-12/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 amd64 [installed,automatic]
postgresql-plpython3-12/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 amd64 [installed,automatic]
postgresql-pltcl-12/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 amd64 [installed,automatic]
postgresql-server-dev-12/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 amd64 [installed,automatic]
postgresql-server-dev-all/focal-updates,focal-security,now 214ubuntu0.1 all [installed,automatic]
postgresql/focal-updates,focal-security,now 12+214ubuntu0.1 all [installed]

Step 2. Open a FIRST terminal:

⋊> ~ sudo su - postgres                                                                                                                                                                                                                                                      22:03:23
postgres@localhost:/var/lib/postgresql$ pwd
/var/lib/postgresql
postgres@localhost:/var/lib/postgresql$ postgres -D /etc/postgresql/12/main
2022-06-03 22:04:41.766 PDT [284525] LOG:  starting PostgreSQL 12.11 (Ubuntu 12.11-0ubuntu0.20.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
2022-06-03 22:04:41.766 PDT [284525] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2022-06-03 22:04:41.767 PDT [284525] LOG:  listening on IPv6 address "::", port 5432
2022-06-03 22:04:41.769 PDT [284525] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2022-06-03 22:04:41.787 PDT [284529] LOG:  database system was shut down at 2022-06-03 22:04:01 PDT
2022-06-03 22:04:41.795 PDT [284525] LOG:  database system is ready to accept connections

Step 3. Open a SECOND terminal:

with user postgres, psql will do
with other users, such as longervision, you've got to do psql -U postgres

⋊> ~ psql -U postgres                                                                                                                                                                                                                                                        22:06:18
psql (12.11 (Ubuntu 12.11-0ubuntu0.20.04.1))
Type "help" for help.

postgres=# \c
You are now connected to database "postgres" as user "postgres".
postgres=# \l
                                     List of databases
     Name     |  Owner   | Encoding |   Collate   |    Ctype    |     Access privileges     
--------------+----------+----------+-------------+-------------+---------------------------
 postgres     | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | 
 template0    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres              +
              |          |          |             |             | postgres=CTc/postgres
 template1    | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres              +
              |          |          |             |             | postgres=CTc/postgres
(3 rows)

postgres=# \du
                                     List of roles
  Role name   |                         Attributes                         | Member of 
--------------+------------------------------------------------------------+-----------
 postgres     | Superuser, Create role, Create DB, Replication, Bypass RLS | {}

postgres=# \dx
                 List of installed extensions
  Name   | Version |   Schema   |         Description          
---------+---------+------------+------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
(1 row)

postgres=# CREATE ROLE username WITH LOGIN PASSWORD 'password';
CREATE ROLE
postgres=# CREATE DATABASE database;
CREATE DATABASE
postgres=# ALTER USER username WITH SUPERUSER;
ALTER ROLE
postgres=# GRANT ALL PRIVILEGES ON DATABASE database TO username;
GRANT
postgres=# ALTER USER username CREATEDB;
ALTER ROLE
postgres=# \c database username 
Password for user username: 
You are now connected to database "database" as user "username".
database=# \dx
                 List of installed extensions
  Name   | Version |   Schema   |         Description          
---------+---------+------------+------------------------------
 plpgsql | 1.0     | pg_catalog | PL/pgSQL procedural language
(1 row)
database=# CREATE EXTENSION btree_gin;
CREATE EXTENSION
database=# CREATE EXTENSION "uuid-ossp";
CREATE EXTENSION
database=# CREATE EXTENSION "ltree";
CREATE EXTENSION
database=# CREATE EXTENSION "pg_trgm";
CREATE EXTENSION
database=# CREATE EXTENSION "hstore";
CREATE EXTENSION
database=# \dx
                                     List of installed extensions
   Name    | Version |   Schema   |                            Description                            
-----------+---------+------------+-------------------------------------------------------------------
 btree_gin | 1.3     | public     | support for indexing common datatypes in GIN
 hstore    | 1.6     | public     | data type for storing sets of (key, value) pairs
 ltree     | 1.1     | public     | data type for hierarchical tree-like structures
 pg_trgm   | 1.4     | public     | text similarity measurement and index searching based on trigrams
 plpgsql   | 1.0     | pg_catalog | PL/pgSQL procedural language
 uuid-ossp | 1.1     | public     | generate universally unique identifiers (UUIDs)
(6 rows)
database=# \conninfo
You are connected to database "database" as user "username" via socket in "/var/run/postgresql" at port "5432".

Step 4. Saleor Reset Migrations (Optional)

Refer to How to Reset Migrations

Run the following 2 lines:

find . -path "*/migrations/*.py" -not -name "__init__.py" -delete
find . -path "*/migrations/*.pyc" -delete

Modify `saleor/settings.py`

From

1
2
3

DATABASE_CONNECTION_DEFAULT_NAME: dj_database_url.config(
    default="postgres://saleor:saleor@localhost:5432/saleor", conn_max_age=600
),

to

1
2
3

DATABASE_CONNECTION_DEFAULT_NAME: dj_database_url.config(
    default="postgres://username:password@localhost:5432/database", conn_max_age=600
),

correspondingly.

Start Migration

⋊> /v/w/v/saleor on main ⨯ python manage.py makemigrations                                                                                                                                                                                                                   22:32:00
WARNING saleor.core.jwt_manager RSA_PRIVATE_KEY is missing. Using temporary key for local development with DEBUG mode. [PID:296644:MainThread]
Migrations for 'channel':
  saleor/channel/migrations/0001_initial.py
    - Create model Channel
Migrations for 'page':
  saleor/page/migrations/0001_initial.py
    - Create model Page
    - Create model PageTranslation
    - Create model PageType
    - Create index pagetype_p_meta_idx on field(s) private_metadata of model pagetype
    - Create index pagetype_meta_idx on field(s) metadata of model pagetype
    - Create index page_pagety_name_7c1cb8_gin on field(s) name, slug of model pagetype
    - Add field page to pagetranslation
    - Add field page_type to page
    - Alter unique_together for pagetranslation (1 constraint(s))
    - Create index page_p_meta_idx on field(s) private_metadata of model page
    - Create index page_meta_idx on field(s) metadata of model page
    - Create index page_page_title_964714_gin on field(s) title, slug of model page
Migrations for 'plugins':
  saleor/plugins/migrations/0001_initial.py
    - Create model PluginConfiguration
    - Create model EmailTemplate
Migrations for 'account':
  saleor/account/migrations/0001_initial.py
    - Create model User
    - Create model Address
    - Create model CustomerEvent
    - Create model StaffNotificationRecipient
    - Create model CustomerNote
  saleor/account/migrations/0002_customerevent_app.py
    - Add field app to customerevent
  saleor/account/migrations/0003_initial.py
    - Add field order to customerevent
    - Add field user to customerevent
    - Create index address_search_gin on field(s) first_name, last_name, city, country of model address
    - Create index warehouse_address_search_gin on field(s) company_name, street_address_1, street_address_2, city, postal_code, phone of model address
    - Add field addresses to user
    - Add field default_billing_address to user
    - Add field default_shipping_address to user
    - Add field groups to user
    - Add field user_permissions to user
    - Create index user_p_meta_idx on field(s) private_metadata of model user
    - Create index user_meta_idx on field(s) metadata of model user
    - Create index order_user_search_gin on field(s) email, first_name, last_name of model user
    - Create index user_search_gin on field(s) search_document of model user
Migrations for 'app':
  saleor/app/migrations/0001_initial.py
    - Create model App
    - Create model AppToken
    - Create model AppInstallation
    - Create model AppExtension
    - Create index app_p_meta_idx on field(s) private_metadata of model app
    - Create index app_meta_idx on field(s) metadata of model app
Migrations for 'csv':
  saleor/csv/migrations/0001_initial.py
    - Create model ExportFile
    - Create model ExportEvent
Migrations for 'webhook':
  saleor/webhook/migrations/0001_initial.py
    - Create model Webhook
    - Create model WebhookEvent
Migrations for 'core':
  saleor/core/migrations/0001_initial.py
    - Create model EventDelivery
    - Create model EventPayload
    - Create model EventDeliveryAttempt
    - Add field payload to eventdelivery
    - Add field webhook to eventdelivery
Migrations for 'attribute':
  saleor/attribute/migrations/0001_initial.py
    - Create model AssignedPageAttribute
    - Create model AssignedPageAttributeValue
    - Create model AssignedProductAttribute
    - Create model AssignedProductAttributeValue
    - Create model AssignedVariantAttribute
    - Create model AssignedVariantAttributeValue
    - Create model Attribute
    - Create model AttributePage
    - Create model AttributeProduct
    - Create model AttributeTranslation
    - Create model AttributeValue
    - Create model AttributeValueTranslation
    - Create model AttributeVariant
  saleor/attribute/migrations/0002_initial.py
    - Add field assigned_variants to attributevariant
    - Add field attribute to attributevariant
    - Add field product_type to attributevariant
    - Add field attribute_value to attributevaluetranslation
    - Add field attribute to attributevalue
    - Add field reference_page to attributevalue
    - Add field reference_product to attributevalue
    - Add field attribute to attributetranslation
    - Add field assigned_products to attributeproduct
    - Add field attribute to attributeproduct
    - Add field product_type to attributeproduct
    - Add field assigned_pages to attributepage
    - Add field attribute to attributepage
    - Add field page_type to attributepage
    - Add field page_types to attribute
    - Add field product_types to attribute
    - Add field product_variant_types to attribute
    - Add field assignment to assignedvariantattributevalue
    - Add field value to assignedvariantattributevalue
    - Add field assignment to assignedvariantattribute
    - Add field values to assignedvariantattribute
    - Add field variant to assignedvariantattribute
    - Add field assignment to assignedproductattributevalue
    - Add field value to assignedproductattributevalue
    - Add field assignment to assignedproductattribute
    - Add field product to assignedproductattribute
    - Add field values to assignedproductattribute
    - Add field assignment to assignedpageattributevalue
    - Add field value to assignedpageattributevalue
    - Add field assignment to assignedpageattribute
    - Add field page to assignedpageattribute
    - Add field values to assignedpageattribute
    - Alter unique_together for attributevariant (1 constraint(s))
    - Alter unique_together for attributevaluetranslation (1 constraint(s))
    - Create index attribute_search_gin on field(s) name, slug of model attributevalue
    - Alter unique_together for attributevalue (1 constraint(s))
    - Alter unique_together for attributetranslation (1 constraint(s))
    - Alter unique_together for attributeproduct (1 constraint(s))
    - Alter unique_together for attributepage (1 constraint(s))
    - Create index attribute_p_meta_idx on field(s) private_metadata of model attribute
    - Create index attribute_meta_idx on field(s) metadata of model attribute
    - Alter unique_together for assignedvariantattributevalue (1 constraint(s))
    - Alter unique_together for assignedvariantattribute (1 constraint(s))
    - Alter unique_together for assignedproductattributevalue (1 constraint(s))
    - Alter unique_together for assignedproductattribute (1 constraint(s))
    - Alter unique_together for assignedpageattributevalue (1 constraint(s))
    - Alter unique_together for assignedpageattribute (1 constraint(s))
Migrations for 'checkout':
  saleor/checkout/migrations/0001_initial.py
    - Create model Checkout
    - Create model CheckoutLine
  saleor/checkout/migrations/0002_initial.py
    - Add field variant to checkoutline
    - Add field billing_address to checkout
    - Add field channel to checkout
    - Add field collection_point to checkout
    - Add field gift_cards to checkout
    - Add field shipping_address to checkout
    - Add field shipping_method to checkout
    - Add field user to checkout
    - Create index checkout_p_meta_idx on field(s) private_metadata of model checkout
    - Create index checkout_meta_idx on field(s) metadata of model checkout
Migrations for 'discount':
  saleor/discount/migrations/0001_initial.py
    - Create model OrderDiscount
    - Create model Sale
    - Create model SaleChannelListing
    - Create model SaleTranslation
    - Create model Voucher
    - Create model VoucherTranslation
    - Create model VoucherCustomer
    - Create model VoucherChannelListing
  saleor/discount/migrations/0002_initial.py
    - Add field categories to voucher
    - Add field collections to voucher
    - Add field products to voucher
    - Add field variants to voucher
    - Add field sale to saletranslation
    - Add field channel to salechannellisting
    - Add field sale to salechannellisting
    - Add field categories to sale
    - Add field collections to sale
    - Add field products to sale
    - Add field variants to sale
    - Add field order to orderdiscount
    - Alter unique_together for vouchertranslation (1 constraint(s))
    - Alter unique_together for vouchercustomer (1 constraint(s))
    - Alter unique_together for voucherchannellisting (1 constraint(s))
    - Alter unique_together for saletranslation (1 constraint(s))
    - Alter unique_together for salechannellisting (1 constraint(s))
    - Create index discount_or_name_d16858_gin on field(s) name, translated_name of model orderdiscount
Migrations for 'giftcard':
  saleor/giftcard/migrations/0001_initial.py
    - Create model GiftCard
    - Create model GiftCardEvent
    - Create model GiftCardTag
    - Create index gift_card_tag_search_gin on field(s) name of model giftcardtag
    - Add field app to giftcardevent
    - Add field gift_card to giftcardevent
  saleor/giftcard/migrations/0002_initial.py
    - Add field order to giftcardevent
    - Add field user to giftcardevent
    - Add field app to giftcard
    - Add field created_by to giftcard
    - Add field fulfillment_line to giftcard
    - Add field product to giftcard
    - Add field tags to giftcard
    - Add field used_by to giftcard
Migrations for 'invoice':
  saleor/invoice/migrations/0001_initial.py
    - Create model Invoice
    - Create model InvoiceEvent
  saleor/invoice/migrations/0002_initial.py
    - Add field order to invoiceevent
    - Add field user to invoiceevent
    - Add field order to invoice
    - Create index invoice_p_meta_idx on field(s) private_metadata of model invoice
    - Create index invoice_meta_idx on field(s) metadata of model invoice
Migrations for 'menu':
  saleor/menu/migrations/0001_initial.py
    - Create model Menu
    - Create model MenuItem
    - Create model MenuItemTranslation
  saleor/menu/migrations/0002_initial.py
    - Add field category to menuitem
    - Add field collection to menuitem
    - Add field menu to menuitem
    - Add field page to menuitem
    - Add field parent to menuitem
    - Create index menu_p_meta_idx on field(s) private_metadata of model menu
    - Create index menu_meta_idx on field(s) metadata of model menu
    - Alter unique_together for menuitemtranslation (1 constraint(s))
    - Create index menuitem_p_meta_idx on field(s) private_metadata of model menuitem
    - Create index menuitem_meta_idx on field(s) metadata of model menuitem
Migrations for 'order':
  saleor/order/migrations/0001_initial.py
    - Create model Fulfillment
    - Create model FulfillmentLine
    - Create model Order
    - Create model OrderEvent
    - Create model OrderLine
  saleor/order/migrations/0002_initial.py
    - Add field variant to orderline
    - Add field app to orderevent
    - Add field order to orderevent
    - Add field user to orderevent
    - Add field billing_address to order
    - Add field channel to order
    - Add field collection_point to order
    - Add field gift_cards to order
    - Add field original to order
    - Add field shipping_address to order
    - Add field shipping_method to order
    - Add field user to order
    - Add field voucher to order
    - Add field fulfillment to fulfillmentline
    - Add field order_line to fulfillmentline
    - Add field stock to fulfillmentline
    - Add field order to fulfillment
    - Create index order_p_meta_idx on field(s) private_metadata of model order
    - Create index order_meta_idx on field(s) metadata of model order
    - Create index order_search_gin on field(s) search_document of model order
    - Create index order_email_search_gin on field(s) user_email of model order
    - Create index fulfillment_p_meta_idx on field(s) private_metadata of model fulfillment
    - Create index fulfillment_meta_idx on field(s) metadata of model fulfillment
Migrations for 'payment':
  saleor/payment/migrations/0001_initial.py
    - Create model Payment
    - Create model TransactionItem
    - Create model TransactionEvent
    - Create model Transaction
    - Create index transactionitem_p_meta_idx on field(s) private_metadata of model transactionitem
    - Create index transactionitem_meta_idx on field(s) metadata of model transactionitem
    - Create index payment_tra_order_i_e783c4_gin on field(s) order_id, status of model transactionitem
    - Create index payment_p_meta_idx on field(s) private_metadata of model payment
    - Create index payment_meta_idx on field(s) metadata of model payment
    - Create index payment_pay_order_i_f22aa2_gin on field(s) order_id, is_active, charge_status of model payment
Migrations for 'product':
  saleor/product/migrations/0001_initial.py
    - Create model Category
    - Create model CategoryTranslation
    - Create model Collection
    - Create model CollectionChannelListing
    - Create model CollectionProduct
    - Create model CollectionTranslation
    - Create model DigitalContent
    - Create model DigitalContentUrl
    - Create model Product
    - Create model ProductChannelListing
    - Create model ProductMedia
    - Create model ProductTranslation
    - Create model ProductType
    - Create model ProductVariant
    - Create model VariantMedia
    - Create model ProductVariantTranslation
    - Create model ProductVariantChannelListing
    - Add field media to productvariant
    - Add field product to productvariant
    - Create index producttype_p_meta_idx on field(s) private_metadata of model producttype
    - Create index producttype_meta_idx on field(s) metadata of model producttype
    - Create index product_type_search_gin on field(s) name, slug of model producttype
    - Add field product to producttranslation
    - Add field product to productmedia
    - Add field channel to productchannellisting
    - Add field product to productchannellisting
    - Add field category to product
    - Add field default_variant to product
    - Add field product_type to product
    - Add field content to digitalcontenturl
    - Add field line to digitalcontenturl
    - Add field product_variant to digitalcontent
    - Add field collection to collectiontranslation
    - Add field collection to collectionproduct
    - Add field product to collectionproduct
    - Add field channel to collectionchannellisting
    - Add field collection to collectionchannellisting
    - Add field products to collection
    - Add field category to categorytranslation
    - Add field parent to category
    - Alter unique_together for variantmedia (1 constraint(s))
    - Alter unique_together for productvarianttranslation (1 constraint(s))
    - Alter unique_together for productvariantchannellisting (1 constraint(s))
    - Create index productvariant_p_meta_idx on field(s) private_metadata of model productvariant
    - Create index productvariant_meta_idx on field(s) metadata of model productvariant
    - Alter unique_together for producttranslation (1 constraint(s))
    - Create index product_pro_publish_a3c049_idx on field(s) published_at of model productchannellisting
    - Create index product_pro_discoun_3145f3_btree on field(s) discounted_price_amount of model productchannellisting
    - Alter unique_together for productchannellisting (1 constraint(s))
    - Create index product_search_gin on field(s) search_document of model product
    - Create index product_tsearch on field(s) search_vector of model product
    - Create index product_p_meta_idx on field(s) private_metadata of model product
    - Create index product_meta_idx on field(s) metadata of model product
    - Create index digitalcontent_p_meta_idx on field(s) private_metadata of model digitalcontent
    - Create index digitalcontent_meta_idx on field(s) metadata of model digitalcontent
    - Alter unique_together for collectiontranslation (1 constraint(s))
    - Alter unique_together for collectionproduct (1 constraint(s))
    - Alter unique_together for collectionchannellisting (1 constraint(s))
    - Create index collection_p_meta_idx on field(s) private_metadata of model collection
    - Create index collection_meta_idx on field(s) metadata of model collection
    - Create index collection_search_gin on field(s) name, slug of model collection
    - Alter unique_together for categorytranslation (1 constraint(s))
    - Create index category_p_meta_idx on field(s) private_metadata of model category
    - Create index category_meta_idx on field(s) metadata of model category
    - Create index category_search_name_slug_gin on field(s) name, slug, description_plaintext of model category
Migrations for 'shipping':
  saleor/shipping/migrations/0001_initial.py
    - Create model ShippingMethod
    - Create model ShippingZone
    - Create model ShippingMethodTranslation
    - Create model ShippingMethodPostalCodeRule
    - Create model ShippingMethodChannelListing
    - Add field shipping_zone to shippingmethod
    - Create index shippingzone_p_meta_idx on field(s) private_metadata of model shippingzone
    - Create index shippingzone_meta_idx on field(s) metadata of model shippingzone
    - Alter unique_together for shippingmethodtranslation (1 constraint(s))
    - Alter unique_together for shippingmethodpostalcoderule (1 constraint(s))
    - Alter unique_together for shippingmethodchannellisting (1 constraint(s))
    - Create index shippingmethod_p_meta_idx on field(s) private_metadata of model shippingmethod
    - Create index shippingmethod_meta_idx on field(s) metadata of model shippingmethod
Migrations for 'warehouse':
  saleor/warehouse/migrations/0001_initial.py
    - Create model Warehouse
    - Create model Stock
    - Create model Reservation
    - Create model PreorderReservation
    - Create model PreorderAllocation
    - Create model Allocation
    - Create index warehouse_p_meta_idx on field(s) private_metadata of model warehouse
    - Create index warehouse_meta_idx on field(s) metadata of model warehouse
    - Alter unique_together for stock (1 constraint(s))
    - Create index warehouse_r_checkou_b66369_idx on field(s) checkout_line, reserved_until of model reservation
    - Alter unique_together for reservation (1 constraint(s))
    - Create index warehouse_p_checkou_3abf41_idx on field(s) checkout_line, reserved_until of model preorderreservation
    - Alter unique_together for preorderreservation (1 constraint(s))
    - Alter unique_together for preorderallocation (1 constraint(s))
    - Alter unique_together for allocation (1 constraint(s))
Migrations for 'site':
  saleor/site/migrations/0001_initial.py
    - Create model SiteSettings
    - Create model SiteSettingsTranslation

⋊> /v/w/v/saleor on main ⨯ python manage.py migrate                                                                                                                                                                                                                          00:02:56
WARNING saleor.core.jwt_manager RSA_PRIVATE_KEY is missing. Using temporary key for local development with DEBUG mode. [PID:462981:MainThread]
Operations to perform:
  Apply all migrations: account, app, attribute, auth, channel, checkout, contenttypes, core, csv, discount, django_celery_beat, django_prices_openexchangerates, django_prices_vatlayer, giftcard, invoice, menu, order, page, payment, plugins, product, shipping, site, sites, warehouse, webhook
Running migrations:
  Applying order.0001_initial... OK
  Applying channel.0001_initial... OK
  Applying product.0001_initial... OK
  Applying shipping.0001_initial... OK
  Applying checkout.0001_initial... OK
  Applying contenttypes.0001_initial... OK
  Applying contenttypes.0002_remove_content_type_name... OK
  Applying auth.0001_initial... OK
  Applying auth.0002_alter_permission_name_max_length... OK
  Applying auth.0003_alter_user_email_max_length... OK
  Applying auth.0004_alter_user_username_opts... OK
  Applying auth.0005_alter_user_last_login_null... OK
  Applying auth.0006_require_contenttypes_0002... OK
  Applying auth.0007_alter_validators_add_error_messages... OK
  Applying auth.0008_alter_user_username_max_length... OK
  Applying auth.0009_alter_user_last_name_max_length... OK
  Applying auth.0010_alter_group_name_max_length... OK
  Applying auth.0011_update_proxy_permissions... OK
  Applying auth.0012_alter_user_first_name_max_length... OK
  Applying app.0001_initial... OK
  Applying account.0001_initial... OK
  Applying account.0002_customerevent_app... OK
  Applying warehouse.0001_initial... OK
  Applying giftcard.0001_initial... OK
  Applying giftcard.0002_initial... OK
  Applying discount.0001_initial... OK
  Applying discount.0002_initial... OK
  Applying order.0002_initial... OK
  Applying account.0003_initial... OK
  Applying page.0001_initial... OK
  Applying attribute.0001_initial... OK
  Applying attribute.0002_initial... OK
  Applying checkout.0002_initial... OK
  Applying webhook.0001_initial... OK
  Applying core.0001_initial... OK
  Applying csv.0001_initial... OK
  Applying django_celery_beat.0001_initial... OK
  Applying django_celery_beat.0002_auto_20161118_0346... OK
  Applying django_celery_beat.0003_auto_20161209_0049... OK
  Applying django_celery_beat.0004_auto_20170221_0000... OK
  Applying django_celery_beat.0005_add_solarschedule_events_choices... OK
  Applying django_celery_beat.0006_auto_20180322_0932... OK
  Applying django_celery_beat.0007_auto_20180521_0826... OK
  Applying django_celery_beat.0008_auto_20180914_1922... OK
  Applying django_celery_beat.0006_auto_20180210_1226... OK
  Applying django_celery_beat.0006_periodictask_priority... OK
  Applying django_celery_beat.0009_periodictask_headers... OK
  Applying django_celery_beat.0010_auto_20190429_0326... OK
  Applying django_celery_beat.0011_auto_20190508_0153... OK
  Applying django_celery_beat.0012_periodictask_expire_seconds... OK
  Applying django_celery_beat.0013_auto_20200609_0727... OK
  Applying django_celery_beat.0014_remove_clockedschedule_enabled... OK
  Applying django_celery_beat.0015_edit_solarschedule_events_choices... OK
  Applying django_prices_openexchangerates.0001_initial... OK
  Applying django_prices_openexchangerates.0002_auto_20160329_0702... OK
  Applying django_prices_openexchangerates.0003_auto_20161018_0707... OK
  Applying django_prices_openexchangerates.0004_auto_20170316_0944... OK
  Applying django_prices_openexchangerates.0005_auto_20190124_1008... OK
  Applying django_prices_vatlayer.0001_initial... OK
  Applying django_prices_vatlayer.0002_ratetypes... OK
  Applying django_prices_vatlayer.0003_auto_20180316_1053... OK
  Applying invoice.0001_initial... OK
  Applying invoice.0002_initial... OK
  Applying menu.0001_initial... OK
  Applying menu.0002_initial... OK
  Applying payment.0001_initial... OK
  Applying plugins.0001_initial... OK
  Applying sites.0001_initial... OK
  Applying sites.0002_alter_domain_unique... OK
  Applying site.0001_initial... OK

How to Prepare and Upload PPA to Launchpad?

Posted on 2022-06-01 Edited on 2024-09-28 In Coding , HowTo

Refer to Launchpad PPA: - Launchpad Packaging/PPA - Launchpad Installing Software - Launchpad Building A Source Package - Building debian packages with debuild - Launchpad Uploading - Launchpad Copying - Basic Overview of the debian/ Directory

Solution

dput Way

1	dput ppa:longervision/googletest googletest_1.11.0_amd64.changes

FTP Edit ~/.dput.cf as:

[googletest]
fqdn = ppa.launchpad.net
method = ftp
incoming = ~longervision/ubuntu/
login = jiapei100
allow_unsigned_uploads = 0

LongerVision PPA

PPA googletest

How to build QtWebEngine?

Posted on 2022-04-28 Edited on 2024-09-28 In Coding , HowTo

NEVER successfully built out QtWebEngine before. Today, I'd love to have a try. From this tutorial Building QtWebEngine, it looks possible.

Qt for Linux/X11 - Building from Source

Hugo

Posted on 2022-04-26 Edited on 2024-09-28 In Websites

Longer Vision Technology

Build Open3D From Source

Build Filament From Source

How to Use MongoDB with Go?

PyTorch Generator

CMake

1. CMake External From Git

Let's Encrypt Certbot with Nginx

How to Run PostgreSQL Server and Database?

1. Online Tutorials

2. Issues

2.1 `psycopg2.OperationalError: could not connect to server: Connection refused`

2.2 `Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?`

2.3 CREATE EXTENSION in PostgreSQL

2.4 Deal With GinIndex

2.5 `django.db.utils.ProgrammingError: syntax error at or near "FUNCTION"`

2.6 `django.db.migrations.exceptions.InconsistentMigrationHistory: Migration site.0001_initial is applied before its dependency account.0003_initial on database 'default'.`

2.7 `LOG: SSL is not supported by this build`

3. Process

Step 1. Install `postgresql` and `postgresql-contrib`

Step 2. Open a FIRST terminal:

Step 3. Open a SECOND terminal:

Step 4. Saleor Reset Migrations (Optional)

Run the following 2 lines:

Modify `saleor/settings.py`

Start Migration

How to Prepare and Upload PPA to Launchpad?

Solution

How to build QtWebEngine?

Hugo

1. Official

2. Themes

1. CMake External From Git

1. Online Tutorials

2. Issues

2.1 psycopg2.OperationalError: could not connect to server: Connection refused

2.2 Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?

2.3 CREATE EXTENSION in PostgreSQL

2.4 Deal With GinIndex

2.5 django.db.utils.ProgrammingError: syntax error at or near "FUNCTION"

2.6 django.db.migrations.exceptions.InconsistentMigrationHistory: Migration site.0001_initial is applied before its dependency account.0003_initial on database 'default'.

2.7 LOG: SSL is not supported by this build

3. Process

Step 1. Install postgresql and postgresql-contrib

Step 2. Open a FIRST terminal:

Step 3. Open a SECOND terminal:

Step 4. Saleor Reset Migrations (Optional)

Run the following 2 lines:

Modify saleor/settings.py

Start Migration

Solution

1. Official

2. Themes

2.1 `psycopg2.OperationalError: could not connect to server: Connection refused`

2.2 `Is the server running on host "localhost" (::1) and accepting TCP/IP connections on port 5432?`

2.5 `django.db.utils.ProgrammingError: syntax error at or near "FUNCTION"`

2.6 `django.db.migrations.exceptions.InconsistentMigrationHistory: Migration site.0001_initial is applied before its dependency account.0003_initial on database 'default'.`

2.7 `LOG: SSL is not supported by this build`

Step 1. Install `postgresql` and `postgresql-contrib`

Modify `saleor/settings.py`