Hostopia MySQL user and Database has disappeared
It's well over an hour now since I posted…
… and the problems mentioned continue. So I assume the problem mentioned is deeper rooted.
David
Quote from: spraxyt My database user and database has disappeared (in control panel MySQL Manager), and WordPress is giving an "Error establishing a database connection" message
I wonder if Hostopia are restarting the server?
… and the problems mentioned continue. So I assume the problem mentioned is deeper rooted.
David
Quote from: spraxyt It's well over an hour now since I posted…
Quote from: spraxyt My database user and database has disappeared (in control panel MySQL Manager), and WordPress is giving an "Error establishing a database connection" message
I wonder if Hostopia are restarting the server?
… and the problems mentioned continue. So I assume the problem mentioned is deeper rooted.
Taking a look now David...
Quote from: Marteknet Plusnet have lost all my clients web sites this is a joke, Customer support is a waste of time Hostopia have really screwed things up.
Looking at your account, the problem seems to be with your DNS configuration rather than anything we or Hostopia have done. I'll take a look and see if I can fix things for you.
Quote from: Marteknet Plusnet say its an extra, that's rubbish they are using it in their advertising
Where?
Quote from: Marteknet It costs money to run and manage servers, or have Hostopia taken over running this service for FREE!
No they haven't. We had two choices really. Decommission the CGI platform or pay to have something replace it. We chose the latter.
Quote from: Marteknet Who picked Hostopia to manage the CCGI, Hostopia have some really bad reviews on the internet.
I don't think those (very dated) reviews are a good reflection. Hostopia have a huge client base and have undergone significant organisational changes since those reviews were written (not least being acquired by another company).
Quote from: Penny are so unremittingly positive it's hard to believe they describe the same company.
Their "migration" page as you pointed out is positively glowing with successful migration data, but I remind you that after all it is their page, are they going to use any negative data in their advertising. I think not.
I have attempted to see what's going on by accessing the databases via the new control pages which are user violent, the file transfer page is so slow it a joke! only one file can be picked at a time to be added to a transfer list, it takes ages to build a transfer list and to do even do simple things. I looked in to their guide so I could set up FileZilla to make this more user friendly. I have followed the info only to find that the server is not accepting FTP connection. I've tested this via Windows DOS FTP and connections are refused.
The Mysql Admin doesn't work!.
I have now after much scratching of my head installed my own version of Mysql Admin, this works. I now find that on the mysqlV4 host that there are no databases set up. On the mysqlv5 host there is indeed a database but not tables have been added. It holds no data at all, its completely empty.Why on earth did they send me an email on 5/2/2014 saying "Your new CGI Webspace is ready" when it clearly is not. Didn't anyone think to check that things has worked correctly first!
Forgetting the reviews I can certainly say from my experience that those that others seem to be having that someone should have made sure that Hostopia were reliable and could quickly fix any errors.
Quote from: Marteknet I looked in to their guide so I could set up FileZilla to make this more user friendly. I have followed the info only to find that the server is not accepting FTP connection. I've tested this via Windows DOS FTP and connections are refused.
Are you sure you're using the correct server address?
C:\Windows\System32>ftp ccgi.******.force9.co.uk
Connected to ccgi.******.force9.co.uk.
220 Website FTP Server Ready
User (ccgi.martek.force9.co.uk:(none)): ccgi.martek.
331 Password required for ccgi.martek.force9.co.uk.
You set the master FTP password using the FTP Manager application in the Control Panel.
Quote from: Marteknet The Mysql Admin doesn't work!.
There should only really be a single MySQL5 database. Speaking to Hostopia I think they've created two where they've struggled with certain database interactions whilst migrating the data (bear in mind we're moving from MySQL4 to MySQL5). If you had database content on the old platform then it should be visible on the new one. Can you please point me in the direction of an area of your site that relies on connectivity to your database? Something that's not working as expected. If you'd prefer, raise a support ticket instead and provide me with the reference number. I'm confident we can fix anything you're having problems with.
Quote from: Marteknet Why on earth did they send me an email on 5/2/2014 saying "Your new CGI Webspace is ready" when it clearly is not. Didn't anyone think to check that things has worked correctly first!
Yes the sites are QA'd using test scripts and a selection inspected by hand. Unfortunately, it is not practical to have a human check all 10,000 accounts as part of the migration.
I have opened tickets to customer support, and telephoned them a few times about all the issues, basically, all the html & php code was migrated a while back, all my web sites are 100% sql driven with dynamic content that my customers can update via allocated pages they can alter text content, design simple pages, upload graphics. the php code consists of page templates and scripts to pull info for the page content this being locations of linked graphics, text, prices, http link and email addresses. This info is then used to populate the web pages that are then displayed.
One web site has over 1,100 Albums of country Artists listed , Another has a Calendar of coming events and a Menu with prices listed. all this info can be changes in an instant by my clients (well they used to be able to till this week).
I found that though the code and some graphics had been migrated, by the look of things over a week ago. The actual database had not been set up in the new mysql sever and if it is done now then it will not match the content that was moved over a week earlier. Someone should have thought about this time lag because php/sql is mainly used for dynamic pages. There is no point in moving graphics one week and then moving the database that accesses them more than a week later.
Plusnet customer support was told all about this, I waited and waited some more. I got fed up waiting, my clients are continually asking when will their web sites be working properly. I then opened myphpadmin, my own version because there are issues with the one on the control panel, I spent the best part of the day creating tables in the mysql v5 database and populating them with data. I then went and started changing the host, user, database and password variables held in the scripts that access the mysql database, at last pages started to have the content that they should. I had completed making these changes to one web site and was well in to changing the second one, when I found that the content was not displaying anymore. I took a look at the mysql databases again to check the tables only to find that they had all been deleted.
I can not point you to a precise part of a web page that is affected by this as its nearly 99% of the pages that are.
To get to the point without a mysql database hardly any page will have to desired content displayed.
What are Plus net going to do about this? the answer would be for you to migrate the databases again, email me the details (host,user,database,password) that my php scripts need to connect with the database. and leave me to amend the actual php code.
And not to delete the database tables again.
Adie:quote
One web site has over 1,100 Albums of country Artists listed , Another has a Calendar of coming events and a Menu with prices listed. all this info can be changes in an instant by my clients (well they used to be able to till this week).
I found that though the code and some graphics had been migrated, by the look of things over a week ago. The actual database had not been set up in the new mysql sever and if it is done now then it will not match the content that was moved over a week earlier. Someone should have thought about this time lag because php/sql is mainly used for dynamic pages. There is no point in moving graphics one week and then moving the database that accesses them more than a week later.
Plusnet customer support was told all about this, I waited and waited some more. I got fed up waiting, my clients are continually asking when will their web sites be working properly. I then opened myphpadmin, my own version because there are issues with the one on the control panel, I spent the best part of the day creating tables in the mysql v5 database and populating them with data. I then went and started changing the host, user, database and password variables held in the scripts that access the mysql database, at last pages started to have the content that they should. I had completed making these changes to one web site and was well in to changing the second one, when I found that the content was not displaying anymore. I took a look at the mysql databases again to check the tables only to find that they had all been deleted.
I can not point you to a precise part of a web page that is affected by this as its nearly 99% of the pages that are.
To get to the point without a mysql database hardly any page will have to desired content displayed.
What are Plus net going to do about this? the answer would be for you to migrate the databases again, email me the details (host,user,database,password) that my php scripts need to connect with the database. and leave me to amend the actual php code.
And not to delete the database tables again.
Adie:quote
Quote from: Marteknet I have opened tickets to customer support, and telephoned them a few times about all the issues, basically, all the html & php code was migrated a while back, all my web sites are 100% sql driven with dynamic content that my customers can update via allocated pages they can alter text content, design simple pages, upload graphics. the php code consists of page templates and scripts to pull info for the page content this being locations of linked graphics, text, prices, http link and email addresses. This info is then used to populate the web pages that are then displayed.
Which I/ completely understand. All I was asking for is a handful of examples so I can work out what's gone wrong and fix the problem.
Quote from: Marteknet I found that though the code and some graphics had been migrated, by the look of things over a week ago. The actual database had not been set up in the new mysql sever...
Which is a problem. Both static content and your database should have been migrated at the same time.
Quote from: Marteknet I then opened myphpadmin, my own version because there are issues with the one on the control panel, I spent the best part of the day creating tables in the mysql v5 database and populating them with data. I then went and started changing the host, user, database and password variables held in the scripts that access the mysql database, at last pages started to have the content that they should.
Again, these are all things that should have been done on your behalf as part of the migration
Quote from: Marteknet I had completed making these changes to one web site and was well in to changing the second one, when I found that the content was not displaying anymore. I took a look at the mysql databases again to check the tables only to find that they had all been deleted.
I have no idea why that would have happened but I'll look into it.
Quote from: Marteknet I can not point you to a precise part of a web page that is affected by this as its nearly 99% of the pages that are.
Which should make it easy? As mentioned above, I was only after a handful of examples.
Quote from: Marteknet What are Plus net going to do about this? the answer would be for you to migrate the databases again, email me the details (host,user,database,password) that my php scripts need to connect with the database. and leave me to amend the actual php code.
Happy to do that, if you can provide the information I've asked for?
Whilst I recognise you've now requested your domains are transferred elsewhere, I'm still keen to get to the bottom of what happened here so it doesn't happen again.
