[bb144]

Ritesh, sorry about the German.

Gentlemen, the problem has been corrected! My ISP restarted Apache and mysql (new build date for php = Jan 24 2006 10:47:24).

The 403 error was caused by me. I deleted the SQLyogTunnel.php file last night and forgot to copy it back before running SQLyog.

I am still not sure why things were not working in the first place, but as you suspected, Peter, it had something to do with the new version of PHP and my ISP not loading all the extensions.

SQLyog is the best mysql manager I've ever used. I was prepared to switch ISP's rather than give it up!

Thank you very much for your help!

Bob

[bb144]

OK, now when I try to connect with SQLyog, I'm getting a 403 error page

Quote:

error 403: Forbidden!

Verboten!

Es sind nur ungenügende Zugriffsrechte gesetzt. Bitte ändern Sie die Rechte mit Ihrem FTP-Programm.

It looks like my tunneling capability has been shut down. Can the tunneling file be changed to compensate?

[bb144]

peterlaursen wrote on Jan 24 2006, 03:49 AM:

I know from my own experience that good arguments can be important with ISP's !

[post=”8572″]<{POST_SNAPBACK}>[/post]

Yes! If you can get through to them! I'm not even sure they want me accessing my db this way. We'll find out tomorrow! 😉

Thanks again.

[bb144]

My ISP's build date was Jan 17.

[bb144]

bb144 wrote on Jan 24 2006, 03:16 AM:

The server is running php 4.2.2

[post=”8567″]<{POST_SNAPBACK}>[/post]

CORRECTION! Make that PHP 4.4.2

[bb144]

The server is running php 4.2.2

Let's hope the developers have an answer! Thanks for your help.

[bb144]

Here is the output from yogtunnel.log

Quote:

Enter aremodulesinstalled

Enter AreModulesInstalled

Enter processquery

Enter showaccesserror

Exit showaccesserror

Exit AreModulesInstalled

Enter aremodulesinstalled

Enter AreModulesInstalled

Enter processquery

Enter getdetailsfrompostedxml

Enter startelement

Exit startelement

Enter startelement

Exit startelement

Enter startelement

Exit startelement

Enter charhandler

Exit charhandler

Enter endElement

Exit  endElement

Enter startelement

Exit startelement

Enter charhandler

Exit charhandler

Enter endElement

Exit  endElement

Enter startelement

Exit startelement

Enter charhandler

Exit charhandler

Enter endElement

Exit  endElement

Enter startelement

Exit startelement

Enter charhandler

Exit charhandler

Enter endElement

Exit  endElement

Enter endElement

Exit  endElement

Enter startelement

Exit startelement

Enter startelement

Exit startelement

Enter charhandler

Exit charhandler

Enter endElement

Exit  endElement

Enter startelement

Exit startelement

Enter charhandler

Exit charhandler

Enter endElement

Exit  endElement

Enter endElement

Exit  endElement

Enter endElement

Exit  endElement

Exit getdetailsfrompostedxml

Trying to connect

Connected

Enter SetName

DB=n

Client=n

Server=n

Exit SetName

Enter ExecuteSingleQuery

mysql_num_rows in ExecuteSingleQuery

Enter HandleExtraInfo

Exit HandleExtraInfo

Enter aremodulesinstalled

Enter AreModulesInstalled

Enter processquery

Enter showaccesserror

Exit showaccesserror

Exit AreModulesInstalled

Any clues? Were the db, client, and server names supposed to be inserted?

[bb144]

peterlaursen wrote on Jan 24 2006, 02:25 AM:

one thing more:

there is a logging option:

Search the tunnelling file for

Code:

/* uncomment this line to create a debug log */
/*define ( “DEBUG”, 1 );/*

Uncomment the last line and lets see if it yields something.

The logfile 'yogtunnel.log' is created on the server in the folder of the tunnelling file.

Provided permissions allow for it.

[post=”8560″]<{POST_SNAPBACK}>[/post]

I'll try this now.

[bb144]

I uploaded the tunnel script several times (from different installs). I'm talking to ISP now. Will be back with an answer (hopefully) tomorrow.

[bb144]

peterlaursen wrote on Jan 24 2006, 12:30 AM:

There could be some setting that restricted PHP to use or not to use scripts from certain folders ?!

[post=”8555″]<{POST_SNAPBACK}>[/post]

I put the files in the same folder and got the same result. The script works. SQLyog does not.

I'm sure the ISP has done something. I'm going to ask them to restart Apache.

[bb144]

peterlaursen wrote on Jan 23 2006, 11:57 PM:

And I ABSOLUTELY am no coder!  Stooped being so when TurboPascal went out!

[post=”8551″]<{POST_SNAPBACK}>[/post]

Peter, you are telling your age! 😀 TurboPascal was the last course I took as well! 😆

Anyway, it appears that my server and database are up and running. I was able to access a table and count the rows. So now I turn my attention to my SQLyog settings. First of all I'm going to reboot my local system…

[bb144]

Thanks for the script. It worked perfectly. It appears that I can access the database. But I still cannot get access with SQLyog. It was working yesterday, but not today (?)

My current configuration is as follows:

LOCAL SETTINGS:

– Windows XP SP2

– SQLyog Enterprise v5.02 (also tried it with v4.07)

REMOTE SETTINGS:

– using http tunneling (and yes, I made sure I am using the right SQLyogTunnel.php file)

– Port 3306

– Server OS: Linux 2.4.28-grsec-20050113a

– HTTP Server: Apache/1.3.33 (Unix)

– PHP Version: 4.4.2 (Zend: 1.3.0)

– Database: MySQL 4.0.20-standard

As far as I know there has been no database name change and no path changes. I will double check…

[bb144]

Hello,

Has there been any progress on an SJA for FreeBSD o/s? A lot of ISP's are using FreeBSD these days and I sure could use the tool as soon as possible. In fact, my purchase of your enterprise product depends upon it!

Thanks for your help!

[Author]

Posts