biolab / biolab/orange2

SQL widget problem

Open
#51 1 comment 0 reactions 0 assignees View on GitHub
Dominant language
Python
Stars
304
Forks
142
PR merge metrics
No merged PRs in 30d

Description

I am using Ubuntu 16.04.1 LTS and installed Orange with the following commands:
sudo apt-get install python3-pip
sudo pip3 install orange3
sudo apt install python3-pyqt5
sudo apt install python3-pyqt5.qtwebkit
sudo apt install python3-pyqt5.qtsvg
sudo pip3 install psycopg2

Then I run orange-canvas and add SQL widget. It draws warning icon and when I open it, it says:
invalid port number: "None"

This can be solved if you enter this to the "server field":
127.0.0.1:5432

My suggestion is if there is no port specified from the user, Orange should use default port (5432), or - there should be another field named port in SQL widget.

And there is another problem: SQL widget says "permission denied to create extension "tsm_system_time".
The problem is, if I connect to psql as postgres user and say CREATE EXTENSION tsm_system_time;, I got an error: extension "tsm_system_time" already exists.

It seems this extension is already installed. Any idea how to solve this?

Contributor guide

No contributing guide indexed for this repository

Research direction

Start by reproducing the SQL widget problems on the reported Ubuntu and PostgreSQL setup, then inspect the SQL widget's connection and extension handling. Done means the reported port handling and the contradictory tsm_system_time permission/installation behavior are clearly resolved or documented.

Written by the indexing model from the issue text.

Assessment

Tech stack
postgresql, python
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Stale
Clarity
Needs clarification
Newbie friendliness
25/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.