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@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
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:
Show quoted text
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