[ic] newbie mysql snag

Kirill Sapelkin interchange-users@interchange.redhat.com
Fri Nov 30 15:24:00 2001


Hello !

Installing Interchange 4.8.3 on Linux Slackware, tripped up when
trying to use mysql.  It installs fine using if no SQL is selected.
bin/makecat dialog that has to do with creation of mysql database
test_foundation is below marked DIALOG makecat.

bin/makecat creates the test_foundation database but does not create
tables and does not populate them.  Running bin/restart yields error
messages included below marked DIALOG restart.

I'll bet I didn't set permissions right somewhere.  I tried installing 
as root and as interchange.

Grateful for any help.

Kirill

DIALOG makecat:

Since you selected the MySQL option, you need to create a database named
"test_foundation". In a default MySQL configuration, any user may create
and drop and modify test_* databases, but some administrators disable this.

done.
done.
Copying share/ files to /var/www/htdocs.....................
Error installing share/ files: Copy of ./interchange/sv_SE/A1.gif to /var/www/htdocs/interchange/sv_SE/A1.gif failed: Permission denied

Moving HTML files to /var/www/htdocs/foundation.............done.
Moving image files to /var/www/htdocs/foundation/images.....done.

Found additional system commands to run.

We need to make some directories to store sessions, logs, and such.

You can install some sample data to start with in this catalog.
This script will install the sample (tools) you selected.


Deleting old configuration foundation.

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://kirill/foundation

In any case, you should get direct access at:

	http://kirill/cgi-bin/foundation

That is, after you START or RESTART the Interchange server.  8-)
It is best done with:

	/usr/local/interchange/bin/interchange -r

For session expiration, you might want to place a line like this in your
crontab:

44 4 * * * /usr/local/interchange/bin/expireall -r

It will prevent the session databases from getting too large.

***********************************

DIALOG restart:

Killing Interchange server 9425 with TERM.
Low traffic settings.
Calling UI......UI is loaded...
Interchange V4.8.3
Configuring catalog foundation...Using MySQL, DSN=dbi:mysql:test_foundation...table 'country' failed: DBD::mysql::st execute failed: Table 'test_foundation.country' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'gift_certs' failed: DBD::mysql::st execute failed: Table 'test_foundation.gift_certs' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'userdb' failed: DBD::mysql::st execute failed: Table 'test_foundation.userdb' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'options' failed: DBD::mysql::st execute failed: Table 'test_foundation.options' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'affiliate' failed: DBD::mysql::st execute failed: Table 'test_foundation.affiliate' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'cat' failed: DBD::mysql::st execute failed: Table 'test_foundation.cat' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'pricing' failed: DBD::mysql::st execute failed: Table 'test_foundation.pricing' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'state' failed: DBD::mysql::st execute failed: Table 'test_foundation.state' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'area' failed: DBD::mysql::st execute failed: Table 'test_foundation.area' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'merchandising' failed: DBD::mysql::st execute failed: Table 'test_foundation.merchandising' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'orderline' failed: DBD::mysql::st execute failed: Table 'test_foundation.orderline' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'inventory' failed: DBD::mysql::st execute failed: Table 'test_foundation.inventory' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'order_returns' failed: DBD::mysql::st execute failed: Table 'test_foundation.order_returns' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'transactions' failed: DBD::mysql::st execute failed: Table 'test_foundation.transactions' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

table 'products' failed: DBD::mysql::st execute failed: Table 'test_foundation.products' doesn't exist at /usr/local/interchange/lib/Vend/Table/DBI.pm line 1370.

foundation config error: products not a database, cannot use as products file


foundation: error in configuration. Skipping.
foundation: config error. Skipping.
Interchange server started in INET and UNIX mode(s) (process id 9430)





Kirill Sapelkin
znanie@best.com