Welcome Guest ( Log In | Register )

Discover the best free computer help!
Learn more about Geeks to Go by taking the tour. Spyware, virus, trojan, fake security or privacy alerts? Read the malware cleaning guide.
      
 
Reply to this topicStart new topic
How to Edit .cgi files, I End With Just a Notepad Folder
Robert Tracy
post Apr 12 2008, 06:51 PM
Post #1


Member
**
Posts: 99
From: Indiana
OS: Windows XP and Mac OS X



I see that Movable Type is back and making it easy. Years ago I did all the coding, etc and had a blog with MT until I switched hosting and lost all my sites.

But it's not so easy. I've got to edit the
CODE
mt-config.cgi-original
and/or a
CODE
mt-config.cgi
file. And I forget how to do it.

And I don't know what to put in it anyway. Here's what I've got:

CODE
Host Name     mysql1.hostica.com (208.179.130.30)
Port number     3306
Database name     henry_reardon  
phpMyAdmin     Built in phpMyAdmin control panel
you will need a properly configured dba user to log in (just add user with dba role if you don't have one)
What's a "dba role"?

My site would be at:

http://ideasillustrated.semperfigraphics.com

And if this is helpful:

HTML Directory Name /hsphere/local/home/henry/semperfigraphics.com

I get so far, and then this error:

CODE
Connection error: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) at /hsphere/local/home/henry/ideasillustrated.semperfigraphics.com/cgi-bin/mt/extlib/Data/ObjectDriver/Driver/BaseCache.pm line 234 at /hsphere/local/home/henry/ideasillustrated.semperfigraphics.com/cgi-bin/mt/extlib/Data/ObjectDriver/Driver/BaseCache.pm line 234
.

I've got a little blog at WordPress but it's nothing Like MT was. Love to have MT back if it's as good as it was two years ago.

Thanks for your attention. smile.gif Will be happy to supply any information I can find beyond the above.

Bob
Go to the top of the page
 
+Quote Post
azarl
post Apr 21 2008, 10:12 AM
Post #2


GeekU Junior
Group Icon
Posts: 123
From: Leeds, UK
OS: XP



Not used this myself but it will be something like:

CODE

ObjectDriver DBI::mysql
Database henry_reardon
DBUser UserName
DBPassword UserPassword
DBHost mysql1.hostica.com


Substitute your own user name and password for UserName and UserPassword (these should have been supplied to you)
Go to the top of the page
 
+Quote Post
Robert Tracy
post Apr 21 2008, 11:17 AM
Post #3


Member
**
Posts: 99
From: Indiana
OS: Windows XP and Mac OS X



Thank you.

That's exactly what I have in the mt-config.cgi And my information is correct.

Looking at it now though I see one extra piece of code at the top of that. It reads:

CODE
CGIPath  http://www.semperfigraphics.com/cgi/mt/


Is it possible that the problem lies there? That I should remove that piece of code? That it doesn't belong there?
Go to the top of the page
 
+Quote Post
azarl
post Apr 22 2008, 03:11 AM
Post #4


GeekU Junior
Group Icon
Posts: 123
From: Leeds, UK
OS: XP



Have you got PERL installed on your webserver, and a cgi directory?
Go to the top of the page
 
+Quote Post
Robert Tracy
post Apr 22 2008, 04:06 AM
Post #5


Member
**
Posts: 99
From: Indiana
OS: Windows XP and Mac OS X



QUOTE (azarl @ Apr 22 2008, 03:11 AM) *
Have you got PERL installed on your webserver, and a cgi directory?


Yes, both.
Go to the top of the page
 
+Quote Post
azarl
post Apr 22 2008, 08:27 AM
Post #6


GeekU Junior
Group Icon
Posts: 123
From: Leeds, UK
OS: XP



Does the MySQL server you're trying to connect with accept remote connections? By default it's usually only local connections. I.E. the script is on the same domain as the server
Go to the top of the page
 
+Quote Post
Robert Tracy
post Apr 22 2008, 09:11 AM
Post #7


Member
**
Posts: 99
From: Indiana
OS: Windows XP and Mac OS X



QUOTE (azarl @ Apr 22 2008, 08:27 AM) *
Does the MySQL server you're trying to connect with accept remote connections? By default it's usually only local connections. I.E. the script is on the same domain as the server


That I don't know. I have access via my control panel and see my MySQL, and see this as the only thing that looks appropriate to answer the question you pose. Please understand that I am really in the dark on any matters beyond a little HTML. So if you can, please guide me along the way.

Thanks much,

Robert
Go to the top of the page
 
+Quote Post
azarl
post Apr 22 2008, 09:28 AM
Post #8


GeekU Junior
Group Icon
Posts: 123
From: Leeds, UK
OS: XP



I know a little about MySQL but nothing about Movable Type, so don't expect expert answers smile.gif

I think you need to ask your MySQL provider if your database can accept external connections. By default (for security) it only accepts connections from localhost, scripts running on the same server as the MySQL
Go to the top of the page
 
+Quote Post
Robert Tracy
post Apr 22 2008, 11:00 AM
Post #9


Member
**
Posts: 99
From: Indiana
OS: Windows XP and Mac OS X



QUOTE (azarl @ Apr 22 2008, 09:28 AM) *
I know a little about MySQL but nothing about Movable Type, so don't expect expert answers smile.gif

