Re: [ic] Installing construct w/ mysql support

[Brian Teague <bteague@rice.edu>]

i just fought through the interchange/mysql install on an RH7.1 box. 
lemme walk you through it.

firstly, the above poster was right.  you need *all* the packages on the 
RH disc starting with "mysql"  including mysql-clients.  make sure that 
you get them.

secondly, the general perl DBI modules get installed by the interchange
installer, but you need the specific mysql database driver (DBD.)  get 
on http://search.cpan.org and search for 'mysql'...grab the package 
named "Msql-Mysql-modules-1.2216".  untar/gzip it, enter the directory 
and run
"perl Makefile.PL"
"make"
"make test"

if all the tests pass, run
"make install"

so.  that should get you set up on the perl end.  next, you need to get 
permissions set up.  i'm going to assume you installed the Interchange 
server under the username 'interch'...if it's different, substitute as 
appropriate in the following.  as root, you need to add the user 
'interch' to the personal group of the user who actually controls the 
catalog.  for example, on my machine, the catalogs are in the home 
directory of user 'brian', at the path /home/brian/catalogs/construct. 
so, to make sure that the interchange server can get there, (as root!) i 
typed
"usermod -G brian interch"

which adds the user 'interch' to group 'brian'.

finally, make sure you run the interchange server (eg, issue the '
/usr/local/interchange/bin/restart' command) as the interch user.  eg, 
as root,
"su interch"
"/usr/local/interchange/bin/restart"
"exit"


that should about do it.  the only other caveat i have is that i was 
unable to run the server it "UNIX" mode.  i had to select "INET" mode 
before the linker would connect to the server.

good luck!  if you have more problems, feel free to email me directly or 
post to the list.

regards,
Brian Teague


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.
> 
> Does this mean the test_construct database did not get created?
> 
> 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
> 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
> 
> 


-- 
Brian Teague
Baker '04
Rice University

Give up on misery
Turn your back on dissent
Leave their distrust behind
Wash your hands of regret


_______________________________________________
Interchange-users mailing list
Interchange-users@lists.akopia.com
http://lists.akopia.com/mailman/listinfo/interchange-users