Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

OperationalError at /admin/vpn/subnettosubnet/ #3

Open
reinethernal opened this issue Jul 27, 2020 · 12 comments
Open

OperationalError at /admin/vpn/subnettosubnet/ #3

reinethernal opened this issue Jul 27, 2020 · 12 comments

Comments

@reinethernal
Copy link

Aaaand a new error with a

You have 5 unapplied migration(s). Your project may not work properly until you apply the migrations for app(s): vpn.
Run 'python manage.py migrate' to apply them.

at console. and
https://dpaste.com/6Q6RP3B8E#line-2

at web.
@reinethernal
Copy link
Author

And when i try to re-migrate db, under a user (thought there were not enough rigths) i receive this

./manage.py migrate result `Operations to perform: Apply all migrations: admin, auth, contenttypes, sessions, vpn Running migrations: Applying contenttypes.0001_initial... OK Applying auth.0001_initial... OK Applying admin.0001_initial... OK Applying admin.0002_logentry_remove_auto_add... OK Applying contenttypes.0002_remove_content_type_name... 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 sessions.0001_initial... OK Applying vpn.0001_initial... OK Applying vpn.0002_auto_20180525_2129... OK Applying vpn.0003_dnsconfig_right_subnet_text... OK Applying vpn.0004_auto_20180527_2031... OK Applying vpn.0005_auto_20180527_2156... OK Applying vpn.0006_auto_20180528_2304... OK Applying vpn.0007_auto_20180529_0017... OK Applying vpn.0008_auto_20180530_1502... OK Applying vpn.0009_auto_20180530_1605... OK Applying vpn.0010_auto_20180530_1719... OK Applying vpn.0011_auto_20180530_1900... OK Applying vpn.0012_auto_20180531_1408... OK Applying vpn.0013_auto_20180531_1728... OK Applying vpn.0014_employee... OK Applying vpn.0015_auto_20180603_2057... OK Applying vpn.0016_auto_20180604_1505... OK Applying vpn.0017_auto_20180604_1538... OK Applying vpn.0018_auto_20180604_1539... OK Applying vpn.0019_auto_20180607_1245... OK Applying vpn.0020_auto_20180612_1203... OK Applying vpn.0021_auto_20180612_1440... OK Applying vpn.0022_auto_20180620_1337... OK Applying vpn.0023_auto_20180620_1412... OK Applying vpn.0024_remove_generatecertificate_token... OK Applying vpn.0025_auto_20180625_1251... OK Applying vpn.0026_certificateconfiguration... OK Applying vpn.0027_auto_20180629_1502... OK Applying vpn.0028_auto_20180629_1519... OK Applying vpn.0029_auto_20180629_1926... OK Applying vpn.0030_generaterootca... OK Applying vpn.0031_auto_20180629_2239... OK Applying vpn.0032_auto_20180703_1434... OK Applying vpn.0033_auto_20180703_1439... OK Applying vpn.0034_auto_20180703_1504... OK Applying vpn.0035_auto_20180703_1513... OK Applying vpn.0036_auto_20180703_1534... OK Applying vpn.0037_generaterootcertificate_password... OK Applying vpn.0038_auto_20180703_1806... OK Applying vpn.0039_latestsavedkeypassword... OK Applying vpn.0040_auto_20180709_1352... OK Applying vpn.0041_delete_latestsavedkeypassword... OK Applying vpn.0042_remove_generaterootcertificate_password... OK Applying vpn.0043_auto_20180722_1558... OK Applying vpn.0044_auto_20180722_1605...Traceback (most recent call last): File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute return self.cursor.execute(sql, params) File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute return self.cursor.execute(query, args) File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute res = self._query(query) File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 319, in _query db.query(q) File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/MySQLdb/connections.py", line 259, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1280, "Incorrect index name 'vpn_privatekeypassword_key_name_b5606c3b_uniq'")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "manage.py", line 22, in
execute_from_command_line(sys.argv)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/core/management/init.py", line 371, in execute_from_command_line
utility.execute()
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/core/management/init.py", line 365, in execute
self.fetch_command(subcommand).run_from_argv(self.argv)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/core/management/base.py", line 288, in run_from_argv
self.execute(*args, **cmd_options)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/core/management/base.py", line 335, in execute
output = self.handle(*args, **options)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 200, in handle
fake_initial=fake_initial,
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate
state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/migrations/executor.py", line 244, in apply_migration
state = migration.apply(state, schema_editor)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/migrations/migration.py", line 122, in apply
operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/migrations/operations/fields.py", line 216, in database_forwards
schema_editor.alter_field(from_model, from_field, to_field)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 525, in alter_field
old_db_params, new_db_params, strict)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 725, in _alter_field
"columns": self.quote_name(new_field.column),
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 133, in execute
cursor.execute(sql, params)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 100, in execute
return super().execute(sql, params)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 68, in execute
return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
return executor(sql, params, many, context)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
return self.cursor.execute(sql, params)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in exit
raise dj_exc_value.with_traceback(traceback) from exc_value
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
return self.cursor.execute(sql, params)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
return self.cursor.execute(query, args)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
res = self._query(query)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 319, in _query
db.query(q)
File "/root/Libreswan-managing-interface/librenv/lib/python3.6/site-packages/MySQLdb/connections.py", line 259, in query
_mysql.connection.query(self, query)
django.db.utils.OperationalError: (1280, "Incorrect index name 'vpn_privatekeypassword_key_name_b5606c3b_uniq'")
`

@Rishabh04-02
Copy link
Owner

I checked the models.py. There exists the model Models Line 324 and the index name vpn_privatekeypassword_key_name seems to be valid.

I'll check why this is throwing this error.

@Rishabh04-02
Copy link
Owner

Rishabh04-02 commented Jul 28, 2020 •
edited
Loading 

(librenv)  ~/Github/Libreswan-managing-interface   master ●  ./manage.py migrate
Operations to perform:
  Apply all migrations: admin, auth, contenttypes, sessions, vpn
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial... OK
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying contenttypes.0002_remove_content_type_name... 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 sessions.0001_initial... OK
  Applying vpn.0001_initial... OK
  Applying vpn.0002_auto_20180525_2129... OK
  Applying vpn.0003_dnsconfig_right_subnet_text... OK
  Applying vpn.0004_auto_20180527_2031... OK
  Applying vpn.0005_auto_20180527_2156... OK
  Applying vpn.0006_auto_20180528_2304... OK
  Applying vpn.0007_auto_20180529_0017... OK
  Applying vpn.0008_auto_20180530_1502... OK
  Applying vpn.0009_auto_20180530_1605... OK
  Applying vpn.0010_auto_20180530_1719... OK
  Applying vpn.0011_auto_20180530_1900... OK
  Applying vpn.0012_auto_20180531_1408... OK
  Applying vpn.0013_auto_20180531_1728... OK
  Applying vpn.0014_employee... OK
  Applying vpn.0015_auto_20180603_2057... OK
  Applying vpn.0016_auto_20180604_1505... OK
  Applying vpn.0017_auto_20180604_1538... OK
  Applying vpn.0018_auto_20180604_1539... OK
  Applying vpn.0019_auto_20180607_1245... OK
  Applying vpn.0020_auto_20180612_1203... OK
  Applying vpn.0021_auto_20180612_1440... OK
  Applying vpn.0022_auto_20180620_1337... OK
  Applying vpn.0023_auto_20180620_1412... OK
  Applying vpn.0024_remove_generatecertificate_token... OK
  Applying vpn.0025_auto_20180625_1251... OK
  Applying vpn.0026_certificateconfiguration... OK
  Applying vpn.0027_auto_20180629_1502... OK
  Applying vpn.0028_auto_20180629_1519... OK
  Applying vpn.0029_auto_20180629_1926... OK
  Applying vpn.0030_generaterootca... OK
  Applying vpn.0031_auto_20180629_2239... OK
  Applying vpn.0032_auto_20180703_1434... OK
  Applying vpn.0033_auto_20180703_1439... OK
  Applying vpn.0034_auto_20180703_1504... OK
  Applying vpn.0035_auto_20180703_1513... OK
  Applying vpn.0036_auto_20180703_1534... OK
  Applying vpn.0037_generaterootcertificate_password... OK
  Applying vpn.0038_auto_20180703_1806... OK
  Applying vpn.0039_latestsavedkeypassword... OK
  Applying vpn.0040_auto_20180709_1352... OK
  Applying vpn.0041_delete_latestsavedkeypassword... OK
  Applying vpn.0042_remove_generaterootcertificate_password... OK
  Applying vpn.0043_auto_20180722_1558... OK
  Applying vpn.0044_auto_20180722_1605... OK
  Applying vpn.0045_generatecertificate_cert_name... OK
  Applying vpn.0046_auto_20180803_0314... OK
  Applying vpn.0047_auto_20180813_0011... OK
  Applying vpn.0048_auto_20180813_0026... OK

