Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


Welcome, Guest
Guest Settings
Help

Thread: InterBase XE - cannot access local_server gds_db / localhost not visible


This question is not answered. Helpful answers available: 2. Correct answers available: 1.


Permlink Replies: 2 - Last Post: Aug 24, 2017 6:57 AM Last Post By: Jaro Laapio Threads: [ Previous | Next ]
Jaro Laapio

Posts: 3
Registered: 9/21/17
InterBase XE - cannot access local_server gds_db / localhost not visible  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 21, 2017 6:25 AM
Hey,

We have Interbase XE installation, which has suddenly lost it's 'visibility' to local server gds_db. It seems that localhost isnt available for Interbase somehow.
We discovered this when our app couldnt access the DB.
"database file appears corrupt () wrong page type page 6 is of wrong type (expected 4, found 6) "
Soon after that we realized that also the other (of two) applications could not access to DB either...
So, we looked from upper level in IBConsole -> Local Server - gds_db cannot be accessed - an Error msg 'Cannot attach to password database" is what we get when trying.

What has gone wrong with our DB? What can we do with it?

is the admin.ib that is corrupted or??

Edited by: Jaro Laapio on Aug 21, 2017 6:32 AM
Jaro Laapio

Posts: 3
Registered: 9/21/17
Re: InterBase XE - cannot access local_server gds_db / localhost not visible  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 21, 2017 12:33 PM   in response to: Jaro Laapio in response to: Jaro Laapio
Jaro Laapio wrote:
Hey,

We have Interbase XE installation, which has suddenly lost it's 'visibility' to local server gds_db. It seems that localhost isnt available for Interbase somehow.
We discovered this when our app couldnt access the DB.
"database file appears corrupt () wrong page type page 6 is of wrong type (expected 4, found 6) "
Soon after that we realized that also the other (of two) applications could not access to DB either...
So, we looked from upper level in IBConsole -> Local Server - gds_db cannot be accessed - an Error msg 'Cannot attach to password database" is what we get when trying.

What has gone wrong with our DB? What can we do with it?

is the admin.ib that is corrupted or??

Edited by: Jaro Laapio on Aug 21, 2017 6:32 AM

We resolved this issue on our own - by restoring the admin.ib file from the backup, and replaced the corrupted one with that + starting the Services.

Jaro Laapio

Posts: 3
Registered: 9/21/17
Re: InterBase XE - cannot access local_server gds_db / localhost not visible  
Click to report abuse...   Click to reply to this thread Reply
  Posted: Aug 24, 2017 6:57 AM   in response to: Jaro Laapio in response to: Jaro Laapio
The issue reoccured! Similar error after running it for a day and half.
This security database / admin.ib reaches some kind of limit, and then it becomes inaccessible.

Any ideas how to clean / refresh this securityDB / admin.ib to get rid of this kind of behavior?

comments are very much appreciated.
Legend
Helpful Answer (5 pts)
Correct Answer (10 pts)

Server Response from: ETNAJIVE02