|
INTERVIEW QUESTIONS
DATABASE
FIREBIRD
DETAILS
Question: What is the best way to determine whether Firebird server is running?
Answer: If you want to do it from an application, a simple try to connect should suffice. Otherwise you have various options:
a) check if firebird server is in the list of running programs (use task manager on Windows, or 'ps ax' command on Linux). Please note that Classic won't be running until there is a connection established.
b) check whether the port 3050 is open on the machine. First, you can check with netstat command, and if it is open, you can test whether it accepts connections by telnet-ing to the port. Just type:
telnet [hostname|IPaddress] 3050
Example: telnet localhost 3050
If you use Linux, you can also check the open port with 'lsof' command. It outputs a lot, so you might want to 'grep' for 3050 or gds_db strings:
# lsof | grep gds_db # lsof | grep 3050
c) if all of this fails, perhaps you should check whether the remote server is reachable at all. You can use 'ping' command:
ping [hostname|IPaddress]
Example: ping 192.168.0.22
Please note that ping can still give you 'host unreachable' message even if host is up. This is because the firewall software can drop the ICMP (ping) packets (it's done to prevent some viruses from spreading, or network scans).
|
|
|
Category |
Firebird Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 8074 users |
Added on |
7/23/2015 |
Views |
68489 |
Rate it! |
|
|
Question:
What is the best way to determine whether Firebird server is running?
Answer:
If you want to do it from an application, a simple try to connect should suffice. Otherwise you have various options:
a) check if firebird server is in the list of running programs (use task manager on Windows, or 'ps ax' command on Linux). Please note that Classic won't be running until there is a connection established.
b) check whether the port 3050 is open on the machine. First, you can check with netstat command, and if it is open, you can test whether it accepts connections by telnet-ing to the port. Just type:
telnet [hostname|IPaddress] 3050
Example: telnet localhost 3050
If you use Linux, you can also check the open port with 'lsof' command. It outputs a lot, so you might want to 'grep' for 3050 or gds_db strings:
# lsof | grep gds_db # lsof | grep 3050
c) if all of this fails, perhaps you should check whether the remote server is reachable at all. You can use 'ping' command:
ping [hostname|IPaddress]
Example: ping 192.168.0.22
Please note that ping can still give you 'host unreachable' message even if host is up. This is because the firewall software can drop the ICMP (ping) packets (it's done to prevent some viruses from spreading, or network scans). Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Why does reading require write privileges on database file?
|
View Answer
|
|
Is there an example how to configure ExternalFileAccess setting in firebird.conf?
|
View Answer
|
|
Is there a way to detect whether fbclient.dll or fbembed.dll is loaded?
|
View Answer
|
|
Is there a way to automate SQL execution from the command-line, batch job or shell script?
|
View Answer
|
|
Is it possible to determine clients IP address?
|
View Answer
|
|
How to write UDF s in Delphi?
|
View Answer
|
|
How to use events with ZeBeDee, SSH or stunnel?
|
View Answer
|
|
How to tell Firebird to only accept conections from XYZ host or network?
|
View Answer
|
|
How to stop SuperServer service on Linux using only Firebird tools?
|
View Answer
|
|
How to specify transaction or query timeout?
|
View Answer
|
|
How to select a random record from a table?
|
View Answer
|
|
How to repair a corrupt Firebird database?
|
View Answer
|
|
How to reorder the table columns (fields)?
|
View Answer
|
|
How to recreate the index on a Firebird table?
|
View Answer
|
|
How to pump the data from one database to another?
|
View Answer
|
|
How to prevent firebird.log file from filling up the disk partition?
|
View Answer
|
|
How to disconnect the user connection?
|
View Answer
|
|
How to do replication of Firebird databases?
|
View Answer
|
|
How to drop all foreign keys in database?
|
View Answer
|
|
How to export data from database and import into another?
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Firebird Interview Questions & Answers - Exam Mode /
Learning Mode
|