I did the installation from scratch and was also updating the installation guide (a few minor edits). But found no problem with the migration. They are working perfectly. And the admin is working great too.

Screenshot_2020-07-28 Site administration Django site admin

@Rishabh04-02
Copy link
Owner

Rishabh04-02 commented Jul 28, 2020 •
edited
Loading

You are getting this error

You have 5 unapplied migration(s). Your project may not work properly until you apply the migrations for app(s): vpn.
Run 'python manage.py migrate' to apply them.

because all your migration were not applied at once. Maybe the process failed mid way.

Just flush your database and start following the installation guide from 6. Preparing the app for running

@reinethernal
Copy link
Author

reinethernal commented Jul 28, 2020 •
edited
Loading

Nope. that doesn't help
Tried many ways, but...

MariaDB [(none)]> drop database libreweb;
Query OK, 18 rows affected (0.036 sec)

MariaDB [(none)]> CREATE DATABASE libreweb CHARACTER SET utf8;
Query OK, 1 row affected (0.001 sec)

MariaDB [(none)]> GRANT ALL PRIVILEGES ON *.* TO 'libreweb'@'localhost' IDENTIFIED BY 'GtSX6TDv';
Query OK, 0 rows affected (0.086 sec)

MariaDB [(none)]> \q
Bye
(librenv) [root@sk-av Libreswan-managing-interface-master]# clear
(librenv) [root@sk-av Libreswan-managing-interface-master]# ./manage.py migrate
Operations to perform:
  Apply all migrations: admin, auth, contenttypes, sessions, vpn
Running migrations:
  Applying contenttypes.0001_initial... OK
  Applying auth.0001_initial... OK
  Applying admin.0001_initial... OK
  Applying admin.0002_logentry_remove_auto_add... OK
  Applying contenttypes.0002_remove_content_type_name... 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 sessions.0001_initial... OK
  Applying vpn.0001_initial... OK
  Applying vpn.0002_auto_20180525_2129... OK
  Applying vpn.0003_dnsconfig_right_subnet_text... OK
  Applying vpn.0004_auto_20180527_2031... OK
  Applying vpn.0005_auto_20180527_2156... OK
  Applying vpn.0006_auto_20180528_2304... OK
  Applying vpn.0007_auto_20180529_0017... OK
  Applying vpn.0008_auto_20180530_1502... OK
  Applying vpn.0009_auto_20180530_1605... OK
  Applying vpn.0010_auto_20180530_1719... OK
  Applying vpn.0011_auto_20180530_1900... OK
  Applying vpn.0012_auto_20180531_1408... OK
  Applying vpn.0013_auto_20180531_1728... OK
  Applying vpn.0014_employee... OK
  Applying vpn.0015_auto_20180603_2057... OK
  Applying vpn.0016_auto_20180604_1505... OK
  Applying vpn.0017_auto_20180604_1538... OK
  Applying vpn.0018_auto_20180604_1539... OK
  Applying vpn.0019_auto_20180607_1245... OK
  Applying vpn.0020_auto_20180612_1203... OK
  Applying vpn.0021_auto_20180612_1440... OK
  Applying vpn.0022_auto_20180620_1337... OK
  Applying vpn.0023_auto_20180620_1412... OK
  Applying vpn.0024_remove_generatecertificate_token... OK
  Applying vpn.0025_auto_20180625_1251... OK
  Applying vpn.0026_certificateconfiguration... OK
  Applying vpn.0027_auto_20180629_1502... OK
  Applying vpn.0028_auto_20180629_1519... OK
  Applying vpn.0029_auto_20180629_1926... OK
  Applying vpn.0030_generaterootca... OK
  Applying vpn.0031_auto_20180629_2239... OK
  Applying vpn.0032_auto_20180703_1434... OK
  Applying vpn.0033_auto_20180703_1439... OK
  Applying vpn.0034_auto_20180703_1504... OK
  Applying vpn.0035_auto_20180703_1513... OK
  Applying vpn.0036_auto_20180703_1534... OK
  Applying vpn.0037_generaterootcertificate_password... OK
  Applying vpn.0038_auto_20180703_1806... OK
  Applying vpn.0039_latestsavedkeypassword... OK
  Applying vpn.0040_auto_20180709_1352... OK
  Applying vpn.0041_delete_latestsavedkeypassword... OK
  Applying vpn.0042_remove_generaterootcertificate_password... OK
  Applying vpn.0043_auto_20180722_1558... OK
  Applying vpn.0044_auto_20180722_1605...Traceback (most recent call last):
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/MySQLdb/connections.py", line 259, in query
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1280, "Incorrect index name 'vpn_privatekeypassword_key_name_b5606c3b_uniq'")

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
  File "./manage.py", line 22, in <module>
    execute_from_command_line(sys.argv)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/core/management/__init__.py", line 371, in execute_from_command_line
    utility.execute()
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/core/management/__init__.py", line 365, in execute
    self.fetch_command(subcommand).run_from_argv(self.argv)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/core/management/base.py", line 288, in run_from_argv
    self.execute(*args, **cmd_options)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/core/management/base.py", line 335, in execute
    output = self.handle(*args, **options)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/core/management/commands/migrate.py", line 200, in handle
    fake_initial=fake_initial,
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/migrations/executor.py", line 117, in migrate
    state = self._migrate_all_forwards(state, plan, full_plan, fake=fake, fake_initial=fake_initial)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/migrations/executor.py", line 147, in _migrate_all_forwards
    state = self.apply_migration(state, migration, fake=fake, fake_initial=fake_initial)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/migrations/executor.py", line 244, in apply_migration
    state = migration.apply(state, schema_editor)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/migrations/migration.py", line 122, in apply
    operation.database_forwards(self.app_label, schema_editor, old_state, project_state)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/migrations/operations/fields.py", line 216, in database_forwards
    schema_editor.alter_field(from_model, from_field, to_field)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 525, in alter_field
    old_db_params, new_db_params, strict)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 725, in _alter_field
    "columns": self.quote_name(new_field.column),
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/base/schema.py", line 133, in execute
    cursor.execute(sql, params)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 100, in execute
    return super().execute(sql, params)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 68, in execute
    return self._execute_with_wrappers(sql, params, many=False, executor=self._execute)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 77, in _execute_with_wrappers
    return executor(sql, params, many, context)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/utils.py", line 89, in __exit__
    raise dj_exc_value.with_traceback(traceback) from exc_value
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/utils.py", line 85, in _execute
    return self.cursor.execute(sql, params)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/django/db/backends/mysql/base.py", line 71, in execute
    return self.cursor.execute(query, args)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 206, in execute
    res = self._query(query)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/MySQLdb/cursors.py", line 319, in _query
    db.query(q)
  File "/root/Libreswan-managing-interface-master/libreswan_managing_interface/librenv/lib/python3.6/site-packages/MySQLdb/connections.py", line 259, in query
    _mysql.connection.query(self, query)
django.db.utils.OperationalError: (1280, "Incorrect index name 'vpn_privatekeypassword_key_name_b5606c3b_uniq'")
(librenv) [root@sk-av Libreswan-managing-interface-master]#

@Rishabh04-02
Copy link
Owner

This problem might be due to MariaDB. I've found this tutorial for you, you can follow it from section MariaDB.

You might be having problems because you haven't flushed the privileges so that they can be used during the current session.

Also, your database name and username are the same. Just create the database and user following this section. So, as to reduce the scope of error.

If this doesn't work you can search for similar solutions.

@reinethernal
Copy link
Author

Just the same.
And to be clear - i use centos 7 and 10.4.13-MariaDB MariaDB Server

@Rishabh04-02
Copy link
Owner

i use centos 7 and 10.4.13-MariaDB MariaDB Server

Okay.

This managing interface was also tested on CentOS. I'll try to get a CentOS system and solve this installation problem.

  • What Django version are you using? The managing interface is made using Django 2.0.x.

  • Could you try and see if this installation works on your system or not.

@bleve
Copy link

bleve commented Jul 30, 2020

epel7 now has django for python3 which is older version.

@Rishabh04-02
Copy link
Owner

@bleve Django 2.0.x also works on python 3.

Django 2.0 supports Python 3.4, 3.5, 3.6, and 3.7. We highly recommend and only officially support the latest release of each series.
The Django 1.11.x series is the last to support Python 2.7.

Source -

epel7 now has django for python3 which is older version.

Yes, Django 2.0 is older but it can be easily migrated to Django 2.2 LTS

@reinethernal
Copy link
Author

i use centos 7 and 10.4.13-MariaDB MariaDB Server

Okay.