I think you need to ask your MySQL provider if your database can accept external connections. By default (for security) it only accepts connections from localhost, scripts running on the same server as the MySQL


I'll do that, and get back to you.

Thanks
Go to the top of the page
 
+Quote Post
Robert Tracy
post Apr 22 2008, 03:25 PM
Post #10


Member
**
Posts: 99
From: Indiana
OS: Windows XP and Mac OS X



I contacted my hosting co. This is their answer:

QUOTE
The server does not allow external connections. We would need to know the IP address where the connection attempt is being made in order to evaluate the situation.


So, it looks like I just won't be able to use Movable Type. Correct?

Go to the top of the page
 
+Quote Post
azarl
post Apr 23 2008, 02:11 AM
Post #11


GeekU Junior
Group Icon
Posts: 123
From: Leeds, UK
OS: XP



Not necessarily. Could you install MySQL on the machine where you have the perl script? Provide the MySQL hoster with your IP, they may be able to to do it. I know of MySQL hosts who will allow external access, but they tend to charge
Go to the top of the page
 
+Quote Post
Robert Tracy
post Apr 23 2008, 11:36 AM
Post #12


Member
**
Posts: 99
From: Indiana
OS: Windows XP and Mac OS X



This is what they said:

QUOTE
We have granted external MySQL access to your IP address. It will now be possible to use a program on your computer to connect to and interact with your MySQL database.


And at no charge.

I suppose this means I can now publish. I'll give it a try and perhaps report back.

No, I tried a test post and it will not publish. These are the errors:

CODE
Perl/CGI Script Issues

Script Not uploaded in ASCII format.

Be sure to check ASCII in your FTP program before uploading your CGI scripts, otherwise they will upload in the incorrect Binary format.

You forgot to make the script executable.

After uploading your Perl/CGI script, change the permissions on the UPLOADED script to 755 or rwxr-xr-x. This is usually done with your FTP program's "chmod" or "change permission" function (when right-clicking on the script).


Path to Perl is Incorrect.

In your Perl/CGI script, make sure to set the path to: #!/usr/bin/perl . Any other path will cause the Internal Server Error.


Other Issues

.htaccess File Has Wrong Syntax.

If you have a .htaccess file uploaded, double check that the syntax of the instructions is correct. Incorrect syntax or incorrectly written instructions will cause an Internal Server Error.


Please understand that I really am a boot at all this. However I'm positive that I uploaded the appropriate files in ASCII mode. But I do not find the Perl/CGI script anywhere nor the .htaccess file. If I could find these I do know how to set permissions.



This post has been edited by Robert Tracy: Apr 23 2008, 12:05 PM
Go to the top of the page
 
+Quote Post
azarl
post Apr 24 2008, 06:00 AM
Post #13


GeekU Junior
Group Icon
Posts: 123
From: Leeds, UK
OS: XP



Haven't done much Perl - can't get my head around it, but here goes:

If I remember correctly, "The file not uploaded in ASCII" can also be caused by issues with the text editor that you used. Something to do with Carriage Returns and Line feeds. Try re-editing in a freeware editor that specifically states it's designed for Perl and uploading again. I had problems using notepad on a windows system.

You should be able to use your FTP program to change the permissions on the uploaded script - it's usually right-click and select chmod or some thing similar

It says that the first line of your script should be #!/usr/bin/perl. Sometimes it's #!/usr/local/bin/perl or #!C:/perl/perl.exe on Windows. Check the script and change the first line to #!/usr/bin/perl if it isn't already

Try creating a test script for example...
CODE
#!/usr/bin/perl
print "Content-type:text/html\n\n";
print "It Works!";

...in your editor and save it as test.cgi or test.pl (check which extension your server uses). Upload to your server and navigate to http://www.yoursite.com/cg-bin/test.pl (or whatever your address and cgi-bin directories are)
If it displays "It Works!" then I think Perl is configured and working OK

The .htaccess file(s) can be in any or all directories - check the parent directory. It uses inheritance to pass the settings down to child directories unless there is another .htaccess. If you can't locate it, pass that error on to your hosting company's support

As I say, I'm not an expert in this so I don't know quite how good my advice is.


Go to the top of the page
 
+Quote Post
Robert Tracy
post Apr 24 2008, 12:28 PM
Post #14


Member
**
Posts: 99
From: Indiana
OS: Windows XP and Mac OS X



I'm working with my hosting company and they tell me this:

QUOTE
The error_log is generating this error when attempting to publish the templates:

----

CODE
*** glibc detected *** realloc(): invalid pointer: 0xb7f568e0 ***


----

This is a programming bug. You'll want to contact the developers at MT to write a patch to correct this issue.


I suppose they may be right, although I doubt it. My version of MT is the latest, 4.1. And who knows how to contact MT anyway?

This is crazy.

Go to the top of the page
 
+Quote Post
azarl
post Apr 25 2008, 10:00 AM
Post #15


GeekU Junior
Group Icon
Posts: 123
From: Leeds, UK
OS: XP



I doubt it too. See here. Same problems , 4 years ago
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 


RSS Time is now: 22nd November 2008 - 09:04 AM
Advertisements do not imply our endorsement of that product or service. The forum is run by volunteers who donate their time and expertise. We make every attempt to ensure that the help and advice posted is accurate and will not cause harm to your computer. However, we do not guarantee that they are accurate and they are to be used at your own risk.