[ic] Installing new templates??? Help

Chris interchange-users@icdevgroup.org
Mon May 12 19:42:00 2003


Hello, I am new to the interchange and having some problems getting
things set up. It is being hosted at "WebHostPalace", the admin of that
host tells me that I can install scripts of php or cgi and so on to
update or add to the "Interchange" shopping cart. Now do I have to have
shell access to do this or do you know depending on the host?

I very much want to change the menu and add other things to it, such as
a PayPal mod to take PayPal payments. 


Is it possible to talk with some one on the phone, I would be willing to
call to save you the bill, but would love to chat a little about this. I
have never done anything with Perl, so some of the things I am lost
unless I can get a little bit of info and the best way to update and
change some of the things in the 'Interchange" cart.
If it is possible to call and talk with someone, The number will never
get out to any one. I totally understand about things like that.

So just some small direction and I could be on my way. 
The best time to chat on the phone for me is after 9:00pm Central time.
So I hope that works for you and I do hope that you would not mind the
call.

WE have been fighting for way to long to get things up and going,
starting to run out of money to found things unless we can get all
running to keep the income coming in.


But if you don't or cant talk on the phone, I understand. I have been
reading the doc's for the program and not really getting any where with
it. Cause it all talks about doing it at the server. I will give you
more info if you need more info to be able to help me out any. I am not
sure how much more info you need.


Thank you very much
Chris Hesseltine

P.S Please don't post this any where on any of the boards!!!!!



-----Original Message-----
From: interchange-users-admin@icdevgroup.org
[mailto:interchange-users-admin@icdevgroup.org] On Behalf Of
interchange-users-request@icdevgroup.org
Sent: Monday, May 12, 2003 11:00 AM
To: interchange-users@icdevgroup.org
Subject: interchange-users digest, Vol 1 #1330 - 8 msgs


Send interchange-users mailing list submissions to
	interchange-users@icdevgroup.org

To subscribe or unsubscribe via the World Wide Web, visit
	http://www.icdevgroup.org/mailman/listinfo/interchange-users
or, via email, send a message with subject or body 'help' to
	interchange-users-request@icdevgroup.org

You can reach the person managing the list at
	interchange-users-admin@icdevgroup.org

When replying, please edit your Subject line so it is more specific than
"Re: Contents of interchange-users digest..."


Today's Topics:

   1. How to create a menu (Interchange User)
   2. Re: Mrore non threaded perl questions (Mike Heins)
   3. Re: How to create a menu (Mike Heins)
   4. 4.9.7 nightly - Wow!! (Brian Kosick)
   5. Convert access.gdbm to mysql (Neil Hambleton)
   6. Re: Convert access.gdbm to mysql (axwack@optonline.net)
   7. Re: Convert access.gdbm to mysql (Mike Heins)
   8. Re: 4.9.7 nightly - Wow!! (Mike Heins)

--__--__--

Message: 1
Date: Sun, 11 May 2003 12:03:20 -0400
From: Interchange User <interchange@framework.cx>
To: interchange-users@icdevgroup.org
Subject: [ic] How to create a menu
Reply-To: interchange-users@icdevgroup.org

Greetings!

