[ic] Install help please

Marcel Montes marcel@multimake.com
Mon, 20 Nov 2000 10:34:31 -0300


--------------263CE9F39D2497FED5260C3D
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

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 ----------------------------



--------------263CE9F39D2497FED5260C3D
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
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 ----------------------------
  --------------263CE9F39D2497FED5260C3D--