From: Marc G. F. <sc...@hu...> - 2011-02-13 08:31:31
|
These may be obvious, but since you don't mention, will ask: If you do: mysql -u xlash -h localhost -p xlash can you connect to the database? Based on the 'Access denied for user' error message, I suspect the answer to the above will be no ... but, need to eliminate that first ... On Sun, 13 Feb 2011, George Taft wrote: > So I'm trying to install Slash fresh in CentOS 5.5 from the lottadot Git > repo. When it gets to installing Bundle::Slash, two packages fail: > > > Failed during this command: > KROW/DBIx-Password-1.9.tar.gz : make_test NO > MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO > > > When I look specifically at the first failure, this is the key error > message: > > DBI connect('database=xlash;host=localhost','xlash',...) failed: > Access denied for user 'xlash'@'localhost' to database 'xlash' > at blib/lib/DBIx/Password.pm line 31 > > > This was a problem I've consistently had trying to install under both CentOS > and Fedora 14. Why might this be happening? > > == George > > P.S.: I have a complete log of the commands I've executed since installing a > fresh distribution of CentOS 5.5 from scratch, in case that helps, but I > haven't pored over every message during the install of a given package. > > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. sc...@hu... http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... |
From: Marc G. F. <sc...@hu...> - 2011-02-14 15:32:30
|
On Mon, 14 Feb 2011, George Taft wrote: > I've tried, and it still fails, just like it does at Perl Monks: > <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't know how to > write/install a replacement for the functionality of ParallelUA like the > page recommends. > I don't even know what I was talking about below when I said versions > "5.814, 5.816 and 5.830" of perl. Seriously lost here. Getting Slash running > on CentOS doesn't seem worth pursuing at the moment. Is there any version of > Linux that will successfully install, or do I have to use FreeBSD? I don't use anything but FreeBSD, so can't answer on that one :) But, I am curious about this ... would you be comfortable with providing me access to that install to take a look? Or, if not, can you do the following, as root, on the machine: typescript /tmp/debug perl -v <enter in all the commands you type to try and install the module> exit and then email me the contents of /tmp/debug directly (or put it somewhere on teh web I can access) ... > == George > > On Sun, Feb 13, 2011 at 11:21 AM, Marc G. Fournier <sc...@hu...> wrote: > On Sun, 13 Feb 2011, George Taft wrote: > > It looks like ParallelUserAgent broke after perl 5.814; > 5.816 and 5.830 were > both reported as having it broken, as well as 5.12.1. > Does this mean we should go back to that version of perl > just to make Slash > work? > > > I'm running the current site on Perl 5.10.1 ... and: > > p5-ParallelUA-2.57_2 > > AGain, as a reminder, this is with FreeBSD ... now, that said, I had > to istall p5-ParallelUA-2.57_2 *after* Slash::Bundle, so its possible > that the one in Slash::Bundle is broken ... ? Try and install > p5-ParallelUA-2.57_2 manually and see if that works ... > > > > > > On Sun, Feb 13, 2011 at 3:45 AM, George Taft > <geo...@gm...> > wrote: > Ooh. Now, suddenly, DBIx-Password didn't fail when I > reran CPAN > and typed install Bundle::Slash. Now only > ParallelUserAgent is > failing. Progress. > I could SWEAR I typed in those grant lines in mysql > beforehand. > > > On Sun, Feb 13, 2011 at 3:41 AM, George Taft > <geo...@gm...> > wrote: > Yep. Just did both of them again, the grant select et > al > and then the grant process. > > > On Sun, Feb 13, 2011 at 3:37 AM, Marc <sc...@hu...> > wrote: > Did u do the GRANT statement that listed in the > INSTALL file for setting up the mysql server? > > Sent from my iPhone > > On 2011-02-13, at 3:34, George Taft > <geo...@gm...> wrote: > > Answer is indeed no... > > On Sun, Feb 13, 2011 at 3:31 AM, Marc G. > Fournier <sc...@hu...> wrote: > > These may be obvious, but since > you don't mention, will ask: > > If you do: > > mysql -u xlash -h localhost -p > xlash > > can you connect to the database? > > Based on the 'Access denied for > user' error message, I suspect the > answer to the above will be no ... > but, need to eliminate that first > ... > > > > On Sun, 13 Feb 2011, George Taft wrote: > > So I'm trying to install Slash > fresh in CentOS 5.5 from the > lottadot Git > repo. When it gets to installing > Bundle::Slash, two packages fail: > > > Failed during this command: > KROW/DBIx-Password-1.9.tar.gz > : make_test NO > > MARCLANG/ParallelUserAgent-2.57.tar.gz > : make_test NO > > > When I look specifically at the > first failure, this is the key > error > message: > > DBI > connect('database=xlash;host=localhost','xlash',...) > failed: > Access denied for user > 'xlash'@'localhost' to database > 'xlash' > at blib/lib/DBIx/Password.pm > line 31 > > > This was a problem I've > consistently had trying to install > under both CentOS > and Fedora 14. Why might this be > happening? > > == George > > P.S.: I have a complete log of the > commands I've executed since > installing a > fresh distribution of CentOS 5.5 > from scratch, in case that helps, > but I > haven't pored over every message > during the install of a given > package. > > > > ---- > Marc G. Fournier > Hub.Org Hosting Solutions S.A. > sc...@hu... > http://www.hub.org > > Yahoo:yscrappy Skype: hub.org > ICQ:7615664 MSN:sc...@hu... > > > > > > > > > ---- > Marc G. Fournier Hub.Org Hosting Solutions S.A. > sc...@hu... http://www.hub.org > > Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... > > > > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. sc...@hu... http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... |
From: Shane Z. <sh...@lo...> - 2011-02-14 15:49:44
|
Interestingly enough, CentOS/Redhat/Fedora is _all_ I have ever run it on (CentOS/Redhat in production). Fedora for dev at times. Mac OSX for most dev, to be honest. If I recall correctly, the *big* thing was getting apache and mod_perl compiled together correctly. Shane On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: >> Getting Slash running >> on CentOS doesn't seem worth pursuing at the moment. |
From: Jamie M. <ja...@mc...> - 2011-02-14 16:58:02
|
On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: > On Mon, 14 Feb 2011, George Taft wrote: > >> I've tried, and it still fails, just like it does at Perl Monks: >> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't know how to >> write/install a replacement for the functionality of ParallelUA FWIW... LWP::UserAgent::Parallel is only used by checkForOpenProxy(). That's the function that scans a few common HTTP proxy ports on the current user's IP address to see if that IP is running an open proxy, and if so, limits access in some way. As I recall, you can't post anonymously from a proxy or something like that. It's been moderately-helpful on Slashdot, but it's not an absolute necessity or anything. If you want, strip out that function and calls to it, delete Slash::Custom::ParUserAgent, and remove L::U::P from the list of install requirements. -- Jamie McCarthy jam...@gm... ja...@mc... 269-267-2008 |
From: Marc G. F. <sc...@hu...> - 2011-02-14 17:05:50
|
On Mon, 14 Feb 2011, Jamie McCarthy wrote: > On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: > >> On Mon, 14 Feb 2011, George Taft wrote: >> >>> I've tried, and it still fails, just like it does at Perl Monks: >>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't know how to >>> write/install a replacement for the functionality of ParallelUA > > FWIW... > > LWP::UserAgent::Parallel is only used by checkForOpenProxy(). That's the > function that scans a few common HTTP proxy ports on the current user's > IP address to see if that IP is running an open proxy, and if so, limits > access in some way. As I recall, you can't post anonymously from a proxy > or something like that. > > It's been moderately-helpful on Slashdot, but it's not an absolute > necessity or anything. If you want, strip out that function and calls to > it, delete Slash::Custom::ParUserAgent, and remove L::U::P from the list > of install requirements. Since I know it is working, rather try and debug it and keep the functinality :) ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. sc...@hu... http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... |
From: George T. <geo...@gm...> - 2011-02-14 20:22:38
|
While this is not a verbatim log of my effort to install under CentOS, it's a list of the commands I issued. Finally at the bottom are the errors I encountered. Reissuing the MySQL commands seemed to fix the first problem, but the second still stands. == George yum update yum install make yum install lynx yum install gcc yum remove perl lynx http://www.cpan.org/src/stable.tar.gz cd /tmp/perl[dir] sh Configure -de make make test make install yum install mysql-server /sbin/chkconfig --levels 235 mysqld on yum install mysql-devel # what about "mysql-client" that misterorange.com refers to? it doesn't seem to exist any more. Is this step still necessary? mysql.i386 0:5.0.77-4.el5_5.4 nano /etc/my.cnf [add "timezone=GMT" to end of file] service mysqld start mysql create database xlash; grant select, insert, update, delete, lock tables, create, drop, index, alter on slash.* to 'xlash'@'localhost' identified by 'haxlash'; grant process on *.* to 'xlash'@'localhost' identified by 'haxlash'; /usr/local/bin/perl -MCPAN -e "install q{LWP}" lynx http://mirrors.axint.net/apache//httpd/apache_1.3.42.tar.gz cd /tmp; tar -xvzf lynx http://perl.apache.org/dist/mod_perl-1.31.tar.gz perl Makefile.PL apache_src=/tmp/apache_1.3.42/src/ do_httpd=1 use_apaci=1 perl_mark_where=1 everything=1 apache_prefix=/usr/local/apache make make test make install yum install zlib-devel [already installed] yum install openssl-devel [already installed] yum install perl [already installed] yum install cpio [already installed] yum install expat-devel yum install gettext-devel rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm yum repolist [should show EPEL repo] yum install git git-daemon git clone git://github.com/lottadot/haxlash.git haxlash cd haxlash git checkout HEAD cpan install Bundle::CPAN quit cpan install Bundle::LWP install Bundle::Slash [again] Failed during this command: > KROW/DBIx-Password-1.9.tar.gz : make_test NO > MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO DBI connect('database=xlash;host=localhost','xlash',...) failed: Access > denied for user 'xlash'@'localhost' to database 'xlash' at > blib/lib/DBIx/Password.pm line 31 On Mon, Feb 14, 2011 at 12:05 PM, Marc G. Fournier <sc...@hu...> wrote: > On Mon, 14 Feb 2011, Jamie McCarthy wrote: > > > On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: > > > >> On Mon, 14 Feb 2011, George Taft wrote: > >> > >>> I've tried, and it still fails, just like it does at Perl Monks: > >>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't know how > to > >>> write/install a replacement for the functionality of ParallelUA > > > > FWIW... > > > > LWP::UserAgent::Parallel is only used by checkForOpenProxy(). That's the > > function that scans a few common HTTP proxy ports on the current user's > > IP address to see if that IP is running an open proxy, and if so, limits > > access in some way. As I recall, you can't post anonymously from a proxy > > or something like that. > > > > It's been moderately-helpful on Slashdot, but it's not an absolute > > necessity or anything. If you want, strip out that function and calls to > > it, delete Slash::Custom::ParUserAgent, and remove L::U::P from the list > > of install requirements. > > Since I know it is working, rather try and debug it and keep the > functinality :) > > ---- > Marc G. Fournier Hub.Org Hosting Solutions S.A. > sc...@hu... http://www.hub.org > > Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... > > > ------------------------------------------------------------------------------ > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: > Pinpoint memory and threading errors before they happen. > Find and fix more than 250 security defects in the development cycle. > Locate bottlenecks in serial and parallel code that limit performance. > http://p.sf.net/sfu/intel-dev2devfeb > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general > |
From: Shane Z. <sh...@lo...> - 2011-02-14 21:19:25
|
I think to install DBIx::Password you've always got to drop into shell/console from CPAN and then do a perl Makefile.PL..... might be that way for ParallelUserAgent too. On Feb 14, 2011, at 3:22 PM, George Taft wrote: > While this is not a verbatim log of my effort to install under CentOS, it's a list of the commands I issued. Finally at the bottom are the errors I encountered. Reissuing the MySQL commands seemed to fix the first problem, but the second still stands. == George > > yum update > yum install make > yum install lynx > yum install gcc > yum remove perl > lynx http://www.cpan.org/src/stable.tar.gz > cd /tmp/perl[dir] > sh Configure -de > make > make test > make install > > yum install mysql-server > /sbin/chkconfig --levels 235 mysqld on > yum install mysql-devel # what about "mysql-client" that misterorange.com refers to? it doesn't seem to exist any more. Is this step still necessary? > > mysql.i386 0:5.0.77-4.el5_5.4 > > nano /etc/my.cnf [add "timezone=GMT" to end of file] > > service mysqld start > mysql > create database xlash; > grant select, insert, update, delete, lock tables, create, drop, index, alter on slash.* to 'xlash'@'localhost' identified by 'haxlash'; > grant process on *.* to 'xlash'@'localhost' identified by 'haxlash'; > > /usr/local/bin/perl -MCPAN -e "install q{LWP}" > > lynx http://mirrors.axint.net/apache//httpd/apache_1.3.42.tar.gz > cd /tmp; tar -xvzf > > lynx http://perl.apache.org/dist/mod_perl-1.31.tar.gz > > perl Makefile.PL apache_src=/tmp/apache_1.3.42/src/ do_httpd=1 use_apaci=1 perl_mark_where=1 everything=1 apache_prefix=/usr/local/apache > make > make test > make install > > yum install zlib-devel [already installed] > yum install openssl-devel [already installed] > yum install perl [already installed] > yum install cpio [already installed] > yum install expat-devel > yum install gettext-devel > > rpm -Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noarch.rpm > yum repolist [should show EPEL repo] > yum install git git-daemon > git clone git://github.com/lottadot/haxlash.git haxlash > cd haxlash > git checkout HEAD > > cpan > install Bundle::CPAN > quit > cpan > install Bundle::LWP > > install Bundle::Slash [again] > > Failed during this command: > KROW/DBIx-Password-1.9.tar.gz : make_test NO > MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO > > DBI connect('database=xlash;host=localhost','xlash',...) failed: Access denied for user 'xlash'@'localhost' to database 'xlash' at blib/lib/DBIx/Password.pm line 31 > > > > > > > On Mon, Feb 14, 2011 at 12:05 PM, Marc G. Fournier <sc...@hu...> wrote: > On Mon, 14 Feb 2011, Jamie McCarthy wrote: > > > On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: > > > >> On Mon, 14 Feb 2011, George Taft wrote: > >> > >>> I've tried, and it still fails, just like it does at Perl Monks: > >>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't know how to > >>> write/install a replacement for the functionality of ParallelUA > > > > FWIW... > > > > LWP::UserAgent::Parallel is only used by checkForOpenProxy(). That's the > > function that scans a few common HTTP proxy ports on the current user's > > IP address to see if that IP is running an open proxy, and if so, limits > > access in some way. As I recall, you can't post anonymously from a proxy > > or something like that. > > > > It's been moderately-helpful on Slashdot, but it's not an absolute > > necessity or anything. If you want, strip out that function and calls to > > it, delete Slash::Custom::ParUserAgent, and remove L::U::P from the list > > of install requirements. > > Since I know it is working, rather try and debug it and keep the > functinality :) > > ---- > Marc G. Fournier Hub.Org Hosting Solutions S.A. > sc...@hu... http://www.hub.org > > Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... > > ------------------------------------------------------------------------------ > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: > Pinpoint memory and threading errors before they happen. > Find and fix more than 250 security defects in the development cycle. > Locate bottlenecks in serial and parallel code that limit performance. > http://p.sf.net/sfu/intel-dev2devfeb > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general > > ------------------------------------------------------------------------------ > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: > Pinpoint memory and threading errors before they happen. > Find and fix more than 250 security defects in the development cycle. > Locate bottlenecks in serial and parallel code that limit performance. > http://p.sf.net/sfu/intel-dev2devfeb_______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general |
From: Marc G. F. <sc...@hu...> - 2011-02-14 20:55:12
|
What I'd be curious to know is why the test failed ... which test? Can you download the source code from CPAN and do a build/install? MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO Its the same version that I have installed here ... On Mon, 14 Feb 2011, George Taft wrote: > While this is not a verbatim log of my effort to install under CentOS, it's > a list of the commands I issued. Finally at the bottom are the errors I > encountered. Reissuing the MySQL commands seemed to fix the first problem, > but the second still stands. == George > > yum update > > yum install make > > yum install lynx > > yum install gcc > > yum remove perl > > lynx http://www.cpan.org/src/stable.tar.gz > > cd /tmp/perl[dir] > > sh Configure -de > > make > > make test > > make install > > > yum install mysql-server > > /sbin/chkconfig --levels 235 mysqld on > > yum install mysql-devel # what about "mysql-client" > that misterorange.com refers to? it doesn't seem to exist any > more. Is this step still necessary? > > > mysql.i386 0:5.0.77-4.el5_5.4 > > > nano /etc/my.cnf [add "timezone=GMT" to end of file] > > > service mysqld start > > mysql > > create database xlash; > > grant select, insert, update, delete, lock tables, create, > drop, index, alter on slash.* to 'xlash'@'localhost' identified > by 'haxlash'; > > grant process on *.* to 'xlash'@'localhost' identified by > 'haxlash'; > > > /usr/local/bin/perl -MCPAN -e "install q{LWP}" > > > lynx http://mirrors.axint.net/apache//httpd/apache_1.3.42.tar.gz > > cd /tmp; tar -xvzf > > > lynx http://perl.apache.org/dist/mod_perl-1.31.tar.gz > > > perl Makefile.PL apache_src=/tmp/apache_1.3.42/src/ do_httpd=1 > use_apaci=1 perl_mark_where=1 everything=1 > apache_prefix=/usr/local/apache > > make > > make test > > make install > > > yum install zlib-devel [already installed] > > yum install openssl-devel [already installed] > > yum install perl [already installed] > > yum install cpio [already installed] > > yum install expat-devel > > yum install gettext-devel > > > rpm-Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noa > rch.rpm > > yum repolist [should show EPEL repo] > > yum install git git-daemon > > git clone git://github.com/lottadot/haxlash.git haxlash > > cd haxlash > > git checkout HEAD > > > cpan > > install Bundle::CPAN > > quit > > cpan > > install Bundle::LWP > > > install Bundle::Slash [again] > > > Failed during this command: > KROW/DBIx-Password-1.9.tar.gz : make_test NO > MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO > > > DBI connect('database=xlash;host=localhost','xlash',...) failed: > Access denied for user 'xlash'@'localhost' to database 'xlash' > at blib/lib/DBIx/Password.pm line 31 > > > > > > > > On Mon, Feb 14, 2011 at 12:05 PM, Marc G. Fournier <sc...@hu...> wrote: > On Mon, 14 Feb 2011, Jamie McCarthy wrote: > > > On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: > > > >> On Mon, 14 Feb 2011, George Taft wrote: > >> > >>> I've tried, and it still fails, just like it does at Perl > Monks: > >>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't > know how to > >>> write/install a replacement for the functionality of > ParallelUA > > > > FWIW... > > > > LWP::UserAgent::Parallel is only used by checkForOpenProxy(). > That's the > > function that scans a few common HTTP proxy ports on the > current user's > > IP address to see if that IP is running an open proxy, and if > so, limits > > access in some way. As I recall, you can't post anonymously > from a proxy > > or something like that. > > > > It's been moderately-helpful on Slashdot, but it's not an > absolute > > necessity or anything. If you want, strip out that function > and calls to > > it, delete Slash::Custom::ParUserAgent, and remove L::U::P > from the list > > of install requirements. > > Since I know it is working, rather try and debug it and keep the > functinality :) > > ---- > Marc G. Fournier Hub.Org Hosting Solutions S.A. > sc...@hu... http://www.hub.org > > Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... > > --------------------------------------------------------------------------- > --- > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio > XE: > Pinpoint memory and threading errors before they happen. > Find and fix more than 250 security defects in the development cycle. > Locate bottlenecks in serial and parallel code that limit performance. > http://p.sf.net/sfu/intel-dev2devfeb > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general > > > > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. sc...@hu... http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... |
From: Shane Z. <sh...@lo...> - 2011-02-14 22:44:25
|
it's probably failing because you've not setup your Password.pm file yet. Create that, make install it, and I betcha it passes. On Feb 14, 2011, at 3:55 PM, Marc G. Fournier wrote: > > What I'd be curious to know is why the test failed ... which test? Can > you download the source code from CPAN and do a build/install? > > MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO > > Its the same version that I have installed here ... > > On Mon, 14 Feb 2011, George Taft wrote: > >> While this is not a verbatim log of my effort to install under CentOS, it's >> a list of the commands I issued. Finally at the bottom are the errors I >> encountered. Reissuing the MySQL commands seemed to fix the first problem, >> but the second still stands. == George >> >> yum update >> >> yum install make >> >> yum install lynx >> >> yum install gcc >> >> yum remove perl >> >> lynx http://www.cpan.org/src/stable.tar.gz >> >> cd /tmp/perl[dir] >> >> sh Configure -de >> >> make >> >> make test >> >> make install >> >> >> yum install mysql-server >> >> /sbin/chkconfig --levels 235 mysqld on >> >> yum install mysql-devel # what about "mysql-client" >> that misterorange.com refers to? it doesn't seem to exist any >> more. Is this step still necessary? >> >> >> mysql.i386 0:5.0.77-4.el5_5.4 >> >> >> nano /etc/my.cnf [add "timezone=GMT" to end of file] >> >> >> service mysqld start >> >> mysql >> >> create database xlash; >> >> grant select, insert, update, delete, lock tables, create, >> drop, index, alter on slash.* to 'xlash'@'localhost' identified >> by 'haxlash'; >> >> grant process on *.* to 'xlash'@'localhost' identified by >> 'haxlash'; >> >> >> /usr/local/bin/perl -MCPAN -e "install q{LWP}" >> >> >> lynx http://mirrors.axint.net/apache//httpd/apache_1.3.42.tar.gz >> >> cd /tmp; tar -xvzf >> >> >> lynx http://perl.apache.org/dist/mod_perl-1.31.tar.gz >> >> >> perl Makefile.PL apache_src=/tmp/apache_1.3.42/src/ do_httpd=1 >> use_apaci=1 perl_mark_where=1 everything=1 >> apache_prefix=/usr/local/apache >> >> make >> >> make test >> >> make install >> >> >> yum install zlib-devel [already installed] >> >> yum install openssl-devel [already installed] >> >> yum install perl [already installed] >> >> yum install cpio [already installed] >> >> yum install expat-devel >> >> yum install gettext-devel >> >> >> rpm-Uvh http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noa >> rch.rpm >> >> yum repolist [should show EPEL repo] >> >> yum install git git-daemon >> >> git clone git://github.com/lottadot/haxlash.git haxlash >> >> cd haxlash >> >> git checkout HEAD >> >> >> cpan >> >> install Bundle::CPAN >> >> quit >> >> cpan >> >> install Bundle::LWP >> >> >> install Bundle::Slash [again] >> >> >> Failed during this command: >> KROW/DBIx-Password-1.9.tar.gz : make_test NO >> MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO >> >> >> DBI connect('database=xlash;host=localhost','xlash',...) failed: >> Access denied for user 'xlash'@'localhost' to database 'xlash' >> at blib/lib/DBIx/Password.pm line 31 >> >> >> >> >> >> >> >> On Mon, Feb 14, 2011 at 12:05 PM, Marc G. Fournier <sc...@hu...> wrote: >> On Mon, 14 Feb 2011, Jamie McCarthy wrote: >> >>> On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: >>> >>>> On Mon, 14 Feb 2011, George Taft wrote: >>>> >>>>> I've tried, and it still fails, just like it does at Perl >> Monks: >>>>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't >> know how to >>>>> write/install a replacement for the functionality of >> ParallelUA >>> >>> FWIW... >>> >>> LWP::UserAgent::Parallel is only used by checkForOpenProxy(). >> That's the >>> function that scans a few common HTTP proxy ports on the >> current user's >>> IP address to see if that IP is running an open proxy, and if >> so, limits >>> access in some way. As I recall, you can't post anonymously >> from a proxy >>> or something like that. >>> >>> It's been moderately-helpful on Slashdot, but it's not an >> absolute >>> necessity or anything. If you want, strip out that function >> and calls to >>> it, delete Slash::Custom::ParUserAgent, and remove L::U::P >> from the list >>> of install requirements. >> >> Since I know it is working, rather try and debug it and keep the >> functinality :) >> >> ---- >> Marc G. Fournier Hub.Org Hosting Solutions S.A. >> sc...@hu... http://www.hub.org >> >> Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... >> >> --------------------------------------------------------------------------- >> --- >> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio >> XE: >> Pinpoint memory and threading errors before they happen. >> Find and fix more than 250 security defects in the development cycle. >> Locate bottlenecks in serial and parallel code that limit performance. >> http://p.sf.net/sfu/intel-dev2devfeb >> _______________________________________________ >> Slashcode-general mailing list >> Sla...@li... >> https://lists.sourceforge.net/lists/listinfo/slashcode-general >> >> >> >> > > ---- > Marc G. Fournier Hub.Org Hosting Solutions S.A. > sc...@hu... http://www.hub.org > > Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... > > ------------------------------------------------------------------------------ > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: > Pinpoint memory and threading errors before they happen. > Find and fix more than 250 security defects in the development cycle. > Locate bottlenecks in serial and parallel code that limit performance. > http://p.sf.net/sfu/intel-dev2devfeb > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general |
From: Marc G. F. <sc...@hu...> - 2011-02-14 23:23:10
|
Huh? When I install p5-DBIx-Password under FreeBSD. that is part of the install process ... which I think is one of hte most annoying perl modules as I've never been able to figure out how to "add users" without having to re-install the port ... But, looking at exactly what DBIx-Password is all about, this should be one of the easiest things to get rid of ... all it does is saves having ot create a db.conf file (or whatever we call it) to store userid/passwds in ... The funny thing is that it really is one of those 'security by obscurity' kinda things, as everything is stored plain text in the file: /usr/local/lib/perl5/./site_perl/5.10.1/DBIx/Password.pm But, there is one flaw in that module, which, altho not huge, can be annoying ... you can't have the same user connecting to different databases ... eerything is keyedd on teh username itself, so for each database, you literally need a distinct username ... I'll look into removing that requirement ... slowly figuring out how all this code works :) On Mon, 14 Feb 2011, George Taft wrote: > Whoa. I have to create a Password.pm file? That's not in the instructions. > What's the file for? Where does it go? > > On Mon, Feb 14, 2011 at 5:18 PM, Shane Zatezalo <sh...@lo...> wrote: > it's probably failing because you've not setup your Password.pm > file yet. > Create that, make install it, and I betcha it passes. > > On Feb 14, 2011, at 3:55 PM, Marc G. Fournier wrote: > > > > > What I'd be curious to know is why the test failed ... which test? > Can > > you download the source code from CPAN and do a build/install? > > > > MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO > > > > Its the same version that I have installed here ... > > > > On Mon, 14 Feb 2011, George Taft wrote: > > > >> While this is not a verbatim log of my effort to install under > CentOS, it's > >> a list of the commands I issued. Finally at the bottom are the > errors I > >> encountered. Reissuing the MySQL commands seemed to fix the first > problem, > >> but the second still stands. == George > >> > >> yum update > >> > >> yum install make > >> > >> yum install lynx > >> > >> yum install gcc > >> > >> yum remove perl > >> > >> lynx http://www.cpan.org/src/stable.tar.gz > >> > >> cd /tmp/perl[dir] > >> > >> sh Configure -de > >> > >> make > >> > >> make test > >> > >> make install > >> > >> > >> yum install mysql-server > >> > >> /sbin/chkconfig --levels 235 mysqld on > >> > >> yum install mysql-devel # what about "mysql-client" > >> that misterorange.com refers to? it doesn't seem to exist any > >> more. Is this step still necessary? > >> > >> > >> mysql.i386 0:5.0.77-4.el5_5.4 > >> > >> > >> nano /etc/my.cnf [add "timezone=GMT" to end of file] > >> > >> > >> service mysqld start > >> > >> mysql > >> > >> create database xlash; > >> > >> grant select, insert, update, delete, lock tables, create, > >> drop, index, alter on slash.* to 'xlash'@'localhost' > identified > >> by 'haxlash'; > >> > >> grant process on *.* to 'xlash'@'localhost' identified by > >> 'haxlash'; > >> > >> > >> /usr/local/bin/perl -MCPAN -e "install q{LWP}" > >> > >> > >> lynx > http://mirrors.axint.net/apache//httpd/apache_1.3.42.tar.gz > >> > >> cd /tmp; tar -xvzf > >> > >> > >> lynx http://perl.apache.org/dist/mod_perl-1.31.tar.gz > >> > >> > >> perl Makefile.PL apache_src=/tmp/apache_1.3.42/src/ do_httpd=1 > >> use_apaci=1 perl_mark_where=1 everything=1 > >> apache_prefix=/usr/local/apache > >> > >> make > >> > >> make test > >> > >> make install > >> > >> > >> yum install zlib-devel [already installed] > >> > >> yum install openssl-devel [already installed] > >> > >> yum install perl [already installed] > >> > >> yum install cpio [already installed] > >> > >> yum install expat-devel > >> > >> yum install gettext-devel > >> > >> > >> rpm-Uvh > http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noa > >> rch.rpm > >> > >> yum repolist [should show EPEL repo] > >> > >> yum install git git-daemon > >> > >> git clone git://github.com/lottadot/haxlash.git haxlash > >> > >> cd haxlash > >> > >> git checkout HEAD > >> > >> > >> cpan > >> > >> install Bundle::CPAN > >> > >> quit > >> > >> cpan > >> > >> install Bundle::LWP > >> > >> > >> install Bundle::Slash [again] > >> > >> > >> Failed during this command: > >> KROW/DBIx-Password-1.9.tar.gz : make_test NO > >> MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO > >> > >> > >> DBI connect('database=xlash;host=localhost','xlash',...) > failed: > >> Access denied for user 'xlash'@'localhost' to database 'xlash' > >> at blib/lib/DBIx/Password.pm line 31 > >> > >> > >> > >> > >> > >> > >> > >> On Mon, Feb 14, 2011 at 12:05 PM, Marc G. Fournier > <sc...@hu...> wrote: > >> On Mon, 14 Feb 2011, Jamie McCarthy wrote: > >> > >>> On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: > >>> > >>>> On Mon, 14 Feb 2011, George Taft wrote: > >>>> > >>>>> I've tried, and it still fails, just like it does at Perl > >> Monks: > >>>>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't > >> know how to > >>>>> write/install a replacement for the functionality of > >> ParallelUA > >>> > >>> FWIW... > >>> > >>> LWP::UserAgent::Parallel is only used by checkForOpenProxy(). > >> That's the > >>> function that scans a few common HTTP proxy ports on the > >> current user's > >>> IP address to see if that IP is running an open proxy, and if > >> so, limits > >>> access in some way. As I recall, you can't post anonymously > >> from a proxy > >>> or something like that. > >>> > >>> It's been moderately-helpful on Slashdot, but it's not an > >> absolute > >>> necessity or anything. If you want, strip out that function > >> and calls to > >>> it, delete Slash::Custom::ParUserAgent, and remove L::U::P > >> from the list > >>> of install requirements. > >> > >> Since I know it is working, rather try and debug it and keep the > >> functinality :) > >> > >> ---- > >> Marc G. Fournier Hub.Org Hosting Solutions > S.A. > >> sc...@hu... > http://www.hub.org > >> > >> Yahoo:yscrappy Skype: hub.org ICQ:7615664 > MSN:sc...@hu... > >> > >>--------------------------------------------------------------------------- > > >> --- > >> The ultimate all-in-one performance toolkit: Intel(R) Parallel > Studio > >> XE: > >> Pinpoint memory and threading errors before they happen. > >> Find and fix more than 250 security defects in the development > cycle. > >> Locate bottlenecks in serial and parallel code that limit > performance. > >> http://p.sf.net/sfu/intel-dev2devfeb > >> _______________________________________________ > >> Slashcode-general mailing list > >> Sla...@li... > >> https://lists.sourceforge.net/lists/listinfo/slashcode-general > >> > >> > >> > >> > > > > ---- > > Marc G. Fournier Hub.Org Hosting Solutions > S.A. > > sc...@hu... > http://www.hub.org > > > > Yahoo:yscrappy Skype: hub.org ICQ:7615664 > MSN:sc...@hu... > > > >--------------------------------------------------------------------------- > --- > > The ultimate all-in-one performance toolkit: Intel(R) Parallel > Studio XE: > > Pinpoint memory and threading errors before they happen. > > Find and fix more than 250 security defects in the development > cycle. > > Locate bottlenecks in serial and parallel code that limit > performance. > > http://p.sf.net/sfu/intel-dev2devfeb > > _______________________________________________ > > Slashcode-general mailing list > > Sla...@li... > > https://lists.sourceforge.net/lists/listinfo/slashcode-general > > > > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. sc...@hu... http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... |
From: Jamie M. <ja...@mc...> - 2011-02-15 02:25:53
|
It's not security through obscurity. Its cpan install directs you to change the module's group, probably its owner, and set it non-world-readable. It essentially is a way of bouncing mysql permission issues up to the filesystem's security model, and it acts as a convenient "address book" for your mysql users+passwords too. -- Jamie McCarthy jmc...@th... ja...@mc... 269-267-2008 On Feb 14, 2011, at 6:23 PM, "Marc G. Fournier" <sc...@hu...> wrote: > > Huh? When I install p5-DBIx-Password under FreeBSD. that is part of the > install process ... which I think is one of hte most annoying perl modules > as I've never been able to figure out how to "add users" without having to > re-install the port ... > > But, looking at exactly what DBIx-Password is all about, this should be > one of the easiest things to get rid of ... all it does is saves having ot > create a db.conf file (or whatever we call it) to store userid/passwds in > ... > > The funny thing is that it really is one of those 'security by obscurity' > kinda things, as everything is stored plain text in the file: > > /usr/local/lib/perl5/./site_perl/5.10.1/DBIx/Password.pm > > But, there is one flaw in that module, which, altho not huge, can be > annoying ... you can't have the same user connecting to different > databases ... eerything is keyedd on teh username itself, so for each > database, you literally need a distinct username ... > > I'll look into removing that requirement ... slowly figuring out how all > this code works :) > > On Mon, 14 Feb 2011, George Taft wrote: > >> Whoa. I have to create a Password.pm file? That's not in the instructions. >> What's the file for? Where does it go? >> >> On Mon, Feb 14, 2011 at 5:18 PM, Shane Zatezalo <sh...@lo...> wrote: >> it's probably failing because you've not setup your Password.pm >> file yet. >> Create that, make install it, and I betcha it passes. >> >> On Feb 14, 2011, at 3:55 PM, Marc G. Fournier wrote: >> >>> >>> What I'd be curious to know is why the test failed ... which test? >> Can >>> you download the source code from CPAN and do a build/install? >>> >>> MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO >>> >>> Its the same version that I have installed here ... >>> >>> On Mon, 14 Feb 2011, George Taft wrote: >>> >>>> While this is not a verbatim log of my effort to install under >> CentOS, it's >>>> a list of the commands I issued. Finally at the bottom are the >> errors I >>>> encountered. Reissuing the MySQL commands seemed to fix the first >> problem, >>>> but the second still stands. == George >>>> >>>> yum update >>>> >>>> yum install make >>>> >>>> yum install lynx >>>> >>>> yum install gcc >>>> >>>> yum remove perl >>>> >>>> lynx http://www.cpan.org/src/stable.tar.gz >>>> >>>> cd /tmp/perl[dir] >>>> >>>> sh Configure -de >>>> >>>> make >>>> >>>> make test >>>> >>>> make install >>>> >>>> >>>> yum install mysql-server >>>> >>>> /sbin/chkconfig --levels 235 mysqld on >>>> >>>> yum install mysql-devel # what about "mysql-client" >>>> that misterorange.com refers to? it doesn't seem to exist any >>>> more. Is this step still necessary? >>>> >>>> >>>> mysql.i386 0:5.0.77-4.el5_5.4 >>>> >>>> >>>> nano /etc/my.cnf [add "timezone=GMT" to end of file] >>>> >>>> >>>> service mysqld start >>>> >>>> mysql >>>> >>>> create database xlash; >>>> >>>> grant select, insert, update, delete, lock tables, create, >>>> drop, index, alter on slash.* to 'xlash'@'localhost' >> identified >>>> by 'haxlash'; >>>> >>>> grant process on *.* to 'xlash'@'localhost' identified by >>>> 'haxlash'; >>>> >>>> >>>> /usr/local/bin/perl -MCPAN -e "install q{LWP}" >>>> >>>> >>>> lynx >> http://mirrors.axint.net/apache//httpd/apache_1.3.42.tar.gz >>>> >>>> cd /tmp; tar -xvzf >>>> >>>> >>>> lynx http://perl.apache.org/dist/mod_perl-1.31.tar.gz >>>> >>>> >>>> perl Makefile.PL apache_src=/tmp/apache_1.3.42/src/ do_httpd=1 >>>> use_apaci=1 perl_mark_where=1 everything=1 >>>> apache_prefix=/usr/local/apache >>>> >>>> make >>>> >>>> make test >>>> >>>> make install >>>> >>>> >>>> yum install zlib-devel [already installed] >>>> >>>> yum install openssl-devel [already installed] >>>> >>>> yum install perl [already installed] >>>> >>>> yum install cpio [already installed] >>>> >>>> yum install expat-devel >>>> >>>> yum install gettext-devel >>>> >>>> >>>> rpm-Uvh >> http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noa >>>> rch.rpm >>>> >>>> yum repolist [should show EPEL repo] >>>> >>>> yum install git git-daemon >>>> >>>> git clone git://github.com/lottadot/haxlash.git haxlash >>>> >>>> cd haxlash >>>> >>>> git checkout HEAD >>>> >>>> >>>> cpan >>>> >>>> install Bundle::CPAN >>>> >>>> quit >>>> >>>> cpan >>>> >>>> install Bundle::LWP >>>> >>>> >>>> install Bundle::Slash [again] >>>> >>>> >>>> Failed during this command: >>>> KROW/DBIx-Password-1.9.tar.gz : make_test NO >>>> MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO >>>> >>>> >>>> DBI connect('database=xlash;host=localhost','xlash',...) >> failed: >>>> Access denied for user 'xlash'@'localhost' to database 'xlash' >>>> at blib/lib/DBIx/Password.pm line 31 >>>> >>>> >>>> >>>> >>>> >>>> >>>> >>>> On Mon, Feb 14, 2011 at 12:05 PM, Marc G. Fournier >> <sc...@hu...> wrote: >>>> On Mon, 14 Feb 2011, Jamie McCarthy wrote: >>>> >>>>> On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: >>>>> >>>>>> On Mon, 14 Feb 2011, George Taft wrote: >>>>>> >>>>>>> I've tried, and it still fails, just like it does at Perl >>>> Monks: >>>>>>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't >>>> know how to >>>>>>> write/install a replacement for the functionality of >>>> ParallelUA >>>>> >>>>> FWIW... >>>>> >>>>> LWP::UserAgent::Parallel is only used by checkForOpenProxy(). >>>> That's the >>>>> function that scans a few common HTTP proxy ports on the >>>> current user's >>>>> IP address to see if that IP is running an open proxy, and if >>>> so, limits >>>>> access in some way. As I recall, you can't post anonymously >>>> from a proxy >>>>> or something like that. >>>>> >>>>> It's been moderately-helpful on Slashdot, but it's not an >>>> absolute >>>>> necessity or anything. If you want, strip out that function >>>> and calls to >>>>> it, delete Slash::Custom::ParUserAgent, and remove L::U::P >>>> from the list >>>>> of install requirements. >>>> >>>> Since I know it is working, rather try and debug it and keep the >>>> functinality :) >>>> >>>> ---- >>>> Marc G. Fournier Hub.Org Hosting Solutions >> S.A. >>>> sc...@hu... >> http://www.hub.org >>>> >>>> Yahoo:yscrappy Skype: hub.org ICQ:7615664 >> MSN:sc...@hu... >>>> >>>> --------------------------------------------------------------------------- >> >>>> --- >>>> The ultimate all-in-one performance toolkit: Intel(R) Parallel >> Studio >>>> XE: >>>> Pinpoint memory and threading errors before they happen. >>>> Find and fix more than 250 security defects in the development >> cycle. >>>> Locate bottlenecks in serial and parallel code that limit >> performance. >>>> http://p.sf.net/sfu/intel-dev2devfeb >>>> _______________________________________________ >>>> Slashcode-general mailing list >>>> Sla...@li... >>>> https://lists.sourceforge.net/lists/listinfo/slashcode-general >>>> >>>> >>>> >>>> >>> >>> ---- >>> Marc G. Fournier Hub.Org Hosting Solutions >> S.A. >>> sc...@hu... >> http://www.hub.org >>> >>> Yahoo:yscrappy Skype: hub.org ICQ:7615664 >> MSN:sc...@hu... >>> >>> --------------------------------------------------------------------------- >> --- >>> The ultimate all-in-one performance toolkit: Intel(R) Parallel >> Studio XE: >>> Pinpoint memory and threading errors before they happen. >>> Find and fix more than 250 security defects in the development >> cycle. >>> Locate bottlenecks in serial and parallel code that limit >> performance. >>> http://p.sf.net/sfu/intel-dev2devfeb >>> _______________________________________________ >>> Slashcode-general mailing list >>> Sla...@li... >>> https://lists.sourceforge.net/lists/listinfo/slashcode-general >> >> >> >> > > ---- > Marc G. Fournier Hub.Org Hosting Solutions S.A. > sc...@hu... http://www.hub.org > > Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... > > ------------------------------------------------------------------------------ > The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: > Pinpoint memory and threading errors before they happen. > Find and fix more than 250 security defects in the development cycle. > Locate bottlenecks in serial and parallel code that limit performance. > http://p.sf.net/sfu/intel-dev2devfeb > _______________________________________________ > Slashcode-general mailing list > Sla...@li... > https://lists.sourceforge.net/lists/listinfo/slashcode-general |
From: Marc G. F. <sc...@hu...> - 2011-02-15 05:23:11
|
On Mon, 14 Feb 2011, Jamie McCarthy wrote: > It's not security through obscurity. Its cpan install directs you to > change the module's group, probably its owner, and set it > non-world-readable. It essentially is a way of bouncing mysql permission > issues up to the filesystem's security model, and it acts as a > convenient "address book" for your mysql users+passwords too. Sad thing is that its most likely more then most ppl will ever do / know ... hell, until George mentione issues and I looked into it, I didn't even know what file was written / created ... now, in my case, this seems to be an issue with the FreeBSD ports system hiding htis informaiton, but I don't recall any messages about permissions or what not :( But, that still doesn't address the issue that you are limited to a system where you can have but one username per database, unless I've missed something ... ? Now, from what I can tell, is it easy to add more databases, as each time you do a 'make install', it will re-gen the file, overwriting anything that was set before, you have to know / remember to re-add any of the old usernames ... or am I mistaken on t his? Slashcode has, IMHO, a relatively nice install system where you can install multiple sites from one installation directory ... but I cannot easily add a new username for a new site nearly as easy :( > > -- > Jamie McCarthy > jmc...@th... > ja...@mc... > 269-267-2008 > > > On Feb 14, 2011, at 6:23 PM, "Marc G. Fournier" <sc...@hu...> wrote: > >> >> Huh? When I install p5-DBIx-Password under FreeBSD. that is part of the >> install process ... which I think is one of hte most annoying perl modules >> as I've never been able to figure out how to "add users" without having to >> re-install the port ... >> >> But, looking at exactly what DBIx-Password is all about, this should be >> one of the easiest things to get rid of ... all it does is saves having ot >> create a db.conf file (or whatever we call it) to store userid/passwds in >> ... >> >> The funny thing is that it really is one of those 'security by obscurity' >> kinda things, as everything is stored plain text in the file: >> >> /usr/local/lib/perl5/./site_perl/5.10.1/DBIx/Password.pm >> >> But, there is one flaw in that module, which, altho not huge, can be >> annoying ... you can't have the same user connecting to different >> databases ... eerything is keyedd on teh username itself, so for each >> database, you literally need a distinct username ... >> >> I'll look into removing that requirement ... slowly figuring out how all >> this code works :) >> >> On Mon, 14 Feb 2011, George Taft wrote: >> >>> Whoa. I have to create a Password.pm file? That's not in the instructions. >>> What's the file for? Where does it go? >>> >>> On Mon, Feb 14, 2011 at 5:18 PM, Shane Zatezalo <sh...@lo...> wrote: >>> it's probably failing because you've not setup your Password.pm >>> file yet. >>> Create that, make install it, and I betcha it passes. >>> >>> On Feb 14, 2011, at 3:55 PM, Marc G. Fournier wrote: >>> >>>> >>>> What I'd be curious to know is why the test failed ... which test? >>> Can >>>> you download the source code from CPAN and do a build/install? >>>> >>>> MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO >>>> >>>> Its the same version that I have installed here ... >>>> >>>> On Mon, 14 Feb 2011, George Taft wrote: >>>> >>>>> While this is not a verbatim log of my effort to install under >>> CentOS, it's >>>>> a list of the commands I issued. Finally at the bottom are the >>> errors I >>>>> encountered. Reissuing the MySQL commands seemed to fix the first >>> problem, >>>>> but the second still stands. == George >>>>> >>>>> yum update >>>>> >>>>> yum install make >>>>> >>>>> yum install lynx >>>>> >>>>> yum install gcc >>>>> >>>>> yum remove perl >>>>> >>>>> lynx http://www.cpan.org/src/stable.tar.gz >>>>> >>>>> cd /tmp/perl[dir] >>>>> >>>>> sh Configure -de >>>>> >>>>> make >>>>> >>>>> make test >>>>> >>>>> make install >>>>> >>>>> >>>>> yum install mysql-server >>>>> >>>>> /sbin/chkconfig --levels 235 mysqld on >>>>> >>>>> yum install mysql-devel # what about "mysql-client" >>>>> that misterorange.com refers to? it doesn't seem to exist any >>>>> more. Is this step still necessary? >>>>> >>>>> >>>>> mysql.i386 0:5.0.77-4.el5_5.4 >>>>> >>>>> >>>>> nano /etc/my.cnf [add "timezone=GMT" to end of file] >>>>> >>>>> >>>>> service mysqld start >>>>> >>>>> mysql >>>>> >>>>> create database xlash; >>>>> >>>>> grant select, insert, update, delete, lock tables, create, >>>>> drop, index, alter on slash.* to 'xlash'@'localhost' >>> identified >>>>> by 'haxlash'; >>>>> >>>>> grant process on *.* to 'xlash'@'localhost' identified by >>>>> 'haxlash'; >>>>> >>>>> >>>>> /usr/local/bin/perl -MCPAN -e "install q{LWP}" >>>>> >>>>> >>>>> lynx >>> http://mirrors.axint.net/apache//httpd/apache_1.3.42.tar.gz >>>>> >>>>> cd /tmp; tar -xvzf >>>>> >>>>> >>>>> lynx http://perl.apache.org/dist/mod_perl-1.31.tar.gz >>>>> >>>>> >>>>> perl Makefile.PL apache_src=/tmp/apache_1.3.42/src/ do_httpd=1 >>>>> use_apaci=1 perl_mark_where=1 everything=1 >>>>> apache_prefix=/usr/local/apache >>>>> >>>>> make >>>>> >>>>> make test >>>>> >>>>> make install >>>>> >>>>> >>>>> yum install zlib-devel [already installed] >>>>> >>>>> yum install openssl-devel [already installed] >>>>> >>>>> yum install perl [already installed] >>>>> >>>>> yum install cpio [already installed] >>>>> >>>>> yum install expat-devel >>>>> >>>>> yum install gettext-devel >>>>> >>>>> >>>>> rpm-Uvh >>> http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noa >>>>> rch.rpm >>>>> >>>>> yum repolist [should show EPEL repo] >>>>> >>>>> yum install git git-daemon >>>>> >>>>> git clone git://github.com/lottadot/haxlash.git haxlash >>>>> >>>>> cd haxlash >>>>> >>>>> git checkout HEAD >>>>> >>>>> >>>>> cpan >>>>> >>>>> install Bundle::CPAN >>>>> >>>>> quit >>>>> >>>>> cpan >>>>> >>>>> install Bundle::LWP >>>>> >>>>> >>>>> install Bundle::Slash [again] >>>>> >>>>> >>>>> Failed during this command: >>>>> KROW/DBIx-Password-1.9.tar.gz : make_test NO >>>>> MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO >>>>> >>>>> >>>>> DBI connect('database=xlash;host=localhost','xlash',...) >>> failed: >>>>> Access denied for user 'xlash'@'localhost' to database 'xlash' >>>>> at blib/lib/DBIx/Password.pm line 31 >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> >>>>> On Mon, Feb 14, 2011 at 12:05 PM, Marc G. Fournier >>> <sc...@hu...> wrote: >>>>> On Mon, 14 Feb 2011, Jamie McCarthy wrote: >>>>> >>>>>> On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: >>>>>> >>>>>>> On Mon, 14 Feb 2011, George Taft wrote: >>>>>>> >>>>>>>> I've tried, and it still fails, just like it does at Perl >>>>> Monks: >>>>>>>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't >>>>> know how to >>>>>>>> write/install a replacement for the functionality of >>>>> ParallelUA >>>>>> >>>>>> FWIW... >>>>>> >>>>>> LWP::UserAgent::Parallel is only used by checkForOpenProxy(). >>>>> That's the >>>>>> function that scans a few common HTTP proxy ports on the >>>>> current user's >>>>>> IP address to see if that IP is running an open proxy, and if >>>>> so, limits >>>>>> access in some way. As I recall, you can't post anonymously >>>>> from a proxy >>>>>> or something like that. >>>>>> >>>>>> It's been moderately-helpful on Slashdot, but it's not an >>>>> absolute >>>>>> necessity or anything. If you want, strip out that function >>>>> and calls to >>>>>> it, delete Slash::Custom::ParUserAgent, and remove L::U::P >>>>> from the list >>>>>> of install requirements. >>>>> >>>>> Since I know it is working, rather try and debug it and keep the >>>>> functinality :) >>>>> >>>>> ---- >>>>> Marc G. Fournier Hub.Org Hosting Solutions >>> S.A. >>>>> sc...@hu... >>> http://www.hub.org >>>>> >>>>> Yahoo:yscrappy Skype: hub.org ICQ:7615664 >>> MSN:sc...@hu... >>>>> >>>>> --------------------------------------------------------------------------- >>> >>>>> --- >>>>> The ultimate all-in-one performance toolkit: Intel(R) Parallel >>> Studio >>>>> XE: >>>>> Pinpoint memory and threading errors before they happen. >>>>> Find and fix more than 250 security defects in the development >>> cycle. >>>>> Locate bottlenecks in serial and parallel code that limit >>> performance. >>>>> http://p.sf.net/sfu/intel-dev2devfeb >>>>> _______________________________________________ >>>>> Slashcode-general mailing list >>>>> Sla...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/slashcode-general >>>>> >>>>> >>>>> >>>>> >>>> >>>> ---- >>>> Marc G. Fournier Hub.Org Hosting Solutions >>> S.A. >>>> sc...@hu... >>> http://www.hub.org >>>> >>>> Yahoo:yscrappy Skype: hub.org ICQ:7615664 >>> MSN:sc...@hu... >>>> >>>> --------------------------------------------------------------------------- >>> --- >>>> The ultimate all-in-one performance toolkit: Intel(R) Parallel >>> Studio XE: >>>> Pinpoint memory and threading errors before they happen. >>>> Find and fix more than 250 security defects in the development >>> cycle. >>>> Locate bottlenecks in serial and parallel code that limit >>> performance. >>>> http://p.sf.net/sfu/intel-dev2devfeb >>>> _______________________________________________ >>>> Slashcode-general mailing list >>>> Sla...@li... >>>> https://lists.sourceforge.net/lists/listinfo/slashcode-general >>> >>> >>> >>> >> >> ---- >> Marc G. Fournier Hub.Org Hosting Solutions S.A. >> sc...@hu... http://www.hub.org >> >> Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... >> >> ------------------------------------------------------------------------------ >> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: >> Pinpoint memory and threading errors before they happen. >> Find and fix more than 250 security defects in the development cycle. >> Locate bottlenecks in serial and parallel code that limit performance. >> http://p.sf.net/sfu/intel-dev2devfeb >> _______________________________________________ >> Slashcode-general mailing list >> Sla...@li... >> https://lists.sourceforge.net/lists/listinfo/slashcode-general > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. sc...@hu... http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... |
From: Marc G. F. <sc...@hu...> - 2011-02-15 20:18:57
|
Okay, grantd that I may be missing something obvious, but you can only have *one* connect string per virtual user, but as many virtual users as you wish ... the code itself states, for instance: sub connect { my ($class, $user, $options) = @_; return undef unless $virtual1->{$user}; my $self; my $virtual = $virtual1->{$user}; return undef unless $virtual; $self = DBI->connect($virtual->{connect} , $virtual->{'username'} , $virtual->{'password'} , $virtual->{'attributes'} ); return undef unless $self; bless $self, $class; $driver_cache{$self} = $user; return $self; } Everything is key'd on the $user value ... so I can't have: virtual_user haxlash with a connect string to mysql *and* virtual_user haxlash with a connect string to pgsql I have to definte two seperate virtual users, one for myslq, one for pgsql ... Again, unless I'm mis-reading the code, you can have as many virtaul Users as you want, but each connect has to have a unique virtual user ... On Tue, 15 Feb 2011, W. Scott Lockwood III wrote: > You can have multiple entries. > -- > W. Scott Lockwood III / US2009033817 > aDC Web Monkey / aRST Forsaken > Cam Wiki Admin (Awakening) > > -----Original Message----- > From: "Marc G. Fournier" <sc...@hu...> > Sender: hax...@ha...Date: Tue, 15 Feb 2011 01:23:00 > To: Jamie McCarthy<ja...@mc...> > Reply-To: hax...@ha... > Cc: hax...@ha...<hax...@ha...>; sla...@li...<sla...@li...> > Subject: Re: [Slashcode-general] DBIx-Password: Access denied for virtual > user to database > > On Mon, 14 Feb 2011, Jamie McCarthy wrote: > >> It's not security through obscurity. Its cpan install directs you to >> change the module's group, probably its owner, and set it >> non-world-readable. It essentially is a way of bouncing mysql permission >> issues up to the filesystem's security model, and it acts as a >> convenient "address book" for your mysql users+passwords too. > > Sad thing is that its most likely more then most ppl will ever do / know > ... hell, until George mentione issues and I looked into it, I didn't even > know what file was written / created ... now, in my case, this seems to be > an issue with the FreeBSD ports system hiding htis informaiton, but I > don't recall any messages about permissions or what not :( > > But, that still doesn't address the issue that you are limited to a system > where you can have but one username per database, unless I've missed > something ... ? Now, from what I can tell, is it easy to add more > databases, as each time you do a 'make install', it will re-gen the file, > overwriting anything that was set before, you have to know / remember to > re-add any of the old usernames ... or am I mistaken on t his? > > Slashcode has, IMHO, a relatively nice install system where you can > install multiple sites from one installation directory ... but I cannot > easily add a new username for a new site nearly as easy :( > > > >> >> -- >> Jamie McCarthy >> jmc...@th... >> ja...@mc... >> 269-267-2008 >> >> >> On Feb 14, 2011, at 6:23 PM, "Marc G. Fournier" <sc...@hu...> wrote: >> >>> >>> Huh? When I install p5-DBIx-Password under FreeBSD. that is part of the >>> install process ... which I think is one of hte most annoying perl modules >>> as I've never been able to figure out how to "add users" without having to >>> re-install the port ... >>> >>> But, looking at exactly what DBIx-Password is all about, this should be >>> one of the easiest things to get rid of ... all it does is saves having ot >>> create a db.conf file (or whatever we call it) to store userid/passwds in >>> ... >>> >>> The funny thing is that it really is one of those 'security by obscurity' >>> kinda things, as everything is stored plain text in the file: >>> >>> /usr/local/lib/perl5/./site_perl/5.10.1/DBIx/Password.pm >>> >>> But, there is one flaw in that module, which, altho not huge, can be >>> annoying ... you can't have the same user connecting to different >>> databases ... eerything is keyedd on teh username itself, so for each >>> database, you literally need a distinct username ... >>> >>> I'll look into removing that requirement ... slowly figuring out how all >>> this code works :) >>> >>> On Mon, 14 Feb 2011, George Taft wrote: >>> >>>> Whoa. I have to create a Password.pm file? That's not in the instructions. >>>> What's the file for? Where does it go? >>>> >>>> On Mon, Feb 14, 2011 at 5:18 PM, Shane Zatezalo <sh...@lo...> wrote: >>>> it's probably failing because you've not setup your Password.pm >>>> file yet. >>>> Create that, make install it, and I betcha it passes. >>>> >>>> On Feb 14, 2011, at 3:55 PM, Marc G. Fournier wrote: >>>> >>>>> >>>>> What I'd be curious to know is why the test failed ... which test? >>>> Can >>>>> you download the source code from CPAN and do a build/install? >>>>> >>>>> MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO >>>>> >>>>> Its the same version that I have installed here ... >>>>> >>>>> On Mon, 14 Feb 2011, George Taft wrote: >>>>> >>>>>> While this is not a verbatim log of my effort to install under >>>> CentOS, it's >>>>>> a list of the commands I issued. Finally at the bottom are the >>>> errors I >>>>>> encountered. Reissuing the MySQL commands seemed to fix the first >>>> problem, >>>>>> but the second still stands. == George >>>>>> >>>>>> yum update >>>>>> >>>>>> yum install make >>>>>> >>>>>> yum install lynx >>>>>> >>>>>> yum install gcc >>>>>> >>>>>> yum remove perl >>>>>> >>>>>> lynx http://www.cpan.org/src/stable.tar.gz >>>>>> >>>>>> cd /tmp/perl[dir] >>>>>> >>>>>> sh Configure -de >>>>>> >>>>>> make >>>>>> >>>>>> make test >>>>>> >>>>>> make install >>>>>> >>>>>> >>>>>> yum install mysql-server >>>>>> >>>>>> /sbin/chkconfig --levels 235 mysqld on >>>>>> >>>>>> yum install mysql-devel # what about "mysql-client" >>>>>> that misterorange.com refers to? it doesn't seem to exist any >>>>>> more. Is this step still necessary? >>>>>> >>>>>> >>>>>> mysql.i386 0:5.0.77-4.el5_5.4 >>>>>> >>>>>> >>>>>> nano /etc/my.cnf [add "timezone=GMT" to end of file] >>>>>> >>>>>> >>>>>> service mysqld start >>>>>> >>>>>> mysql >>>>>> >>>>>> create database xlash; >>>>>> >>>>>> grant select, insert, update, delete, lock tables, create, >>>>>> drop, index, alter on slash.* to 'xlash'@'localhost' >>>> identified >>>>>> by 'haxlash'; >>>>>> >>>>>> grant process on *.* to 'xlash'@'localhost' identified by >>>>>> 'haxlash'; >>>>>> >>>>>> >>>>>> /usr/local/bin/perl -MCPAN -e "install q{LWP}" >>>>>> >>>>>> >>>>>> lynx >>>> http://mirrors.axint.net/apache//httpd/apache_1.3.42.tar.gz >>>>>> >>>>>> cd /tmp; tar -xvzf >>>>>> >>>>>> >>>>>> lynx http://perl.apache.org/dist/mod_perl-1.31.tar.gz >>>>>> >>>>>> >>>>>> perl Makefile.PL apache_src=/tmp/apache_1.3.42/src/ do_httpd=1 >>>>>> use_apaci=1 perl_mark_where=1 everything=1 >>>>>> apache_prefix=/usr/local/apache >>>>>> >>>>>> make >>>>>> >>>>>> make test >>>>>> >>>>>> make install >>>>>> >>>>>> >>>>>> yum install zlib-devel [already installed] >>>>>> >>>>>> yum install openssl-devel [already installed] >>>>>> >>>>>> yum install perl [already installed] >>>>>> >>>>>> yum install cpio [already installed] >>>>>> >>>>>> yum install expat-devel >>>>>> >>>>>> yum install gettext-devel >>>>>> >>>>>> >>>>>> rpm-Uvh >>>> http://download.fedora.redhat.com/pub/epel/5/i386/epel-release-5-4.noa >>>>>> rch.rpm >>>>>> >>>>>> yum repolist [should show EPEL repo] >>>>>> >>>>>> yum install git git-daemon >>>>>> >>>>>> git clone git://github.com/lottadot/haxlash.git haxlash >>>>>> >>>>>> cd haxlash >>>>>> >>>>>> git checkout HEAD >>>>>> >>>>>> >>>>>> cpan >>>>>> >>>>>> install Bundle::CPAN >>>>>> >>>>>> quit >>>>>> >>>>>> cpan >>>>>> >>>>>> install Bundle::LWP >>>>>> >>>>>> >>>>>> install Bundle::Slash [again] >>>>>> >>>>>> >>>>>> Failed during this command: >>>>>> KROW/DBIx-Password-1.9.tar.gz : make_test NO >>>>>> MARCLANG/ParallelUserAgent-2.57.tar.gz : make_test NO >>>>>> >>>>>> >>>>>> DBI connect('database=xlash;host=localhost','xlash',...) >>>> failed: >>>>>> Access denied for user 'xlash'@'localhost' to database 'xlash' >>>>>> at blib/lib/DBIx/Password.pm line 31 >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> On Mon, Feb 14, 2011 at 12:05 PM, Marc G. Fournier >>>> <sc...@hu...> wrote: >>>>>> On Mon, 14 Feb 2011, Jamie McCarthy wrote: >>>>>> >>>>>>> On Feb 14, 2011, at 10:32 AM, Marc G. Fournier wrote: >>>>>>> >>>>>>>> On Mon, 14 Feb 2011, George Taft wrote: >>>>>>>> >>>>>>>>> I've tried, and it still fails, just like it does at Perl >>>>>> Monks: >>>>>>>>> <http://www.perlmonks.org/bare/?node_id=758739>. I wouldn't >>>>>> know how to >>>>>>>>> write/install a replacement for the functionality of >>>>>> ParallelUA >>>>>>> >>>>>>> FWIW... >>>>>>> >>>>>>> LWP::UserAgent::Parallel is only used by checkForOpenProxy(). >>>>>> That's the >>>>>>> function that scans a few common HTTP proxy ports on the >>>>>> current user's >>>>>>> IP address to see if that IP is running an open proxy, and if >>>>>> so, limits >>>>>>> access in some way. As I recall, you can't post anonymously >>>>>> from a proxy >>>>>>> or something like that. >>>>>>> >>>>>>> It's been moderately-helpful on Slashdot, but it's not an >>>>>> absolute >>>>>>> necessity or anything. If you want, strip out that function >>>>>> and calls to >>>>>>> it, delete Slash::Custom::ParUserAgent, and remove L::U::P >>>>>> from the list >>>>>>> of install requirements. >>>>>> >>>>>> Since I know it is working, rather try and debug it and keep the >>>>>> functinality :) >>>>>> >>>>>> ---- >>>>>> Marc G. Fournier Hub.Org Hosting Solutions >>>> S.A. >>>>>> sc...@hu... >>>> http://www.hub.org >>>>>> >>>>>> Yahoo:yscrappy Skype: hub.org ICQ:7615664 >>>> MSN:sc...@hu... >>>>>> >>>>>> --------------------------------------------------------------------------- >>>> >>>>>> --- >>>>>> The ultimate all-in-one performance toolkit: Intel(R) Parallel >>>> Studio >>>>>> XE: >>>>>> Pinpoint memory and threading errors before they happen. >>>>>> Find and fix more than 250 security defects in the development >>>> cycle. >>>>>> Locate bottlenecks in serial and parallel code that limit >>>> performance. >>>>>> http://p.sf.net/sfu/intel-dev2devfeb >>>>>> _______________________________________________ >>>>>> Slashcode-general mailing list >>>>>> Sla...@li... >>>>>> https://lists.sourceforge.net/lists/listinfo/slashcode-general >>>>>> >>>>>> >>>>>> >>>>>> >>>>> >>>>> ---- >>>>> Marc G. Fournier Hub.Org Hosting Solutions >>>> S.A. >>>>> sc...@hu... >>>> http://www.hub.org >>>>> >>>>> Yahoo:yscrappy Skype: hub.org ICQ:7615664 >>>> MSN:sc...@hu... >>>>> >>>>> --------------------------------------------------------------------------- >>>> --- >>>>> The ultimate all-in-one performance toolkit: Intel(R) Parallel >>>> Studio XE: >>>>> Pinpoint memory and threading errors before they happen. >>>>> Find and fix more than 250 security defects in the development >>>> cycle. >>>>> Locate bottlenecks in serial and parallel code that limit >>>> performance. >>>>> http://p.sf.net/sfu/intel-dev2devfeb >>>>> _______________________________________________ >>>>> Slashcode-general mailing list >>>>> Sla...@li... >>>>> https://lists.sourceforge.net/lists/listinfo/slashcode-general >>>> >>>> >>>> >>>> >>> >>> ---- >>> Marc G. Fournier Hub.Org Hosting Solutions S.A. >>> sc...@hu... http://www.hub.org >>> >>> Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... >>> >>> ------------------------------------------------------------------------------ >>> The ultimate all-in-one performance toolkit: Intel(R) Parallel Studio XE: >>> Pinpoint memory and threading errors before they happen. >>> Find and fix more than 250 security defects in the development cycle. >>> Locate bottlenecks in serial and parallel code that limit performance. >>> http://p.sf.net/sfu/intel-dev2devfeb >>> _______________________________________________ >>> Slashcode-general mailing list >>> Sla...@li... >>> https://lists.sourceforge.net/lists/listinfo/slashcode-general >> > > ---- > Marc G. Fournier Hub.Org Hosting Solutions S.A. > sc...@hu... http://www.hub.org > > Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... > ---- Marc G. Fournier Hub.Org Hosting Solutions S.A. sc...@hu... http://www.hub.org Yahoo:yscrappy Skype: hub.org ICQ:7615664 MSN:sc...@hu... |