Mailing List Archive: Interchange: users

catalog working, no admin/login, unable to checkout

Index | Next | Previous | View Threaded

curthauge at mnwebdesign

Aug 31, 2011, 5:30 PM

Post #1 of 20 (494 views)
Permalink

catalog working, no admin/login, unable to checkout

Hi,

I am on a new Centos 5.x server, Apache 2.2.19, MySQL 5.1.57. As root I
installed a local perl at usr/local/bin/perl like this:

sh Configure #accepted all defaults, no threads
make
make test
make install

I now have /usr/bin/perl -v #This is perl, v5.8.8 built for
x86_64-linux-thread-multi
and /usr/local/bin/perl -v #This is perl, v5.10.0 built for
x86_64-linux

As root I checked 'which perl' and saw this:
/usr/bin/perl #which is what I expected
(but, alas...it now reports: /usr/local/bin/perl) <--could that be an issue
and how did it happen?

I then installed the bundle like this:
perl -MCPAN -e 'install Bundle::Interchange'

Question 1: Should I be installing the bundle with /use/local/bin/perl or
/usr/bin/perl?

I finally got the bundle to install, but I cannot get the kitchensink to
finish up, so...

I've installed 5.6.3 tarball after installing the bundle:
tar zvxf interchange-5.6.3.tar.gz
/usr/local/bin/perl Makefile.PL
make
make test #passed all 6
make install

ran makecat, using MySQL, database is set up, and now have a test cat up,
but no admin/login access. I do have to chmod 755 the cgi-bin/catlink as
they aren't created with correct permissions. (strange, wonder why?)

I tarred up an old foundation-based cat that was recently running on 5.6 for
years now, untarred to my destination folder, and finally got it fired up,
but no access to admin/login (Internal Server Error).

During checkout, once I am on the shipmode.html and submit to 'Next' I
expect to see the last page of my multi-page checkout (finalize.html) but I
also get "Internal Server Error". I have credit cards enabled.

I then re-installed Interchange from scratch (now I have no access to my
test cat) but my old foundation cat still has the same problems.

Current rrrors in interchange error.log:
Similar to cat

Current errors in cat error.log

74.117.242.45 K7Mcfhbm:74.117.242.45 - [31/August/2011:13:32:59 -0400] fts1
/cgi-bin/fts1/ord/finalize.html Runtime error: mv_metadata import into
failed: sdbm store returned -1, errno 22, key "kinventory" at
/home/funtime/fts1/interchange/lib/Vend/Table/Common.pm line 513, <IN> line
121.

Common.pm line 121 says this:
#::logDebug("needed separation: '$_'");

Common.pm line 513 says this:
$s->[$TIE_HASH]{"k$key"} = join("\t", map(stuff($_), @fields));

I uncommented line 121 and turned on debugging, reatarted, tested, no output
in CATROOT/tmp

Any other ideas? I've been all over google and I keep trying to get the
kitchen sink installed as well.

Over 12 years and 5 days messing with Interchange and linux and I still
don't get it. I'm ready to throw in the towel...

Curt

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

jon at endpoint

Aug 31, 2011, 7:07 PM

Post #2 of 20 (484 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On Wed, 31 Aug 2011, Curt Hauge wrote:

> I now have /usr/bin/perl -v #This is perl, v5.8.8 built for
> x86_64-linux-thread-multi
> and /usr/local/bin/perl -v #This is perl, v5.10.0 built for
> x86_64-linux
>
> As root I checked 'which perl' and saw this:
> /usr/bin/perl #which is what I expected
> (but, alas...it now reports: /usr/local/bin/perl) <--could that be an issue
> and how did it happen?

That's normal. Try `echo $PATH` and you will see /usr/local/bin comes
earlier than /usr/bin, which is why /usr/local/bin/perl is the one that
runs when you don't specify a path.

> I then installed the bundle like this:
> perl -MCPAN -e 'install Bundle::Interchange'
>
> Question 1: Should I be installing the bundle with /use/local/bin/perl or
> /usr/bin/perl?

That depends on which perl you want to use for Interchange. I presume you
installed /usr/local/bin/perl because you want to use that one, so that's
the one to use.

> I finally got the bundle to install, but I cannot get the kitchensink to
> finish up, so...

If you can't get everything in Bundle::InterchangeKitchenSink to install,
you need to stop there and fix whatever the problem is till it installs.
Otherwise trying to run Interchange is going to run into problems.

> 74.117.242.45 K7Mcfhbm:74.117.242.45 - [31/August/2011:13:32:59 -0400] fts1
> /cgi-bin/fts1/ord/finalize.html Runtime error: mv_metadata import into
> failed: sdbm store returned -1, errno 22, key "kinventory" at
> /home/funtime/fts1/interchange/lib/Vend/Table/Common.pm line 513, <IN> line
> 121.

That error mentioning sdbm makes it sound like you did not have gdbm-devel
and gdbm installed before building your new perl. You should do:

yum install gdbm-devel

Then rebuild your local perl or possibly just `cpan GDBM`.

Jon

--
Jon Jensen
End Point Corporation
http://www.endpoint.com/

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Aug 31, 2011, 9:11 PM

Post #3 of 20 (479 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 01/09/11 12:30, Curt Hauge wrote:
> Hi,
>
> I am on a new Centos 5.x server, Apache 2.2.19, MySQL 5.1.57.

I'll get into your problems below, but if you want you may just want to
start over clean and follow this guide:
http://www.pajamian.dhs.org/Rackspace%20Interchange%20Setup.html

Don't worry about the Rackspace part, this guide is for any CentOS/RHEL
5 Interchange install.

Note the only thing that you should be aware of is that perl 5.12.4 has
been released since the guide was last updated. I recommend you use
that now but don't use 5.14 as that has unresolved issues with
Interchange. Everything else is the same and at the bottom is an
appendix telling you how to install MySQL instead of PostgreSQL if you want.

Note2: CentOS 6 is out now (and has been for a few weeks). The guide is
written for CentOS 5 but the procedure should be largely the same. I
will be making a new updated guide for CentOS 6 soon.

Ok, now to get into your problems:

> As root I
> installed a local perl at usr/local/bin/perl like this:
>
> sh Configure #accepted all defaults, no threads

A better command that I recommend:
./Configure -des -Dprefix=/usr/local/perl-5.12.4

... this runs all the defaults automatically without making you answer
200 questions and sets the install prefix to a directory where it's easy
to keep track of what version of perl it is (you can use symlinks to
point your /usr/local/bin/perl to any perl executable you want).

