Postgres Pro
Downloads
Home   >   mailing lists

Thread: ANNOUNCE: ShellSQL 0.7

ANNOUNCE: ShellSQL 0.7

From
Edward Macnaghten
Date:
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

Identity Problem

From
"Mike-Olumide Johnson"
Date:
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@mj data]# psql -U
psql: option requires an argument -- U
Try 'psql --help' for more information.
[root@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@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

Re: Identity Problem

From
Edward Macnaghten
Date:
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@mj data]# psql -U
> psql: option requires an argument -- U
> Try 'psql --help' for more information.
> [root@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@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@postgresql.org
>