Forum Replies Created
-
AuthorPosts
-
peterlaursen
ParticipantPlease read:
http://webyog.com/faq/content/23/36/en/i-g…t-connect-.html
If you are connecting as 'root' then first try with another user.
peterlaursen
ParticipantFrom your description I can tell it is basically correct what you are doing.
1) Isn't there a little more information than just 'error 1'? Could just paste a screenshot of this?
2) Maybe you could let us try? We will not need access to any data. Just create a user with no privileges at all.You can give details in a ticket.
3) Do you know positively that another PHP script in the same folder can connect to MySQL. I think we could help wiht such script, if you cant't!
I do not know IIS too well. If server was Apache I would suggest you try this: create an empty folder, copy the tunneller in there and turn off global directives for the folder by having an empty .htaccess there. Can you handle same for IIS or need help?
peterlaursen
ParticipantMy personal idea is that we should simply enable the BLOB-viewer if a 'newline' is detected – just like we do now if a NULL-byte is detected.
But I will have to discuss with the develpment team about this.
peterlaursen
Participantok .. with server 4.1 your SQLyog 7.02 and mine 7.1 beta behave different!
This may be a side-effect of a fix in 7.1 for varchars > 711 chars.
It also may be because our 4.1 server versions are not exactly the same. What is you version exactly?
But .. yes .. a totally empty cell in the GRID should not occur. We will research into it.
peterlaursen
ParticipantI do not understand what you are telling.
“If you have the usual row and column view you need to click on the “size” button to see the data.” What size button?
[attachment=976:ver4_1.jpg] [attachment=977:ver5_0.jpg]
Please see attached images. MySQL versions are 4.1.22 and 5.0.67 respectively. This is SQLyog 7.1 beta.
They both display for me in text-mode (text-mode is required for multi-line results). However it seems that in 5.0 the formatting of the returned string from the server has been improved (the image shows a word-wrapped view with 4.1 due to the result being one long string!
We cannot support multiline-results in GRID-mode. But we should display some indication that the result is a multiline result. I think this has been added to our issue tracker already. I will check this! I will also check why it does not display “status —-” in the grid. It does not look like first line is empty.
peterlaursen
ParticipantQuote:* How can I specify a “default”/”preselected” database for a given connection, yet at the same time not hide all other databases from the object browser view?The short answer is that you cannot! When a database is selected in the Object browser or the database dropdown, SQLyog sends a USE statement to the server and from now on this database is the “default”/”preselected” database – any SQL statement with no explicit database specification received by the server will be executed against the one selected. This is an implementation I do not see how we can change without causing other problems.
It is true that if you create a new database that is not specified in connection settings it will not be visible. I think (administrative) users that create databases wil normally not use this filtering option. But anyway .. in that siutation we could consider adding this database to the OB *for this session only*. This will be possible, I think, if the database is created from the menu – but not if created with a SQL statement in the editor (SQLyog does not parse SQL statments in the editor – it is the server that does).
peterlaursen
ParticipantWe have reproduced this on a machine running Fedora3 and Wine 0.9x. On a machine running Ubuntu and Wine 1.0 it is not reproducable. We also believe we have fixed but the fix is not fully tested yet.
So maybe it depends on graphcis hardware and driver more than Wine and OS.
However with 7.1 you can resize the window. Won't it then display correctly next time you open on that configuration?
peterlaursen
ParticipantOk ..
I am told that there is information (user@host info for every connection) in the general log that makes it possible to tell when, how many times etc. a specific ip connected in a time interval. But still it will only tell 'localhost' for those that connected through a website or a webserver script (like phpMyAdmin and SQLyog tunneller). Also with SSH connections to the server (with Putty, With SQLyog SSH-tunnel) the client host will be 'localhost'. For those the webserver log and/or OS logs will be required.
This is not the purpose of MONyog log analysis currently. The purpose is to identify SQL statements with certain properties (mostly inefficient SQL statements).
A log analyser module doing user and host/ip-statistics would be quite a new task. And with the limitations of the first paragraph in mind I doubt that we will ever do it.
peterlaursen
ParticipantWe cannot have a “backdated 'processlist' output”. That would require the processlist page was running always and data stored. You would need huge amounts of storage.
I am not sure if the general log has information about the client ip? Do you know? Parsing the log for this information would be the only chance.
But all users using a PHP application running on the server (like this Forums) for instance will connect to MySQL from localhost. MySQL does not know what is the ip/host of the user. This would require simultaneous analysis of webserver log and MySQL log, I believe (and will probably never be accurate anyway).
peterlaursen
ParticipantActually in very early (internal) 7.0 builds we had an option to sync left>right and right>left. But in combination with the hide/filtering options it was very confusing. Even our developers and testers and I could not agree how to understand the interface. So we removed it.
What we can consider is an option (like a button) that reverses/swaps the selections in source and target dropdowns. What say?
peterlaursen
Participant1) The arrow navigation in query area does not move focus from tab to tab. It moves/shfts the *whole query window* so you can use more tabs than what can be displayed at a time. So it is only active if there are more tabs than what can be displayed in the query window area and horizontal scrollbar has appeared. A guy named Ritesh implemented like this, I believe! Does it behave like described here or not?
2) Additionaly we implemented in 7.1 that query tab navigation is possible through ctrl+pgUp and pgDown keyboard shortcuts
3) We were able to reproduce that “d” was partially stripped in “save password” label. This is added to our issue tracker.
peterlaursen
ParticipantOne more detail. The window is resizable on the build I linked to above. The setting when program is closed is stored in .ini and used next time program opens.
peterlaursen
ParticipantOn my laptop runnning Vista that also has 1440*900 the sync window displays OK. It must be an issue with VMWARE on Mac! But I am not sure we ever checked this version with very low resolution. This I will ask our test team to verify!
peterlaursen
Participantdid you see this: http://www.webyog.com/forums//index.php?showtopic=4126
changelogs for 7.1 beta3 will have this fix
Quote:* In Wine Schema Sync could generate an erroneous sync script (specific functions on Wine functioned slightly different than the original Win32 API).This build
http://www.webyog.com/downloads/betas/not_…Lyog71n3Ent.exe
.. fixes the issue reported by the other user. If it does not fix yours, please post a reproducable test case (here or in a ticket).
It is a problem with the wine tree-view control (that does not exactly as the original Win32 API)
peterlaursen
ParticipantI am not sure I understand,
Have you deleted the server from the registration page or changed those connection details? In such case the details are not stored any more. If you delete the server all data for this server will be deleted from the MONyog database too.
However if you only deselected the server you can just select again (there is a setting where you decide if data shall be collected from a deselected server or not). But then you will need a license for all servers you want to have registered.
-
AuthorPosts