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 :



enter image description here



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!.



enter image description here



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 :



enter image description here



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







share|improve this question
























  • 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

















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 :



enter image description here



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!.



enter image description here



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 :



enter image description here



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







share|improve this question
























  • 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















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 :



enter image description here



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!.



enter image description here



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 :



enter image description here



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







share|improve this question















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 :



enter image description here



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!.



enter image description here



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 :



enter image description here



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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Dec 6 at 13:40

























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 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




















  • 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


















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

















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


















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














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





















































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







-

Popular posts from this blog

Ellipse (mathématiques)

Image
Pour les articles homonymes, voir Ellipse. L'ellipse est le lieu des points dont la somme des distances à deux points fixes, dits foyers, est constante. Section du cône ou projection du cercle. En géométrie, une ellipse est une courbe plane fermée obtenue par l’intersection d’un cône de révolution avec un plan, à condition que celui-ci coupe l'axe de rotation du cône ou du cylindre : c'est une conique d'excentricité strictement comprise entre 0 et 1. On peut également la définir comme le lieu des points dont la somme des distances à deux points fixes, dits foyers, est constante (sa construction par la méthode du jardinier est très simple). Dans la vie courante, l’ellipse est la forme qu'on perçoit en regardant un cercle en perspective, ou la figure formée par l’ombre d'un disque sur une surface plane. On retrouve aussi, en première approximation [ 1 ] , des ellipses dans les trajectoires des corps célestes (planètes, comètes ou satellites arti...
Read more

Quarter-circle Tiles

Image
up vote 0 down vote favorite I have $99$ identical square tiles, each with a quarter-circle drawn on it like this: [asy] size(1.5cm); draw(Arc((2,0),1,90,180),red+1); draw((0,0)--(2,0)--(2,2)--(0,2)--(0,0)); [/asy] When I arrange the tiles in a $9times 11$ rectangular grid, each with a random orientation, what is the expected value of the number of full circles I form? I think this problem has to do with finding the chance any given 2x2 square has a circle, but I can't find it. expected-value share | cite | improve this question asked Nov 20 at 15:03 6minecraftninja 1 2 ...
Read more

Mont Emei

Image
Mont Emei.mw-parser-output .entete.map{background-image:url("//upload.wikimedia.org/wikipedia/commons/7/7a/Picto_infobox_map.png")} Vue du sommet Wanfo du mont Emei Géographie Altitude 3 099  m , Wanfo Coordonnées 29° 31′ 11″ nord, 103° 19′ 57″ est Administration Pays   Chine Province Sichuan Ville-préfecture Leshan Géolocalisation sur la carte : Sichuan Mont Emei Géolocalisation sur la carte : Chine Mont Emei modifier   Paysage panoramique du mont Emei, incluant le paysage panoramique du grand Bouddha de Leshan *   Patrimoine mondial de l'UNESCO Passerelle en bois sur le versant ouest Pays   Chine Subdivision Sichuan Type Mixte Critères (iv) (vi) (x) Superficie 15 400 ha Numéro d’identification 779 Zone géographique Asie et Pacifique  ** Année d’inscription 1996 (20 e session) * Descriptif officiel UNESCO ** Classification géog...
Read more