[isf-wifidog] database error when installing auth server

[Pascal Leclerc]

The errors come from unwanted postgresql lines during the DB schema dump.
These lines are specific options and can be removed. I'm currently
updating install.php and the lines will be commented out automatically.

In wifidog-postgres-schema.sql file remove these lines :

CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler
    AS '$libdir/plpgsql', 'plpgsql_call_handler'
    LANGUAGE c;

CREATE FUNCTION plpgsql_validator(oid) RETURNS void
    AS '$libdir/plpgsql', 'plpgsql_validator'
    LANGUAGE c;

CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql HANDLER plpgsql_call_handler
VALIDATOR plpgsql_validator;

The new network object broke the installation and many change need to be
done to create the network, default node, first node and the admin user.

I think you should use the previous working snapshot of wifidog-auth or
wait for my update on install.php to continue your installation. You will
hit many more annoying bugs from development changes if you use up to date
cvs code.

  Pascal

> Hi,
>   I'm seeing the following error during the dbinit phase of
> setting up the auth server:
>
> Database initialisation
>
>     * Creating wifidog database schema :
>       Warning: pg_query() [function.pg-query]: Query failed: ERROR: c:
> permission denied in
> /home/roofnet/www/html/wifidog-auth/wifidog/install.php on line
> 910 ERROR: c: permission denied <=
>
> I'm not familiar with postgres, so I'm not sure what to check exactly. I
> verified the password I typed in the form is the same as the one in
> createuser.
>
> The error showed up using PHP 5.0.5, postgres 7.3.4 on a Redhat 9-based
> system.
>
> Thanks,
> Sanjit