On 12/9/2014 12:39, Alex Peshkoff wrote:
> On 12/08/14 22:45, Werner wrote:
>> Hi Alex,
>>
>> On 12/8/2014 17:30, Alex Peshkoff wrote:
>> ...
>>> What is current_user value in that attachment?
>> Not sure what you mean with 'current_user'.
> select current_user from rdb$database;
SYSDBA
>
>> I connect from within IBExpert (SYSDBA with the pw I set using gsec) and
>> see the following when doing a test:
>>
>> Attempting to connect to:
>> localhost/4050:C:\Program Files
>> (x86)\Firebird\Firebird_3_0\examples\empbuild\EMPLOYEE.FDB
>>
>> Connecting... Failed!
>> ------------------------------------
>> Unsuccessful execution caused by a system error that precludes
>> successful execution of subsequent statements.
>> Your user name and password are not defined. Ask your database
>> administrator to set up a Firebird login.
>>
>> Attempting to connect to services manager... Failed!
>> ------------------------------------
>>
>> Unsuccessful execution caused by a system error that precludes
>> successful execution of subsequent statements.
>> Your user name and password are not defined. Ask your database
>> administrator to set up a Firebird login.
>>
>> Just FYI, similar setup works for me with 2.5 (localhost/3050 and
>> employee db within the 2.5 folder.
>>
>> So, I guess I still haven't done something correction with FB 3.
>>
> Stop firebird server and use gsec exactly like Vlad suggested.
After stopping if I do the gsec -add I get an error:
An error occurred while attempting to add the user.
violation of PRIMARY or UNIQUE KEY constraint "INTEG_5" on table "PLG$SRP"
Problematic key value is ("PLG$USER_NAME" = 'SYSDBA')Which makes sense as I had done this yesterday after seeing Vlad's mail, but at the time FB 3 was running (with switches -a -m). If I do gsec -modify then it passes without error, but after starting with a shortcut which has this command: "C:\Program Files (x86)\Firebird\Firebird_3_0\firebird.exe" -a -m I still can only connect using 'local' in IBExpert, if I use localhost/4050. My current fiebird.conf has only this change: #RemoteServiceName = gds_db RemoteServicePort = 4050 Werner ------------------------------------------------------------------------------ Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server from Actuate! Instantly Supercharge Your Business Reports and Dashboards with Interactivity, Sharing, Native Excel Exports, App Integration & more Get technology previously reserved for billion-dollar corporations, FREE http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
