[ic] Install help please

Jerry O'Brien obrienj@cuttingedge.net
Mon, 20 Nov 2000 08:51:18 -0600


I think you may be half correct. I think it was that I didn't have DBI, but
the only error I got was "premature end of script headers", and no error at
all from Interchange, so maybe this all-too-common error in installation
could be prevented with a test in makecat just after the clueless newbie
asks for SQL and doesn't have his/her DB driver module installed. I'm
installing DBI now - fingers crossed.

Thanks for your patience and help.

Jerry O'Brien

----- Original Message -----
From: "Marcel Montes" <marcel@multimake.com>
To: <interchange-users@minivend.com>
Sent: Monday, November 20, 2000 7:34 AM
Subject: Re: [ic] Install help please


> For the 23452463563573rd time....
>
> This is or a MySQL or a DBI error.
> Look at the httpd/error.log and look if it says that DBI couldn't connect.
> It it says so (the message should be that couldn't connect to mysql socket
> through /var/lib/mysql/mysql.socket).
> If THAT's the case... look the archive. I've already posted the solution
> twice.
>
>
> Jerry O'Brien wrote:
>
> > I've really tried to do my homework and not bother everyone with stupid
> > questions, but I'm still not getting 4.6 installed right. I get through
> > creating the catalog with no errors, I can get the front page with the
> > customer and admin links, but after that I get lots of server errors. I
> > can't get to the customer link at all, and only the content, page
editor,
> > reporting, and administration links work out of the admin section.
> >
> > The apache server error log shows:
> >
> > [Sat Nov 18 16:05:32 2000] [error] [client 208.35.151.7] Premature end
of
> > script headers: /home/www/cgi-bin/sampson
> >
> > the error.log in the interchange home directory shows no errors:
> >
> > - - - [18/November/2000:14:36:58 -0600] - - Low traffic settings.
> > - - - [18/November/2000:14:36:58 -0600] - - Calling UI....
> > - - - [18/November/2000:14:36:58 -0600] - - ...UI is loaded....
> > - - - [18/November/2000:14:36:58 -0600] - - Interchange V4.6.0
> > - - - [18/November/2000:14:36:58 -0600] - - Config 'sampson' at server
> > startup
> > - - - [18/November/2000:14:36:58 -0600] - - Using MySQL,
> > DSN=dbi:mysql:sampson.
> > - - - [18/November/2000:14:36:59 -0600] - - START server (23985) (INET
and
> > UNIX)
> > - - - [18/November/2000:14:37:00 -0600] - - Accepting connections from
> > localhost|1
> > 27\.0\.0\.1
> > - - - [18/November/2000:14:37:00 -0600] - - START server (23987) (INET
and
> > UNIX)
> >
> > and there is no error.log in the catalog directory
> >
> > There are no tables in the database "sampson", but makecat didn't
complain
> > as it was creating the MySQL db.
> >
> > any advice please?
> >
> > Jerry O'Brien
> > Network Administrator
> > Cutting Edge Systems
> >
> > checking return type of signal handlers... void
> > checking for select... yes
> > checking for socket... yes
> > checking for strerror... yes
> > updating cache ./config.cache
> > creating ./config.status
> > creating syscfg
> > creating config.h
> > Checking directories........................................
> > /home/www/sampsonsteinworks/sampson: directory exists!
> > The above directories already exist. Overwrite files? y
> > mkdir /home/interch/catalogs
> > mkdir /home/interch/catalogs/sampson
> > done.
> > Copying demo files..........................................found more
to
> > ask.
> >
> > Your company name: ...............................Sampson SteinWorks
> >
> > Interchange has a workable internal database, but many things will
> > work better (and a few worse) if you use a SQL database. Interchange
> > can configure MySQL, PostgreSQL, and Oracle in a test configuration.
> >
> > Set to 1 if you want to use MySQL, PostgreSQL, or Oracle: ..1
> >
> > You can select this to use MySQL in your test catalog. Careful!
> > This requires the ability to create a database named "test_construct",
> > and is highly dependent on your Perl and MySQL configuration. Don't
> > be too surprised if this doesn't work.
> >
> > Set to 1 if you want to use MySQL: ...............1
> > Database to use (will be created): ...............sampson
> > DBI DSN to use: ..................................dbi:mysql:sampson
> > Username for MySQL (if any): .....................sampson
> > Password for MySQL (if any): .....................pass
> >
> > We can try and use mysqladmin to create the database in
> > MySQL. In many default MySQL distributions, any user can create
> > a database beginning with "test".
> >
> > Use the next option to add parameters. If your MySQL is
password-protected
> > (and you know the password) you may want to add "-u root -p".
> >
> > Set to 1 to create 'sampson' with mysqladmin: ....1
> >
> > To create the database you may need to supply a password and
> > username. To do that, add the option "-u USERNAME -p", where
> > USERNAME is a MySQL user with permission to create databases.
> > This is often the user "root".
> >
> > Extra options for creation: ......................-u mysql -p
> >
> > You can use Interchange's companion configuration
> > interface, to do upload/download of files, manipulation of
> > the database, reconfiguration of the catalog, and much more.
> >
> > To enable the UI, you will need a "super-user" account
> > name that has full access.
> >
> > The initial password is "pass". CHANGE IT! You can do this
> > by going to the admin menu and selecting the superuser and
> > then "Change password".
> >
> > Account name that will control this catalog: .....interchange
> > Administrative password: .........................pass
> > Found system commands to run.
> >
> > Since you selected the MySQL option, you need to create
> > a database named "sampson". In a default MySQL
> > configuration, any user may create and drop and modify
> > test_* databases, but some administrators disable this.
> >
> > run "mysqladmin -u mysql -p create sampson"? y
> > Enter password:
> > done.
> > Moving link, /home/www/cgi-bin/sampson exists, overwrite? ..y
> > done.
> > Copying share/ files to /home/www/sampsonsteinworks.........done.
> > Moving HTML files to /home/www/sampsonsteinworks/sampson....done.
> > Moving image files to /home/www/sampsonsteinworks/sampson/images..done.
> >
> > Found additional system commands to run.
> >
> > To enable image upload feature, you need to make a symbolic
> > link of the image base directory into your catalog directory.
> >
> > nworks/sampson/images /home/interch/catalogs/sampson"? y
> > Add catalog to interchange.cfg? y
> >
> > Done with installation. If my reading of your input is correct, you
> > should be able to access the demo catalog with the following URL:
> >
> >         http://www.sampsonsteinworks.com/sampson
> >
> > In any case, you should get direct access at:
> >
> >         http://www.sampsonsteinworks.com/cgi-bin/sampson
> >
> > That is, after you START or RESTART the Interchange server.  8-)
> > It is best done with:
> >
> >         /home/interch/interchange/bin/interchange -r
> >
> > For session expiration, you might want to place a line like this in your
> > crontab:
> >
> > 44 4 * * * /home/interch/interchange/bin/expireall -r
> >
> > It will prevent the session databases from getting too large.
> >
> > [interch@maui interchange]$ /home/interch/interchange/bin/interchange -r
> > The Interchange server was not running
> > (/home/interch/interchange/etc/interchange.
> > pid).
> > Low traffic settings.
> > Calling UI....
> > ...UI is loaded....
> > Interchange V4.6.0
> > Configuring catalog sampson...Using MySQL, DSN=dbi:mysql:sampson.
> > done.
> > Interchange server started in INET and UNIX mode(s) (process id 23987)
> > [interch@maui interchange]$
> >
> > _______________________________________________
> > Interchange-users mailing list
> > Interchange-users@www.minivend.com
> > http://www.minivend.com/mailman/listinfo/interchange-users
>
> --
>  Marcel Montes [marcel(at)multimake(dot)com] - Programmer
>  "If our brain were so simple that we could understand it,
>  we would be so stupid that we couldn't do so"
> -------------------------- EOF ----------------------------
>
>
>