Re: Fedora 29 startup issue

2018-11-01 Thread Devrim Gündüz

Hi,

On Thu, 2018-11-01 at 11:58 +, Dave Page wrote:
> Either there's a config file around overriding the one you've created, or
> that's not being found at all and it's defaulting to system paths.

I'd say the latter -- but not sure. Please note that the default is 3.7, not
3.6.

That said, on RHEL, I just bumped up the version in the spec file and rebuilt
the package. We had no issues with pgAdmin 3.4 RPMs with the same spec file.

Regards,
-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part


Re: Fedora 29 startup issue

2018-11-01 Thread Dave Page
On Thu, Nov 1, 2018 at 10:24 AM Devrim Gündüz  wrote:

>
> Hi,
>
> On Thu, 2018-11-01 at 10:03 +, Dave Page wrote:
> > What does the startup log say? Look for ~/.pgAdmin4.startup.log
>
> Weird. Where does "3.6" come from? This is definitely 3.7...
>
> 01.11.2018 09:56:23 Checking for system tray...
> 01.11.2018 09:56:23 System tray not found, creating floating window...
> 01.11.2018 09:56:23 Starting pgAdmin4 server...
> 01.11.2018 09:56:23 Creating server object, port:33817,
> key:1c82f5ad-c110-4d76-b977-ac971c97b18d,
> logfile:/home/devrim/.pgAdmin4.5793612742908622588.log
> 01.11.2018 09:56:23 Python Path:
> /usr/lib/python3.6/site-packages:/usr/lib64/python3.6/site-packages
> 01.11.2018 09:56:23 Python Home:
> 01.11.2018 09:56:23 Initializing Python...
> 01.11.2018 09:56:23 Python initialized.
> 01.11.2018 09:56:23 Adding new additional path elements
> 01.11.2018 09:56:23 Redirecting stderr...
> 01.11.2018 09:56:23 stderr redirected successfully.
> 01.11.2018 09:56:23 Initializing server...
> 01.11.2018 09:56:23 Failed to locate pgAdmin4.py, terminating server
> thread.
> 01.11.2018 09:57:09 An error occurred initialising the application server:
>

Either there's a config file around overriding the one you've created, or
that's not being found at all and it's defaulting to system paths.

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Fedora 29 startup issue

2018-11-01 Thread Dave Page
On Thu, Nov 1, 2018 at 10:28 AM Fahar Abbas 
wrote:

>
>
> On Thu, Nov 1, 2018 at 3:23 PM Dave Page  wrote:
>
>>
>>
>> On Thu, Nov 1, 2018 at 10:17 AM Fahar Abbas 
>> wrote:
>>
>>> I am facing issue on Centos 7.4(by default python is 2.7) while Devrim
>>> facing issue on Fedora 29 with Python 3.7.
>>>
>>
>> OK, well I need Devrim's logs to try to solve Devrim's problem. Yours may
>> be entirely different.
>>
>> If you try to run pgAdmin.py from the command line, what is the output?
>>
> [root@localhost bin]# pwd
> /usr/pgadmin4/bin
> [root@localhost bin]# ./pgadmin4-web-setup.sh
> Traceback (most recent call last):
>   File "/usr/lib/python2.7/site-packages/pgadmin4-web/setup.py", line 15,
> in 
> from pgadmin.model import db, Version, SCHEMA_VERSION as
> CURRENT_SCHEMA_VERSION
>   File
> "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/__init__.py", line
> 33, in 
> from pgadmin.utils.session import create_session_interface,
> pga_unauthorised
>   File
> "/usr/lib/python2.7/site-packages/pgadmin4-web/pgadmin/utils/session.py",
> line 26, in 
> import config
>   File "/usr/lib/python2.7/site-packages/pgadmin4-web/config.py", line
> 121, in 
> if builtins.SERVER_MODE is None:
> AttributeError: 'module' object has no attribute 'SERVER_MODE'
> Error setting up server mode. Please examine the output above.
>

Did this system have an older version installed?


>
>
>>
>>
>>>
>>> On Thu, Nov 1, 2018 at 3:09 PM Dave Page  wrote:
>>>


 On Thu, Nov 1, 2018 at 10:08 AM Fahar Abbas <
 fahar.ab...@enterprisedb.com> wrote:

