How to Configuring Prewikka for Bionic at First time?
up vote
2
down vote
favorite
I trying to installing the Prewikka package a Security Information and Events Management System based a Web Interface for Bionic.
I following the instructions on my terminal, when i getting started to setup Prewikka package, a confirmation appears :
i'm never provide configuring a password for the Prewikka Database, i try to find on a site Docs but i cannot find my issue exactly anything.
How do i know a password for my Prewikka on dbconfig-common? cause i choose the dbconfig-common Database as default on the instructions previously, see below!.
Edit #1
The Developer of Prewikka said As for Prelude, we choose to use dbconfig-common, give the administrator password and enter the DB password. on this Docs for make the integration to Prelude Manager, therefore i choose dbconfig-common in the previous instructions. when i Reading all Docs of the Prelude Developer, i forgot to make a database for my Prewikka!. Oh that's my false. and this moment, i get some the Errors that i don't understand! but i still little bit confusing at the Confirmation a password which I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude?
Edit #2
at this moment, i get some the Errors that i don't understand and really complicated to me! when i open the default port of Prewikka, the errors appears :
On my terminal appears :
$ sudo prewikka-httpd
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 59, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 489, in __init__
dh.apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 74, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 424, in apply
self._apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in _apply
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in <listcomp>
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 87, in inner
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 221, in apply
self.run()
File "/usr/lib/python3/dist-packages/prewikka/sql/install.py", line 72, in run
""")
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 211, in query
self.db.query(q)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 277, in process
response = self._process_static(webreq) or self._process_dynamic(webreq)
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 244, in _process_dynamic
self._prewikka_init_if_needed()
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 134, in _prewikka_init_if_needed
raise self._prewikka_initialized
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 122, in _prewikka_init_if_needed
env.db = database.Database(env.config.database)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 873, in __new__
return MySQLDatabase(config)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 61, in inner
raise DatabaseError(message=text_type(e))
prewikka.database.DatabaseError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.6/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/lib/python3/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 90, in _html_respond
from prewikka import baseview
File "/usr/lib/python3/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/lib/python3/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N_("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 59, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 489, in __init__
dh.apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 74, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 424, in apply
self._apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in _apply
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in <listcomp>
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 87, in inner
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 221, in apply
self.run()
File "/usr/lib/python3/dist-packages/prewikka/sql/install.py", line 72, in run
""")
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 211, in query
self.db.query(q)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 277, in process
response = self._process_static(webreq) or self._process_dynamic(webreq)
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 244, in _process_dynamic
self._prewikka_init_if_needed()
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 134, in _prewikka_init_if_needed
raise self._prewikka_initialized
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 122, in _prewikka_init_if_needed
env.db = database.Database(env.config.database)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 873, in __new__
return MySQLDatabase(config)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 61, in inner
raise DatabaseError(message=text_type(e))
prewikka.database.DatabaseError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.6/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/lib/python3/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 90, in _html_respond
from prewikka import baseview
File "/usr/lib/python3/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/lib/python3/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N_("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist
Edit #3
I tried to following from this issue and he solved with following :
- Deleted the Prewikka Database
- Recreated the Prewikka Database
- Retry to run the Prewikka
But it doesn't work to me, i also using the instructions like a mentioned it Howto : https://www.prelude-siem.org/projects/prelude/wiki/InstallingPackageUbuntu. so what i missing something guys??
Hope anyone can help me!, Thanks in advance.
apt 18.04 package-management
asked Dec 1 at 12:59
abu-ahmed al-khatiri
89015
add a comment |
up vote
2
down vote
favorite
I trying to installing the Prewikka package a Security Information and Events Management System based a Web Interface for Bionic.
I following the instructions on my terminal, when i getting started to setup Prewikka package, a confirmation appears :
i'm never provide configuring a password for the Prewikka Database, i try to find on a site Docs but i cannot find my issue exactly anything.
How do i know a password for my Prewikka on dbconfig-common? cause i choose the dbconfig-common Database as default on the instructions previously, see below!.
Edit #1
The Developer of Prewikka said As for Prelude, we choose to use dbconfig-common, give the administrator password and enter the DB password. on this Docs for make the integration to Prelude Manager, therefore i choose dbconfig-common in the previous instructions. when i Reading all Docs of the Prelude Developer, i forgot to make a database for my Prewikka!. Oh that's my false. and this moment, i get some the Errors that i don't understand! but i still little bit confusing at the Confirmation a password which I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude?
Edit #2
at this moment, i get some the Errors that i don't understand and really complicated to me! when i open the default port of Prewikka, the errors appears :
On my terminal appears :
$ sudo prewikka-httpd
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 59, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 489, in __init__
dh.apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 74, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 424, in apply
self._apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in _apply
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in <listcomp>
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 87, in inner
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 221, in apply
self.run()
File "/usr/lib/python3/dist-packages/prewikka/sql/install.py", line 72, in run
""")
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 211, in query
self.db.query(q)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 277, in process
response = self._process_static(webreq) or self._process_dynamic(webreq)
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 244, in _process_dynamic
self._prewikka_init_if_needed()
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 134, in _prewikka_init_if_needed
raise self._prewikka_initialized
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 122, in _prewikka_init_if_needed
env.db = database.Database(env.config.database)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 873, in __new__
return MySQLDatabase(config)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 61, in inner
raise DatabaseError(message=text_type(e))
prewikka.database.DatabaseError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.6/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/lib/python3/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 90, in _html_respond
from prewikka import baseview
File "/usr/lib/python3/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/lib/python3/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N_("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 59, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 489, in __init__
dh.apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 74, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 424, in apply
self._apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in _apply
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in <listcomp>
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 87, in inner
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 221, in apply
self.run()
File "/usr/lib/python3/dist-packages/prewikka/sql/install.py", line 72, in run
""")
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 211, in query
self.db.query(q)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 277, in process
response = self._process_static(webreq) or self._process_dynamic(webreq)
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 244, in _process_dynamic
self._prewikka_init_if_needed()
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 134, in _prewikka_init_if_needed
raise self._prewikka_initialized
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 122, in _prewikka_init_if_needed
env.db = database.Database(env.config.database)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 873, in __new__
return MySQLDatabase(config)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 61, in inner
raise DatabaseError(message=text_type(e))
prewikka.database.DatabaseError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.6/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/lib/python3/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 90, in _html_respond
from prewikka import baseview
File "/usr/lib/python3/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/lib/python3/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N_("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist
Edit #3
I tried to following from this issue and he solved with following :
- Deleted the Prewikka Database
- Recreated the Prewikka Database
- Retry to run the Prewikka
But it doesn't work to me, i also using the instructions like a mentioned it Howto : https://www.prelude-siem.org/projects/prelude/wiki/InstallingPackageUbuntu. so what i missing something guys??
Hope anyone can help me!, Thanks in advance.
apt 18.04 package-management
asked Dec 1 at 12:59
abu-ahmed al-khatiri
89015
as you said "i forgot to make a database for my Prewikka!" you want to continue without that? your question is with this clause? how to configure after forgetting to make a database?
– PRATAP
Dec 4 at 9:37
@PRATAP no, when i tried to configuration of Prewikka, i forgot to make the MySQL Database for my Prewikka before i installing Prewikka package. so i still little bit confusing at the Confirmationa passwordwhich I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude???
– abu-ahmed al-khatiri
Dec 4 at 9:50
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
I trying to installing the Prewikka package a Security Information and Events Management System based a Web Interface for Bionic.
I following the instructions on my terminal, when i getting started to setup Prewikka package, a confirmation appears :
i'm never provide configuring a password for the Prewikka Database, i try to find on a site Docs but i cannot find my issue exactly anything.
How do i know a password for my Prewikka on dbconfig-common? cause i choose the dbconfig-common Database as default on the instructions previously, see below!.
Edit #1
The Developer of Prewikka said As for Prelude, we choose to use dbconfig-common, give the administrator password and enter the DB password. on this Docs for make the integration to Prelude Manager, therefore i choose dbconfig-common in the previous instructions. when i Reading all Docs of the Prelude Developer, i forgot to make a database for my Prewikka!. Oh that's my false. and this moment, i get some the Errors that i don't understand! but i still little bit confusing at the Confirmation a password which I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude?
Edit #2
at this moment, i get some the Errors that i don't understand and really complicated to me! when i open the default port of Prewikka, the errors appears :
On my terminal appears :
$ sudo prewikka-httpd
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 59, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 489, in __init__
dh.apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 74, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 424, in apply
self._apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in _apply
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in <listcomp>
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 87, in inner
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 221, in apply
self.run()
File "/usr/lib/python3/dist-packages/prewikka/sql/install.py", line 72, in run
""")
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 211, in query
self.db.query(q)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 277, in process
response = self._process_static(webreq) or self._process_dynamic(webreq)
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 244, in _process_dynamic
self._prewikka_init_if_needed()
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 134, in _prewikka_init_if_needed
raise self._prewikka_initialized
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 122, in _prewikka_init_if_needed
env.db = database.Database(env.config.database)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 873, in __new__
return MySQLDatabase(config)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 61, in inner
raise DatabaseError(message=text_type(e))
prewikka.database.DatabaseError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.6/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/lib/python3/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 90, in _html_respond
from prewikka import baseview
File "/usr/lib/python3/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/lib/python3/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N_("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 59, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 489, in __init__
dh.apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 74, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 424, in apply
self._apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in _apply
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in <listcomp>
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 87, in inner
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 221, in apply
self.run()
File "/usr/lib/python3/dist-packages/prewikka/sql/install.py", line 72, in run
""")
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 211, in query
self.db.query(q)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 277, in process
response = self._process_static(webreq) or self._process_dynamic(webreq)
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 244, in _process_dynamic
self._prewikka_init_if_needed()
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 134, in _prewikka_init_if_needed
raise self._prewikka_initialized
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 122, in _prewikka_init_if_needed
env.db = database.Database(env.config.database)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 873, in __new__
return MySQLDatabase(config)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 61, in inner
raise DatabaseError(message=text_type(e))
prewikka.database.DatabaseError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.6/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/lib/python3/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 90, in _html_respond
from prewikka import baseview
File "/usr/lib/python3/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/lib/python3/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N_("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist
Edit #3
I tried to following from this issue and he solved with following :
- Deleted the Prewikka Database
- Recreated the Prewikka Database
- Retry to run the Prewikka
But it doesn't work to me, i also using the instructions like a mentioned it Howto : https://www.prelude-siem.org/projects/prelude/wiki/InstallingPackageUbuntu. so what i missing something guys??
Hope anyone can help me!, Thanks in advance.
apt 18.04 package-management
asked Dec 1 at 12:59
abu-ahmed al-khatiri
89015
I trying to installing the Prewikka package a Security Information and Events Management System based a Web Interface for Bionic.
I following the instructions on my terminal, when i getting started to setup Prewikka package, a confirmation appears :
i'm never provide configuring a password for the Prewikka Database, i try to find on a site Docs but i cannot find my issue exactly anything.
How do i know a password for my Prewikka on dbconfig-common? cause i choose the dbconfig-common Database as default on the instructions previously, see below!.
Edit #1
The Developer of Prewikka said As for Prelude, we choose to use dbconfig-common, give the administrator password and enter the DB password. on this Docs for make the integration to Prelude Manager, therefore i choose dbconfig-common in the previous instructions. when i Reading all Docs of the Prelude Developer, i forgot to make a database for my Prewikka!. Oh that's my false. and this moment, i get some the Errors that i don't understand! but i still little bit confusing at the Confirmation a password which I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude?
Edit #2
at this moment, i get some the Errors that i don't understand and really complicated to me! when i open the default port of Prewikka, the errors appears :
On my terminal appears :
$ sudo prewikka-httpd
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 59, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 489, in __init__
dh.apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 74, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 424, in apply
self._apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in _apply
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in <listcomp>
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 87, in inner
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 221, in apply
self.run()
File "/usr/lib/python3/dist-packages/prewikka/sql/install.py", line 72, in run
""")
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 211, in query
self.db.query(q)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 277, in process
response = self._process_static(webreq) or self._process_dynamic(webreq)
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 244, in _process_dynamic
self._prewikka_init_if_needed()
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 134, in _prewikka_init_if_needed
raise self._prewikka_initialized
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 122, in _prewikka_init_if_needed
env.db = database.Database(env.config.database)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 873, in __new__
return MySQLDatabase(config)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 61, in inner
raise DatabaseError(message=text_type(e))
prewikka.database.DatabaseError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.6/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/lib/python3/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 90, in _html_respond
from prewikka import baseview
File "/usr/lib/python3/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/lib/python3/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N_("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 59, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 489, in __init__
dh.apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 74, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 424, in apply
self._apply()
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in _apply
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 415, in <listcomp>
[ update.apply() for update in self.list() ]
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 87, in inner
return func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 221, in apply
self.run()
File "/usr/lib/python3/dist-packages/prewikka/sql/install.py", line 72, in run
""")
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 211, in query
self.db.query(q)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 277, in process
response = self._process_static(webreq) or self._process_dynamic(webreq)
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 244, in _process_dynamic
self._prewikka_init_if_needed()
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 134, in _prewikka_init_if_needed
raise self._prewikka_initialized
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 122, in _prewikka_init_if_needed
env.db = database.Database(env.config.database)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 873, in __new__
return MySQLDatabase(config)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 61, in inner
raise DatabaseError(message=text_type(e))
prewikka.database.DatabaseError: All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "/usr/lib/python3.6/wsgiref/handlers.py", line 137, in run
self.result = application(self.environ, self.start_response)
File "/bin/prewikka-httpd", line 62, in application
return wsgi.application(environ, start_response)
File "/usr/lib/python3/dist-packages/prewikka/web/wsgi.py", line 161, in application
core.process(WSGIRequest(environ, start_response))
File "/usr/lib/python3/dist-packages/prewikka/main.py", line 280, in process
response = err.respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 106, in respond
return self._html_respond()
File "/usr/lib/python3/dist-packages/prewikka/error.py", line 90, in _html_respond
from prewikka import baseview
File "/usr/lib/python3/dist-packages/prewikka/baseview.py", line 27, in <module>
from prewikka import error, history, hookmanager, resource, response, template, utils, view
File "/usr/lib/python3/dist-packages/prewikka/history.py", line 102, in <module>
crontab.schedule("search_history", N_("Search history deletion"), "0 * * * *", _regfunc=history._history_cron, enabled=True)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 240, in schedule
self._init_system_job(ext_type, name, schedule, enabled, _regfunc)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 91, in inner
ret = func(self, *args, **kwargs)
File "/usr/lib/python3/dist-packages/prewikka/crontab.py", line 152, in _init_system_job
res = env.db.query("SELECT 1 FROM Prewikka_Crontab WHERE ext_type=%s AND userid IS NULL", ext_type)
File "/usr/lib/python3/dist-packages/prewikka/database.py", line 547, in query
return preludedb.SQL.query(self, sql)
RuntimeError: Table 'prewikka.Prewikka_Crontab' doesn't exist
Edit #3
I tried to following from this issue and he solved with following :
- Deleted the Prewikka Database
- Recreated the Prewikka Database
- Retry to run the Prewikka
But it doesn't work to me, i also using the instructions like a mentioned it Howto : https://www.prelude-siem.org/projects/prelude/wiki/InstallingPackageUbuntu. so what i missing something guys??
Hope anyone can help me!, Thanks in advance.
apt 18.04 package-management
apt 18.04 package-management
asked Dec 1 at 12:59
abu-ahmed al-khatiri
89015
asked Dec 1 at 12:59
abu-ahmed al-khatiri
89015
edited Dec 6 at 13:40
asked Dec 1 at 12:59
abu-ahmed al-khatiri
89015
asked Dec 1 at 12:59
abu-ahmed al-khatiri
89015
asked Dec 1 at 12:59
abu-ahmed al-khatiri
89015
89015
as you said "i forgot to make a database for my Prewikka!" you want to continue without that? your question is with this clause? how to configure after forgetting to make a database?
– PRATAP
Dec 4 at 9:37
@PRATAP no, when i tried to configuration of Prewikka, i forgot to make the MySQL Database for my Prewikka before i installing Prewikka package. so i still little bit confusing at the Confirmationa passwordwhich I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude???
– abu-ahmed al-khatiri
Dec 4 at 9:50
add a comment |
as you said "i forgot to make a database for my Prewikka!" you want to continue without that? your question is with this clause? how to configure after forgetting to make a database?
– PRATAP
Dec 4 at 9:37
@PRATAP no, when i tried to configuration of Prewikka, i forgot to make the MySQL Database for my Prewikka before i installing Prewikka package. so i still little bit confusing at the Confirmationa passwordwhich I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude???
– abu-ahmed al-khatiri
Dec 4 at 9:50
as you said "i forgot to make a database for my Prewikka!" you want to continue without that? your question is with this clause? how to configure after forgetting to make a database?
– PRATAP
Dec 4 at 9:37
as you said "i forgot to make a database for my Prewikka!" you want to continue without that? your question is with this clause? how to configure after forgetting to make a database?
– PRATAP
Dec 4 at 9:37
@PRATAP no, when i tried to configuration of Prewikka, i forgot to make the MySQL Database for my Prewikka before i installing Prewikka package. so i still little bit confusing at the Confirmation
a password which I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude???– abu-ahmed al-khatiri
Dec 4 at 9:50
@PRATAP no, when i tried to configuration of Prewikka, i forgot to make the MySQL Database for my Prewikka before i installing Prewikka package. so i still little bit confusing at the Confirmation
a password which I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude???– abu-ahmed al-khatiri
Dec 4 at 9:50
add a comment |
active
oldest
votes
Your Answer
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "89"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1097669%2fhow-to-configuring-prewikka-for-bionic-at-first-time%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
active
oldest
votes
active
oldest
votes
active
oldest
votes
active
oldest
votes
draft saved
draft discarded
Thanks for contributing an answer to Ask Ubuntu!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
draft saved
draft discarded
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2faskubuntu.com%2fquestions%2f1097669%2fhow-to-configuring-prewikka-for-bionic-at-first-time%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
as you said "i forgot to make a database for my Prewikka!" you want to continue without that? your question is with this clause? how to configure after forgetting to make a database?
– PRATAP
Dec 4 at 9:37
@PRATAP no, when i tried to configuration of Prewikka, i forgot to make the MySQL Database for my Prewikka before i installing Prewikka package. so i still little bit confusing at the Confirmation
a passwordwhich I have to enter a password between MySQL Database of Prewikka or DBConfig-Common of Prelude???– abu-ahmed al-khatiri
Dec 4 at 9:50