Database issues

Hi Torben

Can you tell me if this is the right set up for a vpn connection ?

First is on the server location

The problem what i did have this afternoon was that i had to rewrite all the settings in the database on the server again. For now the problem is been solved. Is this the right way to do? See attachements

Regards

Goos


mairlist config @ home studio.png

mairlist config on server.jpg

Hard to tell just from two screenshots… But if everything works fine, the configuration seems to be OK :wink:

For the moment it is . I can see the wave forms on my home studio pc . And make overlaps better.

What do you need more to check ?

Or what can i do the best . From next week i am in a new situation on the windows 2008 server. It took a little bit longer because of a delevery of a kvm switch. Can we still use postgress or is it better to switch over to mysql ?

Regards

Goos

MySQL? You probably mean MS SQL. MySQL is not supported (and will not be supported).

Keep using PostgreSQL. It’s better. And you can simply reuse your old database by using dump/restore.

Thanks for the info.

Goos

What would you suggest the best way to share a database between your server and studio be?

Can multiple computers read and write a .db file at once?

Whats the advantage over using eg. MS SQL?

The *.db files are only made for use on a single computer. You will receive lots of “Database is locked” errors when you try to access them from multiple computers at the same time (or even multiple processes on the same computer).

For networked setups, you should use the PostgreSQL backend. (Microsoft SQL Server should work as well but PostgreSQL is recommended.) This requires a bit more setup work, but you end up with a solution that works for an arbitrary number of clients in your network.

Which version of PostgreSQL is Mairlist compatible with eg. Postgresql 8.4 or just 8.0?

Cheers,
Ethan

Postgress 8.3 is working fine here.

9.1 will work as well.