[peterlaursen]

Is it COMMUNITY (free) or ENTERPRISE version you are using?

[peterlaursen]

Create a ticket from the link in 'about us' (top menu).

I have no experience with Chinese but from control panel .. regional settings you can change the locale.

that is the only option.  As a non-unicode program SQLyog needs the locale of the OS to be chinese is chinese shall be supported! I once have managed Thai and Arabic in SQLyog that way in combination with the Windows 'character map'  (start menu .. accessories .. system tool).  

hex-numbers of characters will not work from the GUI, but I think that they will work from a text file with LOAD DATA LOCAL INFILE (That is the same as 'CSV-import' in SQLyog).   (that is a bug with MySQL actually – 

there is no option to specify a charset for LOAD DATA – it will come with 5.0.38 only.

After 5.0.38 you should be able to “LOAD DATA LOCAL INFILE CHARSET BINARY … “)

Now if you create that ticket I'll araange that you get the next Unicode build for test.  Will be this week.  Maybe even tomorrow!

[peterlaursen]

How do you connect?

With HTTP-tunnel every query creates a new connection.  That is not a SQLyog issue, but a PHP issue!

However you can try changing the _connect to _pconnect in the tunneller as described here:

http://webyog.com/faq/21_103_en.html

If you need help, please write back.  

Can't you simply raise that setting?  Normally it is set as “0” – meaning “no limit”.

[peterlaursen]

“When I copy from one of these cells into SQLYog, what gets pasted in is just '???' .. that happens because Excel encodes as Windows Unicode (UTF16) – what SQLyog cannot handle internally.  

Internally SQLyog only recognizes ANSI.

You can store a unicode as a character set (ucs2, utf8) or a non-unicode character set ('big5' for instance') as you like.  

But SQLyog cannot handle unicode internally.  For the connection manager you will have to choose a chinese non-unicode character set (like 'big5).  The MySQL server will than transform when sending and recieving.

But copy-paste from Excel to SQLyog won't work.

We will release the first SQLyog (beta) with unicode support in a few days. that will make things easier.  Do you want an early beta for testing?  If so create a ticket and we will let you have one maybe even tonight or tomorrow.

a FAQ: http://webyog.com/faq/34_102_en.html

(but that we change soon!)

[peterlaursen]

1) I think you are mistaken that you did not allow password login.  the setting

“PasswordAuthentication no” only applies to sftp I think.  

In the general setting it says

# Change to no to disable tunnelled clear text passwords

#PasswordAuthentication yes

and as every thing is commented out defults are active – and defaualt is 'yes'.

But this of course no reason why key authentication should fail!

do we agree so far?

[peterlaursen]

First suggestion is that you write what SQLyog version you are using. You should use latest version (5.25 or 5.26 when available in a few  days).  There were some small fixes related to Vista around 5.23 (most imporatant a specific API call (that works OK with all other Windows versions!) generated an infinite loop that consumed CPU and made the User Interface nonresponsive and 'flickering') .  

On 2 vista systems here it runs fine now.  But we never tested any version in depth before 5.2x on Vista.

[peterlaursen]

hmmm .. OpenBSD – not every day we meet this OS.  There could be some special issue.

Today Monday is national holiday in India.  We will not be able to work on this untill 2morrow.  I think we will need to provide a build that does more logging and/or debugging.  But let me discuss with the developer 2morrow morning.

[peterlaursen]

I replied in your ticket!

[peterlaursen]

We can reproduce this if the text-box for the private key is left empty.

That happens because of the structure of the parameterlist for the PLINK command that SQLyog executes internally.

however you write “I.. selected the private key”

.. are you perfectly sure that the text box was not empty ??

We will make sure that PLINK/SQLyog does not try to connect with an empty string for in the next release. We will simply validate for that before generating the connection string.

There is one more issue actually. And that is that if the SSH server is not configured for PK/PK authentication then is silently ignored on the server side and you can choose the option (and even enter a Word-file for the Private Key) if you like – SSH connects with password authentication if the 'passphrase' given is the user 'password'.

Finally always check for 'orphaned' PLINKs in the task manager, when SSH behaves weird.

[peterlaursen]

Quote:

To me it looks like it is still trying to do a password login even if the public key button is checked, and when I have the ssh server set for no password logons it just times out.

I log on to two different servers with password and with passphrase (each at a time of course) – and the password and passphrase are different.  So authentication would fail for me when I tried public/private key authentication if you were right in this.

Give us a little time to discuss how to handle this!

Quote:

Also the help file instructs you to enter the path to your public key. I think it should be your private key

my mistake actually!  Will be corrected!

[peterlaursen]

Are you sure that the overrun with 5.21 and 5.25 happens with exactly the same data where 5.23 is successfull?

You can have more versions installed to different folders, so please verify again that this only depends on the program version and not the schema or data.

I understand that this happens in the wizard.  

At exactly what step of the wizard does it happen?

Can you execute a sync job from commandline successfully?

I also suggest that you attach the jobfile and a small SQL-dump (one for each host actually) to reproduce with.  

Now we want to get to the bottom of this!

[peterlaursen]

We will check this again.  Maybe some mistake was doen with the Community version.  With Enterprise I cannot reproduce.

[peterlaursen]

We absolutely did not change anything in this respect!  So it is very strange what is happening here.

Maybe a compiler/linker bug ?!

would you mind try:

http://www.webyog.com/downloads/betas/not_…d/SQLyog526.exe (community)

http://www.webyog.com/downloads/betas/not_…QLyog526Ent.exe (registered)

http://www.webyog.com/downloads/betas/not_…526EntTrial.exe (trial)

[peterlaursen]

you are right!  There is a small GUI bug here!

[peterlaursen]

hmmm … wonder how the semicolon got into that link 🙁

[Author]

Posts