Обсуждение: 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: > 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 >