[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::sql_services

Title:SQL/Services Forum
Notice:kits(3) ft info(7) QAR access (8) SPR access (10)
Moderator:SQLSRV::MAVRIS
Created:Thu Oct 13 1988
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:2214
Total number of notes:8586

2195.0. "UAF-E-PWDSYNTAX 7.0 install" by M5::BLITTIN () Thu Apr 24 1997 15:32

    
    During install of 7.0, customer is getting 'invalid password syntax'
    error (uaf-f-pwdsyntax) when trying to create the SQLSRV$DEFLT 
    account.
    
    Installing Alpha MV from system account.  Currently has 6.0 & 6.1
    installed.  The system account has /flags=dispwdhis & dispwddic.
    
    The uic's they chose did not exist. The SQLSRV$DEFLT account did
    not previously exist.
    
    Any ideas?
T.RTitleUserPersonal
Name
DateLines
2195.1sqlsrv_install.com info?M5::BLITTINThu Apr 24 1997 16:2821
    
    
    
    
    
    I pulled the following out of the SQLSRV_INSTALL.COM procedure in
    an attempt to figure out what might be going on...
    
    Is the error complaining about the SQLSRV$SERVER_PASSWORD value
    that is returned and subsequently used to create the account?
    
    
    $   vmi$callback GET_PASSWORD SQLSRV$SERVER_PASSWORD AUTO
    $ _o
    $   if ( ("''SQLSRV$SERVER_PASSWORD'" .eqs. "") .or. -
             (f$locate("%SET-","''SQLSRV$SERVER_PASSWORD'") .lt. -
              f$length("''SQLSRV$SERVER_PASSWORD'")) )
    $   then...
    
    
    $       vmi$callback CREATE_ACCOUNT 'SQLSRV$ACC' "''QUALS'"
2195.2ORAREP::HERON::GODFRINDOracle Rdb EngineeringFri Apr 25 1997 07:4316
Well the explanation for that error is:

 PWDSYNTAX,  invalid password syntax

  Facility:     UAF, Authorize Utility

  Explanation:  A password was entered using incorrect syntax.

  User Action:  Enter a password using 1 to 31 alphanumeric characters, the
                dollar sign ($),  or the underscore (_) characters.

Looks like the customer just specified a password for that account (in answer
to the prompt during installation) that included some illegal characters (maybe
a "-" instead of a "_")

/albert
2195.3Not prompted...M5::BLITTINFri Apr 25 1997 14:362
    
    They weren't prompted for a password....
2195.4Circumvented...M5::BLITTINFri Apr 25 1997 18:393
    
    Circumvented problem by manually creating the SQLSRV$DEFLT & RMU$SRV
    accounts.  Were able to get IVP's to run eventually.