Donate Share

daloRADIUS

The forum address has changed, you have been automatically redirected. Please update any bookmarks to use the new URL.

Subscribe

converting database to pgsql

You are viewing a single message from this topic. View all messages.

  1. 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 ?

< Previous | 1 | Next >

Add a Reply

This forum does not allow anonymous participation.

Log in to add a reply. Not registered? Create an account to participate and receive email updates when replies are posted to this topic.