[ic] Problem with makecat and MySQL DB :(
Joel
interchange-users@interchange.redhat.com
Thu Oct 25 04:47:01 2001
Hi !
I can't create a SQL based Catalog with makecat :( There is a Problem to
create the DB , here is the whole dialog with makecat :
--------------------------------------------
[root@ntweb products]# /usr/lib/interchange/bin/makecat
Select a short, mnemonic name for the catalog. This will be
used to set the defaults for naming the catalog, executable,
and directory, so you will have to type in this name frequently.
NOTE: This will be the name of 'vlink' or 'tlink', the link CGI
program. Depending on your CGI setup, it may also have the
extension .cgi added.
Only the characters [-a-zA-Z0-9_] are allowed, and it is strongly suggested
that the catalog name be all lower case.
If you are doing the demo for the first time, you might use "foundation".
Catalog name? sql6
makecat -- Interchange catalog installation program.
*** We will be making a catalog named 'sql6'. ***
Try using the UP arrow at some of the prompts -- you have the
Term::ReadLine module installed, and Interchange may find some
default values in your HTTP server configuration file. You can
cycle among them with the UP and DOWN arrows.
######### BEGINNING CATALOG CONFIGURATION #########
During many of the following operations, defaults are placed in
a buffer for you. You may use the up and down arrows to toggle
between the defaults.
If you made a mistake on a *previous* entry and realize that
in a later one, if you enter ONLY an @ sign and press return you
should be returned to the previous step.
# The server name, something like: www.company.com
# www.company.com:8000
# www.company.com/~yourname
#
Server name? ntweb.solution-service.de
# The type of demo catalog to use. The standard one distributed is:
#
# foundation
#
# If you have defined your own custom template catalog,
# you can enter its name.
#
# If you are new to Interchange, use "foundation" to start with.
DemoType? weinshop
# The type of permission structure for multiple user catalogs.
# Select M for each user in own group (with interchange user in group)
# G for all users in group of interchange user
# U for all catalogs owned by interchange user (must be catuser as
well)
#
# M is recommended, G works for most installations.
permtype? G
# The user name the Interchange server runs under on this machine. This
# should not be the same as the user that runs the HTTP server (i.e.
# NOT nobody).
#
InterchangeUser? interch
#
# The user name the catalog will be owned by.
#
CatUser? interch
# The group name the server-owned files should be set to. This is
# only important if Interchange catalogs will be owned by multiple users
# and the group to be used is not the default for the catalog user.
#
# Normally this is left blank unless G mode was selected above.
#
InterchangeGroup? interch
# The email address where orders for this catalog should go.
# To have a secure catalog, either this should be a local user name and
# not go over the Internet -- or use the PGP option.
#
MailOrderTo? interch@ntweb
# Where the Interchange files for this catalog will go, pages,
# products, config and all. This should not be in HTML document
# space! Usually a 'catalogs' directory below your home directory
# works well. Remember, you will want a test catalog and an online
# catalog.
#
CatRoot? /var/lib/interchange/sql6
# The location of the normal CGI directory. This is a
# file path, not a script alias.
#
# If all of your CGI programs must end in .cgi, this is
# should be the same as your HTML directory.
#
CgiDir? /var/www/cgi-bin
# The URL location of the CGI program, without the http://
# or server name.
#
# http://www.virtual.com/cgi-bin/prog
# ^^^^^^^^^^^^^
#
# http://www.virtual.com/program.cgi
# ^^^^^^^^^^^^
#
CgiUrl? /cgi-bin/sql6
#
# Additional URL locations for the CGI program, as with CgiUrl.
# This is used when calling the catalog from more than one place,
# perhaps because your secure server is not the same name as the
# non-secure one.
#
# http://www.secure.domain/secure-bin/prog
# ^^^^^^^^^^^^^^^^
#
# We set it to the name of the catalog by default to enable the
# internal HTTP server.
#
Aliases? /sql6
# The base directory for HTML for this (possibly virtual) domain.
# This is a directory path name, not a URL -- it is your HTML
# directory.
#
DocumentRoot? /var/www/html
# Where the sample HTML files (not Interchange pages) should be installed.
# There is a difference. Usually a subdirectory of your HTML directory.
#
SampleHtml? /var/www/html/sql6
# Where the image files should be copied. A directory path
# name, not a URL.
#
ImageDir? /var/www/html/sql6/images
# The URL base for the sample images. Sets the ImageDir
# directive in the catalog configuration file. This is a URL
# fragment, not a directory or file name.
#
# <IMG SRC="/foundation/images/icon.gif">
# ^^^^^^^^^^^^^^^^^^
#
ImageUrl? /sql6/images
Interchange can use either UNIX- or internet-domain sockets.
Most ISPs would prefer UNIX mode, and it is more secure.
If you already have a program there, or use a common program
and the FullURL directive, select NONE. You will then need
to copy the program by hand or otherwise ensure its presence.
(You can use the up/down arrows to toggle).
INET or UNIX mode? UNIX
Do you use CGIWRAP or SUEXEC? n
Checking directories........................................mkdir
/var/lib/interchange/sql6
mkdir /var/www/html/sql6
mkdir /var/www/html/sql6/images
done.
Copying demo files..........................................found more to ask.
Your company name: ...............................SQL6
You can choose to pre-populate your Foundation template with some
data which might be illustrative. You can always delete it later
and replace it with your own.
The types are:
tools Construct Something, includes products, users, orders
reports Marketing reports, downloadable softgoods, products, users
none No data. Same as leaving blank.
Sample data type?: ...............................tools
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, Oracle, or DB2: ..1
You can select this to use MySQL in your test catalog. Careful!
This requires the ability to create a database named "test_foundation",
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): ...............test_foundation
DBI DSN to use:
..................................dbi:mysql:test_foundation:localhost:3306
Username for MySQL (if any): .....................interch
Password for MySQL (if any): .....................interch
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 '' 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 interch -p interch
You can select this to use PostgreSQL in your test catalog.
This requires the ability to create a database named "test_foundation",
and is highly dependent on your Perl and system configuration. Don't
be too surprised if this doesn't work.
Set to 1 if you want to use PostgreSQL: ..........
You can select this to use Oracle in your test catalog. This requires
that you know your Oracle DSN and that you've already created a user and
tablespace for Interchange. You should also have the environment variables
ORACLE_BASE, ORACLE_HOME, and ORACLE_SID set. Don't be too surprised if
this doesn't work.
Set to 1 if you want to use Oracle: ..............
You can select this to use DB2 in your test catalog. Careful!
This requires the ability to create a database named "intchg",
and is highly dependent on your Perl and DB2 configuration. Don't
be too surprised if this doesn't work.
Set to 1 if you want to use DB2: .................
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: .....interch
Administrative password: .........................pass
Set to 1 to display demo helper features in your store: ..
Found system commands to run.
Since you selected the MySQL option, you need to create a database named
"". In a default MySQL configuration, any user may create
and drop and modify test_* databases, but some administrators disable this.
run "mysqladmin -u -p create"? y
mysqladmin: Too few arguments to create
Command returned error code 1: Datei oder Verzeichnis nicht gefunden
done.
Moving link program to /var/www/cgi-bin/sql6................done.
Copying share/ files to /var/www/html.......................done.
HTML dir copy error: Datei oder Verzeichnis nicht gefunden
Trying to continue.
Moving HTML files to /var/www/html/sql6.....................done.
Image dir copy error: Datei oder Verzeichnis nicht gefunden
Trying to continue.
Moving image files to /var/www/html/sql6/images.............done.
Found additional system commands to run.
We need to make some directories to store sessions, logs, and such.
run "sh
/var/tmp/interchange-4.8.2/var/lib/interchange/foundation/config/makedirs"? y
/var/tmp/interchange-4.8.2/var/lib/interchange/foundation/config/makedirs:
/var/tmp/interchange-4.8.2/var/lib/interchange/foundation/config/makedirs:
Datei oder Verzeichnis nicht gefunden
Command returned error code 127: Datei oder Verzeichnis nicht gefunden
You can install some sample data to start with in this catalog.
This script will install the sample (tools) you selected.
run "sh
/var/tmp/interchange-4.8.2/var/lib/interchange/foundation/config/installsample"?
n
skipping 'sh
/var/tmp/interchange-4.8.2/var/lib/interchange/foundation/config/installsample'
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://ntweb.solution-service.de/sql6
In any case, you should get direct access at:
http://ntweb.solution-service.de/cgi-bin/sql6
That is, after you START or RESTART the Interchange server. 8-)
It is best done with:
su -c "/usr/lib/interchange/bin/interchange -r" interch
For session expiration, you might want to place a line like this in your
crontab:
44 4 * * * /usr/lib/interchange/bin/expireall -r
It will prevent the session databases from getting too large.
[root@ntweb products]#
----------------------------------------------------------
What is the Problem ? Is there a misstake with
DBI DSN to
use:..................................dbi:mysql:test_foundation:localhost:3306
i do not understand why
Since you selected the MySQL option, you need to create a database named
"". In a default MySQL configuration, any user may create
and drop and modify test_* databases, but some administrators disable this.
run "mysqladmin -u -p create"? y
mysqladmin: Too few arguments to create
there are no arguments in the mysqladmin statement :(
MySQL is running on the standardport 3306 and i created the user interch
with all right .
Thanks for help's
Joel