Peter Nixon [Fri, Jul 13, 2007 at 12:57:32PM +0300]:
On Fri 13 Jul 2007, Nico Schottelius wrote:
Hello!
I tried to move our current freeradius 0.9.3 with mysql to a new machine running either 1.1.3 or 1.1.6 with postgresql.
Converting the data was no big deal.
But then I recognized that the sql.conf has wrong quoting for postgresql (was mysql specific). Corrected that.
Thats because you are supposed to use postgresql.conf with postgresql.
Also thought that, but when I installed it from ports (FreeBSD 6.2) I get this: [root@ddba017 /usr/local/etc/raddb]# ls acct_users hints radiusd.conf.working certs huntgroups samples clients.conf old snmp.conf dictionary preproxy_users sql.conf eap.conf proxy.conf users example.pl radiusd.conf So, perhaps the port is broken.
But now I've another problem: When testing, it showed that the queries from 1.1.3 do not fit for the tables I've imported from 0.9.3.
Question: - Can I convert the db automatically? - Are the changes somewhere documentated, so I could convert the db manually?
They are not, but if you can post your existing schema to the list we will try to help you convert it.
That would be pretty good! I attached pg_dump -s -U pgsql radius from the new server that imported the old schema. Nico -- Think about Free and Open Source Software (FOSS). http://nico.schottelius.org/documentations/foss/the-term-foss/ PGP: BFE4 C736 ABE5 406F 8F42 F7CF B8BE F92A 9885 188C