sysPass 2.0 Install issue

[c1xx]

Hi,

i'm trying to install sysPass on my webspace and I can't enter a Port for my Database Server.
Can you please fix it? I'm getting an error/message: incorrect format...

Thank you,
Lukas

[c1xx]

Hi,

when I enter databaseserver:port and try to install sysPass on my Webspace then I get this error:

Unable to connect to the DB
Compruebe los datos de conexión
SQLSTATE[HY000] [2027] Malformed packet

I tried to use MariaDB 10.1 and MySQL 5.7

Br,
Lukas

[nuxsmin]

Please, take a look to this link: https://bugs.mysql.com/bug.php?id=77298

[c1xx]

Hmm okay, but I'm getting this error with MariaDB 10.1 too
WordPress is running w/o any problems via MariaDB 10.1

[nuxsmin]

Ok, let me take a test on that versions and I'll be back

[nuxsmin]

Hi, did you try out with the latest release?

[c1xx]

Yes

[nuxsmin]

Perhaps it could be wrong because the PHP mysql driver...

https://bugs.php.net/bug.php?id=72638

But I don't know why WordPress is running fine, so I think that is so because WordPress doesn't use PDO (http://php.net/manual/en/intro.pdo.php) and uses mysql_* functions instead: http://wordpress.stackexchange.com/questions/84680/wordpress-mysqli-and-pdo

[c1xx]

I will contact my provider, i hope that they can help me

[nuxsmin]

Fine, hosting providers usually set some config parameters to avoid services overloading and other security related issues.

The sysPass demo site is on a shared hosting and the only issue detected was related to MySQL views and the prepared statements, it didn't work, so I had to set some kind of emulation in the code that wouldn't be needed on a private hosting.

Hope they help you!

[c1xx]

I will report !

[c1xx]

I got an answer. It's not possible to change needed settings on their database servers because I'm on a shared Server with many other customers

Also I can't use sysPass on my webspace... :-(

Is there other way to get it running on my webspace?

[nuxsmin]

Are you using "localhost" as the connection server? Did you try it?

[c1xx]

Yes, error is:

Unable to connect to the DB
Compruebe los datos de conexión
SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

MySQL Socket Path is:
MySQL 5.7 --> /temp/mysql57.sock
MariaDB 10.1 --> /tmp/mariadb101.sock

@nuxsmin Maybe this is the Problem for this error message?

[nuxsmin]

Could be....

Could you replace the files attached in the gist?: https://gist.github.com/nuxsmin/38ebe238ace78542eab4d4eba80cf5aa

They are located at: "inc/SP/Storage" and "inc/SP/Core"

[c1xx]

Thank you very much, but -> Error:

Unable to connect to the DB
Compruebe los datos de conexión
SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Do you need more informations about my webspace? I can provide you access data to my Database and FTP. Are you interested ? If yes send me an email.

[nuxsmin]

Sorry, I missed to remove some parts in the connection string. Please, replace the files again.

[c1xx]

No Chance :-(

Unable to connect to the DB
Compruebe los datos de conexión
SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/temp/mysql57.sock' (2)

Some infos from my provider:

Example of use in PHP scripts with mysqli_connect
Recommended connection (works everywhere):
$connection = mysqli_connect("mysql57.websupport.sk", "USER", "here_insert_password", "DB", 3311);

Socket connection (works only on our servers):
$connection = mysqli_connect(null, "USER", "here_insert_password", "DB", null, "/tmp/mysql57.sock");

Localhost connection:
$connection = mysqli_connect("localhost", "USER", "here_insert_password", "DB");

Example of use in PHP scripts with PDO connection:
Recommended connection (works everywhere):
$connection = new PDO("mysql:host=mysql57.websupport.sk;port=3311;dbname=DB", "USER", "here_insert_password");

Socket connection (works only on our servers):
$connection = new PDO("mysql:unix_socket=/tmp/mysql57.sock;dbname=DB", "USER", "here_insert_password");

Localhost connection:
$connection = new PDO("mysql:host=localhost;dbname=DB", "USER", "here_insert_password");

Maybe this can help you?

[nuxsmin]

And what about by setting 127.0.0.1:3306 as db server? (You would need to switch back to the original files....)

[c1xx]

Unable to connect to the DB
Compruebe los datos de conexión
SQLSTATE[HY000] [2027] Malformed packet

[nuxsmin]

I know that should be correct, but..is it the right port?

[c1xx]

when I try that with "localhost" and no port, I get this error:

Unable to connect to the DB
Compruebe los datos de conexión
SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[nuxsmin]

Could you place a file called "info.php" in the sysPass root and then access to it?

The content is as follows:

<?php

phpinfo(INFO_MODULES);

The interesting parts are those related to MySQL

[c1xx]

You got a Mail

[nuxsmin]

Fine...it seems that the socket path was wrong...it should be "/tmp/mysql57.sock". I have just updated the gist, please replace the files again

[c1xx]

Thank you. It seems to ignoring mySQL-User. User lukasp = Admin User for sysPass

No es posible comprobar el usuario de sysPass (lukasp)
Please, check the DB connection user rights

[nuxsmin]

If you are in a hosted environment you would need to use the hosting mode, because the installer will check some disallowed tables.

Please, take a look to: https://wiki.syspass.org/en/hostingmode

[c1xx]

Great! It works with hosting mode now! Big thx!

Important question: How I can use further sysPass updates now?

[nuxsmin]

You're welcome!

And sorry about those untranslated messages, an undesired behavior on the translating function returns them untranslated. It will be fixed in next commit ;)

[c1xx]

Everthing is fine, you're very active @github ! :-)

Can you please tell me, how I have to use comer updates?

[nuxsmin]

I've just done a commit about that... ;)

Currently I'm finishing the sysPass v2 release so every feedback is welcome and I'll try to fix it as soon as possible :)

[c1xx]

Great, you're amazing ! :)

[nuxsmin]

Thanks!

Please, could you try it out on your environment?

Update: sorry, I missed to mention that you would need to use "unix:/path/to/socket" in the db host field...

[c1xx]

Ok I used "devel" release. When I try to make a clean install:

SQLSTATE[HY000] [2002] Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

[nuxsmin]

Did you use the "unix:" prefix?

[c1xx]

No, how I have to use it?

In DB Field -> unix:/tmp/mysql57.sock?

[nuxsmin]

Right!

[nuxsmin]

sorry...DB Host field

[c1xx]

ok, popup message tells me that I have to use correct / right format

[nuxsmin]

Agrrr, the html regex checker wasn't modified...I've just updated it

[c1xx]

Is working fine now :)

[nuxsmin]

Great! Hope you enjoy it ;)

[c1xx]

Yes, I do! :-)