Hendrik

thanks for your help guys. i have found the problem, it was from my side

thank you for your patience

I see that i accidentally wrote that i can't drop tables in my previous post, but that ain't the case.

It is the stored procedures i cannot drop, which i could do 2 weeks ago. For some reason back then i could not drop the procedures from MySQL Workbench but i could do it from phpAdmin, therefore i had no problems, but now i cannot drop them even from control panel phpAdmin.

I know that you have previously mentioned that it is due to some sort of a MySQL 5.x bug. But what confuses me is that why was i able to do the dropping before anyway even though there was a bug :S

It was actually working about 2 weeks ago, when i could drop the tables from phpAdmin, but not alter the tables from the MySQL Workbench

What are the procedures you are trying to drop?

I was trying to drop stored procedures.

EDIT:

I get the following error: #1370 - alter routine command denied to user 'tazan_ngsis'@'localhost' for routine 'tazan_ngsis.new_routine'

Hendrik

Hi Support,

Server: johnny

Domain: ngs.is

Username: tazan

About 2 weeks ago i had no problems with dropping stored procedures in the database, but now i cannot drop my procedures.

Why is that so?

Best Regards,

Hendrik

that is okey

thanks for your concern guys

I'm getting this error: Error 324 (net::ERR_EMPTY_RESPONSE)

This is due to a problem with mono. Please see the topic in escalated requests.

I read the topic that Krydos referred to and i have never used Mono before, therefore i do not understand how that can be a problem at all? And i have downgraded my application from .Net 4.0 to .NET 3.5

so this time the problem was actually at the domain name registrar side, but they fixed it and it works now

Is it still not working? If not, shall I escalate this? If so, what should djbob do?

I'm able to add your name servers to my domain registrar, as all of the issues with that were solved.

But the problem now is that error i get when accessing my page "Error 324 (net::ERR_EMPTY_RESPONSE)" and i have do not know how to fix it.

We don't support .is domains at this moment in time. However, we are working on it and are awaiting a response from the organization which represents this domain:

 

http://www.helionet.org/index/index.php?showtopic=9157

That topic is also created by me, i think all the .is domain related topics are created by me.

But how long do you think it will take to get everything sorted out?

Hendrik

Hi Support,

I assume that the problem I state in this topic is related to name servers again, as I got an error when I was changing name servers for my Icelandic domain name.

Error:

---------------

ns1.heliohost.org does not exist.

For .is domains the nameservers must be configured correctly before the delegation can be completed. Not all ISPs are aware of this. Please contact the administrators of the nameservers you are trying to use, and ask them to create a valid zone file for ngs.is on all the nameservers.

---------------

Previously, I had 2 other errors related to Icelandic domain names, which have been solved, so this is the third one .

Best Regards,

Hendrik

@Hendrik Please post your username/domain/server. Thanks.

 

Possibly related: http://bugs.mysql.com/bug.php?id=9467

username: tazan

domain: ngs.is

server: johnny

I use mysql workbench to execute the changes. I can delete and create routines easily through the tool, but that is a bit annoying when it comes down to small changes which i wanna test out. Previously my database resided in another web-server and there i didn't have any problems with changing the routines.

I won't give the full routine as i don't want to publish it, but when i even add a comment to the routine it fails and therefore i think it is unnecessary to view my routine in full content

That is what mysql workbench tries to execute.

//mysql workbench added code start
USE `tazan_ngsis`;
DROP procedure IF EXISTS `insertVisitor`;
DELIMITER $$
USE `tazan_ngsis`$$
//mysql workbench added code end

//my routine start
CREATE DEFINER=`tazan_ngsis`@`%` PROCEDURE `insertVisitor`(IN shortUrl TEXT)
BEGIN
//changed code here
END
//my routine end

After i execute my code i get an error message with this information

//mysql workbench added code start
ERROR 1370: alter routine command denied to user 'tazan_ngsis'@'%' for routine 'tazan_ngsis.insertVisitor'
SQL Statement:
DROP procedure IF EXISTS `insertVisitor`
ERROR: Error when running failback script. Details follow.
ERROR 1304: PROCEDURE insertVisitor already exists
//mysql workbench added code end
SQL Statement: //changed code here

Hi Support,

It makes me wonder, why can't i alter my stored procedures while i can drop and create them?

Best Regards,

Hendrik

Hi Support,

