Issue with PostgreSQL and python/Django application.

InoT

I have setup python app and it's running.
I have created the required Postgres DB.

Now when I try to do

python manage.py makemigrations

I get this error:

File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/core/management/base.py", line 328, in run_from_argv
self.execute(args, **cmd_options)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/core/management/base.py", line 369, in execute
output = self.handle(args, **options)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/core/management/base.py", line 83, in wrapped
res = handle_func(args, **kwargs)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/core/management/commands/makemigrations.py", line 101, in handle
loader.check_consistent_history(connection)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/migrations/loader.py", line 283, in check_consistent_history
applied = recorder.applied_migrations()
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/migrations/recorder.py", line 76, in applied_migrations
if self.has_table():
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/migrations/recorder.py", line 56, in has_table
return self.Migration.meta.db_table in self.connection.introspection.table_names(self.connection.cursor())
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
return func(args, **kwargs)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/backends/base/base.py", line 260, in cursor
return self.cursor()
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/backends/base/base.py", line 236, in _cursor
self.ensure_connection()
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
return func(args, **kwargs)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
self.connect()
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/utils.py", line 90, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/backends/base/base.py", line 220, in ensure_connection
self.connect()
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
return func(args, **kwargs)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/backends/base/base.py", line 197, in connect
self.connection = self.get_new_connection(conn_params)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/utils/asyncio.py", line 26, in inner
return func(*args, kwargs)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/django/db/backends/postgresql/base.py", line 185, in get_new_connection
connection = Database.connect(conn_params)
File "/www/wwwroot/ContentStarzCP/CStarzCP_venv/lib/python3.8/site-packages/psycopg2/init.py", line 127, in connect
conn = _connect(dsn, connection_factory=connection_factory, **kwasync)
django.db.utils.OperationalError: FATAL: role "cs_db_user" does not exist

But that's not all. Trying to restart PostgreSQL from the addon app inside aaPanel, gives me another error:

aaPanel_Jose

Hello InoT

Did you modify the storage path of pgsql?

InoT

aaPanel_Jose no I didn't.

aaPanel_Jose

InoT
Your picture reveals your ip address, I deleted it, does this issue affect your use? If it doesn't affect me, let me arrange a time to reproduce it locally

InoT

aaPanel_Jose the ip was temporary and IP can easily be found from any domain too. So, not much of a big deal.

What issue I face I have shared at the top. I haven't changed any config of the addon.

Let me know if you can help me fix the issue.

InoT

aaPanel_Jose any update?

aaPanel_Jose

InoT

Sorry i cant reprouduce this problem on my test server, can i login to you panel to check?

InoT

aaPanel_Jose I am mailing you the login details.

InoT

aaPanel_Jose hello? Any update?

aaPanel_Jose

InoT
Hello, I have received your email and will check it for you today

InoT

aaPanel_Jose any update?

InoT

aaPanel_Jose after you fixed the restart issue, it still failed to work when I tried running the django commands.

So, I removed the old user and created a new user and it worked this time. So, all good now.

Thank you once again.

aaP_Rach_derman

Hi @aaPanel_Jose

Can you help me out with the solution ?

I am having the same issue

aapanel_power

aaP_Rach_derman Hello, you give me your panel login address to my email, I'll see what the problem is
power@aapanel.com