2009-07-22 19:54:13 UTC
Hi
The postgresql databases in the contrib/db dont seem to be complete.
So I'm trying to convert / import the mysql db ..
I have never worked with postgresql before so it's all new to me ..
Can someone help with this error
Database error
Error Message: DB Error: no such table
Debug info: SELECT distinct(radcheck.username),radcheck.value, radcheck.id,usergroup.groupname as groupname, radcheck.attribute, userinfo.firstname, userinfo.lastname FROM radcheck LEFT JOIN userinfo ON radcheck.username=userinfo.username LEFT JOIN usergroup ON radcheck.username=usergroup.username WHERE (Attribute LIKE '%-Password') OR (Attribute='Auth-Type') GROUP BY UserName [nativecode=ERROR: relation "usergroup" does not exist]
How do I figure out the relationships in mysql so I can create the in pgsql
how do I create relationships ?