Very weird put im not able to load my website.

Domain: ngs.is

Username: tazan

I'm getting this error: Error 324 (net::ERR_EMPTY_RESPONSE)

I have tried to solve it, without success.

I also found some other topic which stated that my website should be in asp.net 3.5 so i converted my website to that, but still.

When I'm testing my website in local host and connecting to the database at johnny.heliohost.org it is all okey.

I'm sure it is some small thing that I don't know about.

Do you guys have any idea what might be causing it?

Best Regards,

Hendrik

thanks, it helped me.

but what baffles me is that prior to making this topic i was trying the same very solution, but the cPanel did not accept '%' at all, but now it does

Hi Support,

I have looked around the forum and have found that other people have had the same problem, but none of the solutions helped me.

The error i get.

---------------------------

Access denied for user 'tazan_ngsis'@'87.104.233.42' (using password: YES)

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: MySql.Data.MySqlClient.MySqlException: Access denied for user 'tazan_ngsis'@'87.104.233.42' (using password: YES)

--------------------------

My domain name is ngs.is.

I have created a database and user and assigned a user to the database.

The user has all the privileges.

Also johnny.heliohost.org is the database server address, right?

I am able to connect to the database through cpanel phpmyadmin, but not remotely.

I doubt that the mistake is in the connection string but i will add it anyway, just in case "SERVER=johnny.heliohost.org; DATABASE=tazan_ngsis; USERNAME=tazan_ngsis; PASSWORD=***********";

Will be waiting for the reply

Best Regards,

Hendrik

thanks for the help djbob .

i emailed to my domain name registrar to ask why i still got the problem as you signed helio name servers to ISNIC.

so this time the problem was actually at the domain name registrar side, but they fixed it and it works now

Hendrik

I was constantly changing the the name servers to see what works and what doesn't, that is why they ngs.is is pointing to other name servers.

But yeah, i have no idea either why it doesn't work. I have contacted my domain name registrar about the issue too but still waiting for the answer.

Anyway, thanks for your help .

Hendrik

Just add that domain as a parked/add-on domain and a zone file will be created.

ngs.is is my main domain and i can't add it as a parked or add-on domain.

I get this error when i try to do it in the control panel

Error from park wrapper: You cannot park your main domain!

Hi Support,

I previously contacted the support about my .is domain name and one of the problems got solved.

But this problem still exists before I'm able to use my domain name with heliohost.

---------------------------------

Error while connecting to ISNIC. Error code: 2490 (Cannot update nameservers). Please try again later or contact customer support if the problem persists.

For .is domains the nameservers must be configured correctly before the delegation can be completed. Not all ISPs are aware of this. Please contact the administrators of the nameservers you are trying to use, and ask them to create a valid zone file for ngs.is on all the nameservers.

------------------------------

I guess the most important part of this information is on the last line that is "valid zone file for ngs.is on all the nameservers."

Would heliohost please make this asked zone file for me?

Appreciate,

Hendrik

Looks like they need reverse DNS to be set up. We ought to have that anyways, so I've requested it from the parent host. I'll let you know when it's set up.

Alright that sounds good

Thank you guys for that.

Keep up the good work

Okey, I'll do my best, but give me a week or so

Uhm... what? They want me to register my nameservers with them? The Internet is based on a decentralized model.

 

What exactly would registering the nameservers entail? It is possible for you to use an alternate source for DNS?

Well that is the error message i get when i try to sign your DNS servers to my domain name.

But how to solve the problem, i don't know unfortunately.

The error message is between the underscore lines.

The error happens because .is (Icelandic) domain name seems more special, but why i don't know.

I hope there is an easy solution, as i would like to use your hosting service .

Hi Support,

my domain name ends with .is. When i try to publish my domain i get the following error.

__________________________________

Error while connecting to ISNIC. Error code: 2491 (Cannot update nameservers; nameservers not correctly configured). Error message from ISNIC:

Please fix the following input errors:

The nameserver ns1.heliohost.org is not registered with ISNIC

The nameserver ns2.heliohost.org is not registered with ISNIC

For .is domains the nameservers must be configured correctly before the delegation can be completed. Not all ISPs are aware of this. Please contact the administrators of the nameservers you are trying to use, and ask them to create a valid zone file for ngs.is on all the nameservers.

___________________________________

What will you do about it because i would like to use your hosting service

Best Regards,

Hendrik