CGI shell access disabled 17/08

[#1]

For those that haven't seen it:
[quote author="Service Status"]When's this work happening?
Today
What does it affect?
Shell access to our CGI hosting platform.
How long will it take?
We will announce further details regarding restoration of the service at a later date.
What does the work involve?
We are disabling SSH and telnet access whilst we investigate a recently identified problem with the platform.
Is it likely to cause problems?
Yes, you won't be unable to access the CGI platform via command line until further notice - http://usertools.plus.net/tutorials/id/18
Is there anything else I need to know?
You will still be able to access the platform using FTP and customers' websites will still be viewable via HTTP. We will post another announcement once we're in a position to be able to restore full access to the platform.
Kind Regards,
Bob Pullen
Customer Support

[#2]

Sorry Bob but....
[quote author="Service Status"]When's this work happening?
Is it likely to cause problems?
Yes, you won't be unable to access the CGI platform via command line until further notice - http://usertools.plus.net/tutorials/id/18

?

[#3]

I lookforward to my occassional telnet//SSH  access to trim my guestbook posts.
best wishes,
Doug

[#4]

Quote from: Bob

We are disabling SSH and telnet access whilst we investigate a recently identified problem with the platform. Is it likely to cause problems? Yes, you won't be unable to access the CGI platform via command line until further notice

I'd appreciate some help from anyone who has been able to populate a mysql table from a txt file (not csv) without using shell access.
About a year back, Kev Mawson kindly gave me the path for doing this on PAYH -

Quote

LOAD DATA LOCAL INFILE '/var/www/vhosts/domain name/httpdocs/CHINESEtcvocab03.txt' INTO TABLE VOCABchinesetc01;

but I haven't yet been successful in executing any address-variables of such a query in the outer-database area of PHPMyAdmin, on the Force9 ccgi server.
I can import a csv file when a table is open (utf8, using CSV LOAD DATA) but all the data goes into the first column, generally (though some of the options cause it to go onto the full number of lines).  I've tried numerous combinations of 'options' but nothing works as simply as a txt file imported via telnet (using a LOAD DATA LOCAL INFILE 'nameoffile.txt' INTO TABLE nameoftable; type of request).
Logic says there must be a direct filepath via which a txt file can be loaded (using php myadmin) into an emptied table, but I haven't been able to locate it and running out of time here.  Currently need to populate tables for Indonesian, Urdu and Bulgarian, amongst others. I've uploaded the txt file to ccgi (Force 9) but I don't know how to tell mysql where it is (and have also tried a number of prefix variables like /files/home1/username/ without mysql having been able to locate the file).  Haven't replicated things like the httpdocs in the original example because assume doesn't apply on ccgi.
Running out of ideas ^^  Any help would be much appreciated.
Regards,
Penny.

[#5]

I'm not sure that can be done within phpMyAdmin since I think "local" would refer to the MySQL server which is probably not the one where the file resides.
However I think running the command within a PHP program on CCGI should work.
The steps would be
(1) FTP the text file to the same directory as the PHP program
Within the PHP program
(2) Connect to the database
(3) $load_query = "LOAD DATA LOCAL INFILE 'nameoffile.txt' INTO TABLE nameoftable";
(4) $result = mysql_query($load_query);
(5) if ($result) {echo "table loaded successfully";}
     else {echo "loading failed< br / >\n", mysql_error();}
Run the program in the browser as for a normal PHP program.
David

[#6]

Quote from: spraxyt

I'm not sure that can be done within phpMyAdmin since I think "local" would refer to the MySQL server which is probably not the one where the file resides. However I think running the command within a PHP program on CCGI should work.

Sheer genius
Barely ten minutes from reading your post, the data was loaded.  Thank you sooo much.

I would probably never have thought of positioning the query where the txt file was located, rather than its intended destination.  Entirely logical, though, thinking about it.  Not that I would have known how to construct that query, either
Really appreciate your help.
Penny.

[#7]

Is there any update to the original subject of this post ... the inability to use shell access to CGI platform. An update was scheduled for 18/08, but nothing has appeared. My problem: Every week I upload a file of mysql statements using putty. I am unable to use mysql import as that stopped working due to a problem your end about 6 months ago (which you couldn't figure). I don't want to have to waste time on another alternative if this is going to be fixed shortly.
Rgds,
Dave Hennings.

[#8]

Why don't you use MySQL Workbench to connect to the Plusnet hosted database and run the updates direct from your local PC?

[#9]

I'll try and get an update out for this today, I don't think there is going to be a quick fix for this though.

[#10]

jelv, thanks for your post. I tried MySQL Workbench last night. I think hostname is cshell.plus.net and it's that service that PN seem to have (temporarily?!) suspended. If another hostname I don't know what it is. Do you? Appreciate your time.

[#11]

The MySQL servers are called rumpus.plus.net and humbug.plus.net (you use whichever one your database is on). They are still accessible.

[#12]

jelv, thanks a lot. I did try that last night from the Database | Manage Connections page, but the Test Connection button just sat and stared so I assumed it was not right. The Database | Reverse Engineer page has the option to show logs, and it now shows the following: Fetching schema list. Operation failed: SELECT command denied to user 'me'@'me.plus.com' for table 'schemata'. (I know schemata is a behind-the-scenes table which PN does not (?) give us access to.) Can't get anything from Google, but I hope you can help again. Thanks.

[#13]

The username and password you use are those which you use when connecting to the MySQL database within programs running on ccgi (you will have been sent them when you activated the MySQL database - username is probably 'username_pn')

[#14]

Yes, thanks ... the user name and password I specified are correct (not 'me' but 'laserbase'). It's connecting OK just having a problem with this schemata table. I have just used Workbench to access another site I have data on and it worked first time (schema fetched OK and reverse engineered). But there I also see and can choose the information_schema database and schemata table.

[#15]

Hmmm...
Until now I've used MySQL Administrator & MySQL Query browser, I was going to give you the link and found it had been replaced by Workbench. I assumed it would work in a similar way. I've now downloaded workbench and seen your problem. Time for some research!