> make
> make test

Also I recommend that you run all of the above commands an an
unprivileged user and only run this last one as root:

> make install
>
> and /usr/local/bin/perl -v #This is perl, v5.10.0 built for
> x86_64-linux

Why did you install such an old version of perl? 5.12.4 is what I
recommend, but if you want to install from the 5.10 branch at least
install the newest which is 5.10.1

> As root I checked 'which perl' and saw this:
> /usr/bin/perl #which is what I expected
> (but, alas...it now reports: /usr/local/bin/perl) <--could that be an issue
> and how did it happen?

As Jon already said, you have /usr/local/bin in your $PATH ahead of
/usr/bin.

> I then installed the bundle like this:
> perl -MCPAN -e 'install Bundle::Interchange'

Just install Bundle::InterchangeKitchenSink. It is a superset of
Bundle::Interchange.

> Question 1: Should I be installing the bundle with /use/local/bin/perl or
> /usr/bin/perl?

/usr/local/bin/perl or wherever your newly installed perl happens to reside.

> I finally got the bundle to install, but I cannot get the kitchensink to
> finish up, so...

There will be a few issues installing KitchenSink which are all outlined
in my guide (linked to above). Please read through at least section 10
of the guide which will tell you how to resolve all of the issues you
will encounter (I recommend reading and following the whole thing
because it is exactly for the platform you are installing on).

> I've installed 5.6.3 tarball after installing the bundle:
> tar zvxf interchange-5.6.3.tar.gz
> /usr/local/bin/perl Makefile.PL
> make
> make test #passed all 6
> make install

There are better ways than installing from the tarball (again, read the
guide).

> ran makecat, using MySQL, database is set up, and now have a test cat up,
> but no admin/login access. I do have to chmod 755 the cgi-bin/catlink as
> they aren't created with correct permissions. (strange, wonder why?)

That chmod could be the reason why you're having problems. It needs to
be setuid root so you need to do:
chmod 4755 cgi-bin/catlink

Note that the exception to the above is if you're running apache with
suexec.

> I tarred up an old foundation-based cat that was recently running on 5.6 for
> years now, untarred to my destination folder, and finally got it fired up,
> but no access to admin/login (Internal Server Error).

Look in your interchange error.log file for the real reason for this error.

Also, why are you running makecat if you already have a catalog?

> During checkout, once I am on the shipmode.html and submit to 'Next' I
> expect to see the last page of my multi-page checkout (finalize.html) but I
> also get "Internal Server Error". I have credit cards enabled.

Again, see your error.log file (the global one, not the catalog one).

> Current errors in cat error.log
>
> 74.117.242.45 K7Mcfhbm:74.117.242.45 - [31/August/2011:13:32:59 -0400] fts1
> /cgi-bin/fts1/ord/finalize.html Runtime error: mv_metadata import into
> failed: sdbm store returned -1, errno 22, key "kinventory" at
> /home/funtime/fts1/interchange/lib/Vend/Table/Common.pm line 513, <IN> line
> 121.

You should not be using sdbm anymore but should switch to gdbm. It is
likely that IC is trying to sdbm, though because it can't find perl
support for gdbm. When you build perl the gdbm-devel package has to be
installed or perl will not build with support for gdbm. You probably
have to install gdbm and then re-build perl. Again, see the guilde for
complete directions.

> Over 12 years and 5 days messing with Interchange and linux and I still
> don't get it. I'm ready to throw in the towel...

Save yourself a lot of grief and read and follow that guide. I wrote it
to help people do exactly what you are trying to do and it makes things
very easy.

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

chaugegw at genesiswireless

Sep 1, 2011, 11:59 AM

