[Everydevel-bugs] [ everydevel-Feature Requests-504040 ] Installer requires mysql root pw - plz disable w/ option

[<no...@so...>]

Feature Requests item #504040, was opened at 2002-01-15 12:07
You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=426096&aid=504040&group_id=39838

>Category: None
Group: None
>Status: Open
Priority: 5
Submitted By: Martin Espinoza (hyperdrink)
Assigned to: Nobody/Anonymous (nobody)
>Summary: Installer requires mysql root pw - plz disable w/ option

Initial Comment:
This seems like a simple description, but it wants 
the mysql root password even when you are not 
creating the database or the user. This complicates 
the install considerably when you are using hosting.

Provided you have created a suitable database and 
user, there is no reason why the installer should 
require the root password at all, though it uses it 
repeatedly even if you specify --nocreatedb and --
nocreateuser.

~/web/everything> bin/install_esite --nocreatedb --
nocreateuser -h=localhost -u=hyperlogos -p='password' 
hyperlogos
found Everything install at .
Ok to use /web/drink/web/everything for Everything 
directory? (N/y)y
Please enter the root password for mysql 
DBI->connect(mysql:localhost) failed: Access denied 
for user: 'root@localhost' (Using password: NO) at 
bin/install_esite line 378
Can't call method "disconnect" on an undefined value 
at bin/install_esite line 389, <STDIN> line 2.
drink@denied:~/web/everything > mysql -u hyperlogos
ERROR 1045: Access denied for 
user: 'hyperlogos@localhost' (Using password: NO)

If you comment out that seemingly unnecessary access 
to the database (which is just a connect and 
disconnect to make sure you have root access) then it 
fails later in some call made to part of the 
Everything perl module. I didn't dig that far.

----------------------------------------------------------------------

>Comment By: Nate Oostendorp (n_oostendorp)
Date: 2002-01-16 11:17

Message:
Logged In: YES 
user_id=297846

I changed this over to a Feat. Req, and altered the subject.

If we have to set this up on a managed system, it's a
necessity.  We could sacrifice table checking.

----------------------------------------------------------------------

Comment By: Martin Espinoza (hyperdrink)
Date: 2002-01-15 21:01

Message:
Logged In: YES 
user_id=374581

Hmm, I guess this is really a feature request for an 
option to skip the checks, then :) Should I (gently) 
submit a feature request, or can I consider my (Selfish) 
desires communicated?

----------------------------------------------------------------------

Comment By: Nate Oostendorp (n_oostendorp)
Date: 2002-01-15 12:51

Message:
Logged In: YES 
user_id=297846

the reason why it needs the root password for the database
is the installNodeball function:

when a nodeball installs it runs some checks to make sure
that the tables it's installing are identical to the
existing tables in the database -> to do this it creates a
temporary database, imports the tables, and connects to both
databases and compares the SHOW COLUMNS FROM *** results.

Without this test database, comparing tables becomes very
hard (you have to do sql munging, etc).

You could probably short-circuit the table checking by
adding "return 1;" to the first line of checkTables and
checkNamedTables in Everything::Nodeball.pm

My only other suggestion would be to not use install_esite,
but instead install the database on a system where you have
root access, dump the database, and import it on your new
system.

Sorry -- I wish there was an easy way to get around the root
 user problem...

----------------------------------------------------------------------

You can respond by visiting: 
http://sourceforge.net/tracker/?func=detail&atid=426096&aid=504040&group_id=39838