Type Error about roxy-wi HOT 18 CLOSED

Hi,

check whether the database was created properly and the table users is have defaults logins

from roxy-wi.

i had only error when install.sh, near
insert into cred('enable','username','password') values ('1', 'root','password');
in haproxy-wi.db.sql file, so i just create it manually, changed it to
insert into cred(enable,username,password) values ('1', 'root','password');
and error gone

from roxy-wi.

ou ) I'm forgot update that file ) thank you

Share your impressions after using

from roxy-wi.

same error, 500 http://server:8080/app/login.py?login=admin&pass=admin
and in error log

[Mon Sep 03 15:43:48.789879 2018] [cgi:error] [pid 17038:tid 140568533346048] [client 10.10.10.10:54826] AH01215: Traceback (most recent call last):: /var/www/haproxy-wi/app/login.py, referer: http://server:8080/app/login.py?ref=/app/overview.py

[Mon Sep 03 15:43:48.789974 2018] [cgi:error] [pid 17038:tid 140568533346048] [client 10.10.10.10:54826] AH01215:   File "/var/www/haproxy-wi/app/login.py", line 68, in <module>: /var/www/haproxy-wi/app/login.py, referer: http://server:8080/app/login.py?ref=/app/overview.py

[Mon Sep 03 15:43:48.789997 2018] [cgi:error] [pid 17038:tid 140568533346048] [client 10.10.10.10:54826] AH01215:     if login in users[1] and password == users[3]:: /var/www/haproxy-wi/app/login.py, referer: http://server:8080/app/login.py?ref=/app/overview.py

[Mon Sep 03 15:43:48.790024 2018] [cgi:error] [pid 17038:tid 140568533346048] [client 10.10.10.10:54826] AH01215: TypeError: a bytes-like object is required, not 'str': /var/www/haproxy-wi/app/login.py, referer: http://server:8080/app/login.py?ref=/app/overview.py
[Mon Sep 03 15:43:48.821473 2018] [cgi:error] [pid 17038:tid 140568533346048] [client 10.10.10.10:54826] End of script output before headers: login.py, referer: http://server:8080/app/login.py?ref=/app/overview.py

from roxy-wi.

you solved this problem and again?

from roxy-wi.

Nope, i did not. I mean, that error on installing gone, but 500 still. so i just did clean install.sh, you have errors in create_db.py

<div class="alert alert-danger">
An error occurred: 1062 (23000): Duplicate entry 'admin' for key 'username'
</div>
An error occurred: 1062 (23000): Duplicate entry 'time_zone' for key 'param'
An error occurred: 1060 (42S21): Duplicate column name 'port'

but w\e, i executed haproxy-wi.db.sql (haproxy-wi.db.sql:5 you forgot a comma), its done successful, but
when i tryin to login i still get 500 error.

from roxy-wi.

from roxy-wi.

and all tables

and config file

from roxy-wi.

I'm updated repo, try update and recreate DB

from roxy-wi.

Same. Maybe its problem in version python? I have
(Python 2.7.13 (default, Nov 24 2017, 17:33:09))

https://ru.stackoverflow.com/questions/466658/Ошибка-при-подключении-сокета-к-серверу-a-bytes-like-object-is-required-not-s

from roxy-wi.

from roxy-wi.

Python 3.5.3 (default, Jan 19 2017, 14:11:04)
На самой базе селекты выполняются нормально, мне кажется проблема не в бд

from roxy-wi.

Кажется нашел в чем причина, посмотри сколько полей в таблице uuid? Если два то сделай

ALTER TABLE `uuid` ADD COLUMN `exp` DATETIME default '0000-00-00 00:00:00';

from roxy-wi.

ну как, помогло?

from roxy-wi.

нет, с таблицой все нормально

from roxy-wi.

A js включаен, jqury нормально подгружается?

Хотя они тут не причем сейчас, если даже не открывается страница...

from roxy-wi.

в итоге поставил скуль и приложение на одном сервере, полет нормальный.

from roxy-wi.

from roxy-wi.