Post #4 of 20 (474 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 9/1/2011 Peter wrote:

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup
> [mailto:interchange-users-bounces [at] icdevgroup] On Behalf Of Peter
> Sent: Wednesday, August 31, 2011 11:12 PM
> To: interchange-users [at] icdevgroup
> Subject: Re: [ic] catalog working, no admin/login, unable to checkout
>
> On 01/09/11 12:30, Curt Hauge wrote:
> > Hi,
> >
> > I am on a new Centos 5.x server, Apache 2.2.19, MySQL 5.1.57.
>
> I'll get into your problems below, but if you want you may
> just want to start over clean and follow this guide:
> http://www.pajamian.dhs.org/Rackspace%20Interchange%20Setup.html
>
> Don't worry about the Rackspace part, this guide is for any
> CentOS/RHEL
> 5 Interchange install.
>
> Note the only thing that you should be aware of is that perl
> 5.12.4 has been released since the guide was last updated. I
> recommend you use that now but don't use 5.14 as that has
> unresolved issues with Interchange. Everything else is the
> same and at the bottom is an appendix telling you how to
> install MySQL instead of PostgreSQL if you want.
>
> Note2: CentOS 6 is out now (and has been for a few weeks).
> The guide is written for CentOS 5 but the procedure should be
> largely the same. I will be making a new updated guide for
> CentOS 6 soon.
>
> Ok, now to get into your problems:
>
> > As root I
> > installed a local perl at usr/local/bin/perl like this:
> >
> > sh Configure #accepted all defaults, no threads
>
> A better command that I recommend:
> ./Configure -des -Dprefix=/usr/local/perl-5.12.4
>
> ... this runs all the defaults automatically without making
> you answer 200 questions and sets the install prefix to a
> directory where it's easy to keep track of what version of
> perl it is (you can use symlinks to point your
> /usr/local/bin/perl to any perl executable you want).
>
> > make
> > make test
>
> Also I recommend that you run all of the above commands an an
> unprivileged user and only run this last one as root:
>
> > make install
> >
> > and /usr/local/bin/perl -v #This is perl, v5.10.0 built for
> > x86_64-linux
>
> Why did you install such an old version of perl? 5.12.4 is
> what I recommend, but if you want to install from the 5.10
> branch at least install the newest which is 5.10.1
>
> > As root I checked 'which perl' and saw this:
> > /usr/bin/perl #which is what I expected (but, alas...it now
> reports:
> > /usr/local/bin/perl) <--could that be an issue and how did
> it happen?
>
> As Jon already said, you have /usr/local/bin in your $PATH
> ahead of /usr/bin.
>
> > I then installed the bundle like this:
> > perl -MCPAN -e 'install Bundle::Interchange'
>
> Just install Bundle::InterchangeKitchenSink. It is a
> superset of Bundle::Interchange.
>
> > Question 1: Should I be installing the bundle with
> /use/local/bin/perl
> > or /usr/bin/perl?
>
> /usr/local/bin/perl or wherever your newly installed perl
> happens to reside.
>
> > I finally got the bundle to install, but I cannot get the
> kitchensink
> > to finish up, so...
>
> There will be a few issues installing KitchenSink which are
> all outlined in my guide (linked to above). Please read
> through at least section 10 of the guide which will tell you
> how to resolve all of the issues you will encounter (I
> recommend reading and following the whole thing because it is
> exactly for the platform you are installing on).
>
> > I've installed 5.6.3 tarball after installing the bundle:
> > tar zvxf interchange-5.6.3.tar.gz
> > /usr/local/bin/perl Makefile.PL
> > make
> > make test #passed all 6
> > make install
>
> There are better ways than installing from the tarball
> (again, read the guide).
>
> > ran makecat, using MySQL, database is set up, and now have
> a test cat
> > up, but no admin/login access. I do have to chmod 755 the
> > cgi-bin/catlink as they aren't created with correct permissions.
> > (strange, wonder why?)
>
> That chmod could be the reason why you're having problems.
> It needs to be setuid root so you need to do:
> chmod 4755 cgi-bin/catlink
>
> Note that the exception to the above is if you're running
> apache with suexec.
>
> > I tarred up an old foundation-based cat that was recently
> running on
> > 5.6 for years now, untarred to my destination folder, and
> finally got
> > it fired up, but no access to admin/login (Internal Server Error).
>
> Look in your interchange error.log file for the real reason
> for this error.
>
> Also, why are you running makecat if you already have a catalog?
>
> > During checkout, once I am on the shipmode.html and submit
> to 'Next' I
> > expect to see the last page of my multi-page checkout
> (finalize.html)
> > but I also get "Internal Server Error". I have credit cards enabled.
>
> Again, see your error.log file (the global one, not the catalog one).
>
> > Current errors in cat error.log
> >
> > 74.117.242.45 K7Mcfhbm:74.117.242.45 -
> [31/August/2011:13:32:59 -0400]
> > fts1 /cgi-bin/fts1/ord/finalize.html Runtime error:
> mv_metadata import
> > into
> > failed: sdbm store returned -1, errno 22, key "kinventory" at
> > /home/funtime/fts1/interchange/lib/Vend/Table/Common.pm
> line 513, <IN>
> > line 121.
>
> You should not be using sdbm anymore but should switch to
> gdbm. It is likely that IC is trying to sdbm, though because
> it can't find perl support for gdbm. When you build perl the
> gdbm-devel package has to be installed or perl will not build
> with support for gdbm. You probably have to install gdbm and
> then re-build perl. Again, see the guilde for complete directions.
>
>
> > Over 12 years and 5 days messing with Interchange and linux and I
> > still don't get it. I'm ready to throw in the towel...
>
> Save yourself a lot of grief and read and follow that guide.
> I wrote it to help people do exactly what you are trying to
> do and it makes things very easy.

This guide is very nice to have, as well as what Jon has offered. I'm sure
I'll be back up before too long.

I have been following your guide, however, I could not get my user to login
without a password, but 'curt' is setup in the wheel group and I got this
far:

$ sudo yum -y install iptables wget
. Note: if you mess up when setting your iptables rules and manage to
block your own access to the server, then follow these directions to get
your ssh access back:
[snip some info stuff]
# service iptables stop # exit
o iptables will now be turned off and you should be able to log back
in via ssh.
. I recommend that you put all your iptables rules in a shell script
and run that script to update the rules. You can download and edit the basic
script that I use to setup iptables.
$ cd
$ wget http://github.com/pajamian/stuff/raw/master/centos/iptables_cfg.sh
$ chmod 700 iptables_cfg.sh
$ vi iptables_cfg.sh
. Make any changes you want. The default configuration is to allow
pings, ssh and http(s).
$ sudo ./iptables_cfg.sh
. Make sure you can still log in via ssh (but *don't* close your
current ssh connection until you do!)

Well, I can't login with SSH any longer or into my DirectAdmin console on
port 2222, my email is all down, http is up, and I do have an open SSH
console. I checked my access via SSH until just before that last command.
I've googled about but not sure what I'm looking for, can you help me get
back up? I didn't make any changes to iptables_cfg.sh. I tried to swap out
iptables.save, re-run sudo ./iptables_cfg.sh, tried stoping then starting as
root, and then swapped them back when no luck. I'm sure I was the correct
user/root for these tasks as well.

Sorry if this is the wrong place to ask this...

> Peter

Thank you very much!

Curt

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Sep 1, 2011, 1:25 PM

Post #5 of 20 (481 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 01/09/11 11:59, Curt Hauge wrote:
> $ sudo ./iptables_cfg.sh
> . Make sure you can still log in via ssh (but *don't* close your
> current ssh connection until you do!)
>
> Well, I can't login with SSH any longer or into my DirectAdmin console on
> port 2222, my email is all down, http is up, and I do have an open SSH
> console. I checked my access via SSH until just before that last command.
> I've googled about but not sure what I'm looking for, can you help me get
> back up? I didn't make any changes to iptables_cfg.sh. I tried to swap out
> iptables.save, re-run sudo ./iptables_cfg.sh, tried stoping then starting as
> root, and then swapped them back when no luck. I'm sure I was the correct
> user/root for these tasks as well.

You're ssh is on a non-standard port (why are you using port 2222 for
ssh?) which is being blocked by the firewall. You need to first
shutdown iptables:

$ sudo service iptables stop

...at this stage you should be able to connect again (check).

Now edit your iptables_cfg.sh file and copy the entry for ssh but change
the port to 2222, you should also add in lines for the other services
you need, such as email (there is a commented example for smtp, you may
also want to add a line for submission port 587).

when you're done editing iptables_cfg.sh rerun it and you should be good
to go:

$ sudo ./iptables_cfg.sh

Again, make sure you can log in via ssh before dropping your connection.

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic_support at mnwebdesign

Sep 1, 2011, 2:29 PM

