Issue Details (XML | Word | Printable)

Key: CORE-2536
Type: New Feature New Feature
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Jim Michaels
Votes: 1
Watchers: 2
Operations

If you were logged in you would be able to see more operations.
Firebird Core

have installer ask for and set SYSDBA password & port

Created: 03/Jul/09 08:58 AM   Updated: 03/Jul/09 08:28 PM
Component/s: Installation
Affects Version/s: 2.1.3
Fix Version/s: None

Environment:
windows XP Pro SP3, 3GB ram, Pentium 4 HT, Dell 4600.
C:\prj\CREATE~1>\u\df c f h -a
*C:----------------------------------------********54.43GB/315.58GB (17.25%)
 F:-------------------------------------------*****31.09GB/250.06GB (12.44%)
 H:---------***************************************130.41GB/160.00GB (81.51%)
TOT----------------------------------**************215.94GB/725.63GB (29.76%)


 Description  « Hide
the installer should ask for and set the SYSDBA password. all good databases do this.
please don't leave the sysadmin to hunt for more instructions on how to properly install the database.
make it easier when you can.

Show the default database port in the port number textbox during installation when asking the user which port to install the server on. (when I installed mine, I had absolutely no clue as to what port the server was going to serve on by default, so I didn't know if the default would conflict with any other ports I currently had, and this was a source of consternation)

http://www.autoitscript.com/autoit3/
Auto-it3 is a scripting language like VB except that it basically works with one dialog. it has ShellExecute and ShellExecuteWait functions. If your gsec program gets fixed properly, it is possible to use a very simple 20-to-30-line program to call gsec to change the SYSDBA password.

I suggest having a "cancel" button, a "change password" button, a static text that says "userid: SYSDBA", and a static text that says "password" next to the password.
Leave some obvious space between the two static texts, but keep the two password items close together.

I might be able to write the code for you if you get gsec working and the command-line parameters for modifying users don't change (currently the command does not work).

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Paul Reeves added a comment - 03/Jul/09 11:19 AM
The installer is intended to be as simple as possible. Lack of choice is a deliberate design decision.

The primary use case scenario for the windows installer is for deployments to developers, and there is no need to change the default password. Developers want and expect the standard password. And it is expected that development deployments are made within a secure environment. If that is not the case then the Firebird password is probably the least of problems to worry about.

Deployment for production use is outside of the scope of the installer. The intention under these circumstances is that the installer is deployed within an installer that will manage application or site specific installation details.


Adriano dos Santos Fernandes added a comment - 03/Jul/09 02:24 PM
Paul, I've to say that I *completelly disagree*.

Jim Michaels added a comment - 03/Jul/09 08:28 PM
there is no way to create users without any access to the SYSDBA password. and you can't do that without changing it since it is not in the documentation.