> Hi Dave,
>
> On Thu, Nov 1, 2018 at 3:04 PM Dave Page  wrote:
>
>>
>>
>> On Thu, Nov 1, 2018 at 9:58 AM Devrim Gündüz 
>> wrote:
>>
>>>
>>> Hi,
>>>
>>> Fedora 29, Python 3.7. When I run:
>>>
>>> /usr/pgadmin4/runtime/pgAdmin4
>>>
>>> Getting:
>>>
>>> An error occurred initialising the application server:
>>> Failed to locate pgAdmin4.py, terminating server thread.
>>>
>>> $ cat /etc/xdg/pgadmin/pgadmin4.conf
>>> ApplicationPath="/usr/lib/python3.7/site-packages/pgadmin4-web/"
>>>
>>> PythonPath="/usr/lib/python3.7/site-packages:/usr/lib64/python3.7/site-packages"
>>>
>>>
>>> What am I missing?
>>>
>>
>> What does the startup log say? Look for ~/.pgAdmin4.startup.log
>>
> 01.11.2018 15:05:55 Checking for system tray...
> 01.11.2018 15:05:55 Starting pgAdmin4 server...
> 01.11.2018 15:05:55 Creating server object, port:55183,
> key:b3ef7ca8-a755-4284-8b8d-2d82b810ef30,
> logfile:/root/.pgAdmin4.5793612742908622588.log
> 01.11.2018 15:05:55 Python Path:
> /usr/lib/python2.7/site-packages:/usr/lib64/python2.7/site-packages
> 01.11.2018 15:05:55 Python Home:
> 01.11.2018 15:05:55 Initializing Python...
> 01.11.2018 15:05:55 Python initialized.
> 01.11.2018 15:05:55 Adding new additional path elements
> 01.11.2018 15:05:55 Redirecting stderr...
> 01.11.2018 15:05:55 stderr redirected successfully.
> 01.11.2018 15:05:55 Initializing server...
> 01.11.2018 15:05:55 Webapp Path:
> /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.py
> 01.11.2018 15:05:55 Server initialized.
> 01.11.2018 15:05:55 Starting Server Thread...
> 01.11.2018 15:05:55 Open the application code and run it.
> 01.11.2018 15:05:55 Set the port number, key and force SERVER_MODE off
> 01.11.2018 15:05:55 PyRun_SimpleFile launching application server...
> 01.11.2018 15:05:56 Application Server URL:
> http://127.0.0.1:55183/?key=b3ef7ca8-a755-4284-8b8d-2d82b810ef30
> 01.11.2018 15:05:56 The server should be up, we'll attempt to connect
> and get a response. Ping the server
> 01.11.2018 15:06:04 Failed to launch the application server, server
> thread exiting.
> 01.11.2018 15:06:26 Attempt to connect one more time in case of a long
> network timeout while looping
>

 The PythonPath and WebappPath don't match what Devrim says he's using.
 Is that from the same system?

 --
 Dave Page
 Blog: http://pgsnake.blogspot.com
 Twitter: @pgsnake

 EnterpriseDB UK: http://www.enterprisedb.com
 The Enterprise PostgreSQL Company

>>>
>>>
>>> --
>>> Fahar Abbas
>>> QMG
>>> EnterpriseDB Corporation
>>> Phone Office: +92-51-835-8874
>>> Phone Direct: +92-51-8466803
>>> Mobile: +92-333-5409707
>>> Skype ID: *live:fahar.abbas*
>>> Website: www.enterprisedb.com
>>>
>>
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
> --
> Fahar Abbas
> QMG
> EnterpriseDB Corporation
> Phone Office: +92-51-835-8874
> Phone Direct: +92-51-8466803
> Mobile: +92-333-5409707
> Skype ID: *live:fahar.abbas*
> Website: www.enterprisedb.com
>


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB 

Re: Fedora 29 startup issue

2018-11-01 Thread Devrim Gündüz

Hi,

On Thu, 2018-11-01 at 10:03 +, Dave Page wrote:
> What does the startup log say? Look for ~/.pgAdmin4.startup.log

Weird. Where does "3.6" come from? This is definitely 3.7...

