Thread: www-sql question
Hello All, I have installed the latest version of PostgreSQL 7.0.3 and all seems to be fine with it. My problem is that I have used www-sql in the past with MySQL which works fine, but since I have just migrated to the newest version of PostgreSQL, I have tried a recompile --with-database-pgsql which also went fine, but the application does not want to seem to work. Has anyone had any luck running www-sql with the newest version of PostgreSQL? Also, I am running a Mandrake Linux box and my PostgreSQL seems to be working fine as I can compile and run the examples without any problems. Really confused about this. Lonnie Cumberland
On Wed, Feb 21, 2001 at 10:53:34PM -0500, lonnie wrote: > My problem is that I have used www-sql in the past with MySQL which > works fine, but since I have just migrated to the newest version of > PostgreSQL, I have tried a recompile --with-database-pgsql which also > went fine, but the application does not want to seem to work. What exactly is the problem? What error messages do you get, and when are these errors encountered? Does it work with a previous release of PgSQL? We need more information. > Has anyone had any luck running www-sql with the newest version of > PostgreSQL? You'll probably have more luck asking on a www-sql related place, like the mailing list -- or email the author directly. Considering that www-sql was last updated Nov. 1998, I'd suggest looking for an alternative. > Also, I am running a Mandrake Linux box and my PostgreSQL seems to be > working fine as I can compile and run the examples without any problems. By '[running] the examples', do you mean running the regression tests? (`make test`) If not, you may as well run them to make sure your install of PgSQL is working. HTH, Neil -- Neil Conway <neilconway@home.com> Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc Encrypted mail welcomed It is dangerous to be right when the government is wrong. -- Voltaire
Hello Neil, The problem is that I am not getting any error messages and it is not returning any data from the database. The database is set up correctly and have also put some test data into the numbers table. I wanted to check that things were working fine so I also did a test but using the MySQL server in that I compiled up a version of www-sql for MySQL also and things are working fine. It appears that there has been some changes in the way that things are being done since the last www-sql version had been released. I suspect that there are some major differences in the newer versions of PostgreSQL that is messing up the comunications. If you know of another alternative like www-sql for PostgreSQL that works then I would be interested in looking into that as well. Cheers, Lonnie --- Neil Conway <nconway@klamath.dyndns.org> wrote: > On Wed, Feb 21, 2001 at 10:53:34PM -0500, lonnie wrote: > > My problem is that I have used www-sql in the past with MySQL which > > works fine, but since I have just migrated to the newest version of > > PostgreSQL, I have tried a recompile --with-database-pgsql which also > > went fine, but the application does not want to seem to work. > > What exactly is the problem? What error messages do you get, and when > are these errors encountered? Does it work with a previous release > of PgSQL? We need more information. > > > Has anyone had any luck running www-sql with the newest version of > > PostgreSQL? > > You'll probably have more luck asking on a www-sql related place, > like the mailing list -- or email the author directly. Considering > that www-sql was last updated Nov. 1998, I'd suggest looking for > an alternative. > > > Also, I am running a Mandrake Linux box and my PostgreSQL seems to be > > working fine as I can compile and run the examples without any problems. > > By '[running] the examples', do you mean running the regression tests? > (`make test`) If not, you may as well run them to make sure your > install of PgSQL is working. > > HTH, > > Neil > > -- > Neil Conway <neilconway@home.com> > Get my GnuPG key from: http://klamath.dyndns.org/mykey.asc > Encrypted mail welcomed > > It is dangerous to be right when the government is wrong. > -- Voltaire __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/
Lonnie Cumberland <lonnie_cumberland@yahoo.com> writes:
> The problem is that I am not getting any error messages and it is not
> returning any data from the database.
> It appears that there has been some changes in the way that things are being
> done since the last www-sql version had been released.
I pulled down www-sql-0.5.7 and took a very quick look at its pgsql.c
module, and didn't see any obvious silliness. I don't have time to try
to run a real test though. Try running the postmaster with -d2 (and
without -S) so that queries are logged in the postmaster log, and then
look to see what queries are being received from the www-sql client.
BTW, you are running www-sql with a recent libpq library compiled into
it, no?
regards, tom lane
Hello Tom, thanks for taking a look at www-sql as I was going to use as a quick solution to having to write so much code, but now a better solution seems to have presented itself and should work without any problems with PostgreSQL. I was initially looking at an application called MetaHTML, but the developers had not really done anything with it for a long time until recently. They have just released (opensource) and working version MetaHTML 6.10 which compiles fine and is very easy to install. This particular piece is MUCH more advanced than www-sql which really need a major re-work. I found out, with www-sql, that it would not return any error messages or results of the query, but that when I compiled up your examples in the libpq++ directory and made a few simple changes to reflect that same database which www-sql used, I could easily get the data from the database. This led me to think that there was some compatibility issues along with the age of development of www-sql as well. In any case, it is all academic now and I will be using the NEW MetaHTML release for our project with PostgreSQL. Thanks for the effort, Lonnie --- Tom Lane <tgl@sss.pgh.pa.us> wrote: > Lonnie Cumberland <lonnie_cumberland@yahoo.com> writes: > > The problem is that I am not getting any error messages and it is not > > returning any data from the database. > > > It appears that there has been some changes in the way that things are > being > > done since the last www-sql version had been released. > > I pulled down www-sql-0.5.7 and took a very quick look at its pgsql.c > module, and didn't see any obvious silliness. I don't have time to try > to run a real test though. Try running the postmaster with -d2 (and > without -S) so that queries are logged in the postmaster log, and then > look to see what queries are being received from the www-sql client. > > BTW, you are running www-sql with a recent libpq library compiled into > it, no? > > regards, tom lane __________________________________________________ Do You Yahoo!? Yahoo! Auctions - Buy the things you want at great prices! http://auctions.yahoo.com/