Firebird 3.0

[respektive]

Ahoj,

zkousim si hrat s 3.0, ale nejak se mi nedari.

Protoze na svem pocitaci uz mam nekolik instanci FB, instaloval jsem to ze zipu a pouzil install_super.bat

Predtim jsem nastavil firebird.conf na gds_3_0_db a 3059 (ten port je urcite volny pouzivam 3050, 3055 a 3056)
Doted mi tento postup vzdy zabral, ale u 3.0 nikoliv

Jeste mi slo pres gsec nastavit uzivatele, a do databases.conf jsem si podle vzoru zalozil novou databazi

db_3_0 = d:\data\db3_0.fdb
{
    RemoteAccess = true
    DefaultDbCachePages = 8192
}

Stale mi pise - kdyz se pokusim pristoupit k databazi, nebo k jeji obnove

IBE: Starting restore. Current time: 13:37:40
IBE: Connection not established.
     connection rejected by remote interface.
IBE: Restore completed. Current time: 13:37:40. Elapsed time: 00:00:00

Pritom kdyz se ukliknu v nastaveni a napisu spatne cislo portu, hlasi toto

IBE: Starting restore. Current time: 13:39:57
IBE: Unsuccessful execution caused by a system error that precludes
     successful execution of subsequent statements.
     Unable to complete network request to host "127.0.0.1".
     Failed to establish a connection.
     Nemohlo být vytvořeno žádné připojení, protože cílový počítač je aktivně odmítl. .
IBE: Restore completed. Current time: 13:39:58. Elapsed time: 00:00:01

Cili by to naznacovalo, ze tam preci jen neco jede

Ve firebird logu je vzdy jen ke spusteni chyba XNET
Mon Jan 26 13:27:45 2015
    XNET error: XNET server initialization failed. Probably another instance of server is already running.
    operating system directive CreateMutex failed
    Nelze vytvořit soubor, který již existuje.

Kdyz se pokusim o restore databaze pres prikazovou radku, tak mi pro naseho uzivatele vypise ze nema prava "no permission for CREATE access to DATABASE"
A to jsem nasemu uzivateli nastavil pres gsec admin = yes

Kdyz se pokusim o restore pres sysdba, tak to sice jede, ale protoze jako ochranu pouzivame roli sysdba, tak to na konci vyhuci, muzu ji samozrejme odstranit z db, ale docela rad bych vedel jak to nastavit pro std. usera aby to fungovalo jako driv

Diky moc, Tom

p.s. vim ze bych mel asi na devel firebirdu, ale nejdriv to zkousim cesky

[Jiří Činčura]

Rekl bych, ze nemas nakonfigurovany auth. To vetsinou dava “connection rejected by remote interface.”. Bud pouzit novy fbclient.dll (pokud je to nativni kod) nebo povolit Legacy_Auth (.NET, Java, ...).

--
Mgr. Jiří Činčura
Independent IT Specialist

[respektive]

Myslis klic AutServer v firebird.conf?

Zkusil jsem ho tedy nastavit na vse co tam bylo, pouzivam 32bit fbclient.dll v IBExpertu, zvlastni je ze kdyz to pustim pres GBAK primo tak to obnoveni (po odstraneni te role) provede
Bohuzel connect opet neprojde

Connecting... Failed!
------------------------------------
Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Error loading plugin Engine12.
Module C:\Firebird\Firebird_3_0_beta\plugins/Engine12 exists but can not be loaded.
 
Attempting to connect to services manager... Failed!
------------------------------------

Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements.
Error loading plugin Engine12.
Module C:\Firebird\Firebird_3_0_beta\plugins/Engine12 exists but can not be loaded.

V logu pak se objevi - INET/inet_error: connect errno = 10061

Ted jsem si zkusil to AutServer opet zakomentovat a chybova hlaska je uplne stejna
 
Disconnecting from database... Passed!

[Jiří Činčura]

Mrkni v RL na oblast security a pak na “Compatibility Issues”.