[marcm]

Ok so does that mean it runs as a service or something on startup?

[marcm]

Hey Peter,

Thanks for your response. I went ahead and purchased my first license of MONyog. I will probably run it on my hosted server.

So, let me clarify something with you. Since MONyog is agentless, does this mean that it will only be working when it is opened in a browser window? Will I be able to receive alerts from MONyog if there is a problem with my MySQL server when I don't have MONyog open in a browser window?

Also, I believe I read in a review that the database login data that I provide is stored in SQLite, is this correct? Where exactly on the server will my secure database info and SSH info be stored? What sort of risks are there for this information being compromised?

I'm sure I'll have some more questions as I go but I wanted to say thanks and ask you the above questions before I decide where to install it.

-Marc

[marcm]

Ok. Thanks to both for clearing that up. It's good to know that I can use https in a pinch, but I'll rely on the SSH Tunneling for speed and security.

[marcm]

No, that's it. I was just curious to know if connecting to my host with https (while not using the tunneling tab) is secure or not. Is that any more or less secure than using the SSH Tunneling tab?

[marcm]

peterlaursen wrote on Jun 7 2006, 08:45 PM:

Not required, I think!

Even when inserting first row of data I get this!

When clicking the mem_date_created column the corresponding NULL value pops up 30-40 characters to the right. SQLyog 5.14 beta2.

Aha! Well, I'm glad you have been able to recreate it. I'm sorry that it's there, but at least now you guys can target and fix the bug.

[marcm]

peterlaursen wrote on Jun 7 2006, 03:48 PM:

Now look here!

I have a similar thing here with this Forums database itself!

I click the 'created_data' column and data pops up somewhere else!

@Ritesh – it is the 'phpbt_auth_user' table!

@marcm: can we have your database schema?

Aha!

Here's a SQL statement for just one of the tables…