01.11.2018 09:56:23 Checking for system tray...
01.11.2018 09:56:23 System tray not found, creating floating window...
01.11.2018 09:56:23 Starting pgAdmin4 server...
01.11.2018 09:56:23 Creating server object, port:33817, 
key:1c82f5ad-c110-4d76-b977-ac971c97b18d, 
logfile:/home/devrim/.pgAdmin4.5793612742908622588.log
01.11.2018 09:56:23 Python Path: 
/usr/lib/python3.6/site-packages:/usr/lib64/python3.6/site-packages
01.11.2018 09:56:23 Python Home: 
01.11.2018 09:56:23 Initializing Python...
01.11.2018 09:56:23 Python initialized.
01.11.2018 09:56:23 Adding new additional path elements
01.11.2018 09:56:23 Redirecting stderr...
01.11.2018 09:56:23 stderr redirected successfully.
01.11.2018 09:56:23 Initializing server...
01.11.2018 09:56:23 Failed to locate pgAdmin4.py, terminating server thread.
01.11.2018 09:57:09 An error occurred initialising the application server:


-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part


Re: Fedora 29 startup issue

2018-11-01 Thread Dave Page
On Thu, Nov 1, 2018 at 10:17 AM Fahar Abbas 
wrote:

> I am facing issue on Centos 7.4(by default python is 2.7) while Devrim
> facing issue on Fedora 29 with Python 3.7.
>

OK, well I need Devrim's logs to try to solve Devrim's problem. Yours may
be entirely different.

If you try to run pgAdmin.py from the command line, what is the output?


>
> On Thu, Nov 1, 2018 at 3:09 PM Dave Page  wrote:
>
>>
>>
>> On Thu, Nov 1, 2018 at 10:08 AM Fahar Abbas 
>> wrote:
>>
>>> Hi Dave,
>>>
>>> On Thu, Nov 1, 2018 at 3:04 PM Dave Page  wrote:
>>>


 On Thu, Nov 1, 2018 at 9:58 AM Devrim Gündüz  wrote:

>
> Hi,
>
> Fedora 29, Python 3.7. When I run:
>
> /usr/pgadmin4/runtime/pgAdmin4
>
> Getting:
>
> An error occurred initialising the application server:
> Failed to locate pgAdmin4.py, terminating server thread.
>
> $ cat /etc/xdg/pgadmin/pgadmin4.conf
> ApplicationPath="/usr/lib/python3.7/site-packages/pgadmin4-web/"
>
> PythonPath="/usr/lib/python3.7/site-packages:/usr/lib64/python3.7/site-packages"
>
>
> What am I missing?
>

 What does the startup log say? Look for ~/.pgAdmin4.startup.log

>>> 01.11.2018 15:05:55 Checking for system tray...
>>> 01.11.2018 15:05:55 Starting pgAdmin4 server...
>>> 01.11.2018 15:05:55 Creating server object, port:55183,
>>> key:b3ef7ca8-a755-4284-8b8d-2d82b810ef30,
>>> logfile:/root/.pgAdmin4.5793612742908622588.log
>>> 01.11.2018 15:05:55 Python Path:
>>> /usr/lib/python2.7/site-packages:/usr/lib64/python2.7/site-packages
>>> 01.11.2018 15:05:55 Python Home:
>>> 01.11.2018 15:05:55 Initializing Python...
>>> 01.11.2018 15:05:55 Python initialized.
>>> 01.11.2018 15:05:55 Adding new additional path elements
>>> 01.11.2018 15:05:55 Redirecting stderr...
>>> 01.11.2018 15:05:55 stderr redirected successfully.
>>> 01.11.2018 15:05:55 Initializing server...
>>> 01.11.2018 15:05:55 Webapp Path:
>>> /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.py
>>> 01.11.2018 15:05:55 Server initialized.
>>> 01.11.2018 15:05:55 Starting Server Thread...
>>> 01.11.2018 15:05:55 Open the application code and run it.
>>> 01.11.2018 15:05:55 Set the port number, key and force SERVER_MODE off
>>> 01.11.2018 15:05:55 PyRun_SimpleFile launching application server...
>>> 01.11.2018 15:05:56 Application Server URL:
>>> http://127.0.0.1:55183/?key=b3ef7ca8-a755-4284-8b8d-2d82b810ef30
>>> 01.11.2018 15:05:56 The server should be up, we'll attempt to connect
>>> and get a response. Ping the server
>>> 01.11.2018 15:06:04 Failed to launch the application server, server
>>> thread exiting.
>>> 01.11.2018 15:06:26 Attempt to connect one more time in case of a long
>>> network timeout while looping
>>>
>>
>> The PythonPath and WebappPath don't match what Devrim says he's using. Is
>> that from the same system?
>>
>> --
>> Dave Page
>> Blog: http://pgsnake.blogspot.com
>> Twitter: @pgsnake
>>
>> EnterpriseDB UK: http://www.enterprisedb.com
>> The Enterprise PostgreSQL Company
>>
>
>
> --
> Fahar Abbas
> QMG
> EnterpriseDB Corporation
> Phone Office: +92-51-835-8874
> Phone Direct: +92-51-8466803
> Mobile: +92-333-5409707
> Skype ID: *live:fahar.abbas*
> Website: www.enterprisedb.com
>


