#127 -pfp doesn't work when analyzing multiple schemas

[John Currier]

If you specify -pfp (prompt for password) when analyzing more than one schema SchemaSpy prompts for the password, but doesn't read what was typed.

Initially reported by Kris Zarns: https://sourceforge.net/projects/schemaspy/forums/forum/462850/topic/3232728

[John Currier]

When analyzing multiple schemas SchemaSpy now prompts for a password one time. That password is passed to child processes through their environment to prevent it from being readily visible to other users on the machine.

Note this is not a secure solution, but it's more secure than exposing it on the command-line.

Resolved in revision 626.

[Kris Zarns]

example input.
java -jar /path/schemaSpy_5.0.0.jar -dp ~/path/mysql-connector-java-5.1.7-bin.jar -t mysql -o ~/schemas/test_child -host host -u user -font courier -schemas "test_child" -pfp
Analyzing schemas:
test_child test_parent
Analyzing test_child
Using database properties:
[/path/schemaSpy_5.0.0.jar]/net/sourceforge/schemaspy/dbTypes/mysql.properties
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:
Password:

As you type, the letters appear, but the cursor deletes them. each "Password: " line here occurs after entering a correct password. Regardless of the number of times the password is entered, the operation does not complete. It doesn't appear to matter how many schemas are int he schemas section, the problem can occur with just one schema.

When using the -db option instead of the -schemas option, -pfp only prompts for the password once. Also, the characters do not appear on the commandline.
example input for correct behavior:
java -jar /path/schemaSpy_5.0.0.jar -dp ~/path/mysql-connector-java-5.1.7-bin.jar -t mysql -o ~/schemas/test_child -host host -u user -font courier -db test_child -pfp

[John Currier]

Can you try the latest beta at http://schemaspy.sourceforge.net/schemaSpy.jar and let me know if that resolves it?

Thanks,
John