sysPass 2.1 Install Issue

[luk6173]

Hey Rubén,

I created a new sysPass 2.1 instance, entered all needed data during setup which finished successfull. After Setup I'm trying to login but I'm getting an error:

Internal Error

I don't have any entry regarding this problem in webserver log, just this:

xxx.xxx.technology [Mon Mar 13 08:02:03.007211 2017] [-:error] [pid 12417] [client 185.111.192.4:35460] Setup log file: /nfsmnt/hosting2_1/c/3/c3618d26-dbe0-436d-a4e5-95aa6eed1ce9/xxx.technology/sub/trezor/inc/../config/syspass.log, referer https://xxx.xxx.technology/index.php

What could be the problem?

I used as database server -> unix:/tmp/mariadb101.sock

Thank you,
Lukas

[luk6173]

In my DB in table "log" I see this:

Table "log_action" -> Login
Table "log_description" -> Invalid IP

what does it mean Invalid IP ?

[nuxsmin]

Hi Lukas,

that message is because the app couldn't get the client IP address to keep tracking of wrong log in attempts. Is your sysPass instance behind a proxy?

I've just added the incorrect IP address in logging messages, in the latest commit to master branch.

Regards.

[luk6173]

sysPass instance is not behind a proxy, but my client is behind a proxy

Thank you, I will try it

[luk6173]

Same error with last master branch :-(

[nuxsmin]

That's right because the latest release only logs the wrong IP address. Could you see it in syspass.logfile (in config directory)?, How is the address looks like?

[luk6173]

This is the content of syspass.log:

2017-03-13 09:09:13 - Session data not encrypted.
2017-03-13 09:09:22 - Invalid IP : 185.111.xxx.xxx, 185.111.xxx.xxx
2017-03-13 09:09:27 - Generating a new session key.

How can I fix it now?

[nuxsmin]

Hi, it should be fixed in the latest commit (just pushed). Please let me know if it works

[luk6173]

Hi,

now I'm getting these erros / messages in "syspass.log":

2017-03-13 12:08:07 - Integrity check failed.
2017-03-13 12:08:07 - Integrity check failed.
2017-03-13 12:08:07 - Session data not encrypted.

In SQL-DB will be these entries created:

Table "log_level" -> INFO
Table "log_description" ->
Typ : authBrowser
Typ : authDatabase
Benutzer : syspass-admin
Profil : Admin
Gruppe : Admins
X-Forwarded-For : 185.111.xxx.xxx, 185.111.xxx.xxx

[nuxsmin]

Those errors are related to the session encryption feature. It's most likely because some scripts ran before the encryption took place, but you can verify it by looking at the sysPass information tab. Please make sure your browser has a cookie named "SYSPASS_SK".

[luk6173]

I'm not able to login, I'm getting always back to login screen after login to my sysPass instance

[nuxsmin]

Are you using Safari? Does your browser have the 'SYSPASS_SK' cookie?

[luk6173]

I used FireFox in privacy mode, that was my problem.

[luk6173]

Other question: How Can i get my Data Backup (SQL) from sysPass 2.0 to sysPass 2.1 ?

[nuxsmin]

Do you mean how to import a 2.0 backup into 2.1?

[luk6173]

yes

[nuxsmin]

Umm, goto #466

In the first comment there is a brief howto about the upgrading using a db backup.

[luk6173]

Is that working for hosting mode too?

[nuxsmin]

Yes, the hosting mode does only matter when you're installing the app, because it skips some installation steps.

[luk6173]

I'm not able to create the user "sp_admin" via phpMyAdmin

[nuxsmin]

Don't worry about the user, you can create another user and then grant permissions over the imported database. This user need to be set in the XML

[luk6173]

ah okay, then I'll try that now

[luk6173]

After klicking on "update" button on update screen, nothing happens...

[luk6173]

I have not seen any progress, I tried just after some time to open my usual syspass URL and that worked for me now

[nuxsmin]

Umm, it seems weird. Please take a look to syspass.logfile, it should log some stuff there, because there are some db upgrades from 2.0 to 2.1

[luk6173]

I can see the progress in syspass.log , but I haven't seen any progress in my browser

[nuxsmin]

Did it finish fine (in syspass.log)?

[luk6173]

are these the "finish" entries in syspass.log ?

2017-03-13 14:52:44 - Total time: 62,9210889339
2017-03-13 14:52:44 - Deregister Task: upgrade

[nuxsmin]

Right, those are the finish entries....

[luk6173]

Okay, fine. Then close this Issue and thank you for your support