-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Fedora 29 startup issue

2018-11-01 Thread Fahar Abbas
I am facing issue on Centos 7.4(by default python is 2.7) while Devrim
facing issue on Fedora 29 with Python 3.7.

On Thu, Nov 1, 2018 at 3:09 PM Dave Page  wrote:

>
>
> On Thu, Nov 1, 2018 at 10:08 AM Fahar Abbas 
> wrote:
>
>> Hi Dave,
>>
>> On Thu, Nov 1, 2018 at 3:04 PM Dave Page  wrote:
>>
>>>
>>>
>>> On Thu, Nov 1, 2018 at 9:58 AM Devrim Gündüz  wrote:
>>>

 Hi,

 Fedora 29, Python 3.7. When I run:

 /usr/pgadmin4/runtime/pgAdmin4

 Getting:

 An error occurred initialising the application server:
 Failed to locate pgAdmin4.py, terminating server thread.

 $ cat /etc/xdg/pgadmin/pgadmin4.conf
 ApplicationPath="/usr/lib/python3.7/site-packages/pgadmin4-web/"

 PythonPath="/usr/lib/python3.7/site-packages:/usr/lib64/python3.7/site-packages"


 What am I missing?

>>>
>>> What does the startup log say? Look for ~/.pgAdmin4.startup.log
>>>
>> 01.11.2018 15:05:55 Checking for system tray...
>> 01.11.2018 15:05:55 Starting pgAdmin4 server...
>> 01.11.2018 15:05:55 Creating server object, port:55183,
>> key:b3ef7ca8-a755-4284-8b8d-2d82b810ef30,
>> logfile:/root/.pgAdmin4.5793612742908622588.log
>> 01.11.2018 15:05:55 Python Path:
>> /usr/lib/python2.7/site-packages:/usr/lib64/python2.7/site-packages
>> 01.11.2018 15:05:55 Python Home:
>> 01.11.2018 15:05:55 Initializing Python...
>> 01.11.2018 15:05:55 Python initialized.
>> 01.11.2018 15:05:55 Adding new additional path elements
>> 01.11.2018 15:05:55 Redirecting stderr...
>> 01.11.2018 15:05:55 stderr redirected successfully.
>> 01.11.2018 15:05:55 Initializing server...
>> 01.11.2018 15:05:55 Webapp Path:
>> /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.py
>> 01.11.2018 15:05:55 Server initialized.
>> 01.11.2018 15:05:55 Starting Server Thread...
>> 01.11.2018 15:05:55 Open the application code and run it.
>> 01.11.2018 15:05:55 Set the port number, key and force SERVER_MODE off
>> 01.11.2018 15:05:55 PyRun_SimpleFile launching application server...
>> 01.11.2018 15:05:56 Application Server URL:
>> http://127.0.0.1:55183/?key=b3ef7ca8-a755-4284-8b8d-2d82b810ef30
>> 01.11.2018 15:05:56 The server should be up, we'll attempt to connect and
>> get a response. Ping the server
>> 01.11.2018 15:06:04 Failed to launch the application server, server
>> thread exiting.
>> 01.11.2018 15:06:26 Attempt to connect one more time in case of a long
>> network timeout while looping
>>
>
> The PythonPath and WebappPath don't match what Devrim says he's using. Is
> that from the same system?
>
> --
> Dave Page
> Blog: http://pgsnake.blogspot.com
> Twitter: @pgsnake
>
> EnterpriseDB UK: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>


-- 
Fahar Abbas
QMG
EnterpriseDB Corporation
Phone Office: +92-51-835-8874
Phone Direct: +92-51-8466803
Mobile: +92-333-5409707
Skype ID: *live:fahar.abbas*
Website: www.enterprisedb.com


Re: Fedora 29 startup issue

2018-11-01 Thread Dave Page
On Thu, Nov 1, 2018 at 10:08 AM Fahar Abbas 
wrote:

