You can subscribe to this list here.
2000 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(23) |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2001 |
Jan
(68) |
Feb
(121) |
Mar
(59) |
Apr
(49) |
May
(110) |
Jun
(109) |
Jul
(146) |
Aug
(122) |
Sep
(83) |
Oct
(94) |
Nov
(90) |
Dec
(157) |
2002 |
Jan
(169) |
Feb
(186) |
Mar
(168) |
Apr
(353) |
May
(338) |
Jun
(278) |
Jul
(220) |
Aug
(336) |
Sep
(122) |
Oct
(183) |
Nov
(111) |
Dec
(265) |
2003 |
Jan
(358) |
Feb
(135) |
Mar
(343) |
Apr
(419) |
May
(277) |
Jun
(145) |
Jul
|
Aug
(134) |
Sep
(118) |
Oct
(97) |
Nov
(240) |
Dec
(293) |
2004 |
Jan
(412) |
Feb
(217) |
Mar
(202) |
Apr
(237) |
May
(333) |
Jun
(201) |
Jul
(303) |
Aug
(218) |
Sep
(285) |
Oct
(249) |
Nov
(248) |
Dec
(229) |
2005 |
Jan
(314) |
Feb
(175) |
Mar
(386) |
Apr
(223) |
May
(281) |
Jun
(230) |
Jul
(200) |
Aug
(197) |
Sep
(110) |
Oct
(243) |
Nov
(279) |
Dec
(324) |
2006 |
Jan
(335) |
Feb
(396) |
Mar
(383) |
Apr
(358) |
May
(375) |
Jun
(190) |
Jul
(212) |
Aug
(320) |
Sep
(358) |
Oct
(112) |
Nov
(213) |
Dec
(95) |
2007 |
Jan
(136) |
Feb
(104) |
Mar
(156) |
Apr
(115) |
May
(78) |
Jun
(75) |
Jul
(30) |
Aug
(35) |
Sep
(50) |
Oct
(44) |
Nov
(33) |
Dec
(35) |
2008 |
Jan
(90) |
Feb
(63) |
Mar
(47) |
Apr
(42) |
May
(72) |
Jun
(85) |
Jul
(25) |
Aug
(20) |
Sep
(14) |
Oct
(11) |
Nov
(25) |
Dec
(39) |
2009 |
Jan
(39) |
Feb
(46) |
Mar
(16) |
Apr
(27) |
May
(51) |
Jun
(66) |
Jul
(78) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2010 |
Jan
|
Feb
|
Mar
(5) |
Apr
|
May
(4) |
Jun
|
Jul
(1) |
Aug
|
Sep
(1) |
Oct
(2) |
Nov
|
Dec
|
2011 |
Jan
|
Feb
(2) |
Mar
|
Apr
(3) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2013 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2014 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
2015 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
2016 |
Jan
(1) |
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
From: Antonio G. <aga...@ag...> - 2001-06-22 01:11:52
|
I miss to write when you can get the "Upsizing Toolkit". Also, if anybody has interest about the "Upsizing Toolkit": You can visit: http://dspace.dial.pipex.com/boylesa/ Antonio Gallardo. _____________________________________________________________ Obtenga una cuenta de correo gratis! Visite AG Software, S. A., http://www.agsoftware.50megs.com/ |
From: Antonio G. <aga...@ag...> - 2001-06-22 01:02:24
|
Maybe the following will contribute to the question: When we started to move applications from MS plataform to PostgreSQL. In the beginning, we did a project where we researched how to connect a MS Access client against ans PostgreSQL Server. This was because our user still want to use MS Windows, while KDE have not an Office Application that fully read and write our Word docs and Excel Spreadsheets under Linux. First we used and rewrote a tool founded in the postgreSQL web site that help to convert an Access DB to PostgreSQL. The DB convert application name is "PgUpt - postgress Upsizing Toolkit". The DB was 10 MB with more than 50 tables. We rewrote some code of this applicartion and we sucefully did the DB conversion at great Time! After that, we start to link the DB Access Client with ODBC Driver for PostgreSQL using "linked tables" and the result was very BAD. Every query taked too mouch time. Sometimes we must wait more than 2 minutes when if the same Database used MS Jet, the query was done in less than 10 seconds! We researched what is the cause of the problem., and in a book we found that "MS Access poorly interact with any ODBC driver!". If you try to get for example 10 registers then Access open a connection, get ONE register and close the connection, then again open a new connection, get the SECOND register and close the connection, etc.!!!!!! Of course if you try the same with MS SQL Server you get a better result! Well, at the end. If anybody wish to write and MS Access Client to interact with PostgreSQL using the native way. He must rewrite the app to get a better performance. I hope this will help anyone who wish to write an MS Access client for SQL-Ledger. Regards, Antonio Gallardo _____________________________________________________________ Obtenga una cuenta de correo gratis! Visite AG Software, S. A., http://www.agsoftware.50megs.com/ |
From: Skot <gst...@te...> - 2001-06-21 16:50:55
|
Is it possible to put a logout button on the sql-ledger? I'm running the latest version. Thanks. |
From: Benjamin L. <ben...@co...> - 2001-06-21 15:43:44
|
To Dieter, and anyone interested, Attached are: IR.pm IS.pm bin/mozilla/ir.pl bin/mozilla/is.pl These files should be able to used as drop-in replacements for the similarly named files in SL 1.4.6. Your mileage may vary. The small changes that I have made are: * CGI.pm hook workarounds, so-to-speak, for developers. If the user doesn't have CGI.pm, everything still works (knock on wood) ;-P. These are minimal at the moment. * Invoice work flow allows 'Update Form' to be _accidently_ used in the place of 'Add Item'. Basically it calls the 'Add Item' code to check to see if the user meant to press 'Add Item' if there is some input in the bottom-most line. * Invoice has autocalculated Due Date on 'Update Form'; based upon customer / vendor's credit terms. So the user can post an Invoice tomorrow and have the Due Date calculated for them? Ha. Probably needs a manual override. * Invoice 'Update Form' checks for valid item Numbers in the rows; and removes the line if invalid. This would occur if the user accidently was to change an item Number for any row bar the bottom-most line. And I've include Form.pm because it's got some CSS stuff in it. That may (or may not) make your browser use smaller and different fonts. Have fun, Ben. -- B. http://makelinux.org/ "Always real." http://realthought.net/ __________________________________________________________________________ Men use thought only to justify their wrong doings, and speech only to conceal their thoughts. -- Voltaire |
From: Administrador <ag...@ho...> - 2001-06-21 08:17:25
|
Also, if anybody has interest about the "Upsizing Toolkit": You can = visit: http://dspace.dial.pipex.com/boylesa/ Antonio Gallardo. > -----Mensaje original----- > De: Oscar Buijten [SMTP:os...@el...] > Enviado el: jueves 21 de junio de 2001 1:28 > Para: sql...@li... > Asunto: Re: Postgresql and ODBC > MsAccess (The answer) >=20 > For those who are interested: >=20 > If you would like to access your Postgresql server on your linux (or > whatever else box) from MickeySoft Access you will need to install = the > Postgresql ODBC server. It is a piece of cake to do. Just ftp to (be > carefull, it might be bussy on this site) >=20 > ftp.postgresql.org=20 >=20 > and move to pub/ > Download the .html and .txt files there for your reference. >=20 > Then move to full/ >=20 > and download: psqlodbc-07_01_0005.zip >=20 > unzip, doubleclick and off you go. >=20 > To access your Pg Dbase from MsAccess97: >=20 > Open a new database, in tables click on new. > Select: attach table and click OK. > A new window will open. Fromfile type, select: ODBC > A new window will open. > Next to the DSN name field you click on NEW. > A new window will open. Select PostgreSQL, click next > Now fill in the name of the new DSN entry you are about to make. > The name of the Dbase you are going to access on Postgrqsql will do = in > most cases. > Click on next and then on finish. > A new window will open. > This one looks very simalar to the user id in SQL ledger doesn't it? > Fill in the details (you may want to peek into the advanced settings = while > you'r there) and off you go! >=20 > Enjoy, >=20 > Oscar >=20 >=20 > ----- Message d'origine -----=20 > De : Oscar Buijten=20 > =C0 : sql...@li...=20 > Envoy=E9 : mercredi 20 juin 2001 12:08 > Objet : Postgresql and ODBC > MsAccess >=20 >=20 > Hello all, >=20 > Realising that thismay not be the perfect place to ask my question = I > want to give it a try anyway. > I currently have information stored in a Access97 database. > Part of this information I would need to transfer to Postgresql (on = a > linux box (Mandrake 8.0) to use it in the SQL-ledger. >=20 > Question is: how to do this? >=20 > I assume I would need to do it using ODBC, but I have no clue what = to > install (as a driver) and > where to install it (on the linux box or on the wondoze box). >=20 > Does anyone has a good answer on this? >=20 > Thanks in advance! >=20 > Regards, >=20 > Oscar > = ________________________________________________________________________= >=20 > Oscar Buijten >=20 > Tel: +33.4.67.57.97.45 > Fax: +33.4.67.57.97.46 > GSM: +33.6.20.84.15.22 > Email: os...@el... >=20 > http://www.elbie.com <<Archivo: ATT00001.htm>>=20 |
From: Administrador <ag...@ho...> - 2001-06-21 08:13:06
|
Maybe the following will contribute to the question: When we started to move applications from MS plataform to PostgreSQL. = In the beginning, we did a project where we researched how to connect a MS = Access client against ans PostgreSQL Server. This was because our user still = want to use MS Windows, while KDE have not an Office Application that fully = read and write our Word docs and Excel Spreadsheets under Linux. First we used and rewrote a tool founded in the postgreSQL web site = that help to convert an Access DB to PostgreSQL. The DB convert application = name is "PgUpt - postgress Upsizing Toolkit". The DB was 10 MB with more = than 50 tables. We rewrote some code of this applicartion and we sucefully did = the DB conversion at great Time! After that, we start to link the DB Access Client with ODBC Driver for PostgreSQL using "linked tables" and the result was very BAD. Every = query taked too mouch time. Sometimes we must wait more than 2 minutes when = if the same Database used MS Jet, the query was done in less than 10 seconds! We researched what is the cause of the problem., and in a book we found = that "MS Access poorly interact with any ODBC driver!". If you try to get = for example 10 registers then Access open a connection, get ONE register = and close the connection, then again open a new connection, get the SECOND register and close the connection, etc.!!!!!! Of course if you try the same with MS SQL Server you get a better = result! Well, at the end. If anybody wish to write and MS Access Client to = interact with PostgreSQL using the native way. He must rewrite the app to get a better performance. I hope this will help anyone who wish to write an MS Access client for SQL-Ledger. Regards, Antonio Gallardo > -----Mensaje original----- > De: Oscar Buijten [SMTP:os...@el...] > Enviado el: jueves 21 de junio de 2001 1:28 > Para: sql...@li... > Asunto: Re: Postgresql and ODBC > MsAccess (The answer) >=20 > For those who are interested: >=20 > If you would like to access your Postgresql server on your linux (or > whatever else box) from MickeySoft Access you will need to install = the > Postgresql ODBC server. It is a piece of cake to do. Just ftp to (be > carefull, it might be bussy on this site) >=20 > ftp.postgresql.org=20 >=20 > and move to pub/ > Download the .html and .txt files there for your reference. >=20 > Then move to full/ >=20 > and download: psqlodbc-07_01_0005.zip >=20 > unzip, doubleclick and off you go. >=20 > To access your Pg Dbase from MsAccess97: >=20 > Open a new database, in tables click on new. > Select: attach table and click OK. > A new window will open. Fromfile type, select: ODBC > A new window will open. > Next to the DSN name field you click on NEW. > A new window will open. Select PostgreSQL, click next > Now fill in the name of the new DSN entry you are about to make. > The name of the Dbase you are going to access on Postgrqsql will do = in > most cases. > Click on next and then on finish. > A new window will open. > This one looks very simalar to the user id in SQL ledger doesn't it? > Fill in the details (you may want to peek into the advanced settings = while > you'r there) and off you go! >=20 > Enjoy, >=20 > Oscar >=20 >=20 > ----- Message d'origine -----=20 > De : Oscar Buijten=20 > =C0 : sql...@li...=20 > Envoy=E9 : mercredi 20 juin 2001 12:08 > Objet : Postgresql and ODBC > MsAccess >=20 >=20 > Hello all, >=20 > Realising that thismay not be the perfect place to ask my question = I > want to give it a try anyway. > I currently have information stored in a Access97 database. > Part of this information I would need to transfer to Postgresql (on = a > linux box (Mandrake 8.0) to use it in the SQL-ledger. >=20 > Question is: how to do this? >=20 > I assume I would need to do it using ODBC, but I have no clue what = to > install (as a driver) and > where to install it (on the linux box or on the wondoze box). >=20 > Does anyone has a good answer on this? >=20 > Thanks in advance! >=20 > Regards, >=20 > Oscar > = ________________________________________________________________________= >=20 > Oscar Buijten >=20 > Tel: +33.4.67.57.97.45 > Fax: +33.4.67.57.97.46 > GSM: +33.6.20.84.15.22 > Email: os...@el... >=20 > http://www.elbie.com <<Archivo: ATT00001.htm>>=20 |
From: Oscar B. <os...@el...> - 2001-06-21 07:31:20
|
For those who are interested: If you would like to access your Postgresql server on your linux (or = whatever else box) from MickeySoft Access you will need to install the = Postgresql ODBC server. It is a piece of cake to do. Just ftp to (be = carefull, it might be bussy on this site) ftp.postgresql.org=20 and move to pub/ Download the .html and .txt files there for your reference. Then move to full/ and download: psqlodbc-07_01_0005.zip unzip, doubleclick and off you go. To access your Pg Dbase from MsAccess97: Open a new database, in tables click on new. Select: attach table and click OK. A new window will open. Fromfile type, select: ODBC A new window will open. Next to the DSN name field you click on NEW. A new window will open. Select PostgreSQL, click next Now fill in the name of the new DSN entry you are about to make. The name of the Dbase you are going to access on Postgrqsql will do in = most cases. Click on next and then on finish. A new window will open. This one looks very simalar to the user id in SQL ledger doesn't it? Fill in the details (you may want to peek into the advanced settings = while you'r there) and off you go! Enjoy, Oscar ----- Message d'origine -----=20 De : Oscar Buijten=20 =C0 : sql...@li...=20 Envoy=E9 : mercredi 20 juin 2001 12:08 Objet : Postgresql and ODBC > MsAccess Hello all, Realising that thismay not be the perfect place to ask my question I = want to give it a try anyway. I currently have information stored in a Access97 database. Part of this information I would need to transfer to Postgresql (on a = linux box (Mandrake 8.0) to use it in the SQL-ledger. Question is: how to do this? I assume I would need to do it using ODBC, but I have no clue what to = install (as a driver) and where to install it (on the linux box or on the wondoze box). Does anyone has a good answer on this? Thanks in advance! Regards, Oscar = ________________________________________________________________________ Oscar Buijten Tel: +33.4.67.57.97.45 Fax: +33.4.67.57.97.46 GSM: +33.6.20.84.15.22 Email: os...@el... http://www.elbie.com |
From: Oscar B. <os...@el...> - 2001-06-21 07:31:13
|
See if the file is actually inthe right place and heck your file permissions=2E ----- Message d'origine ----- De : "Jess" <jess@ozscan=2Enet=2Eau> =C0 : <sql-ledger-users@lists=2Esourceforge=2Enet> Envoy=E9 : jeudi 21 juin 2001 05:28 Objet : Premature end of script headers=2E > Hi People, > > I am getting an error after I press "save" when adding a user to SQL-Ledger > via the admin=2Epl program=2E The log also says it can't find a perl scrip= t waba > waba see below=2E > > Any ideas? > > Error Log > > [Thu Jun 21 12:39:12 2001] [error] [client 192=2E168=2E1=2E3] Premature en= d of > script headers: /www/websites/bookmen/sqll/admin=2Epl > [Thu Jun 21 12:39:12 2001] [error] [client 192=2E168=2E1=2E3] Can't open p= erl > script "action=3Dlist_users&path=3Dbin/mozilla&root=3Droot": No such file = or > directory > > > > Regards Jess=2E > > > |
From: Ibrahim S. <gtk...@ya...> - 2001-06-21 06:48:53
|
Jonas Smedegaard wrote: > On Wed, 20 Jun 2001, Jonathan Gonzalez wrote: > > > ok Jonas.... i think i'm a little better now i get this error > > > > > > Error! > > > > Database is offline; please try again later > > > > I already create the database and make the psql dbname < acc-Pg.sql > > > > Jonas Smedegaard wrote: > > > > Another issue is accessing PostgreSQL through tcp/ip instead of unix > > > sockets. Make sure that it is turned on in your PostgreSQL server. > > > > > > Read earlier posts in the mailinglist archive for more on this... > > Have you looked through recent posts in the mailinglist archive? > > Your problem sounds _very_ familiar (within the last couple of days) and > as far as I remember the problem was solved. > > Please don't abuse the ease of posting a question to lots of people on a > mailinglist, do a bit of diggin' yourself as well. > > Don't get me wrong here - I'd love to help! I really do. It just feels > silly to repeat what have been said quite recently (by fellow hackers - I > am just whining here, not the guru with all the answers ;-) > Hi, I slightly disagree with you. When starting to learn something new it takes a hell of time to get yourself together. A small question which could take one second for a veteran to answer might cost hours, days, weeks to solve for a novice. I am a live example. Although I had installed several times PostgreSQL on Slackware, I had a hard time with Mandrake 8.0, until yesterday when Oscar Buijten shared his experience. So please don't discourage questions. No question is a bad question! Thanks Ibrahim > > Have a look in the archive and come back if that didn't help. Maybe my > search page will be of use (I had problems with the one at the archive): > http://search.jones.dk/ - Remember to select "SQL-Ledger"... > > Friendly, > > Jonas > > -- > Jonas Smedegaard <jo...@jo...> http://www.jones.dk/~jonas/ > IT-guide dr. Jones <dr...@jo...> http://dr.jones.dk/ +45 40843136 > Debian GNU/Linux <js...@de...> http://www.debian.org/ > GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085 ECA9 9FB0 DB32 C024 40B8 > > GNU GPL: "The source will be with you... always." _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com |
From: Jess <je...@oz...> - 2001-06-21 03:33:32
|
Hi People, I am getting an error after I press "save" when adding a user to SQL-Ledger via the admin.pl program. The log also says it can't find a perl script waba waba see below. Any ideas? Error Log [Thu Jun 21 12:39:12 2001] [error] [client 192.168.1.3] Premature end of script headers: /www/websites/bookmen/sqll/admin.pl [Thu Jun 21 12:39:12 2001] [error] [client 192.168.1.3] Can't open perl script "action=list_users&path=bin/mozilla&root=root": No such file or directory Regards Jess. |
From: Jonathan G. <jgo...@br...> - 2001-06-20 21:14:32
|
thanks jonas.... i'm doing that right now.... and i understand you... i love to learn... i will be trying some other things.... Jonas Smedegaard wrote: > On Wed, 20 Jun 2001, Jonathan Gonzalez wrote: > >> ok Jonas.... i think i'm a little better now i get this error >> >> >> Error! >> >> Database is offline; please try again later >> >> I already create the database and make the psql dbname < acc-Pg.sql >> >> Jonas Smedegaard wrote: > >>> Another issue is accessing PostgreSQL through tcp/ip instead of unix >>> sockets. Make sure that it is turned on in your PostgreSQL server. >>> >>> Read earlier posts in the mailinglist archive for more on this... >> > > Have you looked through recent posts in the mailinglist archive? > > Your problem sounds _very_ familiar (within the last couple of days) and > as far as I remember the problem was solved. > > Please don't abuse the ease of posting a question to lots of people on a > mailinglist, do a bit of diggin' yourself as well. > > Don't get me wrong here - I'd love to help! I really do. It just feels > silly to repeat what have been said quite recently (by fellow hackers - I > am just whining here, not the guru with all the answers ;-) > > Have a look in the archive and come back if that didn't help. Maybe my > search page will be of use (I had problems with the one at the archive): > http://search.jones.dk/ - Remember to select "SQL-Ledger"... > > Friendly, > > Jonas > |
From: Jonas S. <jo...@jo...> - 2001-06-20 20:58:47
|
On Wed, 20 Jun 2001, Jonathan Gonzalez wrote: > ok Jonas.... i think i'm a little better now i get this error > > > Error! > > Database is offline; please try again later > > I already create the database and make the psql dbname < acc-Pg.sql > > Jonas Smedegaard wrote: > > Another issue is accessing PostgreSQL through tcp/ip instead of unix > > sockets. Make sure that it is turned on in your PostgreSQL server. > > > > Read earlier posts in the mailinglist archive for more on this... Have you looked through recent posts in the mailinglist archive? Your problem sounds _very_ familiar (within the last couple of days) and as far as I remember the problem was solved. Please don't abuse the ease of posting a question to lots of people on a mailinglist, do a bit of diggin' yourself as well. Don't get me wrong here - I'd love to help! I really do. It just feels silly to repeat what have been said quite recently (by fellow hackers - I am just whining here, not the guru with all the answers ;-) Have a look in the archive and come back if that didn't help. Maybe my search page will be of use (I had problems with the one at the archive): http://search.jones.dk/ - Remember to select "SQL-Ledger"... Friendly, Jonas -- Jonas Smedegaard <jo...@jo...> http://www.jones.dk/~jonas/ IT-guide dr. Jones <dr...@jo...> http://dr.jones.dk/ +45 40843136 Debian GNU/Linux <js...@de...> http://www.debian.org/ GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085 ECA9 9FB0 DB32 C024 40B8 GNU GPL: "The source will be with you... always." |
From: Jonathan G. <jgo...@br...> - 2001-06-20 20:58:33
|
Thanks roderick.... i already check it... Roderick A. Anderson wrote: > On Wed, 20 Jun 2001, Jonas Smedegaard wrote: > >> On Wed, 20 Jun 2001, Jonathan Gonzalez wrote: >> >>> i haven't check my error log...... >> >> Log files are usually the first place to look for hints about the cause of >> problems. It is quicker than writing an email and waiting for someone on a >> mailinglist to do guesswork about it (hint hint). > > > Yes!!! > >> In this case have a look at log files for Apache and PostgreSQL (the two >> servers involved). > > > Down side is PostgreSQL typically comes with logging going to the null > device ie. not logging, but Apache logs are located in '/var/log/httpd'. > The file 'error_log' is what you're looking for. > > > Rod |
From: Tomas K. <to...@bi...> - 2001-06-20 20:53:10
|
Jonathan Gonzalez wrote: > > Well in my case.. root is the user that runs the Apche web server > (httpd) and also creates the postgres database................. > httpd.conf --- # User/Group: The name (or #number) of the user/group to run apache as. # . On SCO (ODT 3) use "User nouser" and "Group nogroup". # . On HPUX you may not be able to use shared memory as nobody, and the # suggested workaround is to create a user www and use that user. # NOTE that some kernels refuse to setgid(Group) or semctl(IPC_SET) # when the value of (unsigned)Group is above 60000; # don't use Group nobody on these systems! # User nobody Group nobody ---- Apache is started by root, but it usually drops privileges to user specified in User directive. Try to create database that belongs to that user ---------------- #su - postgres $ createuser nobody ... has right to create databases? y ...has right to create other users? n $exit # su - nobody $createdb ledger $psql ledger < acc-Pg.sql .... $exit ---------------- If then you can connect to the database, - check postgresql pg-hpa.conf (access rights). It allows to connect only if user ID matches (ident sameuser). This was the reason why I got into "Internal server error" trouble. -- Tomas Kuliavas |
From: Roderick A. A. <raa...@ti...> - 2001-06-20 20:37:58
|
On Wed, 20 Jun 2001, Jonas Smedegaard wrote: > On Wed, 20 Jun 2001, Jonathan Gonzalez wrote: > > > i haven't check my error log...... > > Log files are usually the first place to look for hints about the cause of > problems. It is quicker than writing an email and waiting for someone on a > mailinglist to do guesswork about it (hint hint). Yes!!! > In this case have a look at log files for Apache and PostgreSQL (the two > servers involved). Down side is PostgreSQL typically comes with logging going to the null device ie. not logging, but Apache logs are located in '/var/log/httpd'. The file 'error_log' is what you're looking for. Rod -- Remove the word 'try' from your vocabulary ... Don't try. Do it or don't do it ... Steers try! Don Aslett |
From: Jonathan G. <jgo...@br...> - 2001-06-20 20:35:00
|
ok Jonas.... i think i'm a little better now i get this error Error! Database is offline; please try again later I already create the database and make the psql dbname < acc-Pg.sql Jonas Smedegaard wrote: > On Wed, 20 Jun 2001, Skot wrote: > >> Don't know what I may have missed in the docs. I got all the parts >> installed and I get this in my err.log file: >> >> Compilation failed in require at /var/www/html/sql-ledger/login.pl line >> 65. >> [Wed Jun 20 11:04:34 2001] [error] [client 127.0.0.1] Premature end of >> script headers: /var/www/html/sql-ledger/login.pl > > > On Wed, 20 Jun 2001, Jonathan Gonzalez wrote: > >> I install the latest version of sql-ledger (1.4.6), i can add new users >> in de Administration page and also i can see the login page, but after i >> type the name and password and click on login... i receive an Internal >> Server Error as follow >> >> >> Internal Server Error > > > As others have pointed out recently, it is probably the database access > that is badly configured. > > When creating a user in admin.pl you also need to specify access to the > PostgreSQL database. > > Put something like the following in the last fields of my users: > > Driver: Pg <- NB! cAsE sEnSiTive! > Host: localhost > Name: ledger > Port: 5432 > User: > > Of course you will have to adapt that info to how your own access to > Postgres is. > > Another issue is accessing PostgreSQL through tcp/ip instead of unix > sockets. Make sure that it is turned on in your PostgreSQL server. > > Read earlier posts in the mailinglist archive for more on this... > > Good luck :-) > > - Jonas > |
From: Jonas S. <jo...@jo...> - 2001-06-20 20:27:03
|
On Wed, 20 Jun 2001, Jonathan Gonzalez wrote: > i haven't check my error log...... Log files are usually the first place to look for hints about the cause of problems. It is quicker than writing an email and waiting for someone on a mailinglist to do guesswork about it (hint hint). In this case have a look at log files for Apache and PostgreSQL (the two servers involved). Friendly, Jonas -- Jonas Smedegaard <jo...@jo...> http://www.jones.dk/~jonas/ IT-guide dr. Jones <dr...@jo...> http://dr.jones.dk/ +45 40843136 Debian GNU/Linux <js...@de...> http://www.debian.org/ GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085 ECA9 9FB0 DB32 C024 40B8 GNU GPL: "The source will be with you... always." |
From: Jonathan G. <jgo...@br...> - 2001-06-20 20:17:35
|
Well in my case.. root is the user that runs the Apche web server (httpd) and also creates the postgres database................. Tomas Kuliavas wrote: > Skot wrote: > >> Hello, >> >> Don't know what I may have missed in the docs. I got all the parts >> installed and I get this in my err.log file: >> >> Compilation failed in require at /var/www/html/sql-ledger/login.pl line >> 65. >> [Wed Jun 20 11:04:34 2001] [error] [client 127.0.0.1] Premature end of >> script headers: /var/www/html/sql-ledger/login.pl >> >> Is it a security thing on my server or did I miss something in the >> setup? >> >> I did manage to find the part about installing DBI and DBD, I can log >> into the database via the command line and through Webmin utilities. >> What esle have I missed? >> >> Scott. > > > > what user is running apache and what user owns the ledger databases? > > If they are not the same, there is possible problem with default > postgresql > security settings. |
From: Skot <gst...@te...> - 2001-06-20 19:55:24
|
Skot wrote: > > Hello, > > Don't know what I may have missed in the docs. I got all the parts > installed and I get this in my err.log file: > > Compilation failed in require at /var/www/html/sql-ledger/login.pl line > 65. > [Wed Jun 20 11:04:34 2001] [error] [client 127.0.0.1] Premature end of > script headers: /var/www/html/sql-ledger/login.pl > OK, I figured it out. I had "DBI" in the driver section of the user's config instead of "Pg". Thanks Scott. |
From: Jonathan G. <jgo...@br...> - 2001-06-20 19:32:21
|
well Skot.. i haven't check my error log...... Skot wrote: > Jonathan Gonzalez wrote: > >> I install the latest version of sql-ledger (1.4.6), i can add new >> users in de Administration page and also i can see the login page, but >> after i type the name and password and click on login... i receive an >> Internal Server Error as follow >> >> Internal Server Error >> >> The server encountered an internal error or misconfiguration and was >> unable to complete your request. >> >> Please contact the server administrator, root@localhost and inform >> them of the time the error occurred, and anything you might have done >> that may have caused the error. >> >> More information about this error may be available in the server error >> log. >> > > Hey, > > That's the sae that just happened to me. Do you also get this error > message in your log: > > Compilation failed in require at /var/www/html/sql-ledger/login.pl line > 65. > [Wed Jun 20 11:04:34 2001] [error] [client 127.0.0.1] Premature end of > script headers: /var/www/html/sql-ledger/login.pl > > Scott. > > |
From: Jonas S. <jo...@jo...> - 2001-06-20 19:29:17
|
On Wed, 20 Jun 2001, Skot wrote: > Don't know what I may have missed in the docs. I got all the parts > installed and I get this in my err.log file: > > Compilation failed in require at /var/www/html/sql-ledger/login.pl line > 65. > [Wed Jun 20 11:04:34 2001] [error] [client 127.0.0.1] Premature end of > script headers: /var/www/html/sql-ledger/login.pl On Wed, 20 Jun 2001, Jonathan Gonzalez wrote: > I install the latest version of sql-ledger (1.4.6), i can add new users > in de Administration page and also i can see the login page, but after i > type the name and password and click on login... i receive an Internal > Server Error as follow > > > Internal Server Error As others have pointed out recently, it is probably the database access that is badly configured. When creating a user in admin.pl you also need to specify access to the PostgreSQL database. Put something like the following in the last fields of my users: Driver: Pg <- NB! cAsE sEnSiTive! Host: localhost Name: ledger Port: 5432 User: Of course you will have to adapt that info to how your own access to Postgres is. Another issue is accessing PostgreSQL through tcp/ip instead of unix sockets. Make sure that it is turned on in your PostgreSQL server. Read earlier posts in the mailinglist archive for more on this... Good luck :-) - Jonas -- Jonas Smedegaard <jo...@jo...> http://www.jones.dk/~jonas/ IT-guide dr. Jones <dr...@jo...> http://dr.jones.dk/ +45 40843136 Debian GNU/Linux <js...@de...> http://www.debian.org/ GnuPG(1024D/C02440B8): 9A98 C6EB C098 9ED0 3085 ECA9 9FB0 DB32 C024 40B8 GNU GPL: "The source will be with you... always." |
From: Tomas K. <to...@bi...> - 2001-06-20 19:11:06
|
Skot wrote: > > Hello, > > Don't know what I may have missed in the docs. I got all the parts > installed and I get this in my err.log file: > > Compilation failed in require at /var/www/html/sql-ledger/login.pl line > 65. > [Wed Jun 20 11:04:34 2001] [error] [client 127.0.0.1] Premature end of > script headers: /var/www/html/sql-ledger/login.pl > > Is it a security thing on my server or did I miss something in the > setup? > > I did manage to find the part about installing DBI and DBD, I can log > into the database via the command line and through Webmin utilities. > What esle have I missed? > > Scott. what user is running apache and what user owns the ledger databases? If they are not the same, there is possible problem with default postgresql security settings. -- Tomas Kuliavas |
From: Skot <gst...@te...> - 2001-06-20 19:00:50
|
Jonathan Gonzalez wrote: > > I install the latest version of sql-ledger (1.4.6), i can add new > users in de Administration page and also i can see the login page, but > after i type the name and password and click on login... i receive an > Internal Server Error as follow > > Internal Server Error > > The server encountered an internal error or misconfiguration and was > unable to complete your request. > > Please contact the server administrator, root@localhost and inform > them of the time the error occurred, and anything you might have done > that may have caused the error. > > More information about this error may be available in the server error > log. > Hey, That's the sae that just happened to me. Do you also get this error message in your log: Compilation failed in require at /var/www/html/sql-ledger/login.pl line 65. [Wed Jun 20 11:04:34 2001] [error] [client 127.0.0.1] Premature end of script headers: /var/www/html/sql-ledger/login.pl Scott. |
From: Jonathan G. <jgo...@br...> - 2001-06-20 18:43:05
|
I install the latest version of sql-ledger (1.4.6), i can add new users in de Administration page and also i can see the login page, but after i type the name and password and click on login... i receive an Internal Server Error as follow Internal Server Error The server encountered an internal error or misconfiguration and was unable to complete your request. Please contact the server administrator, root@localhost and inform them of the time the error occurred, and anything you might have done that may have caused the error. More information about this error may be available in the server error log. ------------------------------------------------------------------------ Apache-AdvancedExtranetServer/1.3.19 Server at johny.cwpanama.net Port 80 Who can help me with this issue..... Regards Jonathan Gonzalez |
From: Skot <gst...@te...> - 2001-06-20 18:13:45
|
Hello, Don't know what I may have missed in the docs. I got all the parts installed and I get this in my err.log file: Compilation failed in require at /var/www/html/sql-ledger/login.pl line 65. [Wed Jun 20 11:04:34 2001] [error] [client 127.0.0.1] Premature end of script headers: /var/www/html/sql-ledger/login.pl Is it a security thing on my server or did I miss something in the setup? I did manage to find the part about installing DBI and DBD, I can log into the database via the command line and through Webmin utilities. What esle have I missed? Scott. |