Git Product home page Git Product logo

keops's Issues

Best system in ranking task

Is it correct to assign "1" to the best among the candidates in ranking task?
Doc here said:

Always start with best position in the ranking (1).

Failed to install dockerized version

Failed to install dockerized version of Keops (KEOPS with default database) according to installation guide.

I'm using commit 2fa573d.
Instead of running git clone http://gitlab.prompsit.com/paracrawl/keops.git, I ran:

git clone https://github.com/paracrawl/keops.git

After running docker-compose up -d, the docker containers are up.
But after signing in with default administrator account ([email protected]), a dialog box popped out in browser.
image

And there are some errors shown when running docker logs keops & docker logs keopsdb.

$ docker logs keopsdb
HELLO KEOPSDB!
STARTING POSTGRES...
 * Stopping PostgreSQL 10 database server
   ...done.
 * Starting PostgreSQL 10 database server
   ...done.
ALTER ROLE
Collecting bcrypt
  Downloading https://files.pythonhosted.org/packages/52/a7/51ab6481ac355517696477889d8ab232106a0ddadda642c54e47a2ab40b9/bcrypt-3.2.0-cp36-abi3-manylinux1_x86_64.whl (63kB)
Requirement already satisfied: six>=1.4.1 in /usr/lib/python3/dist-packages (from bcrypt)
Collecting cffi>=1.1 (from bcrypt)
  Downloading https://files.pythonhosted.org/packages/1c/1a/90fa7e7ee05d91d0339ef264bd8c008f57292aba4a91ec512a0bbb379d1d/cffi-1.14.4-cp36-cp36m-manylinux1_x86_64.whl (401kB)
Collecting pycparser (from cffi>=1.1->bcrypt)
  Downloading https://files.pythonhosted.org/packages/ae/e7/d9c3a176ca4b02024debf82342dab36efadfc5776f9c8db077e8f6e71821/pycparser-2.20-py2.py3-none-any.whl (112kB)
Installing collected packages: pycparser, cffi, bcrypt
Successfully installed bcrypt-3.2.0 cffi-1.14.4 pycparser-2.20
INSERT 0 1
SERVICES STARTED!
2021-01-14 05:51:51.028 CET [33] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2021-01-14 05:51:51.073 CET [34] LOG:  database system was shut down at 2021-01-14 04:30:21 CET
2021-01-14 05:51:51.105 CET [33] LOG:  database system is ready to accept connections
2021-01-14 05:51:51.696 CET [41] [unknown]@[unknown] LOG:  incomplete startup packet
2021-01-14 05:51:53.727 CET [62] postgres@postgres FATAL:  password authentication failed for user "postgres"
2021-01-14 05:51:53.727 CET [62] postgres@postgres DETAIL:  User "postgres" has no password assigned.
        Connection matched pg_hba.conf line 100: "host  all all 0.0.0.0/0   md5"
2021-01-14 05:51:53.731 CET [63] postgres@postgres FATAL:  password authentication failed for user "postgres"
2021-01-14 05:51:53.731 CET [63] postgres@postgres DETAIL:  User "postgres" has no password assigned.
        Connection matched pg_hba.conf line 100: "host  all all 0.0.0.0/0   md5"
2021-01-14 05:52:13.315 CET [90] keopsdb@keopsdb ERROR:  function lower_if_text(timestamp without time zone) does not exist at character 565
2021-01-14 05:52:13.315 CET [90] keopsdb@keopsdb HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
2021-01-14 05:52:13.315 CET [90] keopsdb@keopsdb STATEMENT:
                    SELECT t.id as id, p.name as name, t.source_lang as source_lang, t.target_lang as target_lang, size, t.status as status, t.creation_date as creation_date, t.evalmode as mode, count(case when st.evaluation!='P' then 1 end) as sentencescompleted, p.id as p_id FROM tasks as t left join projects as p on p.id = t.project_id left join users as u on u.id = t.assigned_user left join users as us on us.id = p.owner left join sentences_tasks as st on t.id = st.task_id WHERE t.assigned_user= $1 GROUP BY t.id, p.name, source_lang, target_lang, p.id ORDER BY lower_if_text(t.creation_date) desc OFFSET $2 LIMIT $3 ;

