kb7sqi mentioned that someone had built postgresql on NS. I gave it a try and with some modifications PostgreSQL 8.3.6 builds on NS3.3 I've only tested it to some extent and it seems to work even though I think it might need some more work. There are some problems with supporting locale other than the standard "C" locale. I don't know much about the locale sopport in NS-3.3 in general so this might be hard to fix.
Anyways, PHP-5 now builds linked against the client library from postgresql 8.3.6 which at least in theory means that one could run a forum like this with Apache/PHP/PostgreSQL with everything entirely on a NEXSTSTEP platform. Maybe this could actually work on the fastest possible i386 box? :D
I've tried the phpBB3 forum-engine but it requres a database that supports locale UTF8 or UNICODE. At least for now I can't do this with postgres on NS3.3. phpBB2 seems to accept databases based on the C locale but there seems to be something else that gives me trouble, haven't really given it a chance though so maybe it not that hard to make it run.
Way to go Magnus! Have I mentioned lately you rock? 8) I downloaded the last 7.x release & was going to mess w/ that this weekend. I guess there's no need. lol. I look forward to playing around w/ all this "new" stuff. Been a busy couple of weeks at work, but I'm hoping this weekend is quiet. Take care.
Well, thanks!
It seems like the phpBB v2 and v3 software works with php4/apache on OpenSTEP. I
m running the PostgreSQL server on my NetBSD/sparc64 box and phpBB3 is running om my OpenSTEP/sparc. However I'm having some problems with postgresql on openstep, some things don't work in the database server, I'm no database expert but I'll se what I can do, would be nice to be able to run everything in a nexstep environment.
Which problems do you have with PostgreSQL on OPENSTEP? I ported PG 7.4.9 to NS 3.3 and OS 4.2. The OS port needed some work with the dynloader, but I think, it worked with the Darwin code (don't remember now, what exactly I modified). My ports are on kb7sqi's server.
Hi!
I'll grab your code and have a look! Tanks! The problems seems to be that, for exampel, when I run the phpBB2 forum I can install the forum, I can add a new "topic" but I can not enter a new post into that topic and if I try it twice I get an error message that some entry in the database already exists. Also after a while I get an error message from the sql server that some backgrund job timed out while trying to start. I can't really say what the problem is exactly, but the phpBB code seemes to work when I run the database under NetBSD...
Did you run the regression test suite of the PG distribution? It can be started with gmake (gnumake) check, I think. You should find it under src/test/regress. When I ran this in my NS 3.3 port, I discovered some problems, although the code compiled and I was able to use the database. But some functions did not work properly, which I found with test suite and solved it.
I haven't checked the 8.3 code, so I don't know, if it's still like this.
If you would provide me your 8.3 port, I could test it in my OS 4.2 (don't have NS 3.3 available for now) and see, if I can reproduce some problems.
I did run the "make check" routine, it didn't wanna complete the tests since there was no perl module comiled, I did tell the configure-script not to build a perl module so I don't know why I can run the tests.
I've downloaded your build and I've built it for NS3.3, when linking it complains that the function "strxfrm" is missing. do you have that function in an external library that you link against?
I'm thinking that maybe something is messed up in my build environment, because now when I try to build postgres8 I get "Memory Fault" and the compile stops, yesterday I managed to build the very same source. I'll upload my postgres8 source as soon I figured out whats going on...
strxfrm is defined in src/backend/port/nextstep/port.c. It should automatically being added, when the platform is "nextstep" (set in variable PORTNAME in Makefile.global). You should find it in src/backend/port/SUBSYS.o. Can you check with "nm SUBSYS.o", if it's there?
Can you send me the output, when you execute gnumake (or gmake)?
Ok, thanks, I'll look for strxfrm and try to figure out why it's not being built.
In the directory
postgresql-8.3.6/src/bin/psql
I type:
gmake
and then I get:
Segmentation fault
I think it is the gmake executable itself that segfaults. I use GNU Make 3.81
It could also be a program, which has been executed by gmake. You could try to start gmake -d to get some additional output. You might see, where it actually fails.
I noticed that if I enter the src/bin/psql and do
rm *.o
I can build psql again, after it is built I cannot run gmake in that directory anymore, until I remove al .o files, strange!
Without seeing the output of your make command, I don't know, what could be the reason for this. You might check the authorities of the files and the psql directory, but I doubt, this is the reason for this.
There is no output what so ever from gmake, I type "gmake" at the prompt inside the /src/bin/psql directory and all I get is "segmentation fault". Quite strange I will tar gzip the source tree and upload it to kb7sqi as soon as I have the chance, maybe if you have the time you can try is on another platform, maybe its just gmake that has problems on sparc?
Have you tried to call "gmake -d"? It should give some debugging output.
I've uploaded the postgresql-8 source to kb7sqi it's in the from-linmag7 directory. The source compiles with NS 3.3 dev kit. I think it should be possible to do a configure if you want to, it should still build. There might be problems with inline assembly if you're not on sparc, I haven't tried to compile it for any other architecture. It's configured to link against libxml2 ans ssl you can find those libs on kb7sqi's site.
The build works to some extent, but not all database operations work, running phpBB2 complains on duplicate entries in the database, same php-code works when I run the database server on NetBSD so I suspect there is something wrong with the port but you never know... also the server seems to "hang" after a few hours, it doen't hang completely but it complains about some sub-process timing out or something... let me know if you figure somethin out
Thanks, I will check. I only have an OS 4.2 system available, so I my version might differ from yours, but I will see, what happens. Unfortunately, my time is currently very limited, so this might take some time.
I've spent some time with gdb over the last couple of days and managed to identify and work around the bugs I mentioned earlier. I now have postgresql 8 up and running and it seems pretty stable. I've set up an apache/php/posgresql environment and I've tested it by running a forum (phpBB2) in the test environment and it seems to work fine.
This means, for instance, that this forum could be run entirely on OpenSTEP and most likely on NeXTSTEP as well. :D I'll try to build a quad-fat package for postgresql-8 and upload it to kb7sqi as soon as possible.
Quote from: "linmag7"I've spent some time with gdb over the last couple of days and managed to identify and work around the bugs I mentioned earlier. I now have postgresql 8 up and running and it seems pretty stable. I've set up an apache/php/posgresql environment and I've tested it by running a forum (phpBB2) in the test environment and it seems to work fine.
This means, for instance, that this forum could be run entirely on OpenSTEP and most likely on NeXTSTEP as well. :D I'll try to build a quad-fat package for postgresql-8 and upload it to kb7sqi as soon as possible.
Once again Magnus, you ROCK! 8) I'm sure I'm not the only one looking forward to using it. Take care.
Well, thanks!
The quad-fat package might take some time though, lots of assembly stuff that's different for the four archs and the source tree seems to be set up in a way that makes multi architecture builds quite nasty. It uses "/bin/ld -r" to lump object files together before it actually links any binaries. ld doesn't work with more than one -arch flag so I guess I will have to lipo it all together from four separate builds... nasty! over 25 binaries and libs...
I've tried to replace /bin/ld -r -o with cc -r -o but then I run into other problems...
Quote from: "linmag7"Well, thanks!
The quad-fat package might take some time though, lots of assembly stuff that's different for the four archs and the source tree seems to be set up in a way that makes multi architecture builds quite nasty. It uses "/bin/ld -r" to lump object files together before it actually links any binaries. ld doesn't work with more than one -arch flag so I guess I will have to lipo it all together from four separate builds... nasty! over 25 binaries and libs...
I've tried to replace /bin/ld -r -o with cc -r -o but then I run into other problems...
Ouch, that's definately worse that openssl! :-) If you just want to create builds for seperate arch's, that's fine also. I have the space. I'd say do what you can. I know I've been extremely busy these days. All the best! Take care.
I've built postgresql 8.3.6 as a quadfat NS 3.3 package and I'm now uploading it to kb7sqi. I've only tested the build to some extent on the SPARC platform, that is, I'm currently running the phpBB2 forum just to have something to put into a test database. It seems to be working fine! I had to make some changes in platform dependent assembly code so I don't know if I messed up any of the other platforms. I'm specially worried about the m68k platform since it was the platform that gave me the most trouble with inline assembly.
Feel free to give it a try and let me know if you run into any problems. I'll also try to put together an apache package with ssl/php4/posgresql if someone whats to use postgresql on a web platform in NS.
Quote from: "linmag7"I've built postgresql 8.3.6 as a quadfat NS 3.3 package and I'm now uploading it to kb7sqi. I've only tested the build to some extent on the SPARC platform, that is, I'm currently running the phpBB2 forum just to have something to put into a test database. It seems to be working fine! I had to make some changes in platform dependent assembly code so I don't know if I messed up any of the other platforms. I'm specially worried about the m68k platform since it was the platform that gave me the most trouble with inline assembly.
Feel free to give it a try and let me know if you run into any problems. I'll also try to put together an apache package with ssl/php4/posgresql if someone whats to use postgresql on a web platform in NS.
Hey Magnus! It's been posted to the web server in the your directory along w/ the mysql-client software as well. Looking forward to hearing other results as well. Thanks again! Take care.
I've built an apache-1.3.41 with mod_ssl mod_php4 and postgresql-8 support. This package along with php-4.4.8 and postgresql-8.3.6 is all you need to run for instance a php web-based bulletin/forum or some other web based database applications entirely in a NeXTSTEP. The apache/php package also has support for mysql databases but its not likely that we will se a mysql port to NeXT.
I'll upload the package to kb7sqi