[GENERAL] CREATE USER and ODBC
Hi, Sorry if this has allready been sent, but Ive not received it from the list. I seem not to able to create a user through ODBC (through MFC classes). What I use is "CDatabase::ExecuteSQL( "CREATE USER jarmo WITH PASSWORD 'myPass'" );" PostgreSQL complains that it can not create users inside a transaction (no transaction is active, unless the ODBC driver creates one). And Ive logged in as a superuser. PostgreSQL 7.0.2 (Linux) and ODBC driver 6.5 (Win98). // Jarmo PS. Ive followed this list for a while and... Is PostgreSQL more buggy and harder to port to than mySQL, or is it just that Im not subscribed to mySQL problem lists. DS.
[GENERAL]
Hi, Scuseme for theOT. I'm interesting to obtain an effect like with ALT= in the image tag, but in a link like a Href="hrttp://eccecc"link/a There is a solution in Javascript ? Thanks, Enrico
[GENERAL] Cant create new users or databases
Can someone point out to me what I am doing wrong here? I can't seem to find this in the documentation anywhere. [root@alphabyte abyte]# createuser abyte Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y NOTICE: mdopen: couldn't open /var/lib/pgsql/pg_shadow: Permission denied NOTICE: RelationIdBuildRelation: smgropen(pg_shadow): Permission denied NOTICE: mdopen: couldn't open /var/lib/pgsql/pg_shadow: Permission denied NOTICE: mdopen: couldn't open /var/lib/pgsql/pg_shadow: Permission denied psql: FATAL 1: cannot open relation pg_shadow createuser: creation of user "abyte" failed Ta Alan -- AlphaByte: PO Box 1941, Auckland, New Zealand Specialising in:Graphic Design, Education and Training, Technical Documentation, Consulting. http://www.alphabyte.co.nz
Re: [GENERAL] Cant create new users or databases
On Sat, 16 Sep 2000, AlphaByte wrote: Can someone point out to me what I am doing wrong here? I can't seem to find this in the documentation anywhere. [root@alphabyte abyte]# createuser abyte Shall the new user be allowed to create databases? (y/n) y Shall the new user be allowed to create more new users? (y/n) y NOTICE: mdopen: couldn't open /var/lib/pgsql/pg_shadow: Permission denied NOTICE: RelationIdBuildRelation: smgropen(pg_shadow): Permission denied NOTICE: mdopen: couldn't open /var/lib/pgsql/pg_shadow: Permission denied NOTICE: mdopen: couldn't open /var/lib/pgsql/pg_shadow: Permission denied psql: FATAL 1: cannot open relation pg_shadow createuser: creation of user "abyte" failed It appears that you are logged in as "root". I think that you need to login as "postgres" to do the first "creatuser" command. When PostgreSQL is first installed, the only valid user is "postgres" and is the equivalent to UNIX's "root" (superuser). It has been a while, but as I recall, when I installed PostgreSQL, this is what I had to do. I logged in as "postgres", did a "creatuser" for my "normal" (non-root) userid. This userid was allowed to create new users and databases. Since then, I have used my "normal" userid to do all the PostgreSQL maintenance activities. You may need to do something slightly different if you have multiple users. I am the only one using my Linux system at present. I hope this helps some, John
[GENERAL] os.h
Where is the misterious "os.h" located that is required when I try to use libpq++ ??? It is not included in the 7.02 packages (neither source nor binary packages). There are no problems / error messages when using just libpq. The other misteriously missing file seems to be "Makefile.global" when trying to make the examples coming with the "test" package. Did I miss an important README? (Thought I had read them all) Horst
Re: [GENERAL] CREATE USER and ODBC
PS. Ive followed this list for a while and... Is PostgreSQL more buggy and harder to port to than mySQL, or is it just that Im not subscribed to mySQL problem lists. DS. I'm not subscribed to mySQL's lists either, so I won't venture a comparison. But reading a mailing list just naturally gives you an inflated perception of the amount of trouble people run into. After all, people who *aren't* having trouble have little reason to post about it. So I think it'd be a big mistake to draw any such conclusion based on reading only one project's lists. regards, tom lane
Re: [GENERAL] Cant create new users or databases
AlphaByte [EMAIL PROTECTED] writes: NOTICE: mdopen: couldn't open /var/lib/pgsql/pg_shadow: Permission denied NOTICE: RelationIdBuildRelation: smgropen(pg_shadow): Permission denied Hmm. What user is the postmaster running as? (Look in ps -aux output if you're not 100% sure.) What are the permissions on the file /var/lib/pgsql/pg_shadow, and what userid owns it? regards, tom lane
Re: [GENERAL] os.h
Horst Herb wrote: Where is the misterious "os.h" located that is required when I try to use libpq++ ??? It is not included in the 7.02 packages (neither source nor binary packages). There are no problems / error messages when using just libpq. The other misteriously missing file seems to be "Makefile.global" when trying to make the examples coming with the "test" package. Did I miss an important README? (Thought I had read them all) Horst As I understand os.h should be in postgres include directory and it's just symlink on proper include file for your os from directory "port" For example on debian linux it must be in /usr/include/postgresql directory and it's symlink on .././port/linux.h. But when I made posgresql-dev debian package from sources I got an error "os.h: now such file ..." Therefore I've created package without this file and then after installation I've copied file src/include/port/linux.h from postgresql sources into /usr/include/postgresql/os.h. So if the file os.h is absent in postgresql include directory on your system take proper include file from src/include/port from postgresql sources and copy it as os.h -- Sincerely yours, Yury
Re: [GENERAL] os.h
On Sun, 17 Sep 2000, Horst Herb wrote: Where is the misterious "os.h" located that is required when I try to use libpq++ ??? It is not included in the 7.02 packages (neither source nor binary packages). There are no problems / error messages when using just libpq. The other misteriously missing file seems to be "Makefile.global" when trying to make the examples coming with the "test" package. Did I miss an important README? (Thought I had read them all) Horst I have that file in the /usr/include/pgsql/ directory. I run RedHat and installed PostgreSQL from the RPMs. That file is in postgresql-devel-7.0.2-2 . I don't know where it might be in some other distribution (such as the tarball). John