$ docker logs keops
HELLO KEOPS!
STARTING SERVICES...
STARTING PHP...
STARTING NGINX...
 * Stopping nginx nginx
   ...done.
 * Starting nginx nginx
   ...done.
STARTING MEMCACHED...
SERVICES STARTED!
APPLYING DATABASE MIGRATION...
psql: FATAL:  password authentication failed for user "postgres"
FATAL:  password authentication failed for user "postgres"
Waiting for Postgres... (1/10)
/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/declarative/base.py:436: SAWarning: Ignoring declarative-like tuple value of attribute 'evalmode': possibly a copy-and-paste error with a comma accidentally placed at the end of the line?
  "accidentally placed at the end of the line?" % k
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
NO ALEMBIC VERSION DETECTED. SETTING UP ALEMBIC HEAD TO LATEST UPDATE
/usr/local/lib/python2.7/dist-packages/sqlalchemy/ext/declarative/base.py:436: SAWarning: Ignoring declarative-like tuple value of attribute 'evalmode': possibly a copy-and-paste error with a comma accidentally placed at the end of the line?
  "accidentally placed at the end of the line?" % k
INFO  [alembic.runtime.migration] Context impl PostgresqlImpl.
INFO  [alembic.runtime.migration] Will assume transactional DDL.
INFO  [alembic.runtime.migration] Running stamp_revision  -> 6086caf1cb18
HEAD IS NOW: 6086caf1cb18 (head)
IF YOUR DATABASE SCHEMA IS NOT UPDATED, YOU SHOULD DO THAT MANUALLY
==> /var/log/nginx/error.log <==

==> /var/log/nginx/access.log <==
172.16.3.36 - - [14/Jan/2021:05:52:05 +0100] "GET /admin/index.php HTTP/1.1" 302 5 "http://192.168.7.138:4000/admin/invite.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:05 +0100] "GET /index.php HTTP/1.1" 200 2469 "http://192.168.7.138:4000/admin/invite.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:05 +0100] "GET /css/bootstrap-4-utilities.min.css HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:05 +0100] "GET /css/general.css HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /js/general.js HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /img/pyramids-icon-white.png HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /img/logotipo-prompsit.png HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /img/github.png HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /img/paracrawl-logo135x62.png HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /img/eu-logo.png HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /img/paracrawl-background.jpg HTTP/1.1" 304 0 "http://192.168.7.138:4000/css/general.css" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /img/background-v3.png HTTP/1.1" 304 0 "http://192.168.7.138:4000/css/general.css" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:06 +0100] "GET /favicon.ico HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"

==> /var/log/nginx/error.log <==
2021/01/14 05:52:07 [error] 60#60: *1 FastCGI sent in stderr: "PHP message: PHP Notice:  Undefined index: resetpassword in /opt/keops/signin.php on line 87" while reading response header from upstream, client: 172.16.3.36, server: keops.com, request: "GET /signin.php HTTP/1.1", upstream: "fastcgi://unix:/run/php/php7.2-fpm.sock:", host: "192.168.7.138:4000", referrer: "http://192.168.7.138:4000/index.php"

==> /var/log/nginx/access.log <==
172.16.3.36 - - [14/Jan/2021:05:52:07 +0100] "GET /signin.php HTTP/1.1" 200 1555 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:07 +0100] "GET /img/pyramids-icon.png HTTP/1.1" 304 0 "http://192.168.7.138:4000/signin.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"

==> /var/log/nginx/error.log <==
2021/01/14 05:52:13 [error] 60#60: *1 FastCGI sent in stderr: "PHP message: PHP Fatal error:  Uncaught Exception: Error in task_dao::getDatatablesUserTasks : SQLSTATE[42883]: Undefined function: 7 ERROR:  function lower_if_text(timestamp without time zone) does not exist
LINE 2: ..., p.name, source_lang, target_lang, p.id ORDER BY lower_if_t...
                                                             ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts. in /opt/keops/dao/task_dao.php:668
