| Subject | Re: Only sysdba can connect others can't ( gstat Attributes = shutdown) |
|---|---|
| Author | Adam |
| Post date | 2006-03-15T03:48:55Z |
--- In firebird-support@yahoogroups.com, "Mohammad Jeffry"
<linuxlah@...> wrote:
Shutdown mode prevents everyone other than SYSDBA and the owner from
connecting.
This allows you to safely run metadata scripts etc and be sure no-one
else is connected while this happens.
gfix -shut f 300 aliasname
will terminate all connections after 5 minutes.
To allow logins again, you need to use
gfix -online
Adam
<linuxlah@...> wrote:
>which is
> Today my fdb got wierd. All other user can't connect execpt me
> using the "SYSDBA". The firebird service is definately up andrunning.
>State
> netstat -nl
> Proto Recv-Q Send-Q Local Address Foreign Address
> .LISTEN
> .
> tcp 0 0 0.0.0.0:3050 0.0.0.0:*
>This is because someone has put the database into shutdown mode.
> but my gstat for the db is giving me
> .
> .
> Attributes database shutdown
>
> How to troubleshoot this?
Shutdown mode prevents everyone other than SYSDBA and the owner from
connecting.
This allows you to safely run metadata scripts etc and be sure no-one
else is connected while this happens.
gfix -shut f 300 aliasname
will terminate all connections after 5 minutes.
To allow logins again, you need to use
gfix -online
Adam