Post #6 of 20 (476 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup
> [mailto:interchange-users-bounces [at] icdevgroup] On Behalf Of Peter
> Sent: Thursday, September 01, 2011 3:26 PM
> To: interchange-users [at] icdevgroup
> Cc: Curt Hauge
> Subject: Re: [ic] catalog working, no admin/login, unable to checkout
>
> On 01/09/11 11:59, Curt Hauge wrote:
> > $ sudo ./iptables_cfg.sh
> > . Make sure you can still log in via ssh (but *don't* close your
> > current ssh connection until you do!)
> >
> > Well, I can't login with SSH any longer or into my
> DirectAdmin console
> > on port 2222, my email is all down, http is up, and I do
> have an open
> > SSH console. I checked my access via SSH until just before
> that last command.
> > I've googled about but not sure what I'm looking for, can
> you help me
> > get back up? I didn't make any changes to iptables_cfg.sh.
> I tried to
> > swap out iptables.save, re-run sudo ./iptables_cfg.sh,
> tried stoping
> > then starting as root, and then swapped them back when no luck. I'm
> > sure I was the correct user/root for these tasks as well.
>
> You're ssh is on a non-standard port (why are you using port 2222 for
> ssh?) which is being blocked by the firewall. You need to
> first shutdown iptables:
>
> $ sudo service iptables stop
>
> ...at this stage you should be able to connect again (check).
>
> Now edit your iptables_cfg.sh file and copy the entry for ssh
> but change the port to 2222, you should also add in lines for
> the other services you need, such as email (there is a
> commented example for smtp, you may also want to add a line
> for submission port 587).
>
> when you're done editing iptables_cfg.sh rerun it and you
> should be good to go:
>
> $ sudo ./iptables_cfg.sh
>
> Again, make sure you can log in via ssh before dropping your
> connection.
>
>
> Peter

OK, I figured everything out, I forgot my host set my VPS SSH on port 1022
while DirectAdmin is on 2222. I am now into installing local perl and failed
1 test. I can't quite figure out where to go from here:

Failed 1 test out of 1695, 99.94% okay.
../cpan/Cwd/t/cwd.t
### Since not all tests were successful, you may want to run some of
### them individually and examine any diagnostic messages they produce.
### See the INSTALL document's section on "make test".
### You have a good chance to get more information by running
### ./perl harness
### in the 't' directory since most (>=80%) of the tests succeeded.

### You may have to set your dynamic library search path,

### LD_LIBRARY_PATH, to point to the build directory:

### setenv LD_LIBRARY_PATH `pwd`; cd t; ./perl harness

### LD_LIBRARY_PATH=`pwd`; export LD_LIBRARY_PATH; cd t; ./perl harness

### export LD_LIBRARY_PATH=`pwd`; cd t; ./perl harness

### for csh-style shells, like tcsh; or for traditional/modern
### Bourne-style shells, like bash, ksh, and zsh, respectively.
u=4.62 s=2.09 cu=371.72 cs=74.00 scripts=1695 tests=349509
make: *** [test] Error 1

I went here ../cpan/Cwd/t and did:
perl ./cwd.t

and got this:
opendir(linktest/../../../../../../../../../..): Permission denied at
./cwd.t line 213
not ok 25
# Failed test at ./cwd.t line 213.
# ''
# doesn't match
'(?i-xsm:\/home\/curt\/perl\-5\.12\.4\/cpan\/Cwd\/t\/_ptrslt_\/_path_\/_to_\
/_a_\/_dir_$)'
ok 26 - abs_path() can be invoked on a file
ok 27 - fast_abs_path() can be invoked on a file
ok 28 - _perl_abs_path() can be invoked on a file
ok 29 - abs_path() can be invoked on a file
ok 30 - fast_abs_path() can be invoked on a file
ok 31 - _perl_abs_path() can be invoked on a file
ok 32 - abs_path() works on files in the root directory
ok 33 - fast_abs_path() works on files in the root directory
ok 34 - _perl_abs_path() works on files in the root directory

and looked up line 213:
like(Cwd::_perl_abs_path($file), qr|$want$|i) if $EXTRA_ABSPATH_TESTS;

looks like it wants a path, I don't have a linktest path...

My google isn't finding me anything with meat ;-)

Any other thoughts on this?

Many thanks!

Curt

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Sep 1, 2011, 3:49 PM

Post #7 of 20 (475 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 01/09/11 14:29, IC Support wrote:
> OK, I figured everything out, I forgot my host set my VPS SSH on port 1022
> while DirectAdmin is on 2222. I am now into installing local perl and failed
> 1 test. I can't quite figure out where to go from here:
>
> I went here ../cpan/Cwd/t and did:
> perl ./cwd.t
>
> and got this:
> opendir(linktest/../../../../../../../../../..): Permission denied at
> ./cwd.t line 213
> not ok 25
> # Failed test at ./cwd.t line 213.
> # ''
> # doesn't match
> '(?i-xsm:\/home\/curt\/perl\-5\.12\.4\/cpan\/Cwd\/t\/_ptrslt_\/_path_\/_to_\
> /_a_\/_dir_$)'
>
> and looked up line 213:
> like(Cwd::_perl_abs_path($file), qr|$want$|i) if $EXTRA_ABSPATH_TESTS;
>
> looks like it wants a path, I don't have a linktest path...

Is this the initial perl install or the CPAN modules install? I think
you may be trying to install modules as an unprivlidged user here, but
the perl is installed as root and so CPAN needs to be run as root as well.

I'm guessing this is the Bundle::CPAN install, but you don't really say?

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Sep 1, 2011, 4:43 PM

Post #8 of 20 (478 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 01/09/11 15:49, Peter wrote:
> On 01/09/11 14:29, IC Support wrote:
>> OK, I figured everything out, I forgot my host set my VPS SSH on port 1022
>> while DirectAdmin is on 2222. I am now into installing local perl and failed
>> 1 test. I can't quite figure out where to go from here:
>>
>> I went here ../cpan/Cwd/t and did:
>> perl ./cwd.t
>>
>> and got this:
>> opendir(linktest/../../../../../../../../../..): Permission denied at
>> ./cwd.t line 213
>> not ok 25
>> # Failed test at ./cwd.t line 213.
>> # ''
>> # doesn't match
>> '(?i-xsm:\/home\/curt\/perl\-5\.12\.4\/cpan\/Cwd\/t\/_ptrslt_\/_path_\/_to_\
>> /_a_\/_dir_$)'
>>
>> and looked up line 213:
>> like(Cwd::_perl_abs_path($file), qr|$want$|i) if $EXTRA_ABSPATH_TESTS;
>>
>> looks like it wants a path, I don't have a linktest path...
>
> Is this the initial perl install or the CPAN modules install? I think
> you may be trying to install modules as an unprivlidged user here, but
> the perl is installed as root and so CPAN needs to be run as root as well.
>
> I'm guessing this is the Bundle::CPAN install, but you don't really say?

