[firebird-support] reset sysdba password without loose existing users
Hi, Anybody can help me to reset SYSDBA without loose all existing users in Firebird Regards
Re: [firebird-support] reset sysdba password without loose existing users
23.03.2017 17:27, startx252...@yahoo.fr [firebird-support] wrote: > Anybody can help me to reset SYSDBA without loose all existing users in > Firebird Attach in embedded mode with SYSDBA name and you can change the password with ALTER USER command. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
RE: [firebird-support] reset sysdba password without loose existing users
Hi, Thanks for your reply, I don't understand what you meansorry As i said, i don't have sysdba passwordand i don't want to loose all existing users account Regards -Message d'origine- De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : jeudi 23 mars 2017 17:29 À : firebird-support@yahoogroups.com Objet : Re: [firebird-support] reset sysdba password without loose existing users 23.03.2017 17:27, startx252...@yahoo.fr [firebird-support] wrote: > Anybody can help me to reset SYSDBA without loose all existing users in Firebird Attach in embedded mode with SYSDBA name and you can change the password with ALTER USER command. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
RE: [firebird-support] reset sysdba password without loose existing users
Hi, What the person meant was that if a database is opened using a firebird server process, that process looks for a valid password for the sysdba user. This is the situation you are in now. But, If you take that Database and open it in embedded mode, meaning that it isn’t using the server process. The Embedded mode only looks for the user to exist. It doesn’t care about the password. Once you connect, you can then issue the appropriate command to change the password. Thanks, Ed Mendez From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, March 23, 2017 1:05 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] reset sysdba password without loose existing users Hi, Thanks for your reply, I don't understand what you meansorry As i said, i don't have sysdba passwordand i don't want to loose all existing users account Regards -Message d'origine- De : firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> [mailto:firebird-support@yahoogroups.com] Envoyé : jeudi 23 mars 2017 17:29 À : firebird-support@yahoogroups.com <mailto:firebird-support@yahoogroups.com> Objet : Re: [firebird-support] reset sysdba password without loose existing users 23.03.2017 17:27, startx252...@yahoo.fr <mailto:startx252...@yahoo.fr> [firebird-support] wrote: > Anybody can help me to reset SYSDBA without loose all existing users in Firebird Attach in embedded mode with SYSDBA name and you can change the password with ALTER USER command. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
RE: [firebird-support] reset sysdba password without loose existing users
Hi thanks Ed, embedded mode ? so must i connect to security2.fdb file with gsec command option ? De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : vendredi 24 mars 2017 03:59 À : firebird-support@yahoogroups.com Objet : RE: [firebird-support] reset sysdba password without loose existing users Hi, What the person meant was that if a database is opened using a firebird server process, that process looks for a valid password for the sysdba user. This is the situation you are in now. But, If you take that Database and open it in embedded mode, meaning that it isn’t using the server process. The Embedded mode only looks for the user to exist. It doesn’t care about the password. Once you connect, you can then issue the appropriate command to change the password. Thanks, Ed Mendez From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, March 23, 2017 1:05 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] reset sysdba password without loose existing users Hi, Thanks for your reply, I don't understand what you meansorry As i said, i don't have sysdba passwordand i don't want to loose all existing users account Regards -Message d'origine- De : firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Envoyé : jeudi 23 mars 2017 17:29 À : firebird-support@yahoogroups.com Objet : Re: [firebird-support] reset sysdba password without loose existing users 23.03.2017 17:27, startx252...@yahoo.fr [firebird-support] wrote: > Anybody can help me to reset SYSDBA without loose all existing users in Firebird Attach in embedded mode with SYSDBA name and you can change the password with ALTER USER command. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links [Non-text portions of this message have been removed]
RE: [firebird-support] reset sysdba password without loose existing users
What you'll need to do is to download the firebird embedded edition and unzip it into a folder. If you are going to try to change the password from the command prompt you'll need to copy the isql.exe file from your original installation into the folder where you unzipped the embedded version. If you are going to use a tool like flamerobin copy the fbemded.dll to its folder. I'm not sure but you may need to rename it to fbclient.dll for flamerobin to use it. If you are using a tool like IBExpert or DBWorkbench then were it ask for the client dll point it to the firebird embeded client. You'll then be able to connect to the security database and issue the commands to change the password. ---In firebird-support@yahoogroups.com, wrote : Hi, What the person meant was that if a database is opened using a firebird server process, that process looks for a valid password for the sysdba user. This is the situation you are in now. But, If you take that Database and open it in embedded mode, meaning that it isn’t using the server process. The Embedded mode only looks for the user to exist. It doesn’t care about the password. Once you connect, you can then issue the appropriate command to change the password. Thanks, Ed Mendez From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, March 23, 2017 1:05 PM To: firebird-support@yahoogroups.com Subject: RE: [firebird-support] reset sysdba password without loose existing users Hi, Thanks for your reply, I don't understand what you meansorry As i said, i don't have sysdba passwordand i don't want to loose all existing users account Regards -Message d'origine- De : firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com] Envoyé : jeudi 23 mars 2017 17:29 À : firebird-support@yahoogroups.com mailto:firebird-support@yahoogroups.com Objet : Re: [firebird-support] reset sysdba password without loose existing users 23.03.2017 17:27, startx252000@... mailto:startx252000@... [firebird-support] wrote: > Anybody can help me to reset SYSDBA without loose all existing users in Firebird Attach in embedded mode with SYSDBA name and you can change the password with ALTER USER command. -- WBR, SD. ++ Visit http://www.firebirdsql.org http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links
RE: [firebird-support] reset sysdba password without loose existing users
Ok, so must i need to download an ambeded firebird server ? - I just read the documentation and it's seems a little bit complexe to install
RE: [firebird-support] reset sysdba password without loose existing users
OK that's sound me more clear. just another question : can i modify de sysdba password in this case with gsec ?
RE: [firebird-support] reset sysdba password without loose existing users
Hi all, I need more help to archive this task. I just copied the file flembed.dll and others in my directory(bin) now i can connect to my database, with gsec or isql but when i try to change de sysdba password in commande line, i got this message : SQL> alter user sysdba password 'mypassword' Statement failed, SQLSTATE = 0A000 feature is not supported Maybe i missed somthing, thanks for your help
Re: [firebird-support] reset sysdba password without loose existing users
> Hi all, > > I need more help to archive this task. > > > I just copied the file flembed.dll and others in my directory(bin) > now i can connect to my database, with gsec or isql > > > but when i try to change de sysdba password in commande line, i got this > message : > > > SQL> alter user sysdba password 'mypassword' > Statement failed, SQLSTATE = 0A000 > feature is not supported > > > Maybe i missed somthing, thanks for your help Are you sure that you are connecting via the embedded DLL and not a regular Firebird server process? I have seen several environments where there have been Firebird Windows Services running in parallel and a faulty connect string pretty much resulted in using the wrong Firebird server. So, for your case, make sure that no other Firebird server is running, e.g. explicitly stopping them in the Windows services panel, in case you are on Windows. -- With regards, Thomas Steinmaurer http://www.upscene.com Professional Tools and Services for Firebird FB TraceManager, IB LogManager, Database Health Check, Tuning etc.