[Solved] Ip Address Payed

[salrandazzo]

I just payed 12$ to add an IP Address to my newly created Johnny SSL website account.

Domine name salrandazzo.heliohost.org

Paypal transaction ID 2LM633435C544480P

THanks

[Byron]

This support request is being escalated to our root admin.

[Krydos]

Since the Johnny server is our experimental server I would just like to confirm that you're ok with the 85% to 95% uptime that Johnny regularly experiences before doing the work of installing your dedicated IP. In comparison Stevie, our production server, regularly experiences 99.6% uptime to 99.99%.

[salrandazzo]

could I switch from Johnny server to the Steve one? Is it possible?

[Ice IT Support]

Follow this guide: http://wiki.helionet.org/Moving_your_account

[Krydos]

If you wish to move to Stevie first go ahead. You can use your same payment to receive a dedicated IP on either server. Just let us know once you're account is ready to receive the IP on this thread.

[salrandazzo]

Ok guys, thanks a lot for your help and free service. My Stevie website is now running (just the maintenance page) at http://salrandazzo.heliohost.org/.

As stated at the start of the thread, I already payed the static IP.

Would you like to connect it now to my website?

And, another question (if I can post it here): my purpose is to practice with php+MySQL building a very simple accounting software for my No-profit association. Database on mySQL and web code on PHP.

But, what if, using the static IP, I try to ODBC connect a microsoft access application to the mySQL database on my Stevie server? Is it possibile?

Thanks a lot.

Salvatore

[Ice IT Support]

It is possible. See http://wiki.helionet.org/MySQL_Databases#Connecting_Remotely for instructions on using remote MySQL.

[salrandazzo]

So, if I understand, I need no IP to connect via ODBC a Microsoft Access application to mySQL.

I should:

• open cPanel and put a % sign on "remote mySQL" add Host.
  
• ODBC connect to the database myCpanelName_myDatabaseName. Example: salranda_salranda_xlpdr_accounting (my cPanel username = salranda, my database name = salranda_xlpdr_accounting).
  
• ODBC connect to the host stevie.heliohost.org (I'm using a stevie server).
  

That should be enough, correct?

 

So, if I don't need an IP address to ODBC connect a PC application to mySQL, what's the usage of a static IP?

I purchased it thinking about the ODBC connection. What other application uses it?

Thanks a lot again.

 

 

Problem solved. The configuration sequence is:

• open cPanel and put a % sign on "remote mySQL" add Host.
  
• ODBC connect to the database myDatabaseName. Example: salranda_xlpdr_accounting (My database name = salranda_xlpdr_accounting).
  
• ODBC connect to the host stevie.heliohost.org (I'm using a stevie server).
  
• Complete with cPanel username and password.
  

Attached the screenshot of the ODBC system DSN configuration dialog.

[Ice IT Support]

The most common reason to use a static IP on HelioHost is for SSL capabilities. It's not really necessary for much else.

[salrandazzo]

Ice-IT, would it be possible (and useful) to use IP static address to remotely connect mySQL instead of the server name? I'm asking that because I use an OpenOffice db application to connect to HelioHost Stevie server via native mySQL connection. It works but it's SO SLOW. I don't know if it depends of the slow server answer or maybe on the native OpenOffice native connection. I'm wandering if the IP Static Address (instead of "stevie.heliohost.org") could supply a faster connection.

Thanks.

 

Addendum: to connect OpenOffice to mySQL i installed the "MySQL SDBC Driver for Apache OpenOffice 1.2.0 (aoo-my-sdbc). I'm using OpenOffice 4.0.0.

[Ice IT Support]

Using the static IP will have no effect on the speed of the connection, as it all goes to the same server. Stevie is having unusually high load today, most likely due to someone abusing server resources. Once the account(s) are suspended, load should return to normal and your speed will increase.

[salrandazzo]

Update about remote SQL accessing:

I tried MySQL-Front (www.mysqlfront.de) to remotely connect my PC to the stevie mySQL database. It's FAST! I still have to investigate how handy and powerful it is (will report later) but it connects and shows table structure and content (three records.....) at soon.

OpenOffice 4.0.0 it's not fast at all. It takes more than 90" to connect, to show table structure or content. Impossibile to use, unless someone gives me to good hint to speedup this connection. Does anyone ever tried to connect OpenOffice DB to a remote mySQL?

Stay tuned, I'll keep you posted.

 

(hm... maybe better to move this topic to some other section? let me know)

[Ice IT Support]

I could split the topics, but it would be out of context since we are still waiting for your static IP to be granted.

[Krydos]

Dedicated IP granted.