I figured out that when I uploaded the GT_base.pm and the GT_templates.pm files that they were not uploaded in ASCII. I fixed that and now get a new error:

CGI ERROR
==========================================
Error Message : fatal undef error: [Wed May 31 06:31:22 2000] mysql.cgi: GT_Template (14312): Unable to open template file '/templates/login.html'. Reason: File does not exist. at html.pl line 381

Script Location : mysql.cgi
Perl Version : 5.00404

It does exist, the whole directory was uploaded in ASCII, permissions are 755 for templates directory and 644 for all files in the directory.

Where did I miss something?

Are you _SURE_ you uploaded them in ASCII ?? I'd double check it.

That error usually means the template cannot be read (it's 0 bytes) but uploading in Binary could probablly do the same thing.

Also, what is the Templates path?

'/templates/login.html'

Looks like it's trying to find an absolute path.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Pugdog, I checked, double checked, deleted the files (All of them) and re-uploaded again making sure the files were uploaded in ASCII.

As for the path: in the README files I followed the instructions explicitly making the paths as follows:

mysql.cgi - path to perl - !/usr/bin/perl

Now it says edit mysql.cfg where the %config is. I found this in the file: # --------------------------
# CONFIG HASH |
# --------------------------

%config = (

What goes there? What path should be put there?

I think that is the problem. The templates folder and all files are chmode right (644 for files and 755 for the templates folder).

I keep getting this error. EVERYTHING is correct, so does anyone know why I get this error?

CGI ERROR
==========================================
Error Message : fatal undef error: [Wed May 31 17:19:56 2000] mysql.cgi: GT_Template (7100): Unable to open template file '/cgi-bin/templates/login.html'. Reason: File does not exist. at html.pl line 381

Script Location : mysql.cgi
Perl Version : 5.00404


Paths, ASCII, CHMODE, it all is correct..... This is getting to be a pain in the butkus!

I'm going to reply again, publicly, so people can see:

The script URL you can "hard code" as "http://www.yourserver.com/cgi-bin/path/to/mysql.cgi"

The home_url you should change to "http://www.yourserver.com"

and the template dir, _IF_ you set the script path at the top of the file (not let it auto set), you can leave that alone. Or, you can hard code it to:

/full/path/to/the/file/then/templates

Make sense?



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Even hard coding the path to the templares directory I get this error:

CGI ERROR
==========================================
Error Message : fatal undef error: [Wed May 31 20:07:58 2000] mysql.cgi: GT_Template (27431): Unable to open template file 'http://www.kerlinfamily.org/cgi-bin/templates/login.html'. Reason: File does not exist. at html.pl line 381

Script Location : mysql.cgi
Perl Version : 5.00404

The files are there, they wewre uploaded in ASCII, they were CHMODE to 644 for ALL files in the templates directory and the directory itself was CHMODE to 755.

This is too much trouble and I have never had a problem like this before after using and uploading 100's of scripts. I think the script has a bug of some kind. As a last effort, how do you stop the mysql.cfg file from "auto setting" the path?

Thanks

If the path is not set automatically then you can comment out/delete BEGIN { ... } and add the line:

$script_path = '/path/to/mysqlman';

I.e.

$script_path = '/path/to/mysqlman';

# BEGIN {
# use vars qw/$script_path/;
# $0 =~ m,(.*?)[^/\\]+$, ? ($script_path = $1) : ($script_path = '.');
#}

Hope that helps.

--
Gossamer Threads, Inc.

Steven, thanks for trying to help. As I said to Pugdog, I have been uploading/downloading and operating CGI scripts for over 3 years and I have NEVER had the problems as I have with this script.

All of your others work great, but not this one! I have taken it down, deleted it and trashed it. I have seen to many threads from others having similer problems with it.

So it does not take a "Mack Truck" running me over to get me to realize this script is CRAP. Don't take offense, it is my opinion and only matters to me alone. I tried what you wrote to and it still does not work so I am just writing this off as junk.

Have a great week!

Don't be so harsh!

They are trying to make the script run on every platform, right out of the box.

How many scripts have you had that -- given the best situation -- you only had to set ONE path variable??? <G>

So, a bit of tweaking is in order.

Maybe pulling all the settings to the top of the file, and clearly saying if the automatic settings don't work, comment out these lines, uncomment and fill in the following lines would be better.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Pugdog said
Or, you can hard code it to:
/full/path/to/the/file/then/templates

Your error says

Unable to open template file
'http://www.kerlinfamily.org/cgi-bin/templates/login.html'.

You obviously have hardcoded the URL to the templates directory, not the path.



JPD

I am sorry to hear that you have gone through much trouble installing MySQLMan. We will review the code and make necessary changes so that we can make using MYSQLMan a more pleasant experience. In the mean time, if you have any questions regarding to the script, please post them on the board and we will try to solve them for you.

Cheers,

--
Gossamer Threads, Inc.

Thanks Steven.... No biggie I just got frustrated but found out why I could not get it to work LATE last night.

Now I can't LOGIN to MySQL to build a database, go figure!

You need to make sure you have sufficent access in mysql to create databases. Make sure you have created a mysql account which has the ability to create databases, and that you are logging on using that account.

Cheers,

Alex

--
Gossamer Threads Inc.

I have access to MySQL and the ability to create databases. My ISP currently has phpMyAdmin to do the tasks of setting up databases but I wanted to try MySQLMan. It did not work!

I will just have to be happy with phpMyAdmin.