I just tried to recreate this and could not. I was able to (following
the directions in the guide) build a new perl 5.12.4 and install
Bundle::CPAN, Bundle::InterchangeKitchenSink and DBD::Pg all without a
hitch. In fact it looks like CentOS 5 no longer has finally upgraded
Expat to fix the bug there so that forcing XML::Parser was not even
necessary (I'll be updating my guide to reflect that, and the newer
5.12.4 version of Perl).

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic_support at mnwebdesign

Sep 1, 2011, 6:01 PM

Post #9 of 20 (474 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

ic_support at mnwebdesign

Sep 1, 2011, 6:08 PM

Post #10 of 20 (474 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

peter at pajamian

Sep 1, 2011, 11:57 PM

Post #11 of 20 (476 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 02/09/11 13:08, IC Support wrote:
> OK, I did this as user curt, from your guide:
>
> $ sudo yum -y install gcc gdbm-devel openssl-devel tk-devel gd-devel
> expat-devel make
> $ cd
> $ wget http://www.cpan.org/src/perl-5.12.3.tar.gz
> $ tar -xvzf perl-5.12.1.tar.gz
> $ cd perl-5.12.1
> $ ./Configure -des -Dprefix=/usr/local/perl-5.12.3
> $ make
> $ make test
>
> That is as far as I got, failed 1 test. Should I be root instead?

Ok, no, this is correct (except I said to do it with 5.12.4 but it
should have worked with 5.12.3 as well and I have in fact tested that in
the past). I honestly don't know why it failed the test for you but
I'll do some further testing and get back to you. Maybe you have some
package installed that is enabling a feature that i don't have and that
is what's failing.

Can you tell me again which test is failing?

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic_support at mnwebdesign

Sep 2, 2011, 7:59 AM

Post #12 of 20 (475 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup
> [mailto:interchange-users-bounces [at] icdevgroup] On Behalf Of Peter
> Sent: Friday, September 02, 2011 1:57 AM
> To: interchange-users [at] icdevgroup
> Subject: Re: [ic] catalog working, no admin/login, unable to checkout
>
> On 02/09/11 13:08, IC Support wrote:
> > OK, I did this as user curt, from your guide:
> >
> > $ sudo yum -y install gcc gdbm-devel openssl-devel tk-devel
> gd-devel
> > expat-devel make $ cd $ wget
> > http://www.cpan.org/src/perl-5.12.3.tar.gz
> > $ tar -xvzf perl-5.12.1.tar.gz
> > $ cd perl-5.12.1
> > $ ./Configure -des -Dprefix=/usr/local/perl-5.12.3 $ make $
> make test
> >
> > That is as far as I got, failed 1 test. Should I be root instead?
>
> Ok, no, this is correct (except I said to do it with 5.12.4
> but it should have worked with 5.12.3 as well and I have in
> fact tested that in the past). I honestly don't know why it
> failed the test for you but I'll do some further testing and
> get back to you. Maybe you have some package installed that
> is enabling a feature that i don't have and that is what's failing.
>
> Can you tell me again which test is failing?

as user curt, during 'make test' it fails and gives:

Failed 1 test out of 1695, 99.94% okay.
../cpan/Cwd/t/cwd.t
### Since not all tests were successful, you may want to run some of
### them individually and examine any diagnostic messages they produce.
### See the INSTALL document's section on "make test".
### You have a good chance to get more information by running
### ./perl harness
### in the 't' directory since most (>=80%) of the tests succeeded.
### You may have to set your dynamic library search path,
### LD_LIBRARY_PATH, to point to the build directory:
### setenv LD_LIBRARY_PATH `pwd`; cd t; ./perl harness
### LD_LIBRARY_PATH=`pwd`; export LD_LIBRARY_PATH; cd t; ./perl harness
### export LD_LIBRARY_PATH=`pwd`; cd t; ./perl harness
### for csh-style shells, like tcsh; or for traditional/modern
### Bourne-style shells, like bash, ksh, and zsh, respectively.
u=4.62 s=2.09 cu=371.72 cs=74.00 scripts=1695 tests=349509

make: *** [test] Error 1

I ran ./perl harness and several tests were skipped for various reasons, but
it was hard to keep track of everything, I may need to run it again (as user
curt) and look for a log file.

I tried:
setenv LD_LIBRARY_PATH `pwd`
but got:
setenv: command not found

I checked around for a way to 'install' setenv and came up empty.

I also went here perl-5.12.4/cpan/Cwd/t and did:
perl ./cwd.t

and got this:

opendir(linktest/../../../../../../../../../..): Permission denied at
./cwd.t line 213 not ok 25
# Failed test at ./cwd.t line 213.
# ''
# doesn't match
'(?i-xsm:\/home\/curt\/perl\-5\.12\.4\/cpan\/Cwd\/t\/_ptrslt_\/_path_\/_to_\
/_a_\/_dir_$)'
ok 26 - abs_path() can be invoked on a file
ok 27 - fast_abs_path() can be invoked on a file
ok 28 - _perl_abs_path() can be invoked on a file
ok 29 - abs_path() can be invoked on a file
ok 30 - fast_abs_path() can be invoked on a file
ok 31 - _perl_abs_path() can be invoked on a file
ok 32 - abs_path() works on files in the root directory
ok 33 - fast_abs_path() works on files in the root directory
ok 34 - _perl_abs_path() works on files in the root directory

and looked up line 213:
like(Cwd::_perl_abs_path($file), qr|$want$|i) if $EXTRA_ABSPATH_TESTS;

I hope that answers your question.

And this is what has heppened since my last email. I tried configuring and
running make and make test as root. You are saying that I WAS doing it
correctly (running make test as curt), so this may all be moot.

# cd perl-5.12.4
# ./Configure -des -Dprefix=/usr/local/perl-5.12.4
# make
# make test
# make install
# cd /usr/local
# sudo ln -s perl-5.12.4 perl

This got me through make test and the install error free. I got through
Text-Query issues and finished the perl install, however, when I do:

/usr/bin/perl -v
This is perl, v5.8.8 built for x86_64-linux-thread-multi

This perl was built by DirectAdmin when they setup my new VPS

however, /usr/local/bin/perl
This is perl, v5.10.0 built for x86_64-linux-v

This is a version I tried as root (which you once questioned my choice of
version), it won't go away, how can I get it out of there? Do I just remove
/usr/local/bin/perl? Again, maybe I should not be doing this as root.

whereis perl
perl: /usr/src/perl-5.12.4/perl.c /usr/src/perl-5.12.4/perl.h
/usr/src/perl-5.12.4/perl.o /usr/src/perl-5.12.4/perl /usr/bin/perl
/usr/local/bin/perl /usr/local/perl /usr/share/man/man1/perl.1.gz

