[ic] Installing construct w/ mysql support

Steve West interchange-users@lists.akopia.com
Sat May 19 14:50:00 2001


Matt,

I did exactly what you said and it seems perl tried to download this file and some other things. Then, it started to download the entire perl application (5.7MB). So, I followed the instructions and allowed it to install. But, it seems there was an error:

make[1]: Leaving directory `/root/.cpan/build/perl-5.6.1'
  /usr/bin/make install  -- OK
Running make for J/JW/JWIED/DBD-mysql-2.0900.tar.gz
  Unwrapped into directory /root/.cpan/build/DBD-mysql-2.0900
  Has already been processed within this session
Running make test
  Oops, make had returned bad status
Running make install
  Oops, make had returned bad status

Any ideas why this happened? I thought I was only downloading just the DBD::mysql but not the entire perl application. I selected all the defaults that the perl installation found or suggested to choose.

P.S. I know we will get this thing to work soon. If only my system can stop asking for more things to be installed! :)

SW

-----Original Message-----
From: Matthew Schick [mailto:matt@brightredproductions.com]
Sent: Saturday, May 19, 2001 12:56 PM
To: wppiphoto@wppi.com
Subject: RE: [ic] Installing construct w/ mysql support



Do "  perl -MCPAN -e 'install Bundle::DBD::mysql' " and it will take care of this on.... glad to see you have gotten past the first problem..... welcome to Interchange..... <g>
On 19 May 2001 12:40:21 -0400, Steve West wrote:
> 
> Math,
> 
> Well, it seems I'm getting closer to getting the construct demo catelog
> working. Per J.P. suggestion, I setup the path for mysqladmin and then ran
> the bin/makecat construct and it seemed to connect to mysql and add the
> test_construct database to mysql:
> 
> mysql> show databases;
> +----------------+
> | Database       |
> +----------------+
> | mysql          |
> | test           |
> | test2          |
> | test_construct |
> +----------------+
> 
> So, I rebooted interchange but got the following errors:
> 
> [root@dns2 ae]# su -c "/usr/local/interchange/bin/interchange -r" interch
> bash: /home/ae/.bashrc: Permission denied
> Killing Interchange server 3495 with TERM.
> Low traffic settings.
> Calling UI....
> ...UI is loaded....
> Interchange V4.6.5
> Configuring catalog construct...Using MySQL, DSN=dbi:mysql:test_construct.
> construct config error: connect failed (create) -- unknown error. Driver
> 'mysql'
>  installed?
> 
> 
> construct: error in configuration. Skipping.
> construct: config error. Skipping.
> Interchange server started in INET and UNIX mode(s) (process id 3762)
> 
> Any ideas why I'm still getting the errors above?
> 
> Thanks for all the help so far!!! :)
> 
> SW
> 
> 
> 
> -----Original Message-----
> From: Matthew Schick [mailto:matt@brightredproductions.com]
> Sent: Saturday, May 19, 2001 12:00 PM
> To: wppiphoto@wppi.com
> Subject: RE: [ic] Installing construct w/ mysql support
> 
> 
> I apologise.....  mysqladmin is part of the the 'MySQL-Client' rpm from
> the mysql site.  Your problem is the program is outside of your path,
> hence the problem.....  I don't remember the exact commands for
> exporting a new path while keeping the new one intact, but you can
> always symlink it to your /usr/bin directory (ln -s /usr/bin/
> /usr/local/mysql/bin/mysqladmin) as root.....
> 
> Matt
> 
> On 19 May 2001 11:44:55 -0400, Steve West wrote:
> >
> > Matt,
> >
> > mysqladmin is installed at the following location:
> >
> > /usr/local/mysql/bin/mysqladmin
> >
> > So, it seems it's installed. How about mysql-client? Or is that part of
> > mysqladmin?
> >
> > Thanks for all the help!
> >
> > SW
> >
> > -----Original Message-----
> > From: Matthew Schick [mailto:matt@brightredproductions.com]
> > Sent: Saturday, May 19, 2001 11:39 AM
> > To: wppiphoto@wppi.com
> > Subject: RE: [ic] Installing construct w/ mysql support
> >
> >
> > Try doing a ' whereis mysqladmin '.  If that's unsuccessful do '
> > updatedb ' followed by ' locate mysqladmin '.  I would highly recommend
> > using the rpms from the mysql site. They have everything you need, and
> > without all the problems :).
> >
> > Lemmie know how this turns out...
> > Matt
> >
> > On 19 May 2001 11:16:12 -0400, Steve West wrote:
> > >
> > > Matt,
> > >
> > > >Are you sure you have the 'MySQL-Client' package installed?
> > >
> > > How can I check? I installed mysql-3.23.38-pc-linux-gnu-i686.tar and
> > > everything installed fine. I created a test database added some tables
> all
> > > without a problem.
> > >
> > > Thanks!
> > >
> > > SW
> > >
> > >
> > > -----Original Message-----
> > > From: interchange-users-admin@developer.akopia.com
> > > [mailto:interchange-users-admin@developer.akopia.com]On Behalf Of
> > > Matthew Schick
> > > Sent: Friday, May 18, 2001 6:30 PM
> > > To: interchange-users@developer.akopia.com
> > > Subject: Re: [ic] Installing construct w/ mysql support
> > >
> > >
> > > On 18 May 2001 17:55:34 -0400, Steve West wrote:
> > > >
> > > > I just installed interchange on a RedHat 7.0 box and I'm having a few
> > > > issues.
> > > >
> > > > First, can someone tell me what does this mean:
> > > >
> > > > Since you selected the MySQL option, you need to create
> > > > a database named "test_construct". In a default MySQL
> > > > configuration, any user may create and drop and modify
> > > > test_* databases, but some administrators disable this.
> > > >
> > > > run "mysqladmin -u root -p create test_construct"? y
> > > >
> > > > Command returned error code 16777215: No such file or directory
> > > > done.
> > > >
> > >
> > > Are you sure you have the 'MySQL-Client' package installed?  It sounds
> > > like mysqladmin doesn't exist on your system
> > >
> > > > Does this mean the test_construct database did not get created?
> > >
> > > Yes.
> > >
> > > >
> > > > Secondly, I'm unable to click to go to "Enter as customer" or "Admin
> > > > interface" link. They both fail. So, I rebooted the server and started
> > the
> > > > service but I got several errors:
> > > >
> > > > [root@dns2 ae]# /usr/local/interchange/bin/restart
> > > >
> > > > The Interchange server should not be run as root. It should run
> > > > as a the user name you configured in when you set up the catalogs.
> > > >
> > > > The name we think should run it is: interch
> > > >
> > > > If you are starting the server from /etc/rc.local or another
> > > > startup file, you can use this:
> > > >
> > > > su -f -c /usr/local/interchange/bin/restart interch
> > > > or if that fails:
> > > >
> > > >         su interch <<EOF
> > > > /usr/local/interchange/bin/restart
> > > > EOF
> > > >
> > > > Do you want me to start it as 'interch' now? [y]
> > > > bash: /home/ae/.bashrc: Permission denied
> > > > The Interchange server was not running
> > > > (/usr/local/interchange/etc/interchange.p
> > > > id).
> > > > Low traffic settings.
> > > > Calling UI....
> > > > ...UI is loaded....
> > > > Interchange V4.6.5
> > > > Configuring catalog construct...construct config error: Couldn't open
> > > > '/catalogs
> > > > /construct/products/variable.txt' read/write: Permission denied
> > >
> > > Check that the user (interch ?) has read and write access to
> > > 'variable.txt'.  You might want to check all of the files for the
> > > correct permissions while you are at it....
> > >
> > > > construct: error in configuration. Skipping.
> > > > construct: config error. Skipping.
> > > > Interchange server started in INET and UNIX mode(s) (process id 698)
> > > >
> > > > Can anyone help me figure out what I'm doing wrong?
> > > >
> > > > Thanks!
> > > >
> > > > SW
> > > >
> > > > _______________________________________________
> > > > Interchange-users mailing list
> > > > Interchange-users@lists.akopia.com
> > > > http://lists.akopia.com/mailman/listinfo/interchange-users
> > > >
> > >
> > > Hope this helps.
> > > Matt
> > >
> > >
> >
> >
> 
>