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: [EMAIL PROTECTED] /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
-- -- PostgreSQL database dump -- SET client_encoding = 'SQL_ASCII'; SET check_function_bodies = false; SET SESSION AUTHORIZATION 'pgsql'; -- -- TOC entry 4 (OID 2200) -- Name: public; Type: ACL; Schema: -; Owner: pgsql -- REVOKE ALL ON SCHEMA public FROM PUBLIC; GRANT ALL ON SCHEMA public TO PUBLIC; SET SESSION AUTHORIZATION 'pgsql'; SET search_path = public, pg_catalog; -- -- TOC entry 5 (OID 1443969) -- Name: dictionary_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE dictionary_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 15 (OID 1443971) -- Name: dictionary; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE dictionary ( id integer DEFAULT nextval('dictionary_id_seq'::text) NOT NULL, "Type" character varying(30), "Attribute" character varying(32), "Value" character varying(32), "Format" character varying(20), "Vendor" character varying(32) ); -- -- TOC entry 6 (OID 1444215) -- Name: hints_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE hints_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 16 (OID 1444217) -- Name: hints; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE hints ( id integer DEFAULT nextval('hints_id_seq'::text) NOT NULL, "HintName" character varying(32) DEFAULT ''::character varying NOT NULL, "GroupName" character varying(32) DEFAULT ''::character varying NOT NULL ); -- -- TOC entry 7 (OID 1444224) -- Name: nas_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE nas_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 17 (OID 1444226) -- Name: nas; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE nas ( id integer DEFAULT nextval('nas_id_seq'::text) NOT NULL, nasname character varying(128), shortname character varying(32), ipaddr character varying(15), "type" character varying(30), ports integer, secret character varying(60), community character varying(50), snmp character varying(10) ); -- -- TOC entry 8 (OID 1444241) -- Name: online_stats_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE online_stats_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 18 (OID 1444243) -- Name: online_stats; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE online_stats ( id integer DEFAULT nextval('online_stats_id_seq'::text) NOT NULL, username character varying(30), tstamp timestamp without time zone, mailed integer ); -- -- TOC entry 9 (OID 1445727) -- Name: radacct_radacctid_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE radacct_radacctid_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 19 (OID 1445729) -- Name: radacct; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE radacct ( "RadAcctId" integer DEFAULT nextval('radacct_RadAcctId_seq'::text) NOT NULL, "AcctSessionId" character varying(32) DEFAULT ''::character varying NOT NULL, "AcctUniqueId" character varying(32) DEFAULT ''::character varying NOT NULL, "UserName" character varying(64) DEFAULT ''::character varying NOT NULL, "Realm" character varying(64) DEFAULT ''::character varying, "NASIPAddress" character varying(15) DEFAULT ''::character varying NOT NULL, "NASPortId" integer, "NASPortType" character varying(32), "AcctStartTime" timestamp without time zone DEFAULT '2006-05-12 12:09:44'::timestamp without time zone, "AcctStopTime" timestamp without time zone DEFAULT '2006-05-12 12:09:44'::timestamp without time zone, "AcctSessionTime" integer, "AcctAuthentic" character varying(32), "ConnectInfo_start" character varying(32), "ConnectInfo_stop" character varying(32), "AcctInputOctets" integer, "AcctOutputOctets" integer, "CalledStationId" character varying(10) DEFAULT ''::character varying NOT NULL, "CallingStationId" character varying(10) DEFAULT ''::character varying NOT NULL, "AcctTerminateCause" character varying(32) DEFAULT ''::character varying NOT NULL, "ServiceType" character varying(32), "FramedProtocol" character varying(32), "FramedIPAddress" character varying(15) DEFAULT ''::character varying NOT NULL, "AcctStartDelay" integer, "AcctStopDelay" integer ); -- -- TOC entry 10 (OID 1743315) -- Name: radcheck_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE radcheck_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 20 (OID 1743317) -- Name: radcheck; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE radcheck ( id integer DEFAULT nextval('radcheck_id_seq'::text) NOT NULL, "UserName" character varying(64) DEFAULT ''::character varying NOT NULL, "Attribute" character varying(32) DEFAULT ''::character varying NOT NULL, "Value" character varying(253) DEFAULT ''::character varying NOT NULL, op character(2) ); -- -- TOC entry 11 (OID 1743364) -- Name: radgroupcheck_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE radgroupcheck_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 21 (OID 1743366) -- Name: radgroupcheck; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE radgroupcheck ( id integer DEFAULT nextval('radgroupcheck_id_seq'::text) NOT NULL, "GroupName" character varying(64) DEFAULT ''::character varying NOT NULL, "Attribute" character varying(32) DEFAULT ''::character varying NOT NULL, "Value" character varying(253) DEFAULT ''::character varying NOT NULL, op character(2) ); -- -- TOC entry 12 (OID 1743374) -- Name: radgroupreply_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE radgroupreply_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 22 (OID 1743376) -- Name: radgroupreply; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE radgroupreply ( id integer DEFAULT nextval('radgroupreply_id_seq'::text) NOT NULL, "GroupName" character varying(64) DEFAULT ''::character varying NOT NULL, "Attribute" character varying(32) DEFAULT ''::character varying NOT NULL, "Value" character varying(253) DEFAULT ''::character varying NOT NULL, op character(2), prio integer DEFAULT 0 NOT NULL ); -- -- TOC entry 13 (OID 1743403) -- Name: radreply_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE radreply_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 23 (OID 1743405) -- Name: radreply; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE radreply ( id integer DEFAULT nextval('radreply_id_seq'::text) NOT NULL, "UserName" character varying(64) DEFAULT ''::character varying NOT NULL, "Attribute" character varying(32) DEFAULT ''::character varying NOT NULL, "Value" character varying(253) DEFAULT ''::character varying NOT NULL, op character(2) ); -- -- TOC entry 14 (OID 1743458) -- Name: usergroup_id_seq; Type: SEQUENCE; Schema: public; Owner: pgsql -- CREATE SEQUENCE usergroup_id_seq START WITH 1 INCREMENT BY 1 NO MAXVALUE NO MINVALUE CACHE 1; -- -- TOC entry 24 (OID 1743460) -- Name: usergroup; Type: TABLE; Schema: public; Owner: pgsql -- CREATE TABLE usergroup ( id integer DEFAULT nextval('usergroup_id_seq'::text) NOT NULL, "UserName" character varying(64) DEFAULT ''::character varying NOT NULL, "GroupName" character varying(64) DEFAULT ''::character varying NOT NULL ); -- -- TOC entry 36 (OID 1445745) -- Name: radacct_UserName_idx; Type: INDEX; Schema: public; Owner: pgsql -- CREATE INDEX "radacct_UserName_idx" ON radacct USING btree ("UserName"); -- -- TOC entry 33 (OID 1445746) -- Name: radacct_FramedIPAddress_idx; Type: INDEX; Schema: public; Owner: pgsql -- CREATE INDEX "radacct_FramedIPAddress_idx" ON radacct USING btree ("FramedIPAddress"); -- -- TOC entry 29 (OID 1445747) -- Name: radacct_AcctSessionId_idx; Type: INDEX; Schema: public; Owner: pgsql -- CREATE INDEX "radacct_AcctSessionId_idx" ON radacct USING btree ("AcctSessionId"); -- -- TOC entry 32 (OID 1445748) -- Name: radacct_AcctUniqueId_idx; Type: INDEX; Schema: public; Owner: pgsql -- CREATE INDEX "radacct_AcctUniqueId_idx" ON radacct USING btree ("AcctUniqueId"); -- -- TOC entry 30 (OID 1445749) -- Name: radacct_AcctStartTime_idx; Type: INDEX; Schema: public; Owner: pgsql -- CREATE INDEX "radacct_AcctStartTime_idx" ON radacct USING btree ("AcctStartTime"); -- -- TOC entry 31 (OID 1445750) -- Name: radacct_AcctStopTime_idx; Type: INDEX; Schema: public; Owner: pgsql -- CREATE INDEX "radacct_AcctStopTime_idx" ON radacct USING btree ("AcctStopTime"); -- -- TOC entry 34 (OID 1445751) -- Name: radacct_NASIPAddress_idx; Type: INDEX; Schema: public; Owner: pgsql -- CREATE INDEX "radacct_NASIPAddress_idx" ON radacct USING btree ("NASIPAddress"); -- -- TOC entry 25 (OID 1443974) -- Name: dictionary_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY dictionary ADD CONSTRAINT dictionary_id_key UNIQUE (id); -- -- TOC entry 26 (OID 1444222) -- Name: hints_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY hints ADD CONSTRAINT hints_id_key UNIQUE (id); -- -- TOC entry 27 (OID 1444229) -- Name: nas_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY nas ADD CONSTRAINT nas_id_key UNIQUE (id); -- -- TOC entry 28 (OID 1444246) -- Name: online_stats_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY online_stats ADD CONSTRAINT online_stats_id_key UNIQUE (id); -- -- TOC entry 35 (OID 1445743) -- Name: radacct_RadAcctId_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY radacct ADD CONSTRAINT "radacct_RadAcctId_key" UNIQUE ("RadAcctId"); -- -- TOC entry 37 (OID 1743323) -- Name: radcheck_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY radcheck ADD CONSTRAINT radcheck_id_key UNIQUE (id); -- -- TOC entry 38 (OID 1743372) -- Name: radgroupcheck_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY radgroupcheck ADD CONSTRAINT radgroupcheck_id_key UNIQUE (id); -- -- TOC entry 39 (OID 1743383) -- Name: radgroupreply_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY radgroupreply ADD CONSTRAINT radgroupreply_id_key UNIQUE (id); -- -- TOC entry 40 (OID 1743411) -- Name: radreply_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY radreply ADD CONSTRAINT radreply_id_key UNIQUE (id); -- -- TOC entry 41 (OID 1743465) -- Name: usergroup_id_key; Type: CONSTRAINT; Schema: public; Owner: pgsql -- ALTER TABLE ONLY usergroup ADD CONSTRAINT usergroup_id_key UNIQUE (id); -- -- TOC entry 3 (OID 2200) -- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: pgsql -- COMMENT ON SCHEMA public IS 'Standard public schema';
signature.asc
Description: Digital signature
- List info/subscribe/unsubscribe? See http://www.freeradius.org/list/users.html