OK, I am going to take a break for awhile and come back to this later today.
If you have anything to add please do. 8-)

Many thanks for all your efforts, Peter!

Curt

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Sep 2, 2011, 3:33 PM

Post #13 of 20 (470 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 03/09/11 02:59, IC Support wrote:
> And this is what has heppened since my last email. I tried configuring and
> running make and make test as root. You are saying that I WAS doing it
> correctly (running make test as curt), so this may all be moot.
>
> # cd perl-5.12.4
> # ./Configure -des -Dprefix=/usr/local/perl-5.12.4
> # make
> # make test
> # make install
> # cd /usr/local
> # sudo ln -s perl-5.12.4 perl
>
> This got me through make test and the install error free. I got through
> Text-Query issues and finished the perl install,

Right, this makes sense since the test was failing on a permissions
error running it as root would likely bypass the problem. I'm still not
sure what the actual issue was but it doesn't look very serious to me.
What concerns me is that I'm unable to reproduce it.

> however, when I do:
>
> /usr/bin/perl -v
> This is perl, v5.8.8 built for x86_64-linux-thread-multi
>
> This perl was built by DirectAdmin when they setup my new VPS

Actually, that's the system perl.

> however, /usr/local/bin/perl
> This is perl, v5.10.0 built for x86_64-linux-v
>
> This is a version I tried as root (which you once questioned my choice of
> version), it won't go away, how can I get it out of there? Do I just remove
> /usr/local/bin/perl? Again, maybe I should not be doing this as root.

I think you can go into the build directory where you built that
particular perl and do: make uninstall

The 5.12.4 perl you just built will be at /usr/local/perl-5.12.4/bin/perl.

> whereis perl
> perl: /usr/src/perl-5.12.4/perl.c /usr/src/perl-5.12.4/perl.h
> /usr/src/perl-5.12.4/perl.o /usr/src/perl-5.12.4/perl /usr/bin/perl
> /usr/local/bin/perl /usr/local/perl /usr/share/man/man1/perl.1.gz

Right, it won't show up on whereis because it's not in your path. You
can either symlink the perl binary to someplace in your path or just
call it with an absolute path, ie:
/usr/local/perl-5.12.4/bin/perl --version

Really it is probably best to leave that perl out of the path so it
doesn't interfere with your system perl.

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic_support at mnwebdesign

Sep 11, 2011, 4:13 PM

Post #14 of 20 (440 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

Peter said:

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup
> [mailto:interchange-users-bounces [at] icdevgroup] On Behalf Of Peter
> Sent: Friday, September 02, 2011 5:33 PM
> To: interchange-users [at] icdevgroup
> Subject: Re: [ic] catalog working, no admin/login, unable to checkout
>
> On 03/09/11 02:59, IC Support wrote:
> > And this is what has heppened since my last email. I tried
> configuring
> > and running make and make test as root. You are saying that I WAS
> > doing it correctly (running make test as curt), so this may
> all be moot.
> >
> > # cd perl-5.12.4
> > # ./Configure -des -Dprefix=/usr/local/perl-5.12.4 # make #
> make test
> > # make install # cd /usr/local # sudo ln -s perl-5.12.4 perl
> >
> > This got me through make test and the install error free. I got
> > through Text-Query issues and finished the perl install,
>
> Right, this makes sense since the test was failing on a
> permissions error running it as root would likely bypass the
> problem. I'm still not sure what the actual issue was but it
> doesn't look very serious to me.
> What concerns me is that I'm unable to reproduce it.
>
> > however, when I do:
> >
> > /usr/bin/perl -v
> > This is perl, v5.8.8 built for x86_64-linux-thread-multi
> >
> > This perl was built by DirectAdmin when they setup my new VPS
>
> Actually, that's the system perl.
>
> > however, /usr/local/bin/perl
> > This is perl, v5.10.0 built for x86_64-linux-v
> >
> > This is a version I tried as root (which you once
> questioned my choice
> > of version), it won't go away, how can I get it out of there? Do I
> > just remove /usr/local/bin/perl? Again, maybe I should not
> be doing this as root.
>
> I think you can go into the build directory where you built
> that particular perl and do: make uninstall
>
> The 5.12.4 perl you just built will be at
> /usr/local/perl-5.12.4/bin/perl.
>
> > whereis perl
> > perl: /usr/src/perl-5.12.4/perl.c /usr/src/perl-5.12.4/perl.h
> > /usr/src/perl-5.12.4/perl.o /usr/src/perl-5.12.4/perl /usr/bin/perl
> > /usr/local/bin/perl /usr/local/perl /usr/share/man/man1/perl.1.gz
>
> Right, it won't show up on whereis because it's not in your
> path. You can either symlink the perl binary to someplace in
> your path or just call it with an absolute path, ie:
> /usr/local/perl-5.12.4/bin/perl --version
>
> Really it is probably best to leave that perl out of the path
> so it doesn't interfere with your system perl.

OK, so I now have a test cat FULLY working and MY cat is running in admin
area. I had to remove the .gdbm and .sql files from products folder. I was
able to get into the user frontend after doing this, place an order, log in,
complete the order, view the receipt, then when going to home page or any
other page it resulted in "Internal server error". My cat error log has this
(and always seemed to have this error):

74.117.242.45 cnXuas58:74.117.242.45 - [11/September/2011:17:47:02 -0400]
fts1 /cgi-bin/fts1/index.html Runtime error: Can't locate object method
"func" via package "DBI::db" at
/usr/local/perl-5.12.4/lib/site_perl/5.12.4/x86_64-linux/DBD/mysql.pm line
227.

Things seem to be up-to-date, though I don't see a DBI::db nor can I find
one to install:
# perl -MDBI -e 'DBI->installed_versions'
Perl : 5.012004 (x86_64-linux)
OS : linux (2.6.18-238.19.1.el5xen)
DBI : 1.616
DBD::mysql : 4.020
DBD::Sponge : 12.010002
DBD::Proxy : 0.2004
DBD::Multiplex : 2.11
DBD::Gofer : 0.014282
DBD::File : 0.40
DBD::ExampleP : 12.014310
DBD::DBM : 0.06

# mysql -V
mysql Ver 14.14 Distrib 5.1.57, for unknown-linux-gnu (x86_64) using
readline 5.1

# /usr/local/bin/perl -MCPAN -eshell
cpan[2]> install DBI
DBI is up to date (1.616).

