Development Security Technical Support

sysPass 2.1.8 – Text not being translated

After some hours being lost, I discovered why sysPass translation system was not doing anything even if locale was installed.

The issue lies in setLocales (/inc/SP/Core/Language.class.php), it doesn’t set all language variable.

putenv('LANG=' . $lang);

is not enough. The following line needs to be added.

putenv('LANGUAGE=' . $lang);

It works with this but according to ubuntu help page, the value we set for LANGUAGE would not be ideal. See for yourself at

I’m guessing the difference between LANG and LANGUAGE has to do with how the combo Apache/PHP is running. I didn’t see anything that indicated setting both variables might be wrong.

I discovered the fix which works with PHP 7.1.* when I saw the comment from “yuricardenas at gmail dot com” in the PHP manual,




Allow connections to mysql through firewall (IPTABLES) from your network.

*Not in production*

List the content of your iptables and display your numbers.
sudo iptables -n -L --line-numbers

In my case, at the 7th line was the drop all line so it’s the place where I want to insert.
eth1 is the network interface on my computer that I wanted to allow access on. Run ifconfig to know which one you want to apply it on.
To give access to my network, I used a netmask
3306 is the default mysql port.

sudo iptables -I INPUT 7 -i eth1 -p tcp --dport 3306 -s -j ACCEPT -m comment --comment "MySQL"

Do not forget to save !
sudo /etc/init.d/iptables-persistent save
sudo /etc/init.d/iptables-persistent reload

snipt johan_adriaans
CentOS HowTos Network IPTables
AskUbuntu (Answer from user213088)


Crystal Report – maximum report processing jobs limit

If you encounter the following error…

CrystalDecisions.Shared.CrystalReportsException: Load report failed. —> System.Runtime.InteropServices.COMException: The maximum report processing jobs limit configured by your system administrator has been reached.

Make sure you do the following after you are done with the report object….


It will probably save you some time.


Subsonic 3 – ActiveRecord – T4 tweak

Quick reminder : I’m using Subsonic 3 ActiveRecord on a MSSQL database.

One of the nice things with Subsonic 3 is to be able to generate your classes from the database fast and easy.

But sometimes when you are many working on the same project or when you work on different machines, it happens that your database doesnt have exactly the same name  as the original and the T4 files provided will not generate the parameters for your stored procedure.

A quick fix is to edit the method GetSPParams in SQLServer.ttinclude

Replace this line :

string[] restrictions = new string[4] { DatabaseName, null, spName, null };

With these

SqlConnectionStringBuilder connStringBuilder = new SqlConnectionStringBuilder(ConnectionString);
string[] restrictions = new string[4] { connStringBuilder.InitialCatalog, null, spName, null };

And then simply run your .tt files again.

Download the zip file containing the modified SQLServer.ttinclude

If you have improvements that you have made, feel free to write about them in the comment section.


Subsonic 3 – ActiveRecord – Bug DateTime with default value

Tonight I just had the weirdest bug using Subsonic 3 and I just solved it, and if it can save you some time here is the solution for my case.

If you get this error :

System.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when sending the request to the server. (provider: Shared Memory Provider, error: 0 – No process is on the other end of the pipe.) …

only on the saving operation for one particular table in your database. If the debugger in you find it strange, you’re not alone.

After searching, I found out that I forgot to initialize a datetime field (property) on one of my object.

When a datetime is not set in .Net, it sets the date to a minimum value. This is where the problem starts. That value is not within the acceptable range for a datetime type in Microsoft SQL Server (MSSQL).

Instead of giving a clear exception, the exception thrown is a transport-level error.

Hope it helps.

Good night.



TortoiseSVN icons absent on windows 7

Some days ago I lost my icons indicating the status of the files in svn. I uninstalled TortoiseSVN and then installed again, unfortunaly still no luck at the end.

Today, I attacked the problem for a second time and actually found the solution on stackoverflow. Instead of copying it here, here is the link to get all the details on how to fix it :