This managing interface was also tested on CentOS. I'll try to get a CentOS system and solve this installation problem.

  • What Django version are you using? The managing interface is made using Django 2.0.x.
  • Could you try and see if this installation works on your system or not.

Here what i receive after installing app by your instruction
image
And here's the install log

'''
[root@sk-av ~]# sudo yum install python-django
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
Resolving Dependencies
--> Running transaction check
---> Package python2-django.noarch 0:1.11.27-1.el7 will be installed
--> Processing Dependency: python-django-bash-completion = 1.11.27-1.el7 for package: python2-django-1.11.27-1.el7.noarch
--> Running transaction check
---> Package python-django-bash-completion.noarch 0:1.11.27-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================
Package Arch Version Repository Size

Installing:
python2-django noarch 1.11.27-1.el7 epel 4.2 M
Installing for dependencies:
python-django-bash-completion noarch 1.11.27-1.el7 epel 10 k

Transaction Summary

Install 1 Package (+1 Dependent package)

Total download size: 4.2 M
Installed size: 16 M
Is this ok [y/d/N]: ^CExiting on user command
Your transaction was saved, rerun it with:
yum load-transaction /tmp/yum_save_tx.2020-07-31.20-33.4XnqkT.yumtx
[root@sk-av ~]# sudo yum install python-django
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
Resolving Dependencies
--> Running transaction check
---> Package python2-django.noarch 0:1.11.27-1.el7 will be installed
--> Processing Dependency: python-django-bash-completion = 1.11.27-1.el7 for package: python2-django-1.11.27-1.el7.noarch
--> Running transaction check
---> Package python-django-bash-completion.noarch 0:1.11.27-1.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================
Package Arch Version Repository Size

Installing:
python2-django noarch 1.11.27-1.el7 epel 4.2 M
Installing for dependencies:
python-django-bash-completion noarch 1.11.27-1.el7 epel 10 k

Transaction Summary

Install 1 Package (+1 Dependent package)

Total download size: 4.2 M
Installed size: 16 M
Is this ok [y/d/N]: sudo yum install python-django
Is this ok [y/d/N]: y
Downloading packages:
(1/2): python-django-bash-completion-1.11.27-1.el7.noarch.rpm | 10 kB 00:00:00
(2/2): python2-django-1.11.27-1.el7.noarch.rpm | 4.2 MB 00:00:01

Total 2.7 MB/s | 4.2 MB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : python-django-bash-completion-1.11.27-1.el7.noarch 1/2
Installing : python2-django-1.11.27-1.el7.noarch 2/2
Verifying : python2-django-1.11.27-1.el7.noarch 1/2
Verifying : python-django-bash-completion-1.11.27-1.el7.noarch 2/2

Installed:
python2-django.noarch 0:1.11.27-1.el7

Dependency Installed:
python-django-bash-completion.noarch 0:1.11.27-1.el7

Complete!
[root@sk-av ~]# sudo yum install python3-django
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
No package python3-django available.
Error: Nothing to do
[root@sk-av ~]# django-admin --version
2.0.6
[root@sk-av ~]# sudo yum install python-pip
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
Package python2-pip-8.1.2-12.el7.noarch already installed and latest version
Nothing to do
[root@sk-av ~]# sudo yum install python3-pip
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
Package python3-pip-9.0.3-7.el7_7.noarch already installed and latest version
Nothing to do
[root@sk-av ~]# sudo pip install django
sudo: pip: command not found
[root@sk-av ~]# pip install django
Requirement already satisfied: django in /usr/local/lib/python3.6/site-packages (2.0.6)
Requirement already satisfied: pytz in /usr/local/lib/python3.6/site-packages (from django) (2020.1)
[root@sk-av ~]# pip3 install django
Requirement already satisfied: django in /usr/local/lib/python3.6/site-packages (2.0.6)
Requirement already satisfied: pytz in /usr/local/lib/python3.6/site-packages (from django) (2020.1)
[root@sk-av ~]# yum install python-pip
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
Package python2-pip-8.1.2-12.el7.noarch already installed and latest version
Nothing to do
[root@sk-av ~]# mkdir ~/newproject
[root@sk-av ~]# cd /newproject
[root@sk-av newproject]# pip install virtualenv
Requirement already satisfied: virtualenv in /usr/local/lib/python3.6/site-packages (16.7.9)
[root@sk-av newproject]# pip3 install virtualenv
Requirement already satisfied: virtualenv in /usr/local/lib/python3.6/site-packages (16.7.9)
[root@sk-av newproject]# virtualenv newenv
Using base prefix '/usr'
No LICENSE.txt / LICENSE found in source
New python executable in /root/newproject/newenv/bin/python3.6
Also creating executable in /root/newproject/newenv/bin/python
Installing setuptools, pip, wheel...
done.
[root@sk-av newproject]# source newenv/bin/activate
(newenv) [root@sk-av newproject]# pip install django
Collecting django
Downloading Django-3.0.8-py3-none-any.whl (7.5 MB)
|--------------------------------| 7.5 MB 10.1 MB/s
Collecting sqlparse>=0.2.2
Using cached sqlparse-0.3.1-py2.py3-none-any.whl (40 kB)
Collecting asgiref=3.2
Using cached asgiref-3.2.10-py3-none-any.whl (19 kB)
Collecting pytz
Using cached pytz-2020.1-py2.py3-none-any.whl (510 kB)
Installing collected packages: sqlparse, asgiref, pytz, django
Successfully installed asgiref-3.2.10 django-3.0.8 pytz-2020.1 sqlparse-0.3.1
(newenv) [root@sk-av newproject]# django-admin --version
3.0.8
(newenv) [root@sk-av newproject]# deactivate
[root@sk-av newproject]# source newenv/bin/activate
(newenv) [root@sk-av newproject]# yum install git python-pip
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
Package git-1.8.3.1-23.el7_8.x86_64 already installed and latest version
Package python2-pip-8.1.2-12.el7.noarch already installed and latest version
Nothing to do
(newenv) [root@sk-av newproject]# git clone git://github.com/django/django ~/django-dev
Cloning into '/root/django-dev'...
remote: Enumerating objects: 7, done.
remote: Counting objects: 100% (7/7), done.
remote: Compressing objects: 100% (7/7), done.
remote: Total 460815 (delta 0), reused 1 (delta 0), pack-reused 460808
Receiving objects: 100% (460815/460815), 193.09 MiB | 11.06 MiB/s, done.
Resolving deltas: 100% (337430/337430), done.
(newenv) [root@sk-av newproject]# pip install -e ~/django-dev
Obtaining file:///root/django-dev
Requirement already satisfied: asgiref>=3.2.10 in ./newenv/lib/python3.6/site-packages (from Django==3.2) (3.2.10)
Requirement already satisfied: pytz in ./newenv/lib/python3.6/site-packages (from Django==3.2) (2020.1)
Requirement already satisfied: sqlparse>=0.2.2 in ./newenv/lib/python3.6/site-packages (from Django==3.2) (0.3.1)
Installing collected packages: Django
Attempting uninstall: Django
Found existing installation: Django 3.0.8
Uninstalling Django-3.0.8:
Successfully uninstalled Django-3.0.8
Running setup.py develop for Django
Successfully installed Django
(newenv) [root@sk-av newproject]# django-admin --version
3.2
(newenv) [root@sk-av newproject]# django-admin startproject projectname
(newenv) [root@sk-av newproject]# cd projectname
(newenv) [root@sk-av projectname]# python manage.py migrate
Traceback (most recent call last):
File "manage.py", line 22, in
main()
File "manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "/root/django-dev/django/core/management/init.py", line 401, in execute_from_command_line
utility.execute()
File "/root/django-dev/django/core/management/init.py", line 377, in execute
django.setup()
File "/root/django-dev/django/init.py", line 24, in setup
apps.populate(settings.INSTALLED_APPS)
File "/root/django-dev/django/apps/registry.py", line 114, in populate
app_config.import_models()
File "/root/django-dev/django/apps/config.py", line 283, in import_models
self.models_module = import_module(models_module_name)
File "/root/newproject/newenv/lib64/python3.6/importlib/init.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "", line 994, in _gcd_import
File "", line 971, in _find_and_load
File "", line 955, in _find_and_load_unlocked
File "", line 665, in _load_unlocked
File "", line 678, in exec_module
File "", line 219, in _call_with_frames_removed
File "/root/django-dev/django/contrib/auth/models.py", line 3, in
from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
File "/root/django-dev/django/contrib/auth/base_user.py", line 47, in
class AbstractBaseUser(models.Model):
File "/root/django-dev/django/db/models/base.py", line 122, in new
new_class.add_to_class('_meta', Options(meta, app_label))
File "/root/django-dev/django/db/models/base.py", line 326, in add_to_class
value.contribute_to_class(cls, name)
File "/root/django-dev/django/db/models/options.py", line 206, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "/root/django-dev/django/db/init.py", line 28, in getattr
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/root/django-dev/django/db/utils.py", line 214, in getitem
backend = load_backend(db['ENGINE'])
File "/root/django-dev/django/db/utils.py", line 111, in load_backend
return import_module('%s.base' % backend_name)
File "/root/newproject/newenv/lib64/python3.6/importlib/init.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "/root/django-dev/django/db/backends/sqlite3/base.py", line 70, in
check_sqlite_version()
File "/root/django-dev/django/db/backends/sqlite3/base.py", line 67, in check_sqlite_version
raise ImproperlyConfigured('SQLite 3.8.3 or later is required (found %s).' % Database.sqlite_version)
django.core.exceptions.ImproperlyConfigured: SQLite 3.8.3 or later is required (found 3.7.17).
(newenv) [root@sk-av projectname]# yum install swqlite
^CTraceback (most recent call last):
File "/usr/lib64/python2.7/site.py", line 556, in
main()
File "/usr/lib64/python2.7/site.py", line 539, in main
known_paths = addsitepackages(known_paths)
File "/usr/lib64/python2.7/site.py", line 317, in addsitepackages
addsitedir(sitedir, known_paths)
File "/usr/lib64/python2.7/site.py", line 190, in addsitedir
addpackage(sitedir, name, known_paths)
File "/usr/lib64/python2.7/site.py", line 152, in addpackage
exec line
File "", line 1, in
^C
(newenv) [root@sk-av projectname]# yum install sqlite
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
Package sqlite-3.7.17-8.el7_7.1.x86_64 already installed and latest version
Nothing to do
(newenv) [root@sk-av projectname]# python3 manage.py migrate
Traceback (most recent call last):
File "manage.py", line 22, in
main()
File "manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "/root/django-dev/django/core/management/init.py", line 401, in execute_from_command_line
utility.execute()
File "/root/django-dev/django/core/management/init.py", line 377, in execute
django.setup()
File "/root/django-dev/django/init.py", line 24, in setup
apps.populate(settings.INSTALLED_APPS)
File "/root/django-dev/django/apps/registry.py", line 114, in populate
app_config.import_models()
File "/root/django-dev/django/apps/config.py", line 283, in import_models
self.models_module = import_module(models_module_name)
File "/root/newproject/newenv/lib64/python3.6/importlib/init.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "", line 994, in _gcd_import
File "", line 971, in _find_and_load
File "", line 955, in _find_and_load_unlocked
File "", line 665, in _load_unlocked
File "", line 678, in exec_module
File "", line 219, in _call_with_frames_removed
File "/root/django-dev/django/contrib/auth/models.py", line 3, in
from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
File "/root/django-dev/django/contrib/auth/base_user.py", line 47, in
class AbstractBaseUser(models.Model):
File "/root/django-dev/django/db/models/base.py", line 122, in new
new_class.add_to_class('_meta', Options(meta, app_label))
File "/root/django-dev/django/db/models/base.py", line 326, in add_to_class
value.contribute_to_class(cls, name)
File "/root/django-dev/django/db/models/options.py", line 206, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "/root/django-dev/django/db/init.py", line 28, in getattr
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/root/django-dev/django/db/utils.py", line 214, in getitem
backend = load_backend(db['ENGINE'])
File "/root/django-dev/django/db/utils.py", line 111, in load_backend
return import_module('%s.base' % backend_name)
File "/root/newproject/newenv/lib64/python3.6/importlib/init.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "/root/django-dev/django/db/backends/sqlite3/base.py", line 70, in
check_sqlite_version()
File "/root/django-dev/django/db/backends/sqlite3/base.py", line 67, in check_sqlite_version
raise ImproperlyConfigured('SQLite 3.8.3 or later is required (found %s).' % Database.sqlite_version)
django.core.exceptions.ImproperlyConfigured: SQLite 3.8.3 or later is required (found 3.7.17).
(newenv) [root@sk-av projectname]# mc

(newenv) [root@sk-av projectname]# whereis sqlite3
sqlite3: /usr/bin/sqlite3 /usr/share/man/man1/sqlite3.1.gz
(newenv) [root@sk-av projectname]# sqlite3 --version
3.7.17 2013-05-20 00:56:22 118a3b35693b134d56ebd780123b7fd6f1497668
(newenv) [root@sk-av projectname]# sudo mv -v /usr/bin/sqlite3 /usr/bin/sqlite3.7
‘/usr/bin/sqlite3’ -> ‘/usr/bin/sqlite3.7’
(newenv) [root@sk-av projectname]# cd /usr/bin/s
Display all 196 possibilities? (y or n)
(newenv) [root@sk-av projectname]# mc

(newenv) [root@sk-av sqlite-tools-linux-x86-3320300]#
(newenv) [root@sk-av sqlite-tools-linux-x86-3320300]# cd /
bin/ lib64/ run/
boot/ lost+found/ sbin/
dev/ media/ srv/
etc/ mnt/ sys/
gophish-v0.9.0-linux-64bit.zip opt/ tmp/
home/ proc/ usr/
lib/ root/ var/
(newenv) [root@sk-av sqlite-tools-linux-x86-3320300]# cd /root/newproject/
(newenv) [root@sk-av newproject]# mc

(newenv) [root@sk-av projectname]# sqlite3 --version
bash: /usr/bin/sqlite3: /lib/ld-linux.so.2: bad ELF interpreter: No such file or directory
(newenv) [root@sk-av projectname]#
(newenv) [root@sk-av projectname]# python manage.py migrate
Traceback (most recent call last):
File "manage.py", line 22, in
main()
File "manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "/root/django-dev/django/core/management/init.py", line 401, in execute_from_command_line
utility.execute()
File "/root/django-dev/django/core/management/init.py", line 377, in execute
django.setup()
File "/root/django-dev/django/init.py", line 24, in setup
apps.populate(settings.INSTALLED_APPS)
File "/root/django-dev/django/apps/registry.py", line 114, in populate
app_config.import_models()
File "/root/django-dev/django/apps/config.py", line 283, in import_models
self.models_module = import_module(models_module_name)
File "/root/newproject/newenv/lib64/python3.6/importlib/init.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "", line 994, in _gcd_import
File "", line 971, in _find_and_load
File "", line 955, in _find_and_load_unlocked
File "", line 665, in _load_unlocked
File "", line 678, in exec_module
File "", line 219, in _call_with_frames_removed
File "/root/django-dev/django/contrib/auth/models.py", line 3, in
from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
File "/root/django-dev/django/contrib/auth/base_user.py", line 47, in
class AbstractBaseUser(models.Model):
File "/root/django-dev/django/db/models/base.py", line 122, in new
new_class.add_to_class('_meta', Options(meta, app_label))
File "/root/django-dev/django/db/models/base.py", line 326, in add_to_class
value.contribute_to_class(cls, name)
File "/root/django-dev/django/db/models/options.py", line 206, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "/root/django-dev/django/db/init.py", line 28, in getattr
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/root/django-dev/django/db/utils.py", line 214, in getitem
backend = load_backend(db['ENGINE'])
File "/root/django-dev/django/db/utils.py", line 111, in load_backend
return import_module('%s.base' % backend_name)
File "/root/newproject/newenv/lib64/python3.6/importlib/init.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "/root/django-dev/django/db/backends/sqlite3/base.py", line 70, in
check_sqlite_version()
File "/root/django-dev/django/db/backends/sqlite3/base.py", line 67, in check_sqlite_version
raise ImproperlyConfigured('SQLite 3.8.3 or later is required (found %s).' % Database.sqlite_version)
django.core.exceptions.ImproperlyConfigured: SQLite 3.8.3 or later is required (found 3.7.17).
(newenv) [root@sk-av projectname]# python3 manage.py migrate
Traceback (most recent call last):
File "manage.py", line 22, in
main()
File "manage.py", line 18, in main
execute_from_command_line(sys.argv)
File "/root/django-dev/django/core/management/init.py", line 401, in execute_from_command_line
utility.execute()
File "/root/django-dev/django/core/management/init.py", line 377, in execute
django.setup()
File "/root/django-dev/django/init.py", line 24, in setup
apps.populate(settings.INSTALLED_APPS)
File "/root/django-dev/django/apps/registry.py", line 114, in populate
app_config.import_models()
File "/root/django-dev/django/apps/config.py", line 283, in import_models
self.models_module = import_module(models_module_name)
File "/root/newproject/newenv/lib64/python3.6/importlib/init.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "", line 994, in _gcd_import
File "", line 971, in _find_and_load
File "", line 955, in _find_and_load_unlocked
File "", line 665, in _load_unlocked
File "", line 678, in exec_module
File "", line 219, in _call_with_frames_removed
File "/root/django-dev/django/contrib/auth/models.py", line 3, in
from django.contrib.auth.base_user import AbstractBaseUser, BaseUserManager
File "/root/django-dev/django/contrib/auth/base_user.py", line 47, in
class AbstractBaseUser(models.Model):
File "/root/django-dev/django/db/models/base.py", line 122, in new
new_class.add_to_class('_meta', Options(meta, app_label))
File "/root/django-dev/django/db/models/base.py", line 326, in add_to_class
value.contribute_to_class(cls, name)
File "/root/django-dev/django/db/models/options.py", line 206, in contribute_to_class
self.db_table = truncate_name(self.db_table, connection.ops.max_name_length())
File "/root/django-dev/django/db/init.py", line 28, in getattr
return getattr(connections[DEFAULT_DB_ALIAS], item)
File "/root/django-dev/django/db/utils.py", line 214, in getitem
backend = load_backend(db['ENGINE'])
File "/root/django-dev/django/db/utils.py", line 111, in load_backend
return import_module('%s.base' % backend_name)
File "/root/newproject/newenv/lib64/python3.6/importlib/init.py", line 126, in import_module
return _bootstrap._gcd_import(name[level:], package, level)
File "/root/django-dev/django/db/backends/sqlite3/base.py", line 70, in
check_sqlite_version()
File "/root/django-dev/django/db/backends/sqlite3/base.py", line 67, in check_sqlite_version
raise ImproperlyConfigured('SQLite 3.8.3 or later is required (found %s).' % Database.sqlite_version)
django.core.exceptions.ImproperlyConfigured: SQLite 3.8.3 or later is required (found 3.7.17).
(newenv) [root@sk-av projectname]# yum update sqlite
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
No packages marked for update
(newenv) [root@sk-av projectname]# yum -y install openssl-devel sqlite-devel libffi-devel bzip2-devel libzip-devel xz-devel lzma-sdk-devel uuid-devel readline-devel ncurses-devel
Loaded plugins: elrepo, product-id, search-disabled-repos, subscription-manager

This system is not registered with an entitlement server. You can use subscription-manager to register.

[elrepo]: 39 kmod packages excluded due to dependency errors
Package 1:openssl-devel-1.0.2k-19.el7.x86_64 already installed and latest version
Package libffi-devel-3.0.13-19.el7.x86_64 already installed and latest version
Package xz-devel-5.2.2-1.el7.x86_64 already installed and latest version
Resolving Dependencies
--> Running transaction check
---> Package bzip2-devel.x86_64 0:1.0.6-13.el7 will be installed
---> Package libzip-devel.x86_64 0:0.10.1-8.el7 will be installed
---> Package lzma-sdk-devel.x86_64 0:4.6.5-21.el7 will be installed
--> Processing Dependency: lzma-sdk(x86-64) = 4.6.5-21.el7 for package: lzma-sdk-devel-4.6.5-21.el7.x86_64
--> Processing Dependency: liblzmasdk.so.4()(64bit) for package: lzma-sdk-devel-4.6.5-21.el7.x86_64
---> Package ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 will be installed
---> Package readline-devel.x86_64 0:6.2-11.el7 will be installed
---> Package sqlite-devel.x86_64 0:3.7.17-8.el7_7.1 will be installed
---> Package uuid-devel.x86_64 0:1.6.2-26.el7 will be installed
--> Processing Dependency: uuid = 1.6.2-26.el7 for package: uuid-devel-1.6.2-26.el7.x86_64
--> Processing Dependency: libossp-uuid.so.16()(64bit) for package: uuid-devel-1.6.2-26.el7.x86_64
--> Running transaction check
---> Package lzma-sdk.x86_64 0:4.6.5-21.el7 will be installed
---> Package uuid.x86_64 0:1.6.2-26.el7 will be installed
--> Finished Dependency Resolution

Dependencies Resolved

=========================================================================================================================
Package Arch Version Repository Size

Installing:
bzip2-devel x86_64 1.0.6-13.el7 base 218 k
libzip-devel x86_64 0.10.1-8.el7 base 77 k
lzma-sdk-devel x86_64 4.6.5-21.el7 epel 95 k
ncurses-devel x86_64 5.9-14.20130511.el7_4 base 712 k
readline-devel x86_64 6.2-11.el7 base 139 k
sqlite-devel x86_64 3.7.17-8.el7_7.1 base 104 k
uuid-devel x86_64 1.6.2-26.el7 base 24 k
Installing for dependencies:
lzma-sdk x86_64 4.6.5-21.el7 epel 74 k
uuid x86_64 1.6.2-26.el7 base 55 k

Transaction Summary

Install 7 Packages (+2 Dependent packages)

Total download size: 1.5 M
Installed size: 3.8 M
Downloading packages:
(1/9): bzip2-devel-1.0.6-13.el7.x86_64.rpm | 218 kB 00:00:00
(2/9): libzip-devel-0.10.1-8.el7.x86_64.rpm | 77 kB 00:00:00
(3/9): lzma-sdk-4.6.5-21.el7.x86_64.rpm | 74 kB 00:00:00
(4/9): readline-devel-6.2-11.el7.x86_64.rpm | 139 kB 00:00:00
(5/9): uuid-1.6.2-26.el7.x86_64.rpm | 55 kB 00:00:00
(6/9): uuid-devel-1.6.2-26.el7.x86_64.rpm | 24 kB 00:00:00
(7/9): sqlite-devel-3.7.17-8.el7_7.1.x86_64.rpm | 104 kB 00:00:00
(8/9): ncurses-devel-5.9-14.20130511.el7_4.x86_64.rpm | 712 kB 00:00:00
(9/9): lzma-sdk-devel-4.6.5-21.el7.x86_64.rpm | 95 kB 00:00:01

Total 841 kB/s | 1.5 MB 00:00:01
Running transaction check
Running transaction test
Transaction test succeeded
Running transaction
Installing : lzma-sdk-4.6.5-21.el7.x86_64 1/9
Installing : uuid-1.6.2-26.el7.x86_64 2/9
Installing : ncurses-devel-5.9-14.20130511.el7_4.x86_64 3/9
Installing : readline-devel-6.2-11.el7.x86_64 4/9
Installing : uuid-devel-1.6.2-26.el7.x86_64 5/9
Installing : lzma-sdk-devel-4.6.5-21.el7.x86_64 6/9
Installing : sqlite-devel-3.7.17-8.el7_7.1.x86_64 7/9
Installing : libzip-devel-0.10.1-8.el7.x86_64 8/9
Installing : bzip2-devel-1.0.6-13.el7.x86_64 9/9
Verifying : bzip2-devel-1.0.6-13.el7.x86_64 1/9
Verifying : libzip-devel-0.10.1-8.el7.x86_64 2/9
Verifying : sqlite-devel-3.7.17-8.el7_7.1.x86_64 3/9
Verifying : ncurses-devel-5.9-14.20130511.el7_4.x86_64 4/9
Verifying : uuid-1.6.2-26.el7.x86_64 5/9
Verifying : lzma-sdk-4.6.5-21.el7.x86_64 6/9
Verifying : uuid-devel-1.6.2-26.el7.x86_64 7/9
Verifying : lzma-sdk-devel-4.6.5-21.el7.x86_64 8/9
Verifying : readline-devel-6.2-11.el7.x86_64 9/9

Installed:
bzip2-devel.x86_64 0:1.0.6-13.el7 libzip-devel.x86_64 0:0.10.1-8.el7 lzma-sdk-devel.x86_64 0:4.6.5-21.el7
ncurses-devel.x86_64 0:5.9-14.20130511.el7_4 readline-devel.x86_64 0:6.2-11.el7 sqlite-devel.x86_64 0:3.7.17-8.el7_7.1
uuid-devel.x86_64 0:1.6.2-26.el7

Dependency Installed:
lzma-sdk.x86_64 0:4.6.5-21.el7 uuid.x86_64 0:1.6.2-26.el7

Complete!
(newenv) [root@sk-av projectname]# deactivate
bash: deactivate: command not found
(newenv) [root@sk-av projectname]# disable
bash: disable: command not found
(newenv) [root@sk-av projectname]# ^C
(newenv) [root@sk-av projectname]# exit
exit

(newenv) [root@sk-av newproject]# ^C
(newenv) [root@sk-av newproject]# deactivate
[root@sk-av newproject]# wget https://www.sqlite.org/2019/sqlite-autoconf-3290000.tar.gz
--2020-07-31 21:10:39-- https://www.sqlite.org/2019/sqlite-autoconf-3290000.tar.gz
Resolving www.sqlite.org (www.sqlite.org)... 45.33.6.223, 2600:3c00::f03c:91ff:fe96:b959
Connecting to www.sqlite.org (www.sqlite.org)|45.33.6.223|:443... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2833613 (2.7M) [application/x-gzip]
Saving to: ‘sqlite-autoconf-3290000.tar.gz’

100%[===============================================================================>] 2,833,613 1.80MB/s in 1.5s

2020-07-31 21:10:42 (1.80 MB/s) - ‘sqlite-autoconf-3290000.tar.gz’ saved [2833613/2833613]

[root@sk-av newproject]# tar zxvf sqlite-autoconf-3290000.tar.gz
sqlite-autoconf-3290000/
sqlite-autoconf-3290000/sqlite3.rc
sqlite-autoconf-3290000/README.txt
sqlite-autoconf-3290000/aclocal.m4
sqlite-autoconf-3290000/sqlite3.c
sqlite-autoconf-3290000/Makefile.am
sqlite-autoconf-3290000/configure
sqlite-autoconf-3290000/configure.ac
sqlite-autoconf-3290000/config.guess
sqlite-autoconf-3290000/Makefile.in
sqlite-autoconf-3290000/config.sub
sqlite-autoconf-3290000/install-sh
sqlite-autoconf-3290000/sqlite3.1
sqlite-autoconf-3290000/shell.c
sqlite-autoconf-3290000/sqlite3.pc.in
sqlite-autoconf-3290000/Replace.cs
sqlite-autoconf-3290000/depcomp
sqlite-autoconf-3290000/missing
sqlite-autoconf-3290000/ltmain.sh
sqlite-autoconf-3290000/sqlite3ext.h
sqlite-autoconf-3290000/Makefile.msc
sqlite-autoconf-3290000/sqlite3.h
sqlite-autoconf-3290000/Makefile.fallback
sqlite-autoconf-3290000/tea/
sqlite-autoconf-3290000/tea/aclocal.m4
sqlite-autoconf-3290000/tea/configure
sqlite-autoconf-3290000/tea/configure.ac
sqlite-autoconf-3290000/tea/Makefile.in
sqlite-autoconf-3290000/tea/README
sqlite-autoconf-3290000/tea/generic/
sqlite-autoconf-3290000/tea/generic/tclsqlite3.c
sqlite-autoconf-3290000/tea/tclconfig/
sqlite-autoconf-3290000/tea/tclconfig/tcl.m4
sqlite-autoconf-3290000/tea/tclconfig/install-sh
sqlite-autoconf-3290000/tea/doc/
sqlite-autoconf-3290000/tea/doc/sqlite3.n
sqlite-autoconf-3290000/tea/pkgIndex.tcl.in
sqlite-autoconf-3290000/tea/win/
sqlite-autoconf-3290000/tea/win/rules.vc
sqlite-autoconf-3290000/tea/win/nmakehlp.c
sqlite-autoconf-3290000/tea/win/makefile.vc
sqlite-autoconf-3290000/tea/license.terms
sqlite-autoconf-3290000/INSTALL
sqlite-autoconf-3290000/compile
[root@sk-av newproject]# cd sqlite-autoconf-3290000
[root@sk-av sqlite-autoconf-3290000]# cd ../
[root@sk-av newproject]# mc

[root@sk-av ~]# cd sqlite-autoconf-3290000
[root@sk-av sqlite-autoconf-3290000]# ./configure --prefix=$HOME/opt/sqlite
checking for a BSD-compatible install... /usr/bin/install -c
checking whether build environment is sane... yes
checking for a thread-safe mkdir -p... /usr/bin/mkdir -p
checking for gawk... gawk
checking whether make sets $(MAKE)... yes
checking whether make supports nested variables... yes
checking for style of include used by make... GNU
checking for gcc... gcc
checking whether the C compiler works... yes
checking for C compiler default output file name... a.out
checking for suffix of executables...
checking whether we are cross compiling... no
checking for suffix of object files... o
checking whether we are using the GNU C compiler... yes
checking whether gcc accepts -g... yes
checking for gcc option to accept ISO C89... none needed
checking whether gcc understands -c and -o together... yes
checking dependency style of gcc... gcc3
checking for special C compiler options needed for large files... no
checking for _FILE_OFFSET_BITS value needed for large files... no
checking for gcc... (cached) gcc
checking whether we are using the GNU C compiler... (cached) yes
checking whether gcc accepts -g... (cached) yes
checking for gcc option to accept ISO C89... (cached) none needed
checking whether gcc understands -c and -o together... (cached) yes
checking dependency style of gcc... (cached) gcc3
checking build system type... x86_64-pc-linux-gnu
checking host system type... x86_64-pc-linux-gnu
checking how to print strings... printf
checking for a sed that does not truncate output... /usr/bin/sed
checking for grep that handles long lines and -e... /usr/bin/grep
checking for egrep... /usr/bin/grep -E
checking for fgrep... /usr/bin/grep -F
checking for ld used by gcc... /usr/bin/ld
checking if the linker (/usr/bin/ld) is GNU ld... yes
checking for BSD- or MS-compatible name lister (nm)... /usr/bin/nm -B
checking the name lister (/usr/bin/nm -B) interface... BSD nm
checking whether ln -s works... yes
checking the maximum length of command line arguments... 1572864
checking how to convert x86_64-pc-linux-gnu file names to x86_64-pc-linux-gnu format... func_convert_file_noop
checking how to convert x86_64-pc-linux-gnu file names to toolchain format... func_convert_file_noop
checking for /usr/bin/ld option to reload object files... -r
checking for objdump... objdump
checking how to recognize dependent libraries... pass_all
checking for dlltool... no
checking how to associate runtime and link libraries... printf %s\n
checking for ar... ar
checking for archiver @file support... @
checking for strip... strip
checking for ranlib... ranlib
checking command to parse /usr/bin/nm -B output from gcc object... ok
checking for sysroot... no
checking for a working dd... /usr/bin/dd
checking how to truncate binary pipes... /usr/bin/dd bs=4096 count=1
checking for mt... no
checking if : is a manifest tool... no
checking how to run the C preprocessor... gcc -E
checking for ANSI C header files... ./configure --prefix=$HOME/opt/sqliteyes
checking for sys/types.h... yes
checking for sys/stat.h... yes
checking for stdlib.h... yes
checking for string.h... yes
checking for memory.h... yes
checking for strings.h... yes
checking for inttypes.h... yes
checking for stdint.h... yes
checking for unistd.h... yes
checking for dlfcn.h... yes
checking for objdir... .libs
checking if gcc supports -fno-rtti -fno-exceptions... no
checking for gcc option to produce PIC... -fPIC -DPIC
checking if gcc PIC flag -fPIC -DPIC works... yes
checking if gcc static flag -static works... no
checking if gcc supports -c -o file.o... yes
checking if gcc supports -c -o file.o... (cached) yes
checking whether the gcc linker (/usr/bin/ld -m elf_x86_64) supports shared libraries... yes
checking whether -lc should be explicitly linked in... no
checking dynamic linker characteristics... GNU/Linux ld.so
checking how to hardcode library paths into programs... immediate
checking whether stripping libraries is possible... yes
checking if libtool supports shared libraries... yes
checking whether to build shared libraries... yes
checking whether to build static libraries... yes
checking for fdatasync... yes
checking for usleep... yes
checking for fullfsync... no
checking for localtime_r... yes
checking for gmtime_r... yes
checking whether strerror_r is declared... yes
checking for strerror_r... yes
checking whether strerror_r returns char *... no
checking editline/readline.h usability... no
checking editline/readline.h presence... no
checking for editline/readline.h... no
checking readline/readline.h usability... yes
checking readline/readline.h presence... yes
checking for readline/readline.h... yes
checking for library containing tgetent... -ltermcap
checking for library containing readline... -lreadline
checking for library containing pthread_create... -lpthread
checking for library containing pthread_mutexattr_init... none required
checking for library containing dlopen... -ldl
checking for whether to support dynamic extensions... yes
checking for library containing log... -lm
checking for posix_fallocate... yes
checking zlib.h usability... yes
checking zlib.h presence... yes
checking for zlib.h... yes
checking for library containing deflate... -lz
checking for library containing system... none required
checking that generated files are newer than configure... done
configure: creating ./config.status
config.status: creating Makefile
config.status: creating sqlite3.pc
config.status: executing depfiles commands
config.status: executing libtool commands
[root@sk-av sqlite-autoconf-3290000]# make && make install
/bin/sh ./libtool --tag=CC --mode=compile gcc -DPACKAGE_NAME="sqlite" -DPACKAGE_TARNAME="sqlite" -DPACKAGE_VERSION="3.29.0" -DPACKAGE_STRING="sqlite\ 3.29.0" -DPACKAGE_BUGREPORT="http://www.sqlite.org\" -DPACKAGE_URL="" -DPACKAGE="sqlite" -DVERSION="3.29.0" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=".libs/" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_READLINE_READLINE_H=1 -DHAVE_READLINE=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_HAVE_ZLIB -g -O2 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c -o sqlite3.lo sqlite3.c
libtool: compile: gcc -DPACKAGE_NAME="sqlite" -DPACKAGE_TARNAME="sqlite" -DPACKAGE_VERSION="3.29.0" "-DPACKAGE_STRING="sqlite 3.29.0"" -DPACKAGE_BUGREPORT="http://www.sqlite.org\" -DPACKAGE_URL="" -DPACKAGE="sqlite" -DVERSION="3.29.0" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=".libs/" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_READLINE_READLINE_H=1 -DHAVE_READLINE=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_HAVE_ZLIB -g -O2 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c sqlite3.c -fPIC -DPIC -o .libs/sqlite3.o
libtool: compile: gcc -DPACKAGE_NAME="sqlite" -DPACKAGE_TARNAME="sqlite" -DPACKAGE_VERSION="3.29.0" "-DPACKAGE_STRING="sqlite 3.29.0"" -DPACKAGE_BUGREPORT="http://www.sqlite.org\" -DPACKAGE_URL="" -DPACKAGE="sqlite" -DVERSION="3.29.0" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=".libs/" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_READLINE_READLINE_H=1 -DHAVE_READLINE=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_HAVE_ZLIB -g -O2 -MT sqlite3.lo -MD -MP -MF .deps/sqlite3.Tpo -c sqlite3.c -o sqlite3.o >/dev/null 2>&1
mv -f .deps/sqlite3.Tpo .deps/sqlite3.Plo
/bin/sh ./libtool --tag=CC --mode=link gcc -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_HAVE_ZLIB -g -O2 -no-undefined -version-info 8:6:8 -o libsqlite3.la -rpath /root/opt/sqlite/lib sqlite3.lo -lz -lm -ldl -lpthread
libtool: link: gcc -shared -fPIC -DPIC .libs/sqlite3.o -lz -lm -ldl -lpthread -g -O2 -Wl,-soname -Wl,libsqlite3.so.0 -o .libs/libsqlite3.so.0.8.6
libtool: link: (cd ".libs" && rm -f "libsqlite3.so.0" && ln -s "libsqlite3.so.0.8.6" "libsqlite3.so.0")
libtool: link: (cd ".libs" && rm -f "libsqlite3.so" && ln -s "libsqlite3.so.0.8.6" "libsqlite3.so")
libtool: link: ar cru .libs/libsqlite3.a sqlite3.o
libtool: link: ranlib .libs/libsqlite3.a
libtool: link: ( cd ".libs" && rm -f "libsqlite3.la" && ln -s "../libsqlite3.la" "libsqlite3.la" )
gcc -DPACKAGE_NAME="sqlite" -DPACKAGE_TARNAME="sqlite" -DPACKAGE_VERSION="3.29.0" -DPACKAGE_STRING="sqlite\ 3.29.0" -DPACKAGE_BUGREPORT="http://www.sqlite.org\" -DPACKAGE_URL="" -DPACKAGE="sqlite" -DVERSION="3.29.0" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=".libs/" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_READLINE_READLINE_H=1 -DHAVE_READLINE=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -g -O2 -MT sqlite3-shell.o -MD -MP -MF .deps/sqlite3-shell.Tpo -c -o sqlite3-shell.o test -f 'shell.c' || echo './'shell.c
mv -f .deps/sqlite3-shell.Tpo .deps/sqlite3-shell.Po
gcc -DPACKAGE_NAME="sqlite" -DPACKAGE_TARNAME="sqlite" -DPACKAGE_VERSION="3.29.0" -DPACKAGE_STRING="sqlite\ 3.29.0" -DPACKAGE_BUGREPORT="http://www.sqlite.org\" -DPACKAGE_URL="" -DPACKAGE="sqlite" -DVERSION="3.29.0" -DSTDC_HEADERS=1 -DHAVE_SYS_TYPES_H=1 -DHAVE_SYS_STAT_H=1 -DHAVE_STDLIB_H=1 -DHAVE_STRING_H=1 -DHAVE_MEMORY_H=1 -DHAVE_STRINGS_H=1 -DHAVE_INTTYPES_H=1 -DHAVE_STDINT_H=1 -DHAVE_UNISTD_H=1 -DHAVE_DLFCN_H=1 -DLT_OBJDIR=".libs/" -DHAVE_FDATASYNC=1 -DHAVE_USLEEP=1 -DHAVE_LOCALTIME_R=1 -DHAVE_GMTIME_R=1 -DHAVE_DECL_STRERROR_R=1 -DHAVE_STRERROR_R=1 -DHAVE_READLINE_READLINE_H=1 -DHAVE_READLINE=1 -DHAVE_POSIX_FALLOCATE=1 -DHAVE_ZLIB_H=1 -I. -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -g -O2 -MT sqlite3-sqlite3.o -MD -MP -MF .deps/sqlite3-sqlite3.Tpo -c -o sqlite3-sqlite3.o test -f 'sqlite3.c' || echo './'sqlite3.c
mv -f .deps/sqlite3-sqlite3.Tpo .deps/sqlite3-sqlite3.Po
/bin/sh ./libtool --tag=CC --mode=link gcc -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -g -O2 -o sqlite3 sqlite3-shell.o sqlite3-sqlite3.o -lreadline -ltermcap -lz -lm -ldl -lpthread
libtool: link: gcc -D_REENTRANT=1 -DSQLITE_THREADSAFE=1 -DSQLITE_ENABLE_FTS4 -DSQLITE_ENABLE_FTS5 -DSQLITE_ENABLE_JSON1 -DSQLITE_ENABLE_RTREE -DSQLITE_HAVE_ZLIB -DSQLITE_ENABLE_EXPLAIN_COMMENTS -DSQLITE_ENABLE_DBPAGE_VTAB -DSQLITE_ENABLE_STMTVTAB -DSQLITE_ENABLE_DBSTAT_VTAB -g -O2 -o sqlite3 sqlite3-shell.o sqlite3-sqlite3.o -lreadline -ltermcap -lz -lm -ldl -lpthread
make[1]: Entering directory `/root/sqlite-autoconf-3290000'
/usr/bin/mkdir -p '/root/opt/sqlite/lib'
/bin/sh ./libtool --mode=install /usr/bin/install -c libsqlite3.la '/root/opt/sqlite/lib'
libtool: install: /usr/bin/install -c .libs/libsqlite3.so.0.8.6 /root/opt/sqlite/lib/libsqlite3.so.0.8.6
libtool: install: (cd /root/opt/sqlite/lib && { ln -s -f libsqlite3.so.0.8.6 libsqlite3.so.0 || { rm -f libsqlite3.so.0 && ln -s libsqlite3.so.0.8.6 libsqlite3.so.0; }; })
libtool: install: (cd /root/opt/sqlite/lib && { ln -s -f libsqlite3.so.0.8.6 libsqlite3.so || { rm -f libsqlite3.so && ln -s libsqlite3.so.0.8.6 libsqlite3.so; }; })
libtool: install: /usr/bin/install -c .libs/libsqlite3.lai /root/opt/sqlite/lib/libsqlite3.la
libtool: install: /usr/bin/install -c .libs/libsqlite3.a /root/opt/sqlite/lib/libsqlite3.a
libtool: install: chmod 644 /root/opt/sqlite/lib/libsqlite3.a
libtool: install: ranlib /root/opt/sqlite/lib/libsqlite3.a
libtool: finish: PATH="/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/root/bin:/sbin" ldconfig -n /root/opt/sqlite/lib

Libraries have been installed in:
/root/opt/sqlite/lib

If you ever happen to want to link against installed libraries
in a given directory, LIBDIR, you must either use libtool, and
specify the full pathname of the library, or use the '-LLIBDIR'
flag during linking and do at least one of the following:

  • add LIBDIR to the 'LD_LIBRARY_PATH' environment variable
    during execution
  • add LIBDIR to the 'LD_RUN_PATH' environment variable
    during linking
  • use the '-Wl,-rpath -Wl,LIBDIR' linker flag
  • have your system administrator add LIBDIR to '/etc/ld.so.conf'

See any operating system documentation about shared libraries for
more information, such as the ld(1) and ld.so(8) manual pages.

/usr/bin/mkdir -p '/root/opt/sqlite/bin'
/bin/sh ./libtool --mode=install /usr/bin/install -c sqlite3 '/root/opt/sqlite/bin'
libtool: install: /usr/bin/install -c sqlite3 /root/opt/sqlite/bin/sqlite3
/usr/bin/mkdir -p '/root/opt/sqlite/include'
/usr/bin/install -c -m 644 sqlite3.h sqlite3ext.h '/root/opt/sqlite/include'
/usr/bin/mkdir -p '/root/opt/sqlite/share/man/man1'
/usr/bin/install -c -m 644 sqlite3.1 '/root/opt/sqlite/share/man/man1'
/usr/bin/mkdir -p '/root/opt/sqlite/lib/pkgconfig'
/usr/bin/install -c -m 644 sqlite3.pc '/root/opt/sqlite/lib/pkgconfig'
make[1]: Leaving directory `/root/sqlite-autoconf-3290000'
[root@sk-av sqlite-autoconf-3290000]# export PATH=$HOME/opt/sqlite/bin:$PATH
[root@sk-av sqlite-autoconf-3290000]# export LD_LIBRARY_PATH=$HOME/opt/sqlite/lib
[root@sk-av sqlite-autoconf-3290000]# export LD_RUN_PATH=$HOME/opt/sqlite/lib
[root@sk-av sqlite-autoconf-3290000]# sqlite3 --version
3.29.0 2019-07-10 17:32:03 fc82b73eaac8b36950e527f12c4b5dc1e147e6f4ad2217ae43ad82882a88bfa6
[root@sk-av sqlite-autoconf-3290000]# curl https://bootstrap.pypa.io/get-pip.py | python3.7
-bash: python3.7: command not found
% Total % Received % Xferd Average Speed Time Time Time Current
Dload Upload Total Spent Left Speed
0 1840k 0 4113 0 0 2619 0 0:11:59 0:00:01 0:11:58 2619
curl: (23) Failed writing body (1354 != 1371)
[root@sk-av sqlite-autoconf-3290000]# cd ~/Libreswan-managing-interface-master/
[root@sk-av Libreswan-managing-interface-master]# cd ../
[root@sk-av ~]# cd /root/newproject/
[root@sk-av newproject]# cd /root/newproject/cd projectname
-bash: cd: /root/newproject/cd: No such file or directory
[root@sk-av newproject]# cd ./projectname/
[root@sk-av projectname]# source newenv/bin/activate
-bash: newenv/bin/activate: No such file or directory
[root@sk-av projectname]# source ../newenv/bin/activate
(newenv) [root@sk-av projectname]# django-admin --version
3.2
(newenv) [root@sk-av projectname]# python manage.py migrate
Operations to perform:
Apply all migrations: admin, auth, contenttypes, sessions
Running migrations:
Applying contenttypes.0001_initial... OK
Applying auth.0001_initial... OK
Applying admin.0001_initial... OK
Applying admin.0002_logentry_remove_auto_add... OK
Applying admin.0003_logentry_add_action_flag_choices... OK
Applying contenttypes.0002_remove_content_type_name... 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 sessions.0001_initial... OK
(newenv) [root@sk-av projectname]# python manage.py syncdb
Unknown command: 'syncdb'
Type 'manage.py help' for usage.
(newenv) [root@sk-av projectname]# python3 manage.py syncdb
Unknown command: 'syncdb'
Type 'manage.py help' for usage.
(newenv) [root@sk-av projectname]# django-admin startproject projectname
CommandError: '/root/newproject/projectname/projectname' already exists
(newenv) [root@sk-av projectname]# python manage.py syncdb
Unknown command: 'syncdb'
Type 'manage.py help' for usage.
(newenv) [root@sk-av projectname]# python ./manage.py syncdb
Unknown command: 'syncdb'
Type 'manage.py help' for usage.
(newenv) [root@sk-av projectname]# python manage.py createsuperuser
Username (leave blank to use 'root'):
Email address: [email protected]
Password:
Password (again):
Superuser created successfully.
(newenv) [root@sk-av projectname]# python manage.py runserver 0.0.0.0:8000
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
July 31, 2020 - 18:25:24
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8000/
Quit the server with CONTROL-C.
Error: That port is already in use.
(newenv) [root@sk-av projectname]# python manage.py runserver 0.0.0.0:8008
Watching for file changes with StatReloader
Performing system checks...

System check identified no issues (0 silenced).
July 31, 2020 - 18:25:29
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8008/
Quit the server with CONTROL-C.
Invalid HTTP_HOST header: 'sk-av.ru:8008'. You may need to add 'sk-av.ru' to ALLOWED_HOSTS.
Bad Request: /
[31/Jul/2020 18:25:41] "GET / HTTP/1.1" 400 64803
Invalid HTTP_HOST header: 'sk-av.ru:8008'. You may need to add 'sk-av.ru' to ALLOWED_HOSTS.
Bad Request: /favicon.ico
[31/Jul/2020 18:25:42] "GET /favicon.ico HTTP/1.1" 400 64841
^C(newenv) [root@sk-av projectname]# python manage.py runserver 0.0.0.0:8008
CommandError: You must set settings.ALLOWED_HOSTS if DEBUG is False.
(newenv) [root@sk-av projectname]# python manage.py runserver 0.0.0.0:8008
Performing system checks...

System check identified no issues (0 silenced).
July 31, 2020 - 18:27:38
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8008/
Quit the server with CONTROL-C.
[31/Jul/2020 18:27:42] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:27:43] "GET /favicon.ico HTTP/1.1" 400 143
[31/Jul/2020 18:27:44] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:27:45] "GET /favicon.ico HTTP/1.1" 400 143
[31/Jul/2020 18:27:45] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:27:46] "GET /favicon.ico HTTP/1.1" 400 143
[31/Jul/2020 18:27:46] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:27:46] "GET /favicon.ico HTTP/1.1" 400 143
[31/Jul/2020 18:27:46] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:27:46] "GET /favicon.ico HTTP/1.1" 400 143
Performing system checks...

System check identified no issues (0 silenced).
July 31, 2020 - 18:28:13
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8008/
Quit the server with CONTROL-C.
[31/Jul/2020 18:28:19] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:28:19] "GET /favicon.ico HTTP/1.1" 400 143
[31/Jul/2020 18:28:21] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:28:22] "GET /favicon.ico HTTP/1.1" 400 143
^C(newenv) [root@sk-av projectname]# python manage.py runserver 0.0.0.0:8008
Performing system checks...

System check identified no issues (0 silenced).
July 31, 2020 - 18:28:31
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8008/
Quit the server with CONTROL-C.
[31/Jul/2020 18:28:34] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:28:35] "GET /favicon.ico HTTP/1.1" 400 143
[31/Jul/2020 18:28:35] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:28:35] "GET /favicon.ico HTTP/1.1" 400 143
[31/Jul/2020 18:28:36] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:28:36] "GET /favicon.ico HTTP/1.1" 400 143
[31/Jul/2020 18:28:42] "GET / HTTP/1.1" 400 143
[31/Jul/2020 18:28:43] "GET /favicon.ico HTTP/1.1" 400 143
^C(newenv) [root@sk-av projectname]# python manage.py runserver 0.0.0.0:8008
Performing system checks...

System check identified no issues (0 silenced).
July 31, 2020 - 18:29:04
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8008/
Quit the server with CONTROL-C.
[31/Jul/2020 18:29:07] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:08] "GET /favicon.ico HTTP/1.1" 404 179
[31/Jul/2020 18:29:08] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:09] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:10] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:10] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:11] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:11] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:12] "GET / HTTP/1.1" 404 179

System check identified no issues (0 silenced).
July 31, 2020 - 18:29:04
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8008/
Quit the server with CONTROL-C.
[31/Jul/2020 18:29:07] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:08] "GET /favicon.ico HTTP/1.1" 404 179
[31/Jul/2020 18:29:08] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:09] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:10] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:10] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:11] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:11] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:29:12] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:31:14] "GET / HTTP/1.1" 404 179
Performing system checks...

System check identified no issues (0 silenced).
July 31, 2020 - 18:32:04
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8008/
Quit the server with CONTROL-C.
[31/Jul/2020 18:32:08] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:32:09] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:32:10] "GET / HTTP/1.1" 404 179
[31/Jul/2020 18:32:11] "GET /favicon.ico HTTP/1.1" 404 179
^C(newenv) [root@sk-av projectname]# python manage.py runserver 0.0.0.0:8008
Performing system checks...

System check identified no issues (0 silenced).
July 31, 2020 - 18:32:35
Django version 3.2, using settings 'projectname.settings'
Starting development server at http://0.0.0.0:8008/
Quit the server with CONTROL-C.
'''

@Rishabh04-02
Copy link
Owner

This managing interface was also tested on CentOS. I'll try to get a CentOS system and solve this installation problem.

@reinethernal i couldn't get a centos server to try it out. If you or @bleve could help in some way, that would be great.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
None yet
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@bleve @Rishabh04-02 @reinethernal