[ic] Installing construct w/ mysql support

Matthew Schick interchange-users@lists.akopia.com
Sat May 19 15:07:00 2001


Damn...  It made me install the new version when I upgraded cpan, but I
didn't think it would do that for a dbd driver.....

I am guessing that it went ahead and installed v5.6.1 and it looks like
it just had a brain fart (technical term) afterwards.  Try rerunning "
perl -MCPAN -e 'install Bundle::DBD::mysql' " and my guess is it will go
thru without a hitch.....

Matt

On 19 May 2001 14:53:21 -0400, Steve West wrote:
> 
> 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
> > > >
> > > >
> > >
> > >
> > 
> > 
> 
>