cpan[3]> install DBD::mysql
DBD::mysql is up to date (4.020).

Here are a few lines from mysql.pm, hope it doesn't break:

192 package DBD::mysql::db; # ====== DATABASE ======
193 use strict;
194 use DBI qw(:sql_types);
195
196 %DBD::mysql::db::db2ANSI = ("INT" => "INTEGER",
197 "CHAR" => "CHAR",
198 "REAL" => "REAL",
199 "IDENT" => "DECIMAL"
200 );
201
202 ### ANSI datatype mapping to mSQL datatypes
203 %DBD::mysql::db::ANSI2db = ("CHAR" => "CHAR",
204 "VARCHAR" => "CHAR",
205 "LONGVARCHAR" => "CHAR",
206 "NUMERIC" => "INTEGER",
207 "DECIMAL" => "INTEGER",
208 "BIT" => "INTEGER",
209 "TINYINT" => "INTEGER",
210 "SMALLINT" => "INTEGER",
211 "INTEGER" => "INTEGER",
212 "BIGINT" => "INTEGER",
213 "REAL" => "REAL",
214 "FLOAT" => "REAL",
215 "DOUBLE" => "REAL",
216 "BINARY" => "CHAR",
217 "VARBINARY" => "CHAR",
218 "LONGVARBINARY" => "CHAR",
219 "DATE" => "CHAR",
220 "TIME" => "CHAR",
221 "TIMESTAMP" => "CHAR"
222 );
223
224 sub prepare {
225 my($dbh, $statement, $attribs)= @_;
226
227 return unless $dbh->func('_async_check');

[end]

Any ideas out there?

Curt

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Sep 11, 2011, 4:54 PM

Post #15 of 20 (435 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 12/09/11 11:13, IC Support wrote:
> OK, so I now have a test cat FULLY working and MY cat is running in admin
> area. I had to remove the .gdbm and .sql files from products folder. I was
> able to get into the user frontend after doing this, place an order, log in,
> complete the order, view the receipt, then when going to home page or any
> other page it resulted in "Internal server error". My cat error log has this
> (and always seemed to have this error):
>
> 74.117.242.45 cnXuas58:74.117.242.45 - [11/September/2011:17:47:02 -0400]
> fts1 /cgi-bin/fts1/index.html Runtime error: Can't locate object method
> "func" via package "DBI::db" at
> /usr/local/perl-5.12.4/lib/site_perl/5.12.4/x86_64-linux/DBD/mysql.pm line
> 227.

You're trying to access a table from a Safe compartment without properly
opening the table first. Figure out which table it is and then open it
properly first. One of the easiest ways to do this is to add something
like this to catalog.cfg:

AutoLoad <<EOA
[perl tablename][/perl]
EOA

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic_support at mnwebdesign

Sep 15, 2011, 10:08 AM

Post #16 of 20 (431 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

Peter said:

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup
> [mailto:interchange-users-bounces [at] icdevgroup] On Behalf Of Peter
> Sent: Sunday, September 11, 2011 6:55 PM
> To: interchange-users [at] icdevgroup
> Subject: Re: [ic] catalog working, no admin/login, unable to checkout
>
> On 12/09/11 11:13, IC Support wrote:
> > OK, so I now have a test cat FULLY working and MY cat is running in
> > admin area. I had to remove the .gdbm and .sql files from products
> > folder. I was able to get into the user frontend after doing this,
> > place an order, log in, complete the order, view the receipt, then
> > when going to home page or any other page it resulted in "Internal
> > server error". My cat error log has this (and always seemed
> to have this error):
> >
> > 74.117.242.45 cnXuas58:74.117.242.45 - [11/September/2011:17:47:02
> > -0400]
> > fts1 /cgi-bin/fts1/index.html Runtime error: Can't locate object
> > method "func" via package "DBI::db" at
> >
> /usr/local/perl-5.12.4/lib/site_perl/5.12.4/x86_64-linux/DBD/mysql.pm
> > line 227.
>
> You're trying to access a table from a Safe compartment
> without properly opening the table first. Figure out which
> table it is and then open it properly first. One of the
> easiest ways to do this is to add something like this to catalog.cfg:
>
> AutoLoad <<EOA
> [perl tablename][/perl]
> EOA

I tried Peters suggestion on all tables, one at a time, restarted
Interchange (always starts quickly), and I get the same result. Nothing has
changed in the catalog, so this must be something on my server causing this.
How strange that I can now get to admin area with complete unfettered
access, but not the customer side.

Can anyone tell me, is it safe to remove all .gdbm, .pag, .dir, .sdbm files
from CATROOT/products?
Is there some place I could start to use debugging on this cat to help
figure this out?

I have another IC 5.6.3 install on another domain and that cat was also
running fine on my old server, and now is having issues on every table while
starting Interchange, like this:

table 'area' failed: connect to dbi:mysql:cambridge_1982 failed (create) --
Access denied for user 'admin'@'localhost' (using password: NO)

and I see this 'occasionally' in the cat error.log
- - - [10/September/2011:20:03:33 -0400] 1982 - table 'photos' failed: table
photos connect failed -- DBI connect('cambridge_1982','',...) failed: Access
denied for user 'admin'@'localhost' (using password: NO) at
/home/cambridge/chs/interchange/lib/Vend/Table/DBI.pm line 613

so I look at DBI.pm and find this:

611 ::logDebug("bad=$bad connecting to $call[0]");
612 eval {
613 $db = DBI->connect( @call ) unless $bad;
614 $db->trace($Global::DataTrace,
$Global::DebugFile)
615 if $Global::DataTrace and
$Global::DebugFile;
616 };

Then I uncomment the debug in DBI.pm and uncomment the DEBUG in
interchange.cfg, restart, nothing in debug but I find this when starting
Interchange:

Vend::Table::DBI:debug: bad= connecting to dbi:mysql:cambridge_1982
Vend::Table::DBI:debug: bad=1 connecting to dbi:mysql:cambridge_1982

I have the mysql db installed and accessible from phpMyAdmin, user and pass
is in CATROOT/dbconf/mysql/mysql.cfg:
Variable SQLUSER myusername
Variable SQLPASS mypassword

Does anyone know how this could be coming up with admin [at] localhos? This
'DBI' seems to keep coming up, do I need to remove and reinstall that (I
have done a reinstall)?

Is it possible that tarring up these cats, then ftp'ing the .tar files to my
local Windows machine, then ftp'ing up to new server is causing some
problems? I just did a tar -cf archive.tar foo to create the archive.