CREATE TABLE `sitemembers` (

`mem_id` int(11) unsigned NOT NULL auto_increment,

`mem_gender` char(1) default NULL,

`mem_firstname` varchar(32) NOT NULL default '',

`mem_lastname` varchar(32) NOT NULL default '',

`mem_username` varchar(32) default NULL,

`mem_email` varchar(64) default NULL,

`mem_password` varchar(40) default NULL,

`mem_level` tinyint(1) unsigned NOT NULL default '0',

`mem_notice` tinyint(1) unsigned NOT NULL default '0',

`mem_deleted` tinyint(1) unsigned NOT NULL default '0',

`mem_date_created` datetime default NULL,

`mem_date_modified` datetime default NULL,

`mem_last_logon` datetime default NULL,

`mem_number_logons` int(7) unsigned default '0',

`mem_newsletter` tinyint(1) unsigned NOT NULL default '0',

`mem_email_format` tinyint(1) unsigned NOT NULL default '0',

`mem_active` tinyint(1) unsigned NOT NULL default '0',

`mem_agree` tinyint(1) unsigned NOT NULL default '0',

PRIMARY KEY (`mem_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

Let me know if you need more info/data…

[marcm]

I figured that – since the directory is 'beta' 🙂 I downloaded it at 8pm last night.

[marcm]

Ritesh wrote on Jun 7 2006, 12:24 AM:

@marcm:

Are you sure that you using 5.13 FINAL?

The speed issue has been fixed in 5.13 FINAL. Check a similar post at:

http://www.webyog.com/forums/index.php?showtopic=2186

We are working on the other issues that you have mentioned.

Well, I got it from this link:

Enterprise Trial Edition: http://www.webyog.com/betas/SQLyog513EntTrial.exe

Is this the correct link?

[marcm]

I'm using 4.1 and 5.13 Enterprise trial edition. Yes, I'll provide you with a sample table – I'll try to do this in a bit.

As for the mouse, I'll see if I can track one down. My bro might have one. I have several, but they are all in storage right now and I won't be getting there for a while unfortunately. I'll check with my brother tomorrow on the mouse thing.

[marcm]

Hello again!

I finally got around to reinstalling the enterprise trial because I'd like to test the SSH feature before I buy. This time I made sure my system was fresh, with nothing running at all. I installed into a new directory so I still have 4.1 running. Unfortunately, I'm still getting some cursor probs with the new version. Also, I wanted to point out that the general response of the table data window, when clicking on fields, is very slow/sluggish compared to the zip of 4.1. For example, when I click on a field, it sometimes takes a second for the field to become active. Also, I've noted some other interesting behavior that you might find handy. Say if I double click a field in row 3 of a table, if the cursor does jump to the right, I also notice that the scroll bar at the bottom of the table data window moves as if it's adjusting the position of the selected field. But for some odd reason, the rest of the fields don't always move with the scroll bar and the selected field. I've also noticed different behavior if I use the enter button instead of the double click. When I use the enter button, the rest of the window scrolls properly and the field is high-lighted properly.

Here's another strange thing I've found – and that is if I select row 1 and then select a field, when I hit enter, instead of selecting that field, it moves to the next field. Where if I'm on row 2 for example, the same enter key stroke selects and high-lights the proper field. That is two totally different behaviors with the same key stroke on two different rows. That seems to be software related and not video card driver related. Maybe you will be able to repeat that? Also, I think that if you can prevent the window from scrolling when selecting a field, then you would probably eliminate this cursor issue altogether. Something to consider. In fact, that may be the difference with 4.1, because I don't see it jump around much when I select a field. Finally, when selecting fields in the newer version, sometimes it creates a new empty row for no apparent reason, I don't recall having that problem with 4.1.

I hope that this is helpful for you guys. I really love this software, so keep at it…

[marcm]

Hi again Peter,

I understand why you suggest reinstalling the video drivers, but that still doesn't explain why it works fine in 4.1. I would think that if it were as simple as a video driver, then it would affect all versions. Anyway, I haven't tried reinstalling anything because I'm in production at the moment and I don't have the time or actual need to mess with it right now.

As for my version of Win2k, I do have all the security patches. I haven't upgraded because I have some very expensive 3d software that I run on this box that could have problems if I upgrade (unless I also upgrade the 3d software, which costs big $$ and I'm happy with the system as it is). I've been in computing for a long time and one thing that I've learned is that chasing hardware and software can be an expensive and time consuming thing. I leapfrog technology when necessary, but if I have a stable system that does what I need it to do, then I try to use it as long as I can. I have a second machine that I use for rendering and audio production, and I might be able to try this software on that box.

As for my hardware profile, I am using a Logitech cordless optical mouse. I've been really happy with this mouse, so I wouldn't exactly call it crap. But Logitech does make some crap, and most manufacturers have made crap, Microsoft included. I'm using a GeForce Nvidia card with Nvidia drivers. Now again, I would like to point out that I have all sorts of applications, from high end 3d, animation and graphics software, web developments apps, word, excel type apps, other db design apps, etc. I could go on. I have had no problem with any piece of software whatsoever. So, if I look at that record, and then look at the problem I have with the cursor, my guess is that it's the software – especially since 4.1 works like a charm. Something must have changed in the software.

However, having said all that, if I have some time, I will reinstall the latest version in a new directory and I'll see if I can experiment with some drivers, etc.

[marcm]

Ritesh wrote on May 29 2006, 05:50 AM:

Was your CSV export issue *NOT* present in v4.1?

This bug should be there for v4.x to the latest one.

Hi guys,

The CSV problem exists in both versions for me. However, the cursor prob doesn't exist in 4.1. I would think that if it were a problem with my system, then it would show up in 4.1 also.

[marcm]

peterlaursen wrote on May 27 2006, 03:25 PM:

“I'm running 5.2 on Win2K”

Do you mean that you are running SQLyog 5.12 on Win 2K?

On Win2K we always need more info! SP-level?, a 2K-server or a 2k-'ordinary'? There are so many 2k-variants …

“I didn't have this problem with 4.1.”

Exactly what problem did you not have with (SQLyog) 4.1?

Do you mean that the 'mouse-cursor' and the 'keyboard-cursor' is not synchronzied, so that keyboards writes in another cell than mouse selects?

This is what I understand from your pictures.

No other program does similar things? Spreadsheet programs for instance?

.. my first inpression is that your system must be sick ….

How goes the CSV-thing?

Uh, no, my system is far from sick. It's actually rock solid. I run Service Pack 2. It's ordinary, not Server.

Yes, you nailed it, I did not have the keyboard curser error in 4.1 or in any other software for that matter. (spread sheets included) I run a variety of software and I have no probs, this is an isolated issue. I've given up on the CSV problem for now. I also have reverted back to 4.1 for now and the cursor prob is gone.

Thanks for your help and interest.

[marcm]

Here's the image of the edit field error. I'm running 5.2 on Win2K. I didn't have this problem with 4.1. It also inserts a new row without me asking it to at times. Note that I'm using MySQL 4.1 one Win2k. Below the image is a sample table structure for the CSV problem..

Note that the fields that are highlighted with a black border are the fields I double clicked on to edit…

CREATE TABLE `categories` (

`categories_id` int(4) unsigned NOT NULL auto_increment,

`pr_types_id` int(3) default NULL,

`cat_name` varchar(32) NOT NULL default '',

`cat_date_added` date default NULL,

`cat_date_modified` date default NULL,

`cat_status` tinyint(1) unsigned NOT NULL default '0',

`cat_item_count` int(11) unsigned default NULL,

PRIMARY KEY (`categories_id`),

KEY `categories_index2` (`pr_types_id`)

) ENGINE=InnoDB DEFAULT CHARSET=latin1

[marcm]

Wow, hello there, thanks for your reply. Here's what I can tell you:

1. I was trying to import through the table menu.

2. The CSV file was made by SQLyog! I was trying to export the data from my local MySQL and then import it into my Live MySQL database – both through SQLyog.

3. Here is an example of a line from the CSV file generated by SQLyog:

1;1;\N;\N;”Architecture”;2005-09-21;2006-05-26;1;6

I tried many different settings, and some wouldn't import at all. This line is from my last attempt.

Fields terminated by ; Optionally enclosed by “, Escaped By \ , Lines Terminated by n

I used these settings for both export and import.

I tried with column names at the top and without.

So, at this point I switched to using SQL insert statements generated by SQLyog, but I can't 'replace' or 'ignore' rows as far as I know.

Does the free trial of the enterprise version let me experience the data synch functions? I plan on upgrading, but it would be nice to see that working first.

Also of note, since I upgraded to 5.2 from 4.1 I notice that double clicking on a field in my result set (especially if NULL) yields strange and unpredictable behavior. Like the editable part appears to the right or the result set jumps around – it never did that before! Maybe I'll revert back to 4.1…

Thanks for your help!

[Author]

Posts