How to change the default database port (5432)?

[Julien4135]

Hello, is it possible please to change port 5432 that IDDataLogger uses easily ?
Because I have another application which uses this same port and which creates a conflict with me?

[robske110]

Port 5432 is used by postgresql. You should be able to change it in postgresql.conf and then in the config at db.host you'd need to add ;port=PORTNUMBER to localhost (the full string should be localhost;port=PORTNUM)

To give more specific help, I'd need to know what kind of setup you are running (which Operating System, what installation method did you use).

[robske110]

I would recommend you to add the line DB_PORT=5422 to the .env file (myconfig.env) of VWFriends, restart and then re-attempt installation of IDDataLogger. That should be the easiest option.

[tillsteinbach]

I hope it works I have to admit that I did not test it.

[Julien4135]

Ok I will keep you posted tomorrow morning following the installation that I am going to attempt this evening. I come home late from work around 10 p.m.
Again thanks to you !

[Julien4135]

Good evening so I put it like that in myconfig.env ?

VWSFRIEND_USERNAME=xxx
VWSFRIEND_PASSWORD=xxx
WECONNECT_USER=xxxx
WECONNECT_PASSWORD=xxxx
WECONNECT_PIN=xxxx # Pin is only necessary for some functions, if your car does not support these, the pin can be ignored
WECONNECT_INTERVAL=300
DB_USER=xxxx
DB_PASSWORD=xxxx
DB_PORT=5422
If you don't want to use Apple Homekit you can ignore these settings
The following settings are only used with homekit in macvlan mode
HOMEKIT_INTERFACE=eth0
HOMEKIT_IP=192.168.0.234
HOMEKIT_MASK=192.168.0.0/24
HOMEKIT_GW=192.168.0.1

[Julien4135]

Apartment with this change everything works fine for the moment, after a reboot

[robske110]

This is how to change the port which is used for the postgresql database:

Note1: There is no need to run a second postgresql server just for IDDataLogger, if you already have one running for another application, you can just create a new empty database with a separate user and set that in IDDataLoggers config.

Note2: If you are using VWsFriend (this only applies for setups using the HomeKit docker file) it is easier to simply add DB_PORT=5422 to the myconfig.env file.

If you still want to change the port IDDataLogger uses for its database, you will need to set db.host to localhost;port=5422. (You can replace localhost or the number 5422 if needed)
The relevant part of the config should look like this:

{
	...
	"db": {
		"host": "localhost;port=5422",
		...
	},
	...
}

(You'll also need to adjust the port setting in your relevant postgresql.conf, for debian/raspbian usually at /etc/postgresql/13/main/postgresql.conf)

[Julien4135]

Hello, I apologize for the time to answer but I finally had a lot of conflict (especially with duplicate postgresql servers) by doing my manipulation without really understanding. I came back to the same situation as last time and all of them are working fine on VWsFriend.

For nota 1 if I run the configuration for beginners with the command "" wget https://raw.githubusercontent.com/robske110/IDDataLogger/master/docs/install.sh; bash install.sh; rm install.sh "" I am going to create a second postgresql server, what not to do, if I understood correctly?
Do you have to do with the advanced, more complex solution?

Nota 2 I have modified the myconfig.env file from VWsFriend by modifying all the lines with 5432 and put 5422 in place, then reboot. For the moment no problem with the configuration with VWsFriend, it works as with the 5432 before.

So it remains to know how to create a new empty database with a separate user and define it in the IDDataLoggers configuration ;)

[robske110]

See my comment in #39

[Julien4135]

I still have the problem and I don't understand what to do with answer #39

[robske110]

Please post the output of the commands I posted in discussion #39.

[Julien4135]

[robske110]

Try to re-run the installation script.
wget https://raw.githubusercontent.com/robske110/IDDataLogger/master/docs/install.sh; bash install.sh; rm install.sh
You'll need to reenter username&password of the VW ID account and then answer N to overwriting defaults and Y to update existing configuration.
The script is designed to be run multiple times, it will not duplicate anything.

[Julien4135]

[robske110]

Great! I also fixed the small bug you encountered with the wizard here: 705d3b2

[Julien4135]

Nickel!

[Julien4135]

It's won I managed to meter online as before and everything works as before! Really cool !!!
Is it now complicated to just change the port or do things have to be done at the risk of it not working anymore?

[Julien4135]

Or do I go directly to the installation of VWsFriend?

[robske110]

You can try to change the port of the IDDataLogger database now, if it doesn't work you can always undo your changes.

sudo nano /etc/postgresql/13/main/postgresql.conf
Go to line 64 and change it to PORT = 5464.

Then you need to set db.host to localhost;port=5464 in the config.json of IDDataLogger
The relevant part of the config should look like this:

{
...
"db": {
"host": "localhost;port=5464",
...
},
...
}
Then you'll need to restart your raspberrypi: sudo reboot
Run pg_isready and post the output here.
Then run ./start.sh and see if it still works.