Query tool - file browser
pts rule name description -- -- -1.0 ALL_TRUSTEDPassed through trusted hosts only via SMTP 0.5 RP_MATCHES_RCVDEnvelope sender domain matches handover relay domain 2.5 BAYES_50 BODY: Bayes spam probability is 40 to 60% [score: 0.5000] X-Pg-Spam-Score: -4.2 () After several months I am trying out pgadmin4 again to see whether it is usable now. This time installed in a virtual environment and using the browser. This is on Debian stretch. I am struggling to find out how to use sql-files from the query-tool. When I try to open my home directory (with file type "All files") it does not find my home directory. The gui seems to start at /. Why? I do not want to use a graphical filemanager to drag a file to the gui every time I want to use a pre-existing query. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer
Re: Query tool - file browser
pts rule name description -- -- -1.0 ALL_TRUSTEDPassed through trusted hosts only via SMTP 0.5 RP_MATCHES_RCVDEnvelope sender domain matches handover relay domain 2.5 BAYES_50 BODY: Bayes spam probability is 40 to 60% [score: 0.5000] X-Pg-Spam-Score: -4.2 () > I am struggling to find out how to use sql-files from the query-tool. > When I try to open my home directory (with file type "All files") it > does not find my home directory. The gui seems to start at /. Why? > After deleting the database in ~/pgadmin and restarting pgadmin4 and reconfiguring the settings I can now open files and the server seems to find my filesystem. Earlier it told me that my home directory did not exist. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer
Re: Query tool - file browser
On Wed, Sep 13, 2017 at 11:26 AM, Johann Spies wrote: > pts rule name description > -- -- > > -1.0 ALL_TRUSTEDPassed through trusted hosts only via SMTP > 0.5 RP_MATCHES_RCVDEnvelope sender domain matches handover relay > domain > 2.5 BAYES_50 BODY: Bayes spam probability is 40 to 60% > [score: 0.5000] > X-Pg-Spam-Score: -4.2 () > > > > I am struggling to find out how to use sql-files from the query-tool. > > When I try to open my home directory (with file type "All files") it > > does not find my home directory. The gui seems to start at /. Why? > > > > After deleting the database in ~/pgadmin and restarting pgadmin4 and > reconfiguring the settings I can now open files and the server seems to > find my filesystem. Earlier it told me that my home directory did not > exist. If you're running in Server mode (SERVER_MODE=True), then file storage is (by default) on the server, in a per-user directory. This is so that you have access to your files no matter where you login to pgAdmin from and to prevent users from browsing the filesystem on your server. If you're running in Desktop mode (SERVER_MODE=False), then you should have access to the entire local filesystem. See the STORAGE_DIR parameter in config.py (if you need to change it, create - if needed - config_local.py in the same directory, and override the setting there). -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Re: Query tool - file browser
On Wed, Sep 13, 2017 at 1:48 PM, Johann Spies wrote: > On Wed, Sep 13, 2017 at 11:56:39AM +0100, Dave Page wrote: > > > If you're running in Server mode (SERVER_MODE=True), then file storage is > > (by default) on the server, in a per-user directory. This is so that you > > have access to your files no matter where you login to pgAdmin from and > to > > prevent users from browsing the filesystem on your server. > > > > If you're running in Desktop mode (SERVER_MODE=False), then you should > have > > access to the entire local filesystem. > > Thanks David. > > I have tried to run it in Desktop mode, but setting SERVER_MODE=False > does not make a difference: > > (pgadmin4.1.6) 14:47:02 js@sitasie:~/pgadmin4.1.6/lib/ > python3.6/site-packages/pgadmin4$ python3.6 pgAdmin4.py > Starting pgAdmin 4. Please navigate to http://127.0.0.1:5050 in your > browser. Changing SERVER_MODE won't change what you see on the command line, but it certainly should change the root of the file browser, unless you've overridden the default config to prevent it. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
Re: Query tool - file browser
pts rule name description -- -- -1.0 ALL_TRUSTEDPassed through trusted hosts only via SMTP 0.5 RP_MATCHES_RCVDEnvelope sender domain matches handover relay domain 2.5 BAYES_50 BODY: Bayes spam probability is 40 to 60% [score: 0.5000] X-Pg-Spam-Score: -4.2 () I have now tried a different approach by installing pgadmin4 source and building it within an enclosed environment. My conclusion is that pgadmin4.1-6 is not ready use on Debian. I will try again in a few months time. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer
Re: Query tool - file browser
On Wed, Sep 13, 2017 at 3:21 PM, Johann Spies wrote: > pts rule name description > -- -- > > -1.0 ALL_TRUSTEDPassed through trusted hosts only via SMTP > 0.5 RP_MATCHES_RCVDEnvelope sender domain matches handover relay > domain > 2.5 BAYES_50 BODY: Bayes spam probability is 40 to 60% > [score: 0.5000] > X-Pg-Spam-Score: -4.2 () > > I have now tried a different approach by installing pgadmin4 source and > building it within an enclosed environment. > > My conclusion is that pgadmin4.1-6 is not ready use on Debian. > > I will try again in a few months time. It works fine on Debian, however, as far as I can tell you didn't try what I suggested to resolve the problem you reported. -- Dave Page Blog: http://pgsnake.blogspot.com Twitter: @pgsnake EnterpriseDB UK: http://www.enterprisedb.com The Enterprise PostgreSQL Company
pgAdmin 1.7 schedule
I normally don't post this type of question but I am waiting on a bug fix for apppath issue in SERVER mode. Is 1.7 close? Thanks Mike
pgAdmin 4 bugs
I am current running a Windows 10 Dell Precision laptop with 16 GB ram. I had original installed pgAdmin 4 1.1, the upgraded it to 1.3. pgAdmin 4 1.3 was stable and ran fine, then I upgraded to 1.6. pgAdmin 4 1.6 had issues reconnecting to postgres (PostgreSQL 9.5.6 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-11), 64-bit) requiring query windows to be closed and restarted and in some cases pgAdmin had to be closed and restarted. Since 1.3 did not have this problem, I uninstalled pgAdmin 4 1.6, which appears not to have cleanly uninstalled, because after installing pgAdmin 4 1.4 the application would display the splash screen and hang. I tried uninstalling 1.4 and hand cleaning the registry, then installing 1.5 getting the same resulting behavior. I then uninstalled 1.5 and reinstalled 1.6, same splash screen and hang. I quit trying pgAdmin 4 and went to pgAdmin 3. I like the speed and handling of pgAdmin 3 over 4, and would rather use it, if had a tab window interface instead of multiple windows. Thanks, David Hickerson
Re: v2.0-rc1 not starting, runtime not building
On Tue, Sep 12, 2017 at 4:33 PM, Willy-Bas Loos wrote: > > > Any ideas considering the runtime trouble with flask? > > > oops, turns out i overlooked that i need to run make too, not just qmake. So i was actually running an old executable. make gives me ld errors. Any idea? g++ -m64 -lpython3.5m -lpthread -ldl -lutil -lm -Xlinker -export-dynamic -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-O1 -Wl,-rpath-link,/usr/lib/x86_64-linux-gnu -o pgAdmin4 pgAdmin4.o BrowserWindow.o Server.o TabWindow.o WebViewWindow.o ConfigWindow.o qrc_pgAdmin4.o moc_BrowserWindow.o moc_Server.o moc_TabWindow.o moc_WebViewWindow.o moc_ConfigWindow.o -L/usr/X11R6/lib64 -lpython3.5m -ldl -lutil -lm -lQt5WebKitWidgets -lQt5Widgets -lQt5WebKit -lQt5Gui -lQt5Network -lQt5Core -lGL -lpthread ConfigWindow.o: In function `ConfigWindow::~ConfigWindow()': ConfigWindow.cpp:(.text+0x55): undefined reference to `QString::free(QString::Data*)' ConfigWindow.cpp:(.text+0x65): undefined reference to `QString::free(QString::Data*)' ConfigWindow.o: In function `ConfigWindow::ConfigWindow(QWidget*)': ConfigWindow.cpp:(.text+0x128): undefined reference to `QString::shared_null' ConfigWindow.cpp:(.text+0x12f): undefined reference to `QString::shared_null' ConfigWindow.cpp:(.text+0x13a): undefined reference to `QString::shared_null' ConfigWindow.cpp:(.text+0x141): undefined reference to `QString::shared_null' ConfigWindow.cpp:(.text+0x18e): undefined reference to `QString::fromUtf8(char const*, int)' ConfigWindow.cpp:(.text+0x227): undefined reference to `QString::fromUtf8(char const*, int)' ConfigWindow.cpp:(.text+0x27f): undefined reference to `QString::fromUtf8(char const*, int)' ConfigWindow.cpp:(.text+0x2ff): undefined reference to `QString::fromUtf8(char const*, int)' ConfigWindow.cpp:(.text+0x36a): undefined reference to `QString::fromUtf8(char const*, int)' ConfigWindow.o:ConfigWindow.cpp:(.text+0x3e2): more undefined references to `QString::fromUtf8(char const*, int)' follow ConfigWindow.o: In function `ConfigWindow::ConfigWindow(QWidget*)': ConfigWindow.cpp:(.text+0x539): undefined reference to `QCoreApplication::translate(char const*, char const*, char const*, QCoreApplication::Encoding)' ConfigWindow.cpp:(.text+0x57e): undefined reference to `QCoreApplication::translate(char const*, char const*, char const*, QCoreApplication::Encoding)' ConfigWindow.cpp:(.text+0x5c4): undefined reference to `QCoreApplication::translate(char const*, char const*, char const*, QCoreApplication::Encoding)' ConfigWindow.cpp:(.text+0x641): undefined reference to `QString::free(QString::Data*)' ConfigWindow.cpp:(.text+0x659): undefined reference to `QString::free(QString::Data*)' ConfigWindow.cpp:(.text+0x669): undefined reference to `QString::free(QString::Data*)' ConfigWindow.cpp:(.text+0x681): undefined reference to `QString::free(QString::Data*)' ConfigWindow.cpp:(.text+0x696): undefined reference to `QString::free(QString::Data*)' ConfigWindow.o:ConfigWindow.cpp:(.text+0x6a6): more undefined references to `QString::free(QString::Data*)' follow moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x60): undefined reference to `QObject::connectNotify(char const*)' moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x68): undefined reference to `QObject::disconnectNotify(char const*)' moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x160): undefined reference to `QWidget::x11Event(_XEvent*)' moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x190): undefined reference to `QWidget::styleChange(QStyle&)' moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x198): undefined reference to `QWidget::enabledChange(bool)' moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x1a0): undefined reference to `QWidget::paletteChange(QPalette const&)' moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x1a8): undefined reference to `QWidget::fontChange(QFont const&)' moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x1b0): undefined reference to `QWidget::windowActivationChange(bool)' moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x1b8): undefined reference to `QWidget::languageChange()' collect2: error: ld returned 1 exit status Makefile:175: recipe for target 'pgAdmin4' failed make: *** [pgAdmin4] Error 1 -- Willy-Bas Loos
Re: v2.0-rc1 not starting, runtime not building
Hi, On Wed, Sep 13, 2017 at 10:36 PM, Willy-Bas Loos wrote: > On Tue, Sep 12, 2017 at 4:33 PM, Willy-Bas Loos > wrote: > >> >> >> Any ideas considering the runtime trouble with flask? >> >> >> > oops, turns out i overlooked that i need to run make too, not just qmake. > So i was actually running an old executable. > make gives me ld errors. Any idea? > > g++ -m64 -lpython3.5m -lpthread -ldl -lutil -lm -Xlinker -export-dynamic > -Wl,-O1 -Wl,-Bsymbolic-functions -Wl,-O1 > -Wl,-rpath-link,/usr/lib/x86_64-linux-gnu > -o pgAdmin4 pgAdmin4.o BrowserWindow.o Server.o TabWindow.o WebViewWindow.o > ConfigWindow.o qrc_pgAdmin4.o moc_BrowserWindow.o moc_Server.o > moc_TabWindow.o moc_WebViewWindow.o moc_ConfigWindow.o -L/usr/X11R6/lib64 > -lpython3.5m -ldl -lutil -lm -lQt5WebKitWidgets -lQt5Widgets -lQt5WebKit > -lQt5Gui -lQt5Network -lQt5Core -lGL -lpthread > ConfigWindow.o: In function `ConfigWindow::~ConfigWindow()': > ConfigWindow.cpp:(.text+0x55): undefined reference to > `QString::free(QString::Data*)' > ConfigWindow.cpp:(.text+0x65): undefined reference to > `QString::free(QString::Data*)' > ConfigWindow.o: In function `ConfigWindow::ConfigWindow(QWidget*)': > ConfigWindow.cpp:(.text+0x128): undefined reference to > `QString::shared_null' > ConfigWindow.cpp:(.text+0x12f): undefined reference to > `QString::shared_null' > ConfigWindow.cpp:(.text+0x13a): undefined reference to > `QString::shared_null' > ConfigWindow.cpp:(.text+0x141): undefined reference to > `QString::shared_null' > ConfigWindow.cpp:(.text+0x18e): undefined reference to > `QString::fromUtf8(char const*, int)' > ConfigWindow.cpp:(.text+0x227): undefined reference to > `QString::fromUtf8(char const*, int)' > ConfigWindow.cpp:(.text+0x27f): undefined reference to > `QString::fromUtf8(char const*, int)' > ConfigWindow.cpp:(.text+0x2ff): undefined reference to > `QString::fromUtf8(char const*, int)' > ConfigWindow.cpp:(.text+0x36a): undefined reference to > `QString::fromUtf8(char const*, int)' > ConfigWindow.o:ConfigWindow.cpp:(.text+0x3e2): more undefined references > to `QString::fromUtf8(char const*, int)' follow > ConfigWindow.o: In function `ConfigWindow::ConfigWindow(QWidget*)': > ConfigWindow.cpp:(.text+0x539): undefined reference to > `QCoreApplication::translate(char const*, char const*, char const*, > QCoreApplication::Encoding)' > ConfigWindow.cpp:(.text+0x57e): undefined reference to > `QCoreApplication::translate(char const*, char const*, char const*, > QCoreApplication::Encoding)' > ConfigWindow.cpp:(.text+0x5c4): undefined reference to > `QCoreApplication::translate(char const*, char const*, char const*, > QCoreApplication::Encoding)' > ConfigWindow.cpp:(.text+0x641): undefined reference to > `QString::free(QString::Data*)' > ConfigWindow.cpp:(.text+0x659): undefined reference to > `QString::free(QString::Data*)' > ConfigWindow.cpp:(.text+0x669): undefined reference to > `QString::free(QString::Data*)' > ConfigWindow.cpp:(.text+0x681): undefined reference to > `QString::free(QString::Data*)' > ConfigWindow.cpp:(.text+0x696): undefined reference to > `QString::free(QString::Data*)' > ConfigWindow.o:ConfigWindow.cpp:(.text+0x6a6): more undefined references > to `QString::free(QString::Data*)' follow > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x60): > undefined reference to `QObject::connectNotify(char const*)' > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x68): > undefined reference to `QObject::disconnectNotify(char const*)' > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x160): > undefined reference to `QWidget::x11Event(_XEvent*)' > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x190): > undefined reference to `QWidget::styleChange(QStyle&)' > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x198): > undefined reference to `QWidget::enabledChange(bool)' > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x1a0): > undefined reference to `QWidget::paletteChange(QPalette const&)' > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x1a8): > undefined reference to `QWidget::fontChange(QFont const&)' > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x1b0): > undefined reference to `QWidget::windowActivationChange(bool)' > moc_ConfigWindow.o:(.rodata._ZTV12ConfigWindow[_ZTV12ConfigWindow]+0x1b8): > undefined reference to `QWidget::languageChange()' > collect2: error: ld returned 1 exit status > Makefile:175: recipe for target 'pgAdmin4' failed > make: *** [pgAdmin4] Error 1 > Here - what I am suspecting is headers and library used are of different version of Qt. Have you installed both versions of Qt4 & Qt5 ? Are you using QtCreator for building runtime ? If yes- there may be some wrong configuration with pgAdmin4 project. Can you please try with command line and give me output of "qmake" & "make" in text file ? > > -- > Willy-Bas Loos >
Re: Query tool - file browser
pts rule name description -- -- -1.0 ALL_TRUSTEDPassed through trusted hosts only via SMTP 0.5 RP_MATCHES_RCVDEnvelope sender domain matches handover relay domain 2.5 BAYES_50 BODY: Bayes spam probability is 40 to 60% [score: 0.4999] X-Pg-Spam-Score: -4.2 () > It works fine on Debian, however, as far as I can tell you didn't try what > I suggested to resolve the problem you reported. I did do that. I could solve the original problem but I could not get the desktop version to work which I prefer to work with. As long as the installation causes so much effort to get it going, it is not worth while. Regards Johann -- Johann SpiesTelefoon: 021-808 4699 Databestuurder / Data manager Faks: 021-883 3691 Sentrum vir Navorsing oor Evaluasie, Wetenskap en Tegnologie Centre for Research on Evaluation, Science and Technology Universiteit Stellenbosch. The integrity and confidentiality of this email is governed by these terms / Hierdie terme bepaal die integriteit en vertroulikheid van hierdie epos. http://www.sun.ac.za/emaildisclaimer