Stack trace:
#0 /opt/keops/tasks/task_user_list.php(12): task_dao->getDatatablesUserTasks(Array, 1)
#1 {main}
  thrown in /opt/keops/dao/task_dao.php on line 668" while reading response header from upstream, client: 172.16.3.36, server: keops.com, request: "GET /tasks/task_user_list.php?draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&colu

==> /var/log/nginx/access.log <==
172.16.3.36 - - [14/Jan/2021:05:52:13 +0100] "POST /users/user_login.php HTTP/1.1" 302 16 "http://192.168.7.138:4000/signin.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:13 +0100] "GET /index.php HTTP/1.1" 200 2472 "http://192.168.7.138:4000/signin.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:13 +0100] "GET /img/tiny-pyramids-white.png HTTP/1.1" 304 0 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"
172.16.3.36 - - [14/Jan/2021:05:52:13 +0100] "GET /tasks/task_user_list.php?draw=1&columns%5B0%5D%5Bdata%5D=0&columns%5B0%5D%5Bname%5D=&columns%5B0%5D%5Bsearchable%5D=true&columns%5B0%5D%5Borderable%5D=true&columns%5B0%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B0%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B1%5D%5Bdata%5D=1&columns%5B1%5D%5Bname%5D=&columns%5B1%5D%5Bsearchable%5D=true&columns%5B1%5D%5Borderable%5D=true&columns%5B1%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B1%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B2%5D%5Bdata%5D=2&columns%5B2%5D%5Bname%5D=&columns%5B2%5D%5Bsearchable%5D=true&columns%5B2%5D%5Borderable%5D=true&columns%5B2%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B2%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B3%5D%5Bdata%5D=3&columns%5B3%5D%5Bname%5D=&columns%5B3%5D%5Bsearchable%5D=true&columns%5B3%5D%5Borderable%5D=true&columns%5B3%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B3%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B4%5D%5Bdata%5D=4&columns%5B4%5D%5Bname%5D=&columns%5B4%5D%5Bsearchable%5D=true&columns%5B4%5D%5Borderable%5D=true&columns%5B4%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B4%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B5%5D%5Bdata%5D=5&columns%5B5%5D%5Bname%5D=&columns%5B5%5D%5Bsearchable%5D=true&columns%5B5%5D%5Borderable%5D=true&columns%5B5%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B5%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B6%5D%5Bdata%5D=6&columns%5B6%5D%5Bname%5D=&columns%5B6%5D%5Bsearchable%5D=true&columns%5B6%5D%5Borderable%5D=true&columns%5B6%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B6%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B7%5D%5Bdata%5D=7&columns%5B7%5D%5Bname%5D=&columns%5B7%5D%5Bsearchable%5D=true&columns%5B7%5D%5Borderable%5D=true&columns%5B7%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B7%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B8%5D%5Bdata%5D=8&columns%5B8%5D%5Bname%5D=&columns%5B8%5D%5Bsearchable%5D=false&columns%5B8%5D%5Borderable%5D=false&columns%5B8%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B8%5D%5Bsearch%5D%5Bregex%5D=false&columns%5B9%5D%5Bdata%5D=9&columns%5B9%5D%5Bname%5D=&columns%5B9%5D%5Bsearchable%5D=false&columns%5B9%5D%5Borderable%5D=false&columns%5B9%5D%5Bsearch%5D%5Bvalue%5D=&columns%5B9%5D%5Bsearch%5D%5Bregex%5D=false&order%5B0%5D%5Bcolumn%5D=6&order%5B0%5D%5Bdir%5D=desc&start=0&length=10&search%5Bvalue%5D=&search%5Bregex%5D=false&_=1610599935379 HTTP/1.1" 500 5 "http://192.168.7.138:4000/index.php" "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/87.0.4280.88 Safari/537.36"

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.