Menu
▾
▴
sql-ledger-users
|
From: kevin b. <kev...@bi...> - 2002-02-17 15:53:29
|
hi there, i am just trying to install SL on a slackware server which is colocated on a server farm and i'm getting the error Error! No Database Drivers available! when i access http://localhost/sql-ledger/admin.pl using lynx over a remote sesion. i have these questions, can anybody help?!? has anyone run SL successfully on slackware - i am a debian man myself but the server farm initially sets up the servers with slackware. it would cost - but i can get them to reinstall and use debian stable instead? how do you browse the list archive? thanks for any help, kev bailey |
|
From: kevin b. <kev...@bi...> - 2002-02-17 18:46:10
|
hi all, it looks like i am further on with an attempt to install to a debian/woody test machine. i have come up against the error permission denied users/members also, i am not entirely sure about the debian instructions. 1. i take it that there is a typo on point 4 and that the file which should be altered is /etc/postgresql/postmaster.conf and not .init 2. the install DBI - is this possible to do via apt-get etc. if not - where do i get hold of DBI-1.14.tar.gz 3. these lines, $ export POSTGRES_INCLUDE=/usr/include/postgresql $ export POSTGRES_LIB=/var/lib/postgres ...can i take it that these are temporary variables set up for when the DBD-Pg is installed which happens next. and again - where do i get hold of DBD-Pg-0.95 thanks for any help, kev |
|
From: <gha...@fr...> - 2002-02-17 19:44:34
|
On Sun, 17 Feb 2002, kevin bailey wrote: > it looks like i am further on with an attempt to install to a > debian/woody test machine. > > 2. the install DBI - is this possible to do via apt-get etc. > > if not - where do i get hold of > DBI-1.14.tar.gz libdbi-perl is what Debian calls it. I have 1.20 on unstable > and again - where do i get hold of DBD-Pg-0.95 libdbd-pg-perl is what Debian calls it. I have 1.01 on unstable Gord |
|
From: kevin b. <kev...@bi...> - 2002-02-17 21:36:03
|
hi there, thanks for the reply - i had found these packages but its good to hear i'm on the right track! i am going to suggest some updates to the installation instructions now that woody is about to be frozen and become the stable debian distribution. i am currently tring to create a new database - and am getting the message IDENT authentication failed i think this may be to do with the setup of postgres and am checking it out via deja.com thanks again, kev gha...@fr... wrote: > On Sun, 17 Feb 2002, kevin bailey wrote: > > >>it looks like i am further on with an attempt to install to a >>debian/woody test machine. >> >>2. the install DBI - is this possible to do via apt-get etc. >> >>if not - where do i get hold of >>DBI-1.14.tar.gz >> > libdbi-perl is what Debian calls it. I have 1.20 on unstable > >>and again - where do i get hold of DBD-Pg-0.95 >> > libdbd-pg-perl is what Debian calls it. I have 1.01 on unstable > > Gord > > > > |
|
From: <gha...@fr...> - 2002-02-17 21:44:56
|
On Sun, 17 Feb 2002, kevin bailey wrote:
> i am currently tring to create a new database - and am getting the message
>
> IDENT authentication failed
You need to edit /etc/postgresql/pg_hba.conf to set up how
you want Host Based Authentication (that's what hba is in pg_hba)
working. I think dpkg installs a line like:
#host all 127.0.0.1 255.255.255.255 password
I changed mine to
host all 192.168.10.2 255.255.255.255 password
^^^^^^^^^^^^ IP of your interface
Gord
|
|
From: kevin b. <kev...@bi...> - 2002-02-17 22:44:47
|
thanks for all the help - with a newsgroup like this sql-ledger is going to be huge!!! i now have sql-ledger working on my debian woody machine - i will post up some notes during the week. next challenge is to get it working on slackware! thanks again - kev gha...@fr... wrote: > On Sun, 17 Feb 2002, kevin bailey wrote: > > >>i am currently tring to create a new database - and am getting the message >> >>IDENT authentication failed >> > > You need to edit /etc/postgresql/pg_hba.conf to set up how > you want Host Based Authentication (that's what hba is in pg_hba) > working. I think dpkg installs a line like: > #host all 127.0.0.1 255.255.255.255 password > I changed mine to > host all 192.168.10.2 255.255.255.255 password > ^^^^^^^^^^^^ IP of your interface > > > Gord > > > NOTICE: When replying, please Reply to the list address. This way other members know if the issues have been resolved or not. Thanks! Your List administrator. > > > > |
|
From: kevin b. <kev...@bi...> - 2002-02-18 21:52:38
|
kevin bailey wrote: > thanks for all the help - with a newsgroup like this sql-ledger is going > to be huge!!! > > i now have sql-ledger working on my debian woody machine - i will post > up some notes during the week. > here are the notes - i have cut and pasted the instructions - and added some comments in amongst them, kev Debian Installation unpack into /var/www/sql-ledger install postgresql (Dselect) install apache # this did not seem to be necessary install libpg-dev (Dselect) # other packages required libdib-perl libdbd-pg-perl libpgperl # should be /etc/postgresql/postmaster.conf modify /etc/postgresql/postmaster.init PGALLOWTCPIP=yes # this produced an error when restarting postgres - i left it out cos this port seems to be the default anyway. PGPORT=5432 create a user for managing SQL-Ledger databases from root su postgres $ createuser name of user- (create a postgres user who is also a Linux user this user will be an account manager. Enable this user to create db and users) # not required cos of the packages installed earlier. --------------------------------------- install DBI perl Makefile.PL make make test login as root make install $ export POSTGRES_INCLUDE=/usr/include/postgresql $ export POSTGRES_LIB=/var/lib/postgres install DBD-Pg login as account manager (above) perl Makefile.PL make make test login as root make install #-------------------------------------------------------------------------------------- change /etc/apache/httpd.conf and add AddHandler cgi-script .pl ScriptAlias /sql-ledger/ /var/www/sql-ledger/ <Directory /var/www/sql-ledger> Options ExecCGI Includes FollowSymlinks </Directory> restart apache # the apahce server on woody runs under the user www-data - so use chown www-data: users templates users/members the ':' menas that the default group for www-data is set. Make sure the web server has write permission to write to the following users/ templates/ users/members # chown nobody:nogroup users templates users/members # i found the file was not created automatically - i 'touched' it and then set the ownership to www-data users/members might not exist. Not to worry, the file will be created when you use admin.pl for the first time. Of course, the permission has to be set correctly for the users directory. # finally the settings in pg_hba.conf were too restrictive and i set them to host all 127.0.0.1 255.0.0.0 trust obviously this should be tighter but it was late at the time!!! From browser enter http://my_domain/sql-ledger/admin.pl Login as the postgres user (account manager) you have created (above) Create a DB Create users then enter http://my_domain/sql-ledger/login.pl Login as one of the users you have just created |
|
From: <gha...@fr...> - 2002-02-18 23:18:35
|
On Mon, 18 Feb 2002, kevin bailey wrote: > here are the notes - i have cut and pasted the instructions - and added > some comments in amongst them, [...] > Debian Installation > unpack into /var/www/sql-ledger [...] > # other packages required > > libdib-perl libdbd-pg-perl libpgperl ^^^^^^^^^^^ libdbi-perl Just the one typo that I can see. Gord |
|
From: Kenneth G. <la...@th...> - 2002-02-18 02:31:14
|
On Monday 18 February 2002 00:25, kevin bailey wrote: > if not - where do i get hold of > DBI-1.14.tar.gz CPAN kg |
|
From: <gha...@fr...> - 2002-02-18 03:27:30
|
On Mon, 18 Feb 2002, Kenneth Gonsalves wrote: > On Monday 18 February 2002 00:25, kevin bailey wrote: > > > if not - where do i get hold of > > DBI-1.14.tar.gz > CPAN He wanted to apt-get them as Debian packages. Knowing the CPAN name for something doesn't always help in finding the Debian name for the same package. It is preferred you get packages as debs, if possible to make keeping things consistent as easy as possible. Gord |
|
From: Cesar V. <da...@et...> - 2002-02-17 19:56:09
|
El Dom 17 Feb 2002 12:02, kevin bailey escribi=F3: > Error! No Database Drivers available! > SQL-Ledger checks whether Perl has DBI/DBD drivers installed. Here it can= not=20 find any; maybe you have to install DBD-Pg (if you are using PostgreSQL). BTW, the check is in the bin/_browser_/admin.pl script, using User.pm mod= ule.=20 =20 > when i access > http://localhost/sql-ledger/admin.pl > > using lynx over a remote sesion. > > i have these questions, > > can anybody help?!? > > has anyone run SL successfully on slackware - i am a debian man myself > but the server farm initially sets up the servers with slackware. it > would cost - but i can get them to reinstall and use debian stable inst= ead? > > how do you browse the list archive? > > thanks for any help, > > kev bailey > > > NOTICE: When replying, please Reply to the list address. This way other > members know if the issues have been resolved or not. Thanks! Your List > administrator. --=20 C=E9sar Villanueva SuSE Linux C.A. "First they ignore you. Then they laugh at you. Then they fight you. Then you win." [Gandhi]=20 |
|
From: kevin b. <kev...@bi...> - 2002-02-17 21:38:30
|
thanks for the help BTW - great quote at the bottom of your emails - it should be the motto for linux!! kev Cesar Villanueva wrote: > El Dom 17 Feb 2002 12:02, kevin bailey escribió: > >>Error! No Database Drivers available! >> >> > > SQL-Ledger checks whether Perl has DBI/DBD drivers installed. Here it can not > find any; maybe you have to install DBD-Pg (if you are using PostgreSQL). > > BTW, the check is in the bin/_browser_/admin.pl script, using User.pm module. > > > > >>when i access >>http://localhost/sql-ledger/admin.pl >> >>using lynx over a remote sesion. >> >>i have these questions, >> >>can anybody help?!? >> >>has anyone run SL successfully on slackware - i am a debian man myself >>but the server farm initially sets up the servers with slackware. it >>would cost - but i can get them to reinstall and use debian stable instead? >> >>how do you browse the list archive? >> >>thanks for any help, >> >>kev bailey >> >> >>NOTICE: When replying, please Reply to the list address. This way other >>members know if the issues have been resolved or not. Thanks! Your List >>administrator. >> > |
Thanks for helping keep SourceForge clean.
X