I have used the menu editor in a recent CVS build to create a new menu, 
but I'm not sure how to go about inserting it into a 
non-foundation-derived catalog (I'm building one from scratch).  I 
assume that I'm missing some tag to reference it.  I made a menu called 
"main", and added the pages that I want to it, but I'm not sure what my 
next step would be.  Any suggestions appreciated.

Thanks!


--__--__--

Message: 2
Date: Sun, 11 May 2003 12:39:42 -0400
From: Mike Heins <mike@perusion.com>
To: interchange-users@icdevgroup.org
Subject: Re: [ic] Mrore non threaded perl questions
Reply-To: interchange-users@icdevgroup.org

Quoting DB (DB@M-and-D.com):
> I found Mike's instructions for installing a new perl and have a 
> question.
> 
> > There are two recommended ways on Linux. Neither of them means 
> > removing the RPM -- you will find Perl is needed by a lot of other 
> > things.
> > 
> > 	1. Replace the system perl.
> > 
> > 		tar xzf stable.tar.gz
> > 		cd perl*
> > 		./configure -Dprefix=/usr -des
> > 		make test
> > 		make install
> > 
> > 	2. Install a separate perl.
> > 
> > 		tar xzf stable.tar.gz
> > 		cd perl*
> > 		./configure -des
> > 		make test
> > 		make install
> > 
> > The second will install it at /usr/local (under Linux), in which 
> > case you install Interchange with
> > 
> > 	/usr/local/bin/perl Makefile.PL
> 
> For option #1, will this just overwrite the existing perl on my Redhat
> 8.0 with a non threaded version? It seems like an easy solution but
I'm 
> afraid of breaking anything else.

Never breaks anything *I* use. I would be extremely surprised to find
any standard Linux program using threaded Perl programs.

> 
> Option #2 I like because it would leave everything else untouched. I
> already have an earlier version of 4.9.7 that I installed from a 
> tarball. Is there a way to upgrade my existing 4.9.7 by telling it to 
> use the alternate non-threaded perl? Will "/usr/local/bin/perl 
> Makefile.PL" do that?

Yes, it will.

>  Or maybe there's some option I can use with the
> configure command to point it to the new perl?

Or you can just modify the shbang on the appropriate scripts:

	cd /usr/local/interchange
	perl -pi -e 's:^#./usr/bin/perl:#\!/usr/local/bin/perl:' \
		`grep -rl '#./usr/bin/perl' *` 

That should about cover it, though you will have to modify
/usr/sbin/interchange and /usr/sbin/makecat if those are on your system.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

Nature, to be commanded, must be obeyed. -- Francis Bacon

--__--__--

Message: 3
Date: Sun, 11 May 2003 12:46:53 -0400
From: Mike Heins <mike@perusion.com>
To: interchange-users@icdevgroup.org
Subject: Re: [ic] How to create a menu
Reply-To: interchange-users@icdevgroup.org

Quoting Interchange User (interchange@framework.cx):
> Greetings!
> 
> I have used the menu editor in a recent CVS build to create a new 
> menu,
> but I'm not sure how to go about inserting it into a 
> non-foundation-derived catalog (I'm building one from scratch).  I 
> assume that I'm missing some tag to reference it.  I made a menu
called 
> "main", and added the pages that I want to it, but I'm not sure what
my 
> next step would be.  Any suggestions appreciated.

The tree approach is shown in templates/component/product_tree, and
flyout in templates/component/product_flyout.

Or use one of the examples in the admin -- this page has one using a
simple menu:

	lib/UI/pages/admin/genfunction.html

Or you can try downloading a modified demo I put together:

	http://ftp.icdevgroup.org/interchange/demos/mike-0.01.tar.gz

(Be sure to check the README file if you want to install it.)

The file variables/COMMON_MENU contains the flydown menu used in the top
bar, and the pages/member/service.html file shows another use.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

There's nothing sweeter than life nor more precious than time.
-- Barney

--__--__--

Message: 4
From: Brian Kosick <briank@nacs.net>
To: interchange-users@icdevgroup.org
Organization: 
Date: 11 May 2003 18:54:19 -0600
Subject: [ic] 4.9.7 nightly - Wow!!
Reply-To: interchange-users@icdevgroup.org

Hi everyone, Mike and Stefan and all other developers, I just wanted to
say that I just recently downloaded a 4.9.7 nightly and got it up and
running, and all I can say is Wow!  everything looks great.  the backend
with IC is often a huge selling point to my clients, and (I haven't
tested the new one yet) if half the stuff works like it looks like it's
supposed to, IC is really maturing into the premier OSS e-commerce
engine.  (like it wasn't all ready ;-) )  anyways, I just wanted to let
all you developers let you know that I and I'm sure many others really
appreciate all the work and devotion that you put into it.  keep up the
good work and where do I send the beer?

Congrats all
Brian


--__--__--

Message: 5
From: "Neil Hambleton" <hambletn@netvigator.com>
To: <interchange-users@icdevgroup.org>
Date: Mon, 12 May 2003 21:25:27 +0800
Subject: [ic] Convert access.gdbm to mysql
Reply-To: interchange-users@icdevgroup.org

At 01:21 PM 01/03/2003 -0500, you wrote:
> > Jan  3 10:19:51 mordred int1: Died in server spawn: Could not tie to
> > '/var/lib/interchange/catalogs/ghast/products/access.gdbm': Resource

> > temporarily unavailable at /usr/lib/interchange/Vend/Table/GDBM.pm 
> > line 115.
>>
>>     Multiple users trying to use the admin backend simultaneously 
>> with
the
>>same user account.
>>
>>
>>Jeff
>
>If you are using an SQL database for most of your tables, I would 
>suggest you convert access to SQL and see if that helps. GDBM is weak 
>when it comes to multi-user/session access.
>
>- Ed L.

I think I may be having a similar problem under IC 4.8.6, and was going
to try converting "access" to SQL instead of gdbm. I have looked, but
not found any documentation on this sort of conversion. My plan was to:

1. Use the Admin UI to export access to access.txt
2. Create a dbconf/mysql/access.mysql file
3. Remove dbconf/mysql/access.dbm
4. Restart Interchange and hope it picks up my new configuration

However I'm a little unsure about the format of the access.mysql file. I
was going to use something like:

Database  access access .txt    __SQLDSN__
ifdef SQLUSER
Database  access  USER         __SQLUSER__
endif
ifdef SQLPASS
Database  access     PASS         __SQLPASS__
endif
Database  access     COLUMN_DEF   "username=char(14) NOT NULL PRIMARY
KEY"


But I'm concerned about whether "char(14)" is sensible for username, and
whether I need to include COLUMN_DEF statements for the other fields. If
so, how do I find out what datatypes, sizes and indices to include?

Before I go ahead and screw anything up, I'd appreciate any advice
anyone can offer.

Thanks,
Neil


--__--__--

Message: 6
Date: Mon, 12 May 2003 09:38:31 -0400
From: axwack@optonline.net
Subject: Re: [ic] Convert access.gdbm to mysql
To: interchange-users@icdevgroup.org
Reply-To: interchange-users@icdevgroup.org

Neil,

I'm working on the same problem with IBM DB2/UDB. Perhaps we can do it
together and build scripts for the each of our respective platforms.
I've made scripts already for UDB and would be willing to share them
with you but you and I have the same problem since I'm not sure about
how to do this using a SQL database.

----- Original Message -----
From: Neil Hambleton <hambletn@netvigator.com>
Date: Monday, May 12, 2003 9:25 am
Subject: [ic] Convert access.gdbm to mysql

> At 01:21 PM 01/03/2003 -0500, you wrote:
> > > Jan  3 10:19:51 mordred int1: Died in server spawn: Could not
> tie to
> > > '/var/lib/interchange/catalogs/ghast/products/access.gdbm':
> Resource> > temporarily unavailable at
> /usr/lib/interchange/Vend/Table/GDBM.pm line
> > > 115.
> >>
> >>     Multiple users trying to use the admin backend
> simultaneously with
> the
> >>same user account.
> >>
> >>
> >>Jeff
> >
> >If you are using an SQL database for most of your tables, I would
> suggest>you convert access to SQL and see if that helps. GDBM is
> weak when it comes
> >to multi-user/session access.
> >
> >- Ed L.
> 
> I think I may be having a similar problem under IC 4.8.6, and was
> going to
> try converting "access" to SQL instead of gdbm. I have looked, but 
> not found
> any documentation on this sort of conversion. My plan was to:
> 
> 1. Use the Admin UI to export access to access.txt
> 2. Create a dbconf/mysql/access.mysql file
> 3. Remove dbconf/mysql/access.dbm
> 4. Restart Interchange and hope it picks up my new configuration
> 
> However I'm a little unsure about the format of the access.mysql
> file. I was
> going to use something like:
> 
> Database  access access .txt    __SQLDSN__
> ifdef SQLUSER
> Database  access  USER         __SQLUSER__
> endif
> ifdef SQLPASS
> Database  access     PASS         __SQLPASS__
> endif
> Database  access     COLUMN_DEF   "username=char(14) NOT NULL 
> PRIMARY KEY"
> 
> 
> But I'm concerned about whether "char(14)" is sensible for
> username, and
> whether I need to include COLUMN_DEF statements for the other 
> fields. If so,
> how do I find out what datatypes, sizes and indices to include?
> 
> Before I go ahead and screw anything up, I'd appreciate any advice
> anyonecan offer.
> 
> Thanks,
> Neil
> 
> _______________________________________________
> interchange-users mailing list interchange-users@icdevgroup.org
> http://www.icdevgroup.org/mailman/listinfo/interchange-users
> 


--__--__--

Message: 7
Date: Mon, 12 May 2003 10:48:53 -0400
From: Mike Heins <mike@perusion.com>
To: interchange-users@icdevgroup.org
Subject: Re: [ic] Convert access.gdbm to mysql
Reply-To: interchange-users@icdevgroup.org

Quoting Neil Hambleton (hambletn@netvigator.com):
> At 01:21 PM 01/03/2003 -0500, you wrote:
> > > Jan  3 10:19:51 mordred int1: Died in server spawn: Could not tie 
> > > to
> > > '/var/lib/interchange/catalogs/ghast/products/access.gdbm':
Resource
> > > temporarily unavailable at /usr/lib/interchange/Vend/Table/GDBM.pm
line
> > > 115.
> >>
> >> Multiple users trying to use the admin backend simultaneously with 
> >> the same user account.
> >
> >If you are using an SQL database for most of your tables, I would 
> >suggest you convert access to SQL and see if that helps. GDBM is weak

> >when it comes to multi-user/session access.
>
> I think I may be having a similar problem under IC 4.8.6, and was 
> going to try converting "access" to SQL instead of gdbm. I have 
> looked, but not found any documentation on this sort of conversion. My

> plan was to:
> 
> 1. Use the Admin UI to export access to access.txt
> 2. Create a dbconf/mysql/access.mysql file
> 3. Remove dbconf/mysql/access.dbm
> 4. Restart Interchange and hope it picks up my new configuration
> 
> However I'm a little unsure about the format of the access.mysql file.

> I was going to use something like:
> 
> Database  access access .txt    __SQLDSN__
> ifdef SQLUSER
> Database  access  USER         __SQLUSER__
> endif
> ifdef SQLPASS
> Database  access     PASS         __SQLPASS__
> endif
> Database  access     COLUMN_DEF   "username=char(14) NOT NULL PRIMARY
KEY"
> 
> But I'm concerned about whether "char(14)" is sensible for username, 
> and whether I need to include COLUMN_DEF statements for the other 
> fields. If so, how do I find out what datatypes, sizes and indices to 
> include?

I would recommend something like:

Database  access access .txt    __SQLDSN__

ifdef SQLUSER
Database  access  USER         __SQLUSER__
endif

ifdef SQLPASS
Database  access     PASS         __SQLPASS__
endif

Database  access     DEFAULT_TYPE text
Database  access     COLUMN_DEF   "username=varchar(32) NOT NULL PRIMARY
KEY"
Database  access     COLUMN_DEF   "password=varchar(64)"
Database  access     COLUMN_DEF   "label=varchar(128)"
Database  access     COLUMN_DEF   "name=varchar(64)"
Database  access     COLUMN_DEF   "last_login=varchar(32)"
Database  access     COLUMN_DEF   "super=varchar(3)"

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

There's nothing sweeter than life nor more precious than time.
-- Barney

--__--__--

Message: 8
Date: Mon, 12 May 2003 11:08:28 -0400
From: Mike Heins <mike@perusion.com>
To: interchange-users@icdevgroup.org
Subject: Re: [ic] 4.9.7 nightly - Wow!!
Reply-To: interchange-users@icdevgroup.org

Quoting Brian Kosick (briank@nacs.net):
> Hi everyone, Mike and Stefan and all other developers, I just wanted 
> to say that I just recently downloaded a 4.9.7 nightly and got it up 
> and running, and all I can say is Wow!  everything looks great.  the 
> backend with IC is often a huge selling point to my clients, and (I 
> haven't tested the new one yet) if half the stuff works like it looks 
> like it's supposed to, IC is really maturing into the premier OSS 
> e-commerce engine.  (like it wasn't all ready ;-) )

If we can finish 5.0/4.9.x and then produce some "macro" documentation,
I think we will be a contender.

> anyways, I just wanted to let
> all you developers let you know that I and I'm sure many others really

> appreciate all the work and devotion that you put into it.  keep up 
> the good work and where do I send the beer?
> 

I gave up beer some years ago -- I had already drunk my share of the
world's supply. Your nice wishes are enough for me, but Stefan likes
beer. 8-)

Thanks for the support.

-- 
Mike Heins
Perusion -- Expert Interchange Consulting    http://www.perusion.com/
phone +1.513.523.7621      <mike@perusion.com>

There's nothing sweeter than life nor more precious than time.
-- Barney


--__--__--

_______________________________________________
interchange-users mailing list
interchange-users@icdevgroup.org
http://www.icdevgroup.org/mailman/listinfo/interchange-users


End of interchange-users Digest