Hello, Guyz!
We start using activitywatch in our company to improve the employers productivity.
We set up a linux server and installed the app in 60 windows clients, after that we configured a GPO to start the aw-qt in the clients and to replace the file aw-client.ini with the correct server adress.
After two days we start to experiencing the error database is locked. Googling about it I realized that it was because the number of connection in the server bd.
I read in another app forum that the error was solved changing the journal mode. So i Change the journal mode to journal_mode=WAL in pragma setting and it works, the events are now beeing saved in BD, but I stil can not see the clients, when i hit activity tab, it shows that there isn’t activity reports available.
I also read that when we change the connection to WAL mode we also need to change the DB connection like the example below:
public static class Connection
{
public abstract SQLiteConnection NewConnection(String file);
}
public class NormalConnection : Connection
{
public override SQLiteConnection NewConnection(String file)
{
return new SQLLiteConneciton(“Data Source=” + file);
}
}
public class WALConnection : Connection
{
public override SQLiteConnection NewConnection(String file)
{
return new SQLLiteConnection(“Data Source=” + file + “;PRAGMA journal_mode=WAL;”
}
}
Could someone help me with this ?
I searched in the forum a saw that there’s isn’t another alternative of BD, like MySQL ou MariaDB.