> Hi Dave,
>
> On Thu, Nov 1, 2018 at 3:04 PM Dave Page  wrote:
>
>>
>>
>> On Thu, Nov 1, 2018 at 9:58 AM Devrim Gündüz  wrote:
>>
>>>
>>> Hi,
>>>
>>> Fedora 29, Python 3.7. When I run:
>>>
>>> /usr/pgadmin4/runtime/pgAdmin4
>>>
>>> Getting:
>>>
>>> An error occurred initialising the application server:
>>> Failed to locate pgAdmin4.py, terminating server thread.
>>>
>>> $ cat /etc/xdg/pgadmin/pgadmin4.conf
>>> ApplicationPath="/usr/lib/python3.7/site-packages/pgadmin4-web/"
>>>
>>> PythonPath="/usr/lib/python3.7/site-packages:/usr/lib64/python3.7/site-packages"
>>>
>>>
>>> What am I missing?
>>>
>>
>> What does the startup log say? Look for ~/.pgAdmin4.startup.log
>>
> 01.11.2018 15:05:55 Checking for system tray...
> 01.11.2018 15:05:55 Starting pgAdmin4 server...
> 01.11.2018 15:05:55 Creating server object, port:55183,
> key:b3ef7ca8-a755-4284-8b8d-2d82b810ef30,
> logfile:/root/.pgAdmin4.5793612742908622588.log
> 01.11.2018 15:05:55 Python Path:
> /usr/lib/python2.7/site-packages:/usr/lib64/python2.7/site-packages
> 01.11.2018 15:05:55 Python Home:
> 01.11.2018 15:05:55 Initializing Python...
> 01.11.2018 15:05:55 Python initialized.
> 01.11.2018 15:05:55 Adding new additional path elements
> 01.11.2018 15:05:55 Redirecting stderr...
> 01.11.2018 15:05:55 stderr redirected successfully.
> 01.11.2018 15:05:55 Initializing server...
> 01.11.2018 15:05:55 Webapp Path:
> /usr/lib/python2.7/site-packages/pgadmin4-web/pgAdmin4.py
> 01.11.2018 15:05:55 Server initialized.
> 01.11.2018 15:05:55 Starting Server Thread...
> 01.11.2018 15:05:55 Open the application code and run it.
> 01.11.2018 15:05:55 Set the port number, key and force SERVER_MODE off
> 01.11.2018 15:05:55 PyRun_SimpleFile launching application server...
> 01.11.2018 15:05:56 Application Server URL:
> http://127.0.0.1:55183/?key=b3ef7ca8-a755-4284-8b8d-2d82b810ef30
> 01.11.2018 15:05:56 The server should be up, we'll attempt to connect and
> get a response. Ping the server
> 01.11.2018 15:06:04 Failed to launch the application server, server thread
> exiting.
> 01.11.2018 15:06:26 Attempt to connect one more time in case of a long
> network timeout while looping
>

The PythonPath and WebappPath don't match what Devrim says he's using. Is
that from the same system?

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Re: Fedora 29 startup issue

2018-11-01 Thread Dave Page
On Thu, Nov 1, 2018 at 9:58 AM Devrim Gündüz  wrote:

>
> Hi,
>
> Fedora 29, Python 3.7. When I run:
>
> /usr/pgadmin4/runtime/pgAdmin4
>
> Getting:
>
> An error occurred initialising the application server:
> Failed to locate pgAdmin4.py, terminating server thread.
>
> $ cat /etc/xdg/pgadmin/pgadmin4.conf
> ApplicationPath="/usr/lib/python3.7/site-packages/pgadmin4-web/"
>
> PythonPath="/usr/lib/python3.7/site-packages:/usr/lib64/python3.7/site-packages"
>
>
> What am I missing?
>

What does the startup log say? Look for ~/.pgAdmin4.startup.log

-- 
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


Fedora 29 startup issue

2018-11-01 Thread Devrim Gündüz

Hi,

Fedora 29, Python 3.7. When I run:

/usr/pgadmin4/runtime/pgAdmin4

Getting:

An error occurred initialising the application server:
Failed to locate pgAdmin4.py, terminating server thread.

$ cat /etc/xdg/pgadmin/pgadmin4.conf 
ApplicationPath="/usr/lib/python3.7/site-packages/pgadmin4-web/"
PythonPath="/usr/lib/python3.7/site-packages:/usr/lib64/python3.7/site-packages"


What am I missing?

Regards,
-- 
Devrim Gündüz
EnterpriseDB: https://www.enterprisedb.com
PostgreSQL Consultant, Red Hat Certified Engineer
Twitter: @DevrimGunduz , @DevrimGunduzTR


signature.asc
Description: This is a digitally signed message part