From owner-freebsd-database Sun Jan 14 11:52:26 2001 Delivered-To: freebsd-database@freebsd.org Received: from spammie.svbug.com (unknown [198.79.110.2]) by hub.freebsd.org (Postfix) with ESMTP id BA59437B401 for ; Sun, 14 Jan 2001 11:52:07 -0800 (PST) Received: from spammie.svbug.com (localhost.mozie.org [127.0.0.1]) by spammie.svbug.com (8.9.3/8.9.3) with ESMTP id LAA01733; Sun, 14 Jan 2001 11:51:10 -0800 (PST) (envelope-from jessem@spammie.svbug.com) Message-Id: <200101141951.LAA01733@spammie.svbug.com> Date: Sun, 14 Jan 2001 11:51:06 -0800 (PST) From: opentrax@email.com Reply-To: opentrax@email.com Subject: Re: Postgresql compile error To: gianluca@parkinson.it Cc: freebsd-database@FreeBSD.ORG In-Reply-To: <3A584DF2.32A69D78@parkinson.it> MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Has anyone responded to your request? If not, email back with the remaining message. Jessem. On 7 Jan, Gianluca Sordiglioni wrote: > Trying to compile postgresql7 on FreeBSD 4.2 with different options I > always get this error: > > gmake[2]: Entering directory > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/perl5' > gmake[2]: Leaving directory > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/perl5' > gmake -C odbc all > gmake[2]: Entering directory > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/odbc' > cc -I../../include -I../../backend -I/usr/local/include > -I/usr/local/include/tcl8.3 -I/usr/local/include/tk8.3 -O -pipe > -march=pentiumpro -DUSE_SSL -I. -DHAVE_CONFIG_H -fpic -DPIC -c -o > tuplelist.o tuplelist.c > In file included from tuplelist.c:16: > /usr/local/include/malloc.h:81: syntax error before `*' > /usr/local/include/malloc.h:82: syntax error before `*' > /usr/local/include/malloc.h:87: syntax error before `*' > gmake[2]: *** [tuplelist.o] Error 1 > gmake[2]: Leaving directory > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/odbc' > gmake[1]: *** [all] Error 2 > gmake[1]: Leaving directory > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces' > gmake: *** [all] Error 2 > *** Error code 2 > > Stop in /usr/ports/databases/postgresql7. > > > Okay, so I edited tuplelist.c and commented out #include : > the result is it compiles, but won't start. > > I took a look to malloc.h, seems ok. > > Any idea? > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-database" in the body of the message > > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Mon Jan 15 9:49:58 2001 Delivered-To: freebsd-database@freebsd.org Received: from spammie.svbug.com (unknown [198.79.110.2]) by hub.freebsd.org (Postfix) with ESMTP id 41F6037B400; Mon, 15 Jan 2001 09:49:36 -0800 (PST) Received: from spammie.svbug.com (localhost.mozie.org [127.0.0.1]) by spammie.svbug.com (8.9.3/8.9.3) with ESMTP id JAA00318; Mon, 15 Jan 2001 09:47:33 -0800 (PST) (envelope-from jessem@spammie.svbug.com) Message-Id: <200101151747.JAA00318@spammie.svbug.com> Date: Mon, 15 Jan 2001 09:47:32 -0800 (PST) From: opentrax@email.com Reply-To: opentrax@email.com Subject: Re: Postgresql compile error To: gianluca@parkinson.it Cc: database@freebsd.org, questions@freebsd.org In-Reply-To: <3A630389.E7A91E8B@parkinson.it> MIME-Version: 1.0 Content-Type: TEXT/plain; charset=us-ascii Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Gianluca, I've reposted your message in case someone else has an idea. On 15 Jan, Gianluca Sordiglioni wrote: > > > opentrax@email.com wrote: >> >> Has anyone responded to your request? >> If not, email back with the remaining message. > > I received no answer. > > It seems there's something wrong in malloc.h, but this is not true. > malloc.h is a system include file. It has no syntax error. > Perhaps there's a bug in gmake or some configuration tool, I guess. > Yes, malloc.h is a system include file, but makefile is looking for the one in '/usr/local/include'. That is not the system include. The system malloc.h is usually in '/usr/include'. I'm not sure if that is what ODBC needs. Perhaps someone who has used/compiled this package can say. Jessem. >> On 7 Jan, Gianluca Sordiglioni wrote: >> > Trying to compile postgresql7 on FreeBSD 4.2 with different options I >> > always get this error: >> > >> > gmake[2]: Entering directory >> > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/perl5' >> > gmake[2]: Leaving directory >> > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/perl5' >> > gmake -C odbc all >> > gmake[2]: Entering directory >> > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/odbc' >> > cc -I../../include -I../../backend -I/usr/local/include >> > -I/usr/local/include/tcl8.3 -I/usr/local/include/tk8.3 -O -pipe >> > -march=pentiumpro -DUSE_SSL -I. -DHAVE_CONFIG_H -fpic -DPIC -c -o >> > tuplelist.o tuplelist.c >> > In file included from tuplelist.c:16: >> > /usr/local/include/malloc.h:81: syntax error before `*' >> > /usr/local/include/malloc.h:82: syntax error before `*' >> > /usr/local/include/malloc.h:87: syntax error before `*' >> > gmake[2]: *** [tuplelist.o] Error 1 >> > gmake[2]: Leaving directory >> > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces/odbc' >> > gmake[1]: *** [all] Error 2 >> > gmake[1]: Leaving directory >> > `/usr/ports/databases/postgresql7/work/postgresql-7.0.3/src/interfaces' >> > gmake: *** [all] Error 2 >> > *** Error code 2 >> > >> > Stop in /usr/ports/databases/postgresql7. >> > >> > >> > Okay, so I edited tuplelist.c and commented out #include : >> > the result is it compiles, but won't start. >> > >> > I took a look to malloc.h, seems ok. >> > >> > Any idea? >> > >> > >> > To Unsubscribe: send mail to majordomo@FreeBSD.org >> > with "unsubscribe freebsd-database" in the body of the message >> > >> > >> >> To Unsubscribe: send mail to majordomo@FreeBSD.org >> with "unsubscribe freebsd-database" in the body of the message > To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Wed Jan 17 22: 1:43 2001 Delivered-To: freebsd-database@freebsd.org Received: from sanson.reyes.somos.net (freyes.static.inch.com [216.223.199.224]) by hub.freebsd.org (Postfix) with ESMTP id 90C7437B400 for ; Wed, 17 Jan 2001 22:01:25 -0800 (PST) Received: from zoraida.reyes.somos.net (zoraida.reyes.somos.net [10.0.0.15]) by sanson.reyes.somos.net (8.9.3/8.9.3) with ESMTP id AAA97522 for ; Thu, 18 Jan 2001 00:57:53 -0500 (EST) (envelope-from lists@reyes.somos.net) Date: Thu, 18 Jan 2001 01:05:29 -0500 (EST) From: Francisco Reyes X-Sender: fran@zoraida.reyes.somos.net To: freebsd-database@freebsd.org Subject: Need help with PostgreSQL database Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG I installed PostgresSQL from ports. I am trying to access any database or to create a new one, without much luck. I noticed the port made a user called pgsql. Am I supposed to use this? I tried using that user by becoming root and then that user. Then I tried psql. It complained about database "psql" not existing. If I try "psql test" it gives me read access denied. Any hints on getting PosgreSQL going on FreeBSD? I bought a book and I am looking at the tutorial, but before I can use them I need to be able to create a database or use the "test" database. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Jan 18 7:23:51 2001 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (SHW2-220.accesscable.net [24.71.145.220]) by hub.freebsd.org (Postfix) with ESMTP id 1BBDE37B400 for ; Thu, 18 Jan 2001 07:23:32 -0800 (PST) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.11.1/8.11.1) with ESMTP id f0IFLOV01840; Thu, 18 Jan 2001 11:21:24 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Thu, 18 Jan 2001 11:21:24 -0400 (AST) From: The Hermit Hacker To: Francisco Reyes Cc: Subject: Re: Need help with PostgreSQL database In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Thu, 18 Jan 2001, Francisco Reyes wrote: > I installed PostgresSQL from ports. I am trying to access any database or > to create a new one, without much luck. > > I noticed the port made a user called pgsql. Am I supposed to use this? > I tried using that user by becoming root and then that user. Then I tried > psql. > > It complained about database "psql" not existing. If I try "psql test" it > gives me read access denied. do a 'psql template1' ... from there, you can do a 'create database' or 'create user' to build ... template1 is as it states ... the base database for the system, that all others are built from. If you create a table in template1, then do a 'create database', that new database you just created will also contain that table you created in template1, so, in general, avoid doing anything but creating users and databases from template1 ... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Thu Jan 18 10:25: 3 2001 Delivered-To: freebsd-database@freebsd.org Received: from cc762335-a.ebnsk1.nj.home.com (cc762335-a.ebnsk1.nj.home.com [24.3.219.36]) by hub.freebsd.org (Postfix) with SMTP id 4405937B402 for ; Thu, 18 Jan 2001 10:24:41 -0800 (PST) Received: (qmail 76283 invoked from network); 18 Jan 2001 18:23:30 -0000 Received: from athena.faerun.com (HELO athena) (192.168.0.2) by cc762335-a.ebnsk1.nj.home.com with SMTP; 18 Jan 2001 18:23:30 -0000 Message-Id: <4.2.2.20010118131827.00c82d50@netmail.home.com> X-Sender: damascus@netmail.home.com X-Mailer: QUALCOMM Windows Eudora Pro Version 4.2.2 Date: Thu, 18 Jan 2001 13:24:03 -0500 To: Francisco Reyes From: Carroll Kong Subject: Re: Need help with PostgreSQL database Cc: freebsd-database@FreeBSD.ORG In-Reply-To: Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG At 01:05 AM 1/18/01 -0500, Francisco Reyes wrote: >I installed PostgresSQL from ports. I am trying to access any database or >to create a new one, without much luck. > >I noticed the port made a user called pgsql. Am I supposed to use this? >I tried using that user by becoming root and then that user. Then I tried >psql. > >It complained about database "psql" not existing. If I try "psql test" it >gives me read access denied. > >Any hints on getting PosgreSQL going on FreeBSD? >I bought a book and I am looking at the tutorial, but before I can use >them I need to be able to create a database or use the "test" database. I had trouble with PostgreSQL on FreeBSD before since I did not know where to look. I cannot quite remember where else to look for except the PostgreSQL documentation on their website. man psql (you will most likely need to add the postgresql man pages in your man path for this to succeed) tells you that by default you will end up creating a db after your own name if you just run psql. You can pass a parameter that lets you choose another db. Conversely, you can setup an environment variable that always chooses a particular db, or even a user! PGDATABASE=yourdb PGUSER=dbuser To create a db, take a look at the /usr/local/pgsql/bin. That is where all the db specific binaries are held. createdb will help create a new db. There are parameters there to create a db under the name of another user. You might want to add a new user before that begins. Just get into the test database. "psql test" Use the create user command to make a subordinate user and then create a db under his name, and you should be set to go. -Carroll Kong To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Fri Jan 19 19:54:48 2001 Delivered-To: freebsd-database@freebsd.org Received: from mailout4-0.nyroc.rr.com (mailout4-0.nyroc.rr.com [24.92.226.120]) by hub.freebsd.org (Postfix) with ESMTP id 350CA37B401 for ; Fri, 19 Jan 2001 19:54:23 -0800 (PST) Received: from newdev (cm-24-29-63-39.nycap.rr.com [24.29.63.39]) by mailout4-0.nyroc.rr.com (8.11.2/RoadRunner 1.03) with SMTP id f0K3ogn26157 for ; Fri, 19 Jan 2001 22:50:42 -0500 (EST) Message-ID: <008901c0828d$47422250$273f1d18@newdev> From: "Sheridan Martin" To: Subject: Sybase, PHP, Apache, Win2000 Date: Fri, 19 Jan 2001 23:01:25 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0086_01C0826B.BF66C9B0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2919.6700 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG This is a multi-part message in MIME format. ------=_NextPart_000_0086_01C0826B.BF66C9B0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I work for NYS Department of Health. We have a large Public Health = Network which operates on SUN boxes with Sybase ASE SQL. Most of the = applications are written in a combination of Perl, Java, HTML, = Javascript.=20 My group is responcible for a major application that was developed to = collect Labs information. This application is written largely in = PowerDynamo, HTML, JavaScript, and Perl using an abundant amount of = stored procedures.=20 PowerDynamo is similar to Cold Fusion melding HTML and JavaScript to = provide connectivity to Sybase SQL Servrers.=20 I am investigating the possibility of replacing the PowerDynamo with = PHP. On the surface it appears that we would not be facing a major = rewrite as we would if we were to employ JSP as an alternative. = PowerDynamo is a dead product in the eyes of Sybase as well as most of = the Sybase Developer community.=20 I first became interested in PHP when we attempted to move the existing = application to Laptop computers for purpose of taking to presentations.=20 I found that the combination of the MS Personal Web Server and = PowerDynamo was very unstable. I began looking for a better Web Server = for the Laptop computers which lead me to Apache. To date I have never = been able to get PowerDynamo to work with the Apache Web Server.=20 In learning about the Apache Web Server I began to seeing the PHP = product being discussed as a SQL Server interface. So I began = investigating PHP at that point.=20 So for I have PHP, MySQL, and Apache functioning properly in Win2000. = Sybase is functioning properly as well in the ODBC interface to = SQLAdvantage, Access, PowerBuilder, etc. When I attempt to connect the = PHP code to the Sybase server it fails giving the following error = message:=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 I put together a short piece of code based on a the Sybase sample that = is posted on Thickbook.com site = (http://www.thickbook.com/extra/php_sybase.phtml) just to check the = ability to connect the Apache Web Server through PHP to a Sybase ASE SQL = Server in a Windows 2000 OS environment.=20 I ran into problems the working the PHP4 build, Apache, and Sybase ASE.=20 I had downloaded PHP4 from several InterNet locations and none have = worked properly when connecting to Sybase ASE through an Apache Web = Server in a Win2000 OS.=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 =20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Apache, PHP4, MySQL, and IE5 work well in Win2000.=20 Sybase ASE is working and can be connected to by SQL Advantage, Access = and other tools using ODBC.=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 On my home computer I get the following error message from Apache/PHP.=20 The instruction at "0x00a555b1" referenced memory at "0xa5ed7940".=20 The memory could not be "written".=20 Click on OK to terminate the program=20 Apache/1.3.14 Server at 127.0.0.1 Port 80=20 This has happened several times with several builds of the Apache, PHP, = and reloading fresh installs of the Win 2000 OS just to be sure.=20 PHP Version 4.0.5-dev=20 Windows NT 5.0 build 2195 / Jan 12 2001=20 Sybase 11.9.2 ASE for Windows NT=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 At work it sometimes writes the following error to the Apache error.log: = [Thu Jan 18 21:39:32 2001] [error] [client 127.0.0.1] Premature end of = script headers: c:/php4/php.exe=20 As soon as I comment out the sybase_connect() line the rest of the = script executes properly although the other sybase calls generate error = messages due to the fact that a connection does not exist. So the = scripting is not the problem.=20 Bottom Line = =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20 Is there some place where I could receive assistance in PHP, APACHE, = SYBASE to work together in a Win2000 OS environment.=20 I would be willing to purchase a version of PHP that support Sybase in = the above configuration. sjm05@health.state.ny.us=20 I have details of the error message and supportive set-up information, = but this format does not support the presentation of such materials.=20 ------=_NextPart_000_0086_01C0826B.BF66C9B0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
I work for NYS Department of Health. We = have a=20 large Public Health Network which operates on SUN boxes with Sybase ASE = SQL.=20 Most of the applications are written in a combination of Perl, Java, = HTML,=20 Javascript.
 
My group is responcible for a major = application=20 that was developed to collect Labs information. This application is = written=20 largely in PowerDynamo, HTML, JavaScript, and Perl using an abundant = amount of=20 stored procedures.
 
PowerDynamo is similar to Cold Fusion = melding HTML=20 and JavaScript to provide connectivity to Sybase SQL Servrers. =
 
I am investigating the possibility of = replacing the=20 PowerDynamo with PHP. On the surface it appears that we would not be = facing a=20 major rewrite as we would if we were to employ JSP as an alternative.=20 PowerDynamo is a dead product in the eyes of Sybase as well as most of = the=20 Sybase Developer community.
 
I first became interested in PHP when = we attempted=20 to move the existing application to Laptop computers for purpose of = taking to=20 presentations.
 
I found that the combination of the MS = Personal Web=20 Server and PowerDynamo was very unstable. I began looking for a better = Web=20 Server for the Laptop computers which lead me to Apache. To date I have = never=20 been able to get PowerDynamo to work with the Apache Web Server. =
 
In learning about the Apache Web Server = I began to=20 seeing the PHP product being discussed as a SQL Server interface. So I = began=20 investigating PHP at that point.
 
So for I have PHP, MySQL, and Apache = functioning=20 properly in Win2000. Sybase is functioning properly as well in the ODBC=20 interface to SQLAdvantage, Access, PowerBuilder, etc. When I attempt to = connect=20 the PHP code to the Sybase server it fails giving the following error = message:=20
 

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
I put together a short piece of code = based on a the=20 Sybase sample that is posted on Thickbook.com site (http://www.thick= book.com/extra/php_sybase.phtml)=20 just to check the ability to connect the Apache Web Server through PHP = to a=20 Sybase ASE SQL Server in a Windows 2000 OS environment.
 
I ran into problems the working the = PHP4 build,=20 Apache, and Sybase ASE.
 
I had downloaded PHP4 from several = InterNet=20 locations and none have worked properly when connecting to Sybase ASE = through an=20 Apache Web Server in a Win2000 OS.
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
<?php
// create connection =
$connection =3D=20 sybase_connect("NEWDEV","sa","smile10")
or die("Couldn't make = connection.");=20
 
// select database
$db =3D=20 sybase_select_db("psdemodb", $connection)
or die("Couldn't select=20 database.");
 
// free resources and close connection=20
sybase_free_result($sql_result);
sybase_close($connection); =
?>=20
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
Apache, PHP4, MySQL, and IE5 work well = in Win2000.=20
 
Sybase ASE is working and can be = connected to by=20 SQL Advantage, Access and other tools using ODBC.
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
On my home computer I get the following = error=20 message from Apache/PHP.
 
The instruction at "0x00a555b1" = referenced memory=20 at "0xa5ed7940".
The memory could not be "written".
 
Click on OK to terminate the program =
 
Apache/1.3.14 Server at 127.0.0.1 Port = 80=20
 
This has happened several times with = several builds=20 of the Apache, PHP, and reloading fresh installs of the Win 2000 OS just = to be=20 sure.
 
PHP Version 4.0.5-dev
Windows NT = 5.0 build 2195=20 / Jan 12 2001
 
Sybase 11.9.2 ASE for Windows NT =
 
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=20
 
At work it sometimes writes the = following error to=20 the Apache error.log:
 
[Thu Jan 18 21:39:32 2001] [error] = [client=20 127.0.0.1] Premature end of script headers: c:/php4/php.exe =
 
As soon as I comment out the = sybase_connect() line=20 the rest of the script executes properly although the other sybase calls = generate error messages due to the fact that a connection does not = exist. So the=20 scripting is not the problem.
 

Bottom Line=20 =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
 
Is there some place where I could = receive=20 assistance in PHP, APACHE, SYBASE to work together in a Win2000 OS = environment.=20
I would be willing to purchase a version of PHP that support Sybase = in the=20 above configuration. sjm05@health.state.ny.us=20
 
I have details of the error message and = supportive=20 set-up information, but this format does not support the presentation of = such=20 materials.
 
 
------=_NextPart_000_0086_01C0826B.BF66C9B0-- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Jan 20 8:21:32 2001 Delivered-To: freebsd-database@freebsd.org Received: from sanson.reyes.somos.net (freyes.static.inch.com [216.223.199.224]) by hub.freebsd.org (Postfix) with ESMTP id D386937B6A8 for ; Sat, 20 Jan 2001 08:21:13 -0800 (PST) Received: from zoraida.reyes.somos.net (zoraida.reyes.somos.net [10.0.0.15]) by sanson.reyes.somos.net (8.9.3/8.9.3) with ESMTP id LAA08091; Sat, 20 Jan 2001 11:17:42 -0500 (EST) (envelope-from fran@reyes.somos.net) Date: Sat, 20 Jan 2001 11:24:54 -0500 (EST) From: Francisco Reyes To: The Hermit Hacker Cc: freebsd-database@FreeBSD.ORG Subject: Re: Need help with PostgreSQL database In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Thu, 18 Jan 2001, The Hermit Hacker wrote: > do a 'psql template1' ... from there, you can do a 'create database' or > 'create user' to build ... What is the difference with doing it that way and using "createdb"? Although I am sure what you suggest is likely the right way, I wonder why both the tutorial and the book I got don't mention it. To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Jan 20 10:36:54 2001 Delivered-To: freebsd-database@freebsd.org Received: from thelab.hub.org (SHW2-220.accesscable.net [24.71.145.220]) by hub.freebsd.org (Postfix) with ESMTP id B5AD237B404 for ; Sat, 20 Jan 2001 10:36:36 -0800 (PST) Received: from localhost (scrappy@localhost) by thelab.hub.org (8.11.1/8.11.1) with ESMTP id f0KIW6b21788; Sat, 20 Jan 2001 14:32:06 -0400 (AST) (envelope-from scrappy@hub.org) X-Authentication-Warning: thelab.hub.org: scrappy owned process doing -bs Date: Sat, 20 Jan 2001 14:32:05 -0400 (AST) From: The Hermit Hacker To: Francisco Reyes Cc: Subject: Re: Need help with PostgreSQL database In-Reply-To: Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG On Sat, 20 Jan 2001, Francisco Reyes wrote: > On Thu, 18 Jan 2001, The Hermit Hacker wrote: > > > do a 'psql template1' ... from there, you can do a 'create database' or > > 'create user' to build ... > > What is the difference with doing it that way and using "createdb"? > Although I am sure what you suggest is likely the right way, I wonder why > both the tutorial and the book I got don't mention it. createdb is a shortcut to do the same thing ... if you want to do stuff like create new users or create new databases, you can call the "proper SQL" from places like PHP and perl, especially when your admin is on one machine, vs your server on a different one ... To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message From owner-freebsd-database Sat Jan 20 15:58:10 2001 Delivered-To: freebsd-database@freebsd.org Received: from misery.sdf.com (misery.sdf.com [204.244.213.49]) by hub.freebsd.org (Postfix) with ESMTP id 4249737B6B1 for ; Sat, 20 Jan 2001 15:57:53 -0800 (PST) Received: from tom (helo=localhost) by misery.sdf.com with local-esmtp (Exim 2.12 #1) id 14K7BJ-00029r-00; Sat, 20 Jan 2001 15:12:25 -0800 Date: Sat, 20 Jan 2001 15:12:24 -0800 (PST) From: Tom Samplonius To: Sheridan Martin Cc: freebsd-database@FreeBSD.ORG Subject: Re: Sybase, PHP, Apache, Win2000 In-Reply-To: <008901c0828d$47422250$273f1d18@newdev> Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII Sender: owner-freebsd-database@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG Connecting to a Sybase database running on Win2000 from a Win2000 client... this has nothing to do with FreeBSD that I can tell. Tom To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-database" in the body of the message