Gossamer Forum
Home : Products : Others : MySQLMan :

Weird Error

Quote Reply
Weird Error
I must be missing something simple here....

I am able to store the username, host, and password info. But when the page redirects me...I get Not Found and the following address shows up in the Location of my web browser:

Code:
http://www.mydomain.com/cgi-bin/mysql/h&t&t&p&:&/&/&w&w&w&.&a&n&t&h&r&o&t&e&c&h&.&c&o&m&/&c&g&i&b&i&n&/&m&y&s&q&l&/&m&y&s&q&l&.&c&g&i&?&d&o&=&t&o&p&_&l&e&v&e&l&_&o&p&
Any suggestions are greatly appreciated.

TIA.

Regards,

Eliot Lee
Anthro TECH, L.L.C
Web: http://www.anthrotech.com/
Quote Reply
Re: Weird Error In reply to
Ouch.... I can see what it's doing, but I don't know why. I'm not getting that.

I've been using it for a few days, and have about 30 databases.

It looks like a configuration problem. But I'm too new to understand where. The old default is to check the Unix permissions, just to make sure, since they can produce weird results some times.

After the logon screen you should see in the location bar:

http://www.yourdomain.com/cgi-bin/mysqlman/mysql.cgi?do=&data_source=&init_login=1

Question: What browser are you using? Do you have cookies enabled?

(Just shots in the dark).


OOOOOHHHHhhhh one other thing. At the top of the mysql.cfg file is :

Code:
# the path to the directory where the scripts reside in.
# If you run into problems, set $script_path to the full path
# to your directory.
my $script_path = '.';
see if setting that makes a difference. it would be

/path/to/the/cgi-bin/mysqlman

(going by the default of . which means "this")



Quote Reply
Re: Weird Error In reply to
Thanks for the reply, pugdog...I appreciate it.

In Reply To:
Question: What browser are you using? Do you have cookies enabled?
I checked my cookie file and the cookie seems to be set. Yes, of course.

In Reply To:
OOOOOHHHHhhhh one other thing. At the top of the mysql.cfg file is :
I set the $db_script_path to the complete absolute path to the directory where the MySQLMan files are located. Actually, I was getting CGI ERROR messages before the URL problem, so I set the variable to the complete absolute path and the script ran.

QUESTION: The other problem I have is when I try to create a database table, I get a Action not Permitted error message. Does this mean that the MySQL server that I am accessing does not allow actions to manage the tables (in terms of creating new tables) from the web browser, only through telnet?

Thanks again for taking the time to respond to my inquiry. I really appreciate it.

Regards,

Eliot Lee
Anthro TECH, L.L.C
Web: http://www.anthrotech.com/
Quote Reply
Re: Weird Error In reply to
Eliot -

With my host I do not type any host information to access my databases.

I was having the same problem until I figured out to just leave the host info blank when entering username and password.

It worked for me, you might try this.

Jerry


Quote Reply
Re: Weird Error In reply to
You're very welcome... good to know that somethings I suggest actually work :)

Did trying the blank hostname work?

The reason for this is that authentication is userid@hostname, and sometimes you are entered _only_ as username in the users table and the @hostname when it's translated to @localhost creates an id string "username@localhost" which is not in the authenticated user database. It's weird, but it's part of why MySQL permissions are so hard to set up.

If that's _not_ the reason, or the fix, I had similar problems in a beta copy (yes, I did see a beta of this) and Alex made some changes to the code for authentication in my server situation. He might have to do the same for this situation. It's hard to test situations that your own servers are not set up for, and Unix is not a single OS, it's a "concept" <G>



Quote Reply
Re: Weird Error In reply to
Thanks again for the suggestions, pugdog...

However, I applied the suggestions you gave before posting my problem.

Smile

BTW: The blank config for the demo_host does not work.

I think this may be higher level problems with the MySQL server and the configurations that my hosting company has used to set-up my account.

Regards,

Regards,

Eliot Lee
Anthro TECH, L.L.C
Web: http://www.anthrotech.com/
Quote Reply
Re: Weird Error In reply to
How did you set up your Links SQL package?

The same USER/ID/Machine should work here.

If it doesn't, it may be something at your MySQL end, or something Alex has to tweak for that sort of configuration.

Quote Reply
Re: Weird Error In reply to
In Reply To:
If it doesn't, it may be something at your MySQL end...
Most likely...I am using the same username and password that I have been using to access the MySQL databases in my account.

I have contacted my hosting company for their assistance.

Anyway, thanks for the continued assistance.

I appreciate it.

Regards,

Eliot Lee
Anthro TECH, L.L.C
Web: http://www.anthrotech.com/