PART ONE SOLVED: RE: [ic] SQL database on another server, Still having wizard problems

[Daniel P. Zepeda]

So, I've figured out what the problem was, here is a simple fix, there 
are three files involved:

1. additional_fields
2. additional_help
3. precopy_commands



Here are the diffs. Let me know if there is a preferred way to post
fixes like this, or if there is a preferred place to post these fixes.

Actually, this only fixes part of the problem. As it stands now
the user that is specified as the SQLUSER and the password specified
as SQLPASS are also used in the mysqladmin command. It seems to me
that this is not optimal, because the user may wish to specify a 
username/password combination for the creation phase, and another 
username/password combination for the regular user of the database.
I'm not sure which is better, I don't have time tonight to delve
any further, and I wanted these fixes posted, so I'll leave it at this.

I still have the wizard problem I mentioned in the original post, I'm 
willing to dig around like I did for this problem, but I really don't
know where to start. This was a pretty simple problem, it looks like
the other may not be so simple. Any help/pointers would be appreciated.

--- additional_fields   Tue Nov 20 18:41:30 2001
+++ additional_fields.orig      Tue Nov 20 18:46:52 2001
@@ -40,7 +40,7 @@

 {MYSQLCREATE}MYSQLCREATEOPT
 Extra options for creation
-
+       -p      -u root -p

 {SOMESQL and ! '__MVC_MYSQL__'}PGSQL
 Set to 1 if you want to use PostgreSQL                                                            


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


--- additional_help     Tue Nov 20 18:45:15 2001
+++ additional_help.orig        Tue Nov 20 18:46:52 2001
@@ -42,11 +42,10 @@

 MYSQLCREATEOPT
 .
-As it stands now, the username and password you supplied above
-will need to be able to create a database. If you need to specify
-extra parameters, for instance to point the mysqladmin program to
-another host or port, then supply them here. To specify another
-host and port put "-h HOSTNAME --port PORTNUMBER".
+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".

 PGSQL
 .                                                                                                 

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


--- precopy_commands    Tue Nov 20 18:39:48 2001
+++ precopy_commands.orig       Tue Nov 20 18:46:52 2001
@@ -1,4 +1,4 @@
-{MYSQL}mysqladmin -u __MVC_SQLUSER__ -p__MVC_SQLPASS__ __MVC_MYSQLCREATEOPT__ create __MVC_SQLDB__+{MYSQL}mysqladmin -u __MVC_SQLUSER__ -p__MVC_SQLPASS__ create __MVC_SQLDB__
 Since you selected the MySQL option, you need to create a database named
 "__MVC_SQLDB__". In a default MySQL configuration, any user may create
 and drop and modify test_* databases, but some administrators disable this.                       



*********************************************************************
-- 
"InterSAT Technical Support" <support@satx.net>