[peterlaursen]

Beta 3 on WINE.

Beta3 on WINE has the same issue as BETA2. However I installed to /home/peter/programs/SQLyog (as I have been doing with all previous YOGs since 5.0. It cannot create the favorites as /home/peter/.wine/drive_c/SQLyog/favorites . All version from 5.0 to 5.12 beta1 could.

If I instal to /home/peter/.wine/drive_C/Program Files/SQLyog there is no issue. The favorite folder is created in /home/peter/SQLyog/favorites succesfully. And program works in every expect for the CTRL+ENTER and CTRL+SPACE functionalites of 'autocomplete'. No change in that.

Did you change the syntax of the folder in the installation script? I have difficulties in explaining this any other way! I don't think I have updated WINE in beteeen. But it is no issue then – it just has to be documented.

[peterlaursen]

Well again … it is one piece of the 'puzzle'. It is only in the end we know how important that piece is compared to others. Maybe the SQLite code interacts with some other libray an unforseen way (could be a bug with our code, with SQLite, with the compiler or even windows itself – or more or them at the same time) .. maybe that happens only when certain drivers or even CPU are present on the system .. maybe there is a memory buffer somewhere else that 'overflows' and corrupts the SQLite memory space … maybe .. maybe

We have examples where it (one the same system) sometimes crashes silently, sometimes displays a 'buffer overrun' message and sometimes runs without problems.

Could I ask to try the latest DEBUG BETA version and see if it throws up an error with a memory stack?

It is this one http://www.webyog.com/betas/SQLyog512EntDebug.exe (just install to another folder). Just zip it and attached it here if it does.

[peterlaursen]

I wish I could answer your questions! If I could it was too late to ask them now! Because there would have been no issue then.

Why does it only happen on .. say .. around or less than 5% of systems (numbers are just a guess) ? And why is the way it manisfests itself different form system to system? You cannot write an open paranthesis. Others cannot acces their favorites older.

Any detail is part of the 'puzzle'. And when details enough have been brought to light and have been ordered you can imagine the full picture, But if your detail is in upper right or lower left corner of it I don't know. The bug in the code could be 500 lines away from the place where it crashes. And I am not sure there is a bug in the SOURCE code at all. Compiler/build issues .. ?? It could be fun to try building with a Borland and not a Microsoft compiler for instance .. just to wee what difference that makes! They do not generate the same BINARY code.

I don't know how complete the puzzle is for Ritesh and the people back in India at this very moment.

But of course you can be perfectly sure that every bit of code around this place where it happens ofr you will be double-checked .. by several persons independently.

[peterlaursen]

Holy Cow .. I know this person from a Danish IT-Forum about 4 years back …. 😀

There are two questions here I think:

1) Your legal rights

2) Your practical/technical possibilities.

1) License terms (for PRO and ENTERPRISE) simply state that you have the right to install to one computer for each License purchased and have free upgrades and support for a year. After that year you must pay for an new license (PRO) or an upgrade (ENTERPRISE) if you still want to be able to upgrade. But you can of course continue using an old version as long as you like without purchasing an upgrade. If you need to move it nothing forbids that.

2) The technical possibilities and limitation follow the common shareware concept of a KEYGEN mechanism. To make the program work you must enter a USER and a REGISTRATION CODE. To be functional those must 'match'. The 'match' is verifed with various sorts of hashing, encryption and similar algoritms. Such mechanism can be pretty weak (SQLyog 3 and 4 was pretty weak!) or pretty strong (5 is) and they can be more or less difficult to recover from bit patterns on the hard disk where things have been permanently or tempoarily stored. BUT there is NO WAY with such system to prevent a repetition of the registration proces (no matter how strong the algoritms are) on another computer. Computer B can by no means know if computer A has done the same thing two weeks ago. So …

1) yes: I you want to move to another computer, you can easily do so. Comuter B does not know what Computer A has been doing lately. How should it? You don't even need to be connected when registering!

2) and: The binary installer linked to in your confirmation mail and the registration details there will always be usable together – at least on all type of Windows systems (including WINE) that we know today. There is no 'expiry' built in (there may be in BETAS and RC's as we don't want people to use them forever !!!) .

and this you did not ask:

3) we don't use ACTIVATION either. (that is linking the validity of the license to a specific hardware configuration where it was first registered). With a low-priced product like SQLyog ACTIVATION (like Microsoft, Adobe etc. do) is out of question – those activation server systems are simply too expensive to access. And involves a lot of monkey work in helping people out when they change hardware – maybe simply because it is broken and they need to. This does does mean that some hardware information cannot be used with the KEYGEN (using the serial of the harddisk where it is installed as part of the 'seed' for a random generator generating an encryption key could be done for instance). But still that will not prevent install on other systems.

4) And actually .. when uninstalling SQLyog the registration information is not removed from the system. So once you install again on that computer it won't ask for details next time. Unless those 'information bits' (whatever it is 🙂 ) have been deleted/overwirtten (by reformatting, by restoring (parts of) a backup from before SQLyog was installed etc). This can actually be a little problems in special situations. If you purchase a second-hand computer with Windows installed and where SQLyog has been installed before (but not there anymore), you will not be able to enter your registration details as there are allready the registration details of a previous user. An issue for us to consider, I think. Also we have had quite a few situations where some person has (thoughtlessly) registered to himself when purchasing and not to his company/employer!

We belive that SQLyog is an attractive 'found' for its price. Of course some may 'borrow' a copy of some registration details. Every engineering student can crack a 3000$ autoCAD in 5 minutes (I think I remember something about that … ). .. and undoubtedly SQLyog can be too. But in our county a personal copy of SQLyog Enterprise costs the same or less than a theatre ticket or 100 cigarettes .. is it worth it?

[peterlaursen]

No not here .. I can easily do as you describe .. see attached!

Did you read this: http://www.webyog.com/forums/index.php?showtopic=2094

There is this issue that SQLyog on some systems SOMETIMES crashes silently and SOMETIMES displays a 'buffer overrun'. But is is only on some systems .. and it differs from system to system how it manifests itself. Very often it happens when the program tries to read or write the 'favorites' folder

It it much more complicated than just a coding bug with 'autocomplete'. It is an issue with the STRUCTURE of the binary that causes problems (windows internal multitasking problems?) with some low level routines of the Windows Kernel (such as the file system routines for instance). You cannot just spot 5 lines of code .. and say 'here it is'. Because what piece of code that triggers that varies from system to system on those systems affected.

Just like when you try to sit down on a chair that somebody just removed (or did not put in place) 1/10 second before that. Except that a few people here would crash SILENTLY 🙂

I think it is a BUILD issue primarily, not a CODE issue. There may be nothing wrong with the SOURCE .. buth the BINARY certainly has some problems!

But thanks anyway .. I don't think we have seen this variation before!

[peterlaursen]

about REBUILDING TAGS:

you can disable the actomatic REBUILD from menu .. tools .. preference and do it manually from powertools. You can also completely disable autocomplete.

It it not the size of the DB that influences then BUILD time. No. of rows does not matter. It is the number of objects (tables, columns etc). In other words STRUCTURE/METADATA and not DATA.

Also if SQLyog is the only client used for modifying the structure there is no need to rebuild (except for possible repair). For instance if SQLyog does an ALTER TABLE that adds a column to a table, it also does a INSERT to the emebdded database – or rather to the cached copy. And this cached copy is saved when program closes (but not if it crashes, of course …)

[peterlaursen]

“probably the Favorites option dont work in Suse”

The favorites feature work fine on WINE/SuSE 10 here on all the 5.1.x versions that I tried except 5.12 Beta2 (that includes all 5.1 betas and RC's, 5.1 Final and 5.11)

[peterlaursen]

I research a little and found this:

http://stunnel.mirt.net/

If you want to experiment with this you are on your own!

We provide SQLyog Enterprise for SSH-encrypted connections to MySQL.

[peterlaursen]

@Ritesh .. you do not seem to understand!

When he runs a query from another QUERY tab, RESULT tabs from the first QUERY tab disappear.

I think an ability to prevent that disappear – (a lock/unlock switch on the tab itself for instance) would be a nice usability improvement. And I have added it to Eventum 🙂

[peterlaursen]

Quote:

Why do you want to run under Cygwin?

I think he tries to run SJA for Linux on cygwin on windows. As the SJA-for-Linux binary is compiled for Linux and only that it will not run on other *nix – not cygwin either.

Quote:

Why do you want to run under Cygwin?

Well .. let me guess .. if it worked he would not need to pay for SQLyog Enterprise to run the SJA on windows 😀

[peterlaursen]

SQLyog does not change any files on the server. It has no access to do so either! It is only connection details that are saved to the sqlyog.ini file on your local machine.

“Since then I lost my connection between my client and the server” What client are you talking about here? A client on the server or on your local? If it the 'mysql' client did you change the port setting in the [client] section of the my.cnf file as well?

I have no experience with the 'stunnel' program and do not know what it does. Is this a client for Windows or a SSH-add on for Linux? Most people use Putty for creating a SSH connection to a shell session on *nix. There is no issue with running Putty and SQLyog at the same time. Do you use this 'stunnel' with SQLyog somehow? SQLyog Enterprise has a SSH-tunneller of its own.

“I did a “find” in the server but I didn't find any “my.cnf” “. I really do not understand how you can change the MySQL port without having acces to the MySQL configuration file. Are you sure that you started the search form the OS's root folder ('/' not to be mismatched with '/root') .It should be in /etc folder (guess it is Linux?)

Please explain a little bit more – if you still have problems.

[peterlaursen]

Maybe we should have considered doing it like this when we introduced the multiple tabs with version 5.0. I cannot tell how big a change this will be in code stucture. If too big a change for SQLyog we should consider it for SQLyogMAX http://webyog.com/faq/33_21_en.html I think.

Or maybe simply a lock/unlock feature on each result tab will do?? comments ??

[peterlaursen]

I think you are right is this!

We are aware that the SHH implementation will soon need a 'modernization'.

[peterlaursen]

I don't Ritesh will need that.

This is an issue on the client side – no a server issue.

I just think that things have been a liitle too 'tense' the last week for Ritesh fully to consider this – due to the MySQL Users Conference and the crashing bug.

[peterlaursen]

Sure …

You should have a look a 'Notifications Services'. With it you can schedule execution of an SQL-script. But the script must be (as of now) be hardcoded into the XML jobfile. It will take a litte programming to dynamically generate XML-jobfile – simply replace what is between the and >/SQL> tags.

If you can generate a CSV file you can import using the LOAD DATA INFILE statement and it can be an external file.

I cannot guarantee when but some day in the future (it is not highest priority) we will also support import of XML-data. Also implementation of a SOURCE statement like that of the Windows 'mysql' client has been proposed. A godd idea but again: no guarantee when.

You will need the Enterprise version to test the possibilities. The TRIAL is fully functional for this.

You may even be able to set up a batch file or a simply script/application that first calls a the source somehow, generates the SQL, inserts it dynamically in the XML and next calls a SJA Notifications Job that does the import. It is not very complicated, but you will need to code something yourself (using any scripting or programming language that can execute a external binary program file and has simple string-handling routines).

The CSV option and using a LOAD DATA INFILE with 'Notifications Services' is the most straightforward option right now.

[Author]

Posts