slashcode-development

[Slashcode-development] postgresql trouble

[<so...@sp...>]

hey,

my problem with setting slash (1.1.1-bender) up on postgresql is what follows.
my DBIx::Password is:

my $virtual1 = {
              'slash' => {
                           'username' => 'slash',
                           'password' => 'kaparma..',
                           'port' => '5432',
                           'database' => 'slash',
                           'attributes' => {},
                           'connect' => 'DBI:Pg:database=slash;host=localhost',
                           'driver' => 'Pg',
                           'host' => 'localhost'
                         }
            };

and apache gives me:
DRIVER Pg:slash
Picking PostgreSQL
Syntax error on line 39 of /home/opt/apache/conf/virtual.conf:
Can't call method "quote" on an undefined value at /usr/lib/perl5/site_perl/5.005/i386-linux/Slash/DB/MySQL.pm line 2817.

this probably is a DBIx configuration problem, but i have no idea how to fix
it.

oh, when i change 'driver' => 'PostgreSQL' it spits out:
DRIVER Pg:slash
Picking PostgreSQL
Major Mojo Bad things
Can't read $DBI::errstr, last handle unknown or destroyed at /usr/lib/perl5/site_perl/5.005/i386-linux/Slash/DB/Utility.pm line 44.
unable to connect to MySQL: Can't connect(DBI:PostgreSQL slash kaparma.. HASH(0x821dcc8)), no database driver specified and DBI_DSN env var not set at /usr/lib/perl5/site_perl/5.005/DBIx/Password.pm line 31
 :

Wojtek

Re: [Slashcode-development] postgresql trouble

[Alessio B. <al...@al...>]

so...@sp... wrote:

> my problem with setting slash (1.1.1-bender) up on postgresql is what follows.

>                            'connect' => 'DBI:Pg:database=slash;host=localhost',

A connect string for PostgreSQL is slightly different. Reads
'DBI:Pg:dbname=slash;host=localhost;port=5432', cannot remember if the
port is needed if it's 5432.

> Can't call method "quote" on an undefined value at

I think the db connection doesn't get initialized.

> /usr/lib/perl5/site_perl/5.005/i386-linux/Slash/DB/MySQL.pm line 2817.

Why it's in MySQL.pm?

> oh, when i change 'driver' => 'PostgreSQL' it spits out:
> DRIVER Pg:slash
> Picking PostgreSQL
> Major Mojo Bad things
> Can't read $DBI::errstr, last handle unknown or destroyed at /usr/lib/perl5/site_perl/5.005/i386-linux/Slash/DB/Utility.pm line 44.
> unable to connect to MySQL: Can't connect(DBI:PostgreSQL slash kaparma.. HASH(0x821dcc8)), no database driver specified and DBI_DSN env var not set at /usr/lib/perl5/site_perl/5.005/DBIx/Password.pm line 31

This makes more sense, it should say anyway 'unable to connect to
PostgreSQL', but maybe it's hardwired in the code?

I will have a try, but I think you should change the connect string.

-- 
Alessio F. Bragadini		al...@al...
APL Financial Services		http://village.albourne.com
Nicosia, Cyprus		 	phone: +357-2-755750

"It is more complicated than you think"
		-- The Eighth Networking Truth from RFC 1925

Re: [Slashcode-development] postgresql trouble

[Brian A. <br...@ta...>]

so...@sp... wrote:
> my $virtual1 = {
>               'slash' => {
>                            'username' => 'slash',
>                            'password' => 'kaparma..',
>                            'port' => '5432',
>                            'database' => 'slash',
>                            'attributes' => {},
>                            'connect' => 'DBI:Pg:database=slash;host=localhost',
>                            'driver' => 'Pg',
>                            'host' => 'localhost'
>                          }
>             };
What version of DBIx::Password are you using? The above looks more like
the output
from an older version for a PostgreSQL entry (or one entered by hand
incorrectly).
Reinstlal DBIx::Password and do a make install. Follow the directions
during the
install (and make sure you have already done a createdb on the database
and
setup the database user).

> oh, when i change 'driver' => 'PostgreSQL' it spits out:
There is no such driver as PostgreSQL (its named Pg). 

	-Brian

[Slashcode-development] Slash mod::perl problem

[<mba...@he...>]

Forgive me if this is in a faq somewhere, I can't find it (by all means
pls point me that direction if it exists)

I am trying to install as indicated in the INSTALL doc:

perl Makefile.PL APACHE_SRC=/where_you_have_the_source DO_HTTPD=
1 \
                        USE_APACI=1 PERL_MARK_WHERE=1 EVERYTHING=1 \
                        APACHE_PREFIX=/where_apache_will_be_installed
                make
                make test
                make install


However, when I get to make, this happens:

/usr/bin/perl `/usr/bin/perl -MConfig -e 'print
$Config{privlibexp}'`/ExtUtils/xsubpp -typemap `/usr/bin/perl -MConfig -e
'print $Config{privlibexp}'`/ExtUtils/typemap Table.xs > Table.c
cc -I. -I../../include -I../../include/regex -I../../include/.././os/unix
-DLINUX=2 -DUSE_HSREGEX -fno-strict-aliasing -D_LARGEFILE_SOURCE
-D_FILE_OFFSET_BITS=64  -I/usr/lib/perl5/5.6.0/ppc-linux/CORE
-I. -I../.. -DUSE_PERL_SSI  -DPERL_MARK_WHERE=1 -DMOD_PERL  `/usr/bin/perl
-MExtUtils::Embed -e ccopts`               -DNO_PERL_RESTART
-DMOD_PERL_VERSION=\"1.21\"  -I./os/unix -I../../include     -c -o
mod_perl.o mod_perl.c
mod_perl.c: In function `perl_handler':
mod_perl.c:783: `PL_siggv' undeclared (first use in this function)
mod_perl.c:783: (Each undeclared identifier is reported only once
mod_perl.c:783: for each function it appears in.)
make[3]: *** [mod_perl.o] Error 1
make[2]: *** [all] Error 1
make[1]: *** [subdirs] Error 1
make[1]: Leaving directory `/tmp/apache_1.3.6/src'
make: *** [apache_httpd] Error 2
[root@shiner mod_perl-1.21]# 



mod perl 1.2.1 and apache 1.3.6 on YellowDog (ppc) linux, kernel 2.2.15.

Re: [Slashcode-development] Slash mod::perl problem

[Brian A. <br...@ta...>]

mba...@he... wrote:
> mod perl 1.2.1 and apache 1.3.6 on YellowDog (ppc) linux, kernel 2.2.15.
I would suggest first switching to apache 1.3.14 and mod_perl 1.24_01.
You can find it here:
http://perl.apache.org/dist/

	-Brian

Re: [Slashcode-development] Slash mod::perl problem

[<mba...@he...>]

On Sat, 16 Dec 2000, Brian Aker wrote:

ba...@he...mba...@he... wrote:
ba...@he...> mod perl 1.2.1 and apache 1.3.6 on YellowDog (ppc) linux, kernel 2.2.15.
ba...@he...I would suggest first switching to apache 1.3.14 and mod_perl 1.24_01.
ba...@he...You can find it here:
ba...@he...http://perl.apache.org/dist/
ba...@he...
ba...@he...	-Brian
ba...@he...
ba...@he..._______________________________________________
ba...@he...Slashcode-development mailing list
ba...@he...Sla...@li...
ba...@he...http://lists.sourceforge.net/mailman/listinfo/slashcode-development
ba...@he...




OK so I think I've gone through the instructions a couple times now and
done everything by the book. Now, when I try to start slashd I get this:

[root@shiner slash]# /etc/rc.d/init.d/slashd start
Starting slashd: ok.
[root@shiner slash]#
DBI->connect(database=slash;host=localhost) failed: Access denied for
user: 'slash@localhost' (Using password: YES) at Slash.pm line 1189
Access denied for user: 'slash@localhost' (Using password: YES) at
Slash.pm line 1189.
Compilation failed in require at ./slashd line 637.
why am I here? at ./slashd line 39
        main::END() called at ./slashd line 0
        require 0 called at ./slashd line 0


However I created all the databases per instruction, so I suppose perms
should be correct?? vertainly (using webmin) user slash appears to have
the proper perms.

Could someone point mein the right direction?

thanks-

-mab