Re: [firebird-support] hostname:databasename
Hi Sean, Helen, Mark Finally got it to work. It is easy, once you see endpoints in Azure. Just had to add an endpoint for my virtual machine in Windows Azure Dashboard. Specify endpoint with public port 3050 and private port 3050. I suppose is some kind of proxy. With that, the virtual machine behaves like a normal remote host and you can use regular "connect scadcam.cloudapp.net:employees" Thanks for your interest. Hector Rios From: HECTOR RIOS To: "firebird-support@yahoogroups.com" Sent: Saturday, September 8, 2012 3:53 PM Subject: Re: [firebird-support] hostname:databasename Hi Sean, I´m just beginning with this cloud thing. It would seem to me like a hassle to do that if the Azure guys wanted to make it easy. I expected like a normal remote host, but maybe you are right about having to login/open connection to access cloud resources, even a database server. At first I tought I could get by with just hostname:databasename but "sintax" is not helping. Have to research if the Microsoft SQL Server guys dont have to login to know if it is a real "sintax" problem. Not sure how to do that about the proxy but sounds logical. Regards, Hector Rios From: "Leyne, Sean" To: "firebird-support@yahoogroups.com" Sent: Saturday, September 8, 2012 3:09 PM Subject: RE: [firebird-support] hostname:databasename Hector, > Sounds nice but still cannot connect with > scadcam.cloudapp.net/51160:employees > Is this / to indicate the port firebird uses or for the port to get access to > the > host? Is "scadcam.cloudapp.net:51160" how you connect to the remote cloud? Doesn't a client need to login/open a connection to "the cloud" before you can access cloud resources? How is port 51160 being mapped/assigned to your cloud Firebird instance? I suspect that you need to create a "redirector" which would be installed on the remote client systems. It would login/establish a connection to the cloud and then listen on port 3050 and "proxy" the TCP messages between the client and the cloud Firebird instance. Sean [Non-text portions of this message have been removed] [Non-text portions of this message have been removed]
RE: [firebird-support] hostname:databasename - Email found in subject
Hector, > The 51160 port is not the firebird port, it is a port used to connect to a > virtual > machine. If you had several virtual machines, you´d use a different port to > communicate to each one. > For example, I connect to the virtual machine -not the database- with > remote desktop using scadcam.cloudapp.net:51165, then you give the > windows account name and password. With that you have a virtual > Windows Server 2008. > Then I go to cmd shell and firebird folder and start isql Once inside isql, > can connect with connect employees or with connect > localhost:employees or with connect localhost/3050:employees (I´m > using the default firebird port). > > That´s why, I think, > > scadcam.cloudapp.net/51160:employees > > does not work in this case. You need to do some reading on the Azure Traffic Manager functionality, it should allow you to define a virtual Host name which is externally accessible.
Re: [firebird-support] hostname:databasename
At 09:14 AM 9/09/2012, HECTOR RIOS wrote: >Hi Helen, > >The 51160 port is not the firebird port, it is a port used to connect to a >virtual machine. If you had several virtual machines, you´d use a different >port to communicate to each one. >For example, I connect to the virtual machine -not the database- with remote >desktop using  scadcam.cloudapp.net:51165, then you give the windows >account name and password. With that you have a virtual Windows Server 2008. >Then I go to cmd shell and firebird folder and start   isql >Once inside isql, can connect with      >connect employees       or with      >connect localhost:employees      or with    >connect localhost/3050:employees  (I´m using the default firebird port). > >That´s why, I think, > >scadcam.cloudapp.net/51160:employees  > >does not work in this case. Yes. I think Sean has your answer. ./heLen
Re: [firebird-support] hostname:databasename
Hi Sean, I´m just beginning with this cloud thing. It would seem to me like a hassle to do that if the Azure guys wanted to make it easy. I expected like a normal remote host, but maybe you are right about having to login/open connection to access cloud resources, even a database server. At first I tought I could get by with just hostname:databasename but "sintax" is not helping. Have to research if the Microsoft SQL Server guys dont have to login to know if it is a real "sintax" problem. Not sure how to do that about the proxy but sounds logical. Regards, Hector Rios From: "Leyne, Sean" To: "firebird-support@yahoogroups.com" Sent: Saturday, September 8, 2012 3:09 PM Subject: RE: [firebird-support] hostname:databasename Hector, > Sounds nice but still cannot connect with > scadcam.cloudapp.net/51160:employees > Is this / to indicate the port firebird uses or for the port to get access to > the > host? Is "scadcam.cloudapp.net:51160" how you connect to the remote cloud? Doesn't a client need to login/open a connection to "the cloud" before you can access cloud resources? How is port 51160 being mapped/assigned to your cloud Firebird instance? I suspect that you need to create a "redirector" which would be installed on the remote client systems. It would login/establish a connection to the cloud and then listen on port 3050 and "proxy" the TCP messages between the client and the cloud Firebird instance. Sean [Non-text portions of this message have been removed]
Re: [firebird-support] hostname:databasename
Hi Helen, The 51160 port is not the firebird port, it is a port used to connect to a virtual machine. If you had several virtual machines, you´d use a different port to communicate to each one. For example, I connect to the virtual machine -not the database- with remote desktop using scadcam.cloudapp.net:51165, then you give the windows account name and password. With that you have a virtual Windows Server 2008. Then I go to cmd shell and firebird folder and start isql Once inside isql, can connect with connect employees or with connect localhost:employees or with connect localhost/3050:employees (I´m using the default firebird port). That´s why, I think, scadcam.cloudapp.net/51160:employees does not work in this case. Regards, Hector From: Helen Borrie To: firebird-support@yahoogroups.com Sent: Friday, September 7, 2012 2:55 PM Subject: Re: [firebird-support] hostname:databasename At 08:35 AM 8/09/2012, scadcam2004 wrote: >Hi, >Hope somebody can help me. >Is it possible to use other than ":" to separate hostname and database name? >My problem is this: >I just started a project using a Microsoft Azure virtual machine in the cloud >that will host a firebird database. >To access the virtual machine you need to give a url plus port number. Like >this: >scadcam.cloudapp.net:51160 This would be the hostname. >But when trying to access the database with >scadcam.cloudapp.net:51160:employees, firebird reads up to the first ":" >leaving out the port number needed to access the host. >Is there a workaround? scadcam.cloudapp.net/51160:employees is the correct TCP/IP syntax when using a non-standard port. This isn't a workaround, it's the external standard for TCP/IP connection. Also locate the parameter #RemoteServicePort = 3050 in firebird.conf on the server, delete the '#' marker and change the port number to 51160. I don't know whether your Microsoft Azure thing recognises external standards, though. If this doesn't work, your best bet would be to contact Microsoft support about it. If you are using events, you will also need to open a specific port for event traffic and set the RemoteAuxPort parameter in firebird.conf. ./hb >Regards, >Héctor Ríos Mendoza >mailto:scadcam%40gmail.com >614 4155821, 4160317 > > > > > >++ > >Visit http://www.firebirdsql.org/ and click the Resources item >on the main (top) menu. Try Knowledgebase and FAQ links ! > >Also search the knowledgebases at http://www.ibphoenix.com/ > >++ >Yahoo! Groups Links > > > [Non-text portions of this message have been removed]
RE: [firebird-support] hostname:databasename
Hector, > Sounds nice but still cannot connect with > scadcam.cloudapp.net/51160:employees > Is this / to indicate the port firebird uses or for the port to get access to > the > host? Is "scadcam.cloudapp.net:51160" how you connect to the remote cloud? Doesn't a client need to login/open a connection to "the cloud" before you can access cloud resources? How is port 51160 being mapped/assigned to your cloud Firebird instance? I suspect that you need to create a "redirector" which would be installed on the remote client systems. It would login/establish a connection to the cloud and then listen on port 3050 and "proxy" the TCP messages between the client and the cloud Firebird instance. Sean
Re: [firebird-support] hostname:databasename
Hi Mark, Sounds nice but still cannot connect with scadcam.cloudapp.net/51160:employees Is this / to indicate the port firebird uses or for the port to get access to the host? If I enter into isql inside the virtual machine, I try the following.. a. connect employees (works fine) b. connect localhost:employees (works fine) c. connect localhost/3050:employees (works fine) d. connect localhost/3060:employees (fails with sqlstate=08006) I have turned off the firewall in both sides but still refuses the connection with sqlstate=08004 Because of point c above, I think / is only to indicate the port firebird uses but not to specify the port to get access to virtual machine. Is there something like a cascading of ports? From within the Windows Azure, scadcam.cloudapp.net gets you to your "environment" (still not familiar), but you still need to give the port to take you to one of possibly several virtual machines and then specify the firebird port (really not needed because is using the default firebird port). Does it sound rational? Regards, Hector Rios From: Mark Rotteveel To: firebird-support@yahoogroups.com Sent: Saturday, September 8, 2012 3:23 AM Subject: Re: [firebird-support] hostname:databasename On 7-9-2012 22:35, scadcam2004 wrote: > Hi, > Hope somebody can help me. > Is it possible to use other than ":" to separate hostname and database name? > My problem is this: > I just started a project using a Microsoft Azure virtual machine in the cloud > that will host a firebird database. > To access the virtual machine you need to give a url plus port number. Like > this: > scadcam.cloudapp.net:51160 This would be the hostname. > But when trying to access the database with > scadcam.cloudapp.net:51160:employees, firebird reads up to the first ":" > leaving out the port number needed to access the host. > Is there a workaround? > Regards, > Héctor Ríos Mendoza > mailto:scadcam%40gmail.com > 614 4155821, 4160317 For the Firebird library itself you simply need to use scadcam.cloudapp.net/51160:employees The fact that Microsoft specifies scadcam.cloudapp.net:51160 is that almost all applications use ':' as the separator between hostname and port. Firebird doesn't, it uses '/' as the separator. At the TCP/IP level where the actual connection is created that distinction doesn't even exist. Mark -- Mark Rotteveel [Non-text portions of this message have been removed]
Re: [firebird-support] hostname:databasename
On 7-9-2012 22:35, scadcam2004 wrote: > Hi, > Hope somebody can help me. > Is it possible to use other than ":" to separate hostname and database name? > My problem is this: > I just started a project using a Microsoft Azure virtual machine in the cloud > that will host a firebird database. > To access the virtual machine you need to give a url plus port number. Like > this: > scadcam.cloudapp.net:51160 This would be the hostname. > But when trying to access the database with > scadcam.cloudapp.net:51160:employees, firebird reads up to the first ":" > leaving out the port number needed to access the host. > Is there a workaround? > Regards, > Héctor Ríos Mendoza > scad...@gmail.com > 614 4155821, 4160317 For the Firebird library itself you simply need to use scadcam.cloudapp.net/51160:employees The fact that Microsoft specifies scadcam.cloudapp.net:51160 is that almost all applications use ':' as the separator between hostname and port. Firebird doesn't, it uses '/' as the separator. At the TCP/IP level where the actual connection is created that distinction doesn't even exist. Mark -- Mark Rotteveel
Re: [firebird-support] hostname:databasename
At 08:35 AM 8/09/2012, scadcam2004 wrote: >Hi, >Hope somebody can help me. >Is it possible to use other than ":" to separate hostname and database name? >My problem is this: >I just started a project using a Microsoft Azure virtual machine in the cloud >that will host a firebird database. >To access the virtual machine you need to give a url plus port number. Like >this: >scadcam.cloudapp.net:51160 This would be the hostname. >But when trying to access the database with >scadcam.cloudapp.net:51160:employees, firebird reads up to the first ":" >leaving out the port number needed to access the host. >Is there a workaround? scadcam.cloudapp.net/51160:employees is the correct TCP/IP syntax when using a non-standard port. This isn't a workaround, it's the external standard for TCP/IP connection. Also locate the parameter #RemoteServicePort = 3050 in firebird.conf on the server, delete the '#' marker and change the port number to 51160. I don't know whether your Microsoft Azure thing recognises external standards, though. If this doesn't work, your best bet would be to contact Microsoft support about it. If you are using events, you will also need to open a specific port for event traffic and set the RemoteAuxPort parameter in firebird.conf. ./hb >Regards, >Héctor Ríos Mendoza >scad...@gmail.com >614 4155821, 4160317 > > > > > >++ > >Visit http://www.firebirdsql.org and click the Resources item >on the main (top) menu. Try Knowledgebase and FAQ links ! > >Also search the knowledgebases at http://www.ibphoenix.com > >++ >Yahoo! Groups Links > > >
[firebird-support] hostname:databasename
Hi, Hope somebody can help me. Is it possible to use other than ":" to separate hostname and database name? My problem is this: I just started a project using a Microsoft Azure virtual machine in the cloud that will host a firebird database. To access the virtual machine you need to give a url plus port number. Like this: scadcam.cloudapp.net:51160 This would be the hostname. But when trying to access the database with scadcam.cloudapp.net:51160:employees, firebird reads up to the first ":" leaving out the port number needed to access the host. Is there a workaround? Regards, Héctor Ríos Mendoza scad...@gmail.com 614 4155821, 4160317
