ANNOUNCE: ShellSQL 0.7

Hi

Announcing ShellSQL 0.7 to an unsuspecting world...

ShellSQL is a utility to allow SQL to be intergrated easily into
UNIX/LINUX shell scripts.

The web page is at http://www.edlsystems.com/shellsql - and at
sourceforge at http://sourceforge.net/projects/shellsql .

Version 0.7 includes many bug fixes and tidy ups. A new utility to
import a file into a table (or use it to update tables), more
input/output formats (CSV, Tab delimited etc) and a new engine (freetds
for MS-SQL/Sybase engines) - (The Postgres engine was one of the
originals there).

Enjoy

Eddy Macnaghten

Hello,

Have RADIUS setup and working properly.

While executing SQL got the following error:

'psql: Warning: The -u option is deprecated. Use -U. User name: Password:
/root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_pos
tgresql.sql: Permission denied'

Below is further ouputs from CLI

root(at)mj data]# psql -U
psql: option requires an argument -- U
Try 'psql --help' for more information.
[root(at)mj data]# psql -u
psql: Warning: The -u option is deprecated. Use -U.
User name: root
Password:
psql: FATAL: Database "root" does not exist in the system catalog.
[root(at)mj data]# psql -u
psql: Warning: The -u option is deprecated. Use -U.
User name: postgres
Password:
psql: FATAL: IDENT authentication failed for user "postgres"

Will appreciate if someone can point me to how this problem could be
resolved.

Thanks in anticipation,
Mike

It looks as though you need to create your database users.

Try using the "createuser" command.

For more information:
http://www.postgresql.org/docs/7.4/interactive/user-manag.html

Eddy

Mike-Olumide Johnson wrote:
> Hello,
>
> Have RADIUS setup and working properly.
>
> While executing SQL got the following error:
>
> 'psql: Warning: The -u option is deprecated. Use -U. User name: Password:
> /root/freeradius-1.0.1/src/modules/rlm_sql/drivers/rlm_sql_postgresql/db_pos
> tgresql.sql: Permission denied'
>
> Below is further ouputs from CLI
>
> root(at)mj data]# psql -U
> psql: option requires an argument -- U
> Try 'psql --help' for more information.
> [root(at)mj data]# psql -u
> psql: Warning: The -u option is deprecated. Use -U.
> User name: root
> Password:
> psql: FATAL: Database "root" does not exist in the system catalog.
> [root(at)mj data]# psql -u
> psql: Warning: The -u option is deprecated. Use -U.
> User name: postgres
> Password:
> psql: FATAL: IDENT authentication failed for user "postgres"
>
> Will appreciate if someone can point me to how this problem could be
> resolved.
>
> Thanks in anticipation,
> Mike
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>