Forum Replies Created
-
AuthorPosts
-
peterlaursen
Participantok …
1)
now first .. I think Supratik meant if you were using SSH connection to MySQL. But I understand that you don't. You are testing this Monyog build on a Linux machine and you are connecting to a MySQL server running on the same machine. Please confirm!
2)
Please attach screenshots of the 4 registration/configuration settings for this server (hide what *text* details you think appropriate)
* MySQL server details
* SSH server details
* Log analyzer settings
* Sniffer options (for completeness only!)
peterlaursen
Participant1) plase checked that you have checked the 'local file' option/radiobutton. I could think you you have SFTP option checked and entering path to a local file?
2) no clue from here rihgt now!
2.5 ships with new SFTP code, so probably *somehow related*. Was 2.0x was able to find the .pid file wihtout problems (for system counters) ?
peterlaursen
ParticipantFilter is there (in DATA tab – not in RESULT tab). Right-click in a cell of the grid …
We do plan a *custom filter* where user can enter his own value to be filtered on and even values for more columns. Priority not decided. Also filter in RESULT tab is considered.
peterlaursen
Participant1) Wordwrap is there .. tools .. preferences .. general .. enable word wrap …
2) Basic 'rich text' editing features is a long standing request
3) Also a simple HTML editor has been requested before. Actually that would make SQLyog more useful with *thousands* of standard PHP applications (Forums Software, Guestbooks, Blog software, Wiki's etc) that make use of BLOB/TEXT columns
4) My personal 'pet' is a hex-editor feature
5) even a simple media player has been requested (for playback of sound clips and video clips)
Actually the BLOG viewer accepts 'sort-of' 'plug-ins' (the current image viewer is basically such plugin – compiled as a .dll). BLOB viewer is identical in COMMUNTY and ENTERPRISE – everything is OpenSource. We take contributions … 🙂
Priority of BLOB viewer additions is not decided yet. We have some other issues that will take some months probably.
peterlaursen
ParticipantThere is no difference in how COMMUNITY and ENTERPRISE use the file system at all.
Could you try interchanging to two installations between the two machine?
No other programs have problems with storing data on mapped drives from the problematic machine?
peterlaursen
Participant“Also, the standard window box buttons on the upper right of the “document” window (minimize, close, unmaximize) do not work.”
I remember this issue wiht a specific Wine version. It was fixed in next release. But you are using 1.0, so that should not happen?
Anyway .. maybe an old bug found its way back to Wine?
peterlaursen
ParticipantAre you sure that that friend of yours do not have some firewall or router?
Your friend must open port 3306 on his computer if his MySQL server listens on this port. If not you will not be able to connect.
peterlaursen
ParticipantWhat is your Windows version? or Wine maybe?
peterlaursen
Participant1) First of all: are you sure that the MySQL server is running? If it is not, then you cannot connect to it of course! You can check from Windows service manager (controla panel .. administrative tools .. services)
2) Also you should ensure that the port no. is correct. It will normallly be 3306, but you can check in the server configuration file (my.ini). But if you did not cahnge this when the server was installed it will be 3306.
3) Please also confirm that you are trying to connect to a MySQL server running on your local machine. The way you describe your problem makes me uncertain about this. The local ip is '127.0.0.1' and the hostname 'localhost' will be configured in the local host file as a synonym for that ip in 99.99% of cases. So you should be able to connect to your local MySQL server with both of those settings
[attachment=934:ip.jpg] [attachment=935:hostname.jpg]
4) Some firewalls will block TCP-connections even to localhost unless you explicitly allow for connection. Do you have a firewall and which one? Especially there where lots of such problems with older versions of ZoneAlarm.
5) If you are trying to connect to MySQL on a remote computer, then your description of the problem is not very good. Anyway also here ensure that firewall systems on both the client machine and the server machine allow for connection. But in that case you may need to use (HTTP or SSH) tunnelling, or you may need to configure you hosting account (using the control panel application of the hosting service) to allow for remote connection for a specific ip or ip-range.
To upgrade SQLyog just download from here: http://webyog.com/en/downloads.php
.. and install 'on top' of the old version.
peterlaursen
ParticipantPrinting is supported in the Schema Designer (Enterprise feature) – currently nowhere else in the program.
peterlaursen
Participantfixed in 7.0 beta1
peterlaursen
ParticipantMaybe every detail is not described in google code. But we know about the issues. Hope to fix it all early in 7.x tree.
peterlaursen
ParticipantWe could add an option to define this setting from the client/connection.
However the feature is broken with recent server versions, unfortunately.
Refer to: http://bugs.mysql.com/bug.php?id=32223
What MySQL AB ends up doing about it is not yet clear.
What is this server version whre it works?
We have a few other examples that it was possible for our users to convince ISP Sysadmins to raise the setting. 16M was default before the (in my opinion) silly 1M default setting was introduced. ISPs have benn running 16M settings with 3.x and 4.0 servers for 5+ years. Maybe/Probably the ISP is not even aware of it!
Have you tried asking if they could raise the setting?
But true that connections created for data sync has no option to define user-defined 'initialisation statements' – what actually has been requested before!
peterlaursen
ParticipantIf you still have the old version could you try both on the same sample data at the same time?
peterlaursen
ParticipantWhy not change the server configuration to reflect the data you have on the server? I think it is *not logical* to keep a setting lower that the size of a single row.
We have no intention of splitting an INSERT statement into an INSERT + 1 or more UPDATEs in Data Sync. You will also get into problems with restoring backups! I know no backup tool that does that either
Also a single MEDIUMBLOB/LONGBLOB may still be larger than the setting, if it is low. Then there is no other solution than raising the configuration setting.
All you need to do is to insert into [mysql] section of the server configuration file like this
max_allowed_packet = 64M
(or whatever value)
.. and restart the server.
-
AuthorPosts