Re: [mv] Interchange bin/makecat and MySQL

[Boyd Lynn Gerber <gerberb@zenez.com>]

******    message to minivend-users from Boyd Lynn Gerber <gerberb@zenez.com>     ******

On Wed, 19 Jul 2000, Mike Heins wrote:
> I am not sure I know what you are talking about.

In the minivend directory I run bin/makecat
...
Set to 1 if you want to use MySQL or Postgres: ..1

You can select this to use MySQL in your test catalog. Careful!
This requires the ability to create a database named "test_barry",
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_barry
DBI DSN to use: ........................dbi:mysql:test_barry
Username for MySQL (if any): ...........mysql
Password for MySQL (if any): ...........password

**** note above username and password ******

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: ..gerberb

Found system commands to run.

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

run "mysqladmin create test_barry"? ....y
mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user: 'gerberb@localhost' (Using password: NO)'

Command returned error code 1: No such file or directory

**** Note the username above is gerberb not mysql and no password was
used.  There should be one more question on encrypts password.  ****
 
> Is the problem that you think the SQL username/password should
> be the same as the admin password? I would disagree. The new
> system encrypts the password for the admin user, and it would
> be a shame to leave it lying around in plain text to be seen.

NO.  The problem is in the **** .... **** notes above.  I think it should
use the username and password supplied instead it used the catalog owner.

> By time of release of 4.6.0, we will encrypt a password you choose
> at the time of catalog build.

I think this should be an option with a yes/no.  Some people use passwords
but do not encrypt them.

Thanks,

--
Boyd Gerber <gerberb@zenez.com> 
ZENEZ	3748 Valley Forge Road, Magna Utah  84044
Office 801-250-0795 FAX 801-250-7975


-
To unsubscribe from the list, DO NOT REPLY to this message.  Instead, send
email with 'UNSUBSCRIBE minivend-users' in the body to Majordomo@minivend.com.
Archive of past messages: http://www.minivend.com/minivend/minivend-list