Re: [mail] Re: [HACKERS] Windows Build System
- Original Message - From: Justin Clift [EMAIL PROTECTED] To: Curt Sampson [EMAIL PROTECTED] Cc: Peter Eisentraut [EMAIL PROTECTED]; Curtis Faith [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, February 02, 2003 4:42 AM Subject: Re: [mail] Re: [HACKERS] Windows Build System + It would be greatly helpful to have some way for the install program to automatically add the Log in as a service Win32 priviledge to the postgres user without having to instruct the user to do so. We can create the user automatically through a shell command, but no idea how to add that permission. If someone could do some Win32 API stuff to do it behind the scenes without a shell command even, that would be great. + The WinMaster project is a first go at creating a Win32 GUI command console for controlling the PostgreSQL service. It's still a bit too basic for real use though: http://gborg.postgresql.org/project/winmaster/projdisplay.php Further suggestions, volunteers, etc are totally welcome. :-) Regards and best wishes, Justin Clift It's still a bit too basic for real use though: Yeah i know. I write this for my internal use. Initial purpose of this stuff is only to avoid teaching of an old lady with minimum computer skills to use bash and hide this ugly dos box :) Mark L. Woodward (mlw) anounce few monts ago a self installing PostgreSQL for Windows so i write him about this console. He do a lof job to. Special thanks Mark. OK, now how to make WinMaster more usefull ? It's open source so if any1 want use it he/she may help to develop it. I. Install as a service feature for winmaster are included in my plans for future. II.I'm thinking about direct link to PostgreSQL server instead usung CreateProcess, but this is unclear idea at present time. Any suggestions will be welcome. IIIPlease add any feature rquests to http://gborg.postgresql.org/project/winmaster/bugs/buglist.php?fr=yes and ideas to mailto:[EMAIL PROTECTED] Justin you are right !!! Further suggestions, volunteers, etc are totally welcome!!! Further suggestions, volunteers, etc are totally welcome!!! Further suggestions, volunteers, etc are totally welcome!!! --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/2003 ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
Re: [HACKERS] [mail] Re: Win32 port patches submitted
http://www.janwieck.net/win32_port/notes.win32-ports.txt How to compile this Win32 port 1) Requirements and 1-time settings: 1.1) Visual C++ You need VC++ 6.0 on ServicePack 5. Oooh no, not MS stuff plz :( Dev-Cpp is cool open source IDE, tha using a mingw port of gcc. http://www.bloodshed.net/ - Original Message - From: Jan Wieck [EMAIL PROTECTED] To: Emmanuel Charpentier [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 1:03 AM Subject: Re: [HACKERS] [mail] Re: Win32 port patches submitted Emmanuel Charpentier wrote: Mingw and mingw-ported tools ? That's a nice small and cozy unix-like envoronment on tom of Windows. Add it emacs, and windoww becomes almost tolerable ... How good is the debugging support under mingW? Is it at least comparable to using gdb under unix? If not, you might find yourself all of the sudden out in cold ... Jan ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster
Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group
- Original Message - From: Devrim GÜNDÜZ [EMAIL PROTECTED] To: PostgreSQL-development [EMAIL PROTECTED] Sent: Saturday, December 14, 2002 4:58 PM Subject: Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group Also, I have something to say about win32 port. I'm a Linux user. I'm happy that PostgreSQL does not have win32 version. If someone wants to use a real database server, then they should install Linux (or *bsd,etc). This is what Oracle offers,too. Native Windows support will cause some problems; such as some dummy windows users will begin using it. I do not believe that PostgreSQL needs native windowz support. Ooops. I'm a Linux user too, but i have a SCO Openserver, UnixWare, Netware and lot of windows boxes in my office. Also I have Informix, Sybase ... etc. This isn't for my entertainment. Our customers need to use a real database server. But what about small business? A lot of our small customers can't spent money for dedicated linux box :((( I spent 2 month in trying open source databases (PostgreSQL, SAP DB, Interbase/Firebird) finaly i choose PostgreSQL. Now we port one of our products from Sybase SQL Anywhere to PostgreSQL. We have more than 100 customers with small networks (2-10). Most of them cant't aford dedicated linux box. Another situation DHL Bulgaria and TNT Worldwide Express Bulgaria are our customers too. In HQ they choose windows nt (i don't comment how smart is this decision), pay a lot of money to mr.Gates and now what - we say PostgreSQL is great , but .. ( and i have personal contacts with their sysadmins i don't believe they are dummy windows users) So if you don't want windows support just don't use it! ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org
[HACKERS] Postmaster windows shell
- Original Message - From: mlw To: Igor Georgiev Cc: [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 6:52 PM Subject: Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell) Hey this is a cool project. I have been thinking doing the exact ame thing, the console Window of 2K/XP just kills the daemon, yuck.What can I do to help? - Original Message - From: "Justin Clift" [EMAIL PROTECTED] To: "Igor Georgiev" [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, December 05, 2002 11:32 PM Subject: Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell) Hi Igor, This would be a really good thing to get into GBorg as a project, so people could work on this through CVS. Would you like to register it as a project? Mark, do you feel it would be better to put your installer plus this together into one project on GBorg too? Not sure, it's just a thought. Was [Re: Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell)] Justin : Current active projects: Project Role winmaster(awaiting approval) Admin WinMaster - windows console for PostgreSQL mlw: I am working on a HOWTO, a set of Windows batch files, and the install scripts I would be glad to post, and I would be very glad to include Igor's console in the install. It would make a cool offering. Its Ok 4 me. Unfortunately i havent Windows 2K/XP so i can't test it :(. I can send u source if u wish.
Re: [HACKERS] Postmaster windows shell
- Original Message - From: Igor Georgiev To: mlw Sent: Friday, December 06, 2002 4:57 PM Subject: Re: Postmaster windows shell - Original Message - From: "mlw" [EMAIL PROTECTED] To: "Igor Georgiev" [EMAIL PROTECTED] Sent: Friday, December 06, 2002 3:43 PM Subject: Re: Postmaster windows shell Yea, send it. Is it GPL? I justreceive approvalfrom gborg. This project is released under the Mozilla Public License (MPL). http://gborg.postgresql.org/project/winmaster/projdisplay.php but with my zero expirience with cvs i dont upload nothing yet :((( any help be welcome :) hereis raw source with Dev-C++ project Does it compile under cygwin or MSC? (I have both) mingw, but i thin it will run wtoh -mno-cygwin
Re: [HACKERS] Shrinkwrap Windows Product, any issues? Anyone? (postmaster windows shell)
I am working on getting a shrink-wrapped version of PostgreSQL for WindowsCurrently it installs a customized version of Cygwin, PostgreSQL 7.2.3, cygipc, psqlodbc, and pgadminIII currently have the setup done. Cool :) I'm now working on postmaster windows shell. It's not finished yet but main things work. Funcionality implemented now is : Console redirection for capture output from postmaster Starting-stoping postmaster Choose for shutdown mode System tray icon Postmaster options are read from registry -postmaster path -datadir -additional options Funcionality not implementedyet, but planned: Writing captured output from postmaster to log file Options setup dialog Edit pg_hba.conf ??? Application is MFC free pure windows API (compiler:gcc-mingw, Dev-C++ IDE) . Here is the screenshot I also be GLAD to read about plans for native windows port in 7.4. If anyone is interested i can post source code, or maybe this firrst steps can go to gborg as a separate project i'm not sure yet. PS: Excuse me for my english, I'm better in C :)
Re: [HACKERS] 7.4 Wishlist
Native Windows port Plz don't forget poor victims of Microsoft !!!
Re: [HACKERS] Security question : Database access control
Next your going to ask what will stop root from stopping your PostgreSQL, compiling a second copy with authentication disabled and using your data directory as it's source :) He he somebody can blow up ur home with C4, but this don't stop you from locking ur door !?! ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])
[HACKERS] Security question : Database access control
Is there any way to prevent superuser to acces the database ? I mean something like "GRANT / REVOKE CONNECT" MECHANISM I have no idea how to prevent root from access data in one of this ways : root @ linux:~#su - postgres postgres @ linux:/usr/local/pgsql/bin$pg_dump or edit pg_hba.conf # Allow any user on the local system to connect to any # database under any username, but only via an IP connection: host all 127.0.0.1 255.255.255.255 trust # The same, over Unix-socket connections: local all trustor my nightmare a cygwin on Win 98 everybody can can access everything :-
Re: [HACKERS] Security question : Database access control
edit *pg_hba.conf * # Allow any user on the local system to connect to any # database under any username, but only via an IP connection: host all 127.0.0.1 255.255.255.255 trust # The same, over Unix-socket connections: local all trust what about reading pg_hba.conf comments? local all md5 Ok, but my question actually isn't about pg_hba.conf comments, i read enough but what will stop root from adding this lines or doing su - postgres ??
Re: [HACKERS] [ADMIN] Security question : Database access control
They can just read the raw database files as well. wow I'm not sure how about this edit pg_hba.conf # Allow any user on the local system to connect to any # database under any username local all trust su - posgres psql test -U dba or pg_dump test You have to be able to trust whoever has root access to the system, as well as anyone who has physical access to the system.
Re: [HACKERS] Security question : Database access control
Next your going to ask what will stop root from stopping your PostgreSQL, compiling a second copy with authentication disabled and using your data directory as it's source :) He he i'm enough paranoic :)) If you want to prevent root from accomplishing these things, you're going to have to look to your kernel for help. The kernel must prevent root from changing users, starting / stopping applications, or touching certain filesystems. PostgreSQL will let you put a password on the data. But that only works if they actually try to use PostgreSQL to get at the data. use PostgreSQL to get at the data -Yeah this will be enough i want just only REVOKE CONNECT PRIVILEGES on database
[HACKERS] COPY FROM recognize \xDD sequence - addition to copy.c idea 4 developers
1. Why i do this: I try to migrate a database with a 200 tables from Sybase SQL Anywhere to PostgreSQL, but SQL Anywhere escapes special characters like a HEX values ( like \x0D \x2C . ). PostgreSQL COPY FROM recognize only OCT values ( lie \001 ... ) 2. How-to it' easy :))) 2.1 - Open $UrSourceDir/src/backend/commands/copy.c 2.2 - Add #include ctype.h in te begining 2.3 find function static char * CopyReadAttribute(FILE *fp, bool *isnull, char *delim, int *newline, char *null_print) /**/ /* Add this code before it */ static int HEXVALUE( int c ) { if (isdigit(c)) { c -= '0'; } else { if (islower(c)) c= c-'a'+10; else c= c-'A'+10; } return(c); } 2.4 in body of CopyReadAttribute find this code and modify it like this if (c == '\\') { c = CopyGetChar(fp); if (c == EOF) goto endOfFile; switch (c) { /*-- Here is my additional code --*/ case 'x': case 'X': { int val; CopyDonePeek(fp, c, true /*pick up*/); /* Get x always */ c = CopyPeekChar(fp); /* Get next */ if (isxdigit(c)) { val = HEXVALUE(c); c = CopyPeekChar(fp); if (isxdigit(c)) { val = (val 4) + HEXVALUE(c); CopyDonePeek(fp, c, true /*pick up*/); } else { if (c == EOF) goto endOfFile; CopyDonePeek(fp, c, false /*put back*/); } } else { if (c == EOF) goto endOfFile; CopyDonePeek(fp, c, false /*put back*/); } c = val; } break; /*--End of myadditional code --*/ case '0': case '1': case '2': case '3': case '4': case '5': case '6': case '7': { int val; val = OCTVALUE(c); 2.4 he he now make , make install 3. An idea to developers : maybe u include this addition to COPY in future releases 10x P.S. Excuse me for my English ( i'm better in C :)