I will be digging into these problems again today. Any other thoughts or
suggestions are appreciated!

Curt

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Sep 15, 2011, 12:55 PM

Post #17 of 20 (429 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 16/09/11 05:08, IC Support wrote:
> Can anyone tell me, is it safe to remove all .gdbm, .pag, .dir, .sdbm files
> from CATROOT/products?

I don't know where .pag or .dir files come from, it is safe to remove
the other two as interchange will re-create them.

When did the .sdbm files appear? Having these suggests that IC did not
find support for gdbm in your perl. It is highly possible that if you
built your own perl you didn't have the gdbm development package
installed at the time and so perl would have been built without it in
this case.

> I have another IC 5.6.3 install on another domain and that cat was also
> running fine on my old server, and now is having issues on every table while
> starting Interchange, like this:
>
> table 'area' failed: connect to dbi:mysql:cambridge_1982 failed (create) --
> Access denied for user 'admin'@'localhost' (using password: NO)
>
> and I see this 'occasionally' in the cat error.log
> - - - [10/September/2011:20:03:33 -0400] 1982 - table 'photos' failed: table
> photos connect failed -- DBI connect('cambridge_1982','',...) failed: Access
> denied for user 'admin'@'localhost' (using password: NO) at
> /home/cambridge/chs/interchange/lib/Vend/Table/DBI.pm line 613
>
> I have the mysql db installed and accessible from phpMyAdmin, user and pass
> is in CATROOT/dbconf/mysql/mysql.cfg:
> Variable SQLUSER myusername
> Variable SQLPASS mypassword
>
> Does anyone know how this could be coming up with admin [at] localhos? This
> 'DBI' seems to keep coming up, do I need to remove and reinstall that (I
> have done a reinstall)?

Check your .mysql files for these tables in catroot/dbconf/mysql

> Is it possible that tarring up these cats, then ftp'ing the .tar files to my
> local Windows machine, then ftp'ing up to new server is causing some
> problems? I just did a tar -cf archive.tar foo to create the archive.

Possible, but unlikely. It is possible that because you didn't compress
the files they were seen as text files by one or both of your FTP
software and so line-ending conversions may have been done in one or
both of the transfers.

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic_support at mnwebdesign

Sep 15, 2011, 2:26 PM

Post #18 of 20 (429 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

Curt said:

> -----Original Message-----
> From: interchange-users-bounces [at] icdevgroup
> [mailto:interchange-users-bounces [at] icdevgroup] On Behalf
> Of IC Support
> Sent: Thursday, September 15, 2011 12:09 PM
> To: interchange-users [at] icdevgroup
> Subject: Re: [ic] catalog working, no admin/login, unable to checkout
>
> Peter said:
>
> > -----Original Message-----
> > From: interchange-users-bounces [at] icdevgroup
> > [mailto:interchange-users-bounces [at] icdevgroup] On Behalf Of Peter
> > Sent: Sunday, September 11, 2011 6:55 PM
> > To: interchange-users [at] icdevgroup
> > Subject: Re: [ic] catalog working, no admin/login, unable
> to checkout
> >
> > On 12/09/11 11:13, IC Support wrote:
> > > OK, so I now have a test cat FULLY working and MY cat is
> running in
> > > admin area. I had to remove the .gdbm and .sql files from
> products
> > > folder. I was able to get into the user frontend after
> doing this,
> > > place an order, log in, complete the order, view the
> receipt, then
> > > when going to home page or any other page it resulted in
> "Internal
> > > server error". My cat error log has this (and always seemed
> > to have this error):
> > >
> > > 74.117.242.45 cnXuas58:74.117.242.45 -
> [11/September/2011:17:47:02
> > > -0400]
> > > fts1 /cgi-bin/fts1/index.html Runtime error: Can't locate object
> > > method "func" via package "DBI::db" at
> > >
> >
> /usr/local/perl-5.12.4/lib/site_perl/5.12.4/x86_64-linux/DBD/mysql.pm
> > > line 227.
> >
> > You're trying to access a table from a Safe compartment without
> > properly opening the table first. Figure out which table it is and
> > then open it properly first. One of the easiest ways to do
> this is to
> > add something like this to catalog.cfg:
> >
> > AutoLoad <<EOA
> > [perl tablename][/perl]
> > EOA
>
> I tried Peters suggestion on all tables, one at a time,
> restarted Interchange (always starts quickly), and I get the
> same result. Nothing has changed in the catalog, so this must
> be something on my server causing this.
> How strange that I can now get to admin area with complete
> unfettered access, but not the customer side.
>
> Can anyone tell me, is it safe to remove all .gdbm, .pag,
> .dir, .sdbm files from CATROOT/products?
> Is there some place I could start to use debugging on this
> cat to help figure this out?
>

OK, I now have 2 separate catalogs that only run in the admin, Internal
server error in customer side.
Both cats exhibit the same error in the cat error log:

/cgi-bin/1982 Runtime error: Can't locate object method "func" via package
"DBI::db" at
/usr/local/perl-5.12.4/lib/site_perl/5.12.4/x86_64-linux/DBD/mysql.pm line
227.

Somehow it seems I need to remove and reinstall DBD or DBI or ?

My test cats DO NOT have any issues.

Curt

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

peter at pajamian

Sep 15, 2011, 2:37 PM

Post #19 of 20 (431 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

On 16/09/11 09:26, IC Support wrote:
> OK, I now have 2 separate catalogs that only run in the admin, Internal
> server error in customer side.
> Both cats exhibit the same error in the cat error log:
>
> /cgi-bin/1982 Runtime error: Can't locate object method "func" via package
> "DBI::db" at
> /usr/local/perl-5.12.4/lib/site_perl/5.12.4/x86_64-linux/DBD/mysql.pm line
> 227.
>
> Somehow it seems I need to remove and reinstall DBD or DBI or ?

It won't hurt to try that, but I'm pretty sure it won't work. This
still looks like a Safe error to me. What does the global error.log say?

> My test cats DO NOT have any issues.

Which only goes to support my theory that it's not a problem with
DBD::mysql or DBI

Peter

_______________________________________________
interchange-users mailing list
interchange-users [at] icdevgroup
http://www.icdevgroup.org/mailman/listinfo/interchange-users

ic_support at mnwebdesign

Sep 16, 2011, 2:58 PM

Post #20 of 20 (441 views)
Permalink

Re: catalog working, no admin/login, unable to checkout [In reply to]

Index | Next | Previous | View Threaded

Interested in having your list archived? Contact Gossamer Threads