search

dbeaver / dbeaver

Free universal database tool and SQL client
https://dbeaver.io
Apache License 2.0
38.72k stars 3.35k forks source link

PostgreSQL отладка, как стартовать? (Debug: How to start?) #3261

Closed sgrinko closed 6 years ago

sgrinko commented 6 years ago

На мой вопрос об этом в задаче 2556 я получил ответ:

  1. open the procedure from the "Databases" view
  2. switch to "Sources" tab
  3. enable the "Omit procedure header" to sync line numbers #3257
  4. Use "Debug As" -> "PL/pgSQL Procedure" context menu item to configure and launch the debug

не могу выполнить пункт 4, так как в контекстном меню у меня нет такого пункта: default что я делаю не так, как всё же активировать режим отладки? PS. если можно, то напишите ответ по русски.

ENG

To my question about this in task 2556, I received the answer:

  1. open the procedure from the "Databases" view
  2. switch to "Sources" tab
  3. enable the "Omit procedure header" to sync line numbers #3257
  4. Use "Debug As" -> "PL/pgSQL Procedure" context menu item to configure and launch the debug

I can not execute item 4, because I do not have such an item in the context menu: default

What am I doing wrong, how can I activate the debugging mode?

ruspl-afed commented 6 years ago

Sorry for not highligting the prerequisite covered by #3255 , Please switch the perspective to "Debug"first : this will enable the platform debug capabilities. You can do it via main menu "Window -> Perspective -> Open Perspective" for example

sgrinko commented 6 years ago

Я переключался на "Debug" перспективу, но это никак мне не помогает. Что ещё не хватает? На самом кластере всё, что нужно для отладки стоит. default

PgAdmin III успешно выполняет отладку... default

ruspl-afed commented 6 years ago

Hmm, do you have this instaled? https://marketplace.eclipse.org/content/dbeaver-sql-debugger

sgrinko commented 6 years ago

Я только лишь скачал и установил версию: Windows 64 bit (installer + JRE) В этой версии нет Marketplace как и я не нашел в списке такого плагина dbeaver-sql-debugger Очень не хотелось бы устанавливать весь Ecipse и ставить в него DBeaver как плагин. Как это сделать в рамках текущей инсталяции?

ENG

I just downloaded and installed the version: Windows 64 bit (installer + JRE) In this version there is no Marketplace as well as I did not find in the list of such plug-in dbeaver-sql-debugger I really would not like to install the whole Ecipse and put DBeaver in it as a plug-in. How to do it in the current installation?

ruspl-afed commented 6 years ago

@serge-rider , do we have a possibility to install marketplace features to DBeaver CE?

ruspl-afed commented 6 years ago

Interesting, there is link to marketplace, but there is no marketplace client inside Looks like one need to do some extra steps.

Please go to the Help->Install New Software And add another update site with URI "https://dbeaver.jkiss.org/update/debug/latest/", like image

Then you need to install it via image And it should be available after restart

sgrinko commented 6 years ago

Error: default

An error occurred while collecting items to be installed session context was:(profile=DefaultProfile, phase=org.eclipse.equinox.internal.p2.engine.phases.Collect, operand=, action=). No repository found containing: osgi.bundle,org.apache.commons.cli,1.3.1 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.ce.feature,5.0.2 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.ce.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.core.application,5.0.2 No repository found containing: osgi.bundle,org.jkiss.dbeaver.core.application.nls,5.0.2 No repository found containing: osgi.bundle,org.jkiss.dbeaver.core.nls,5.0.2 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.db2.nls,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.ext.db2.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.derby.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.erd.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.exasol.nls,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.ext.exasol.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.firebird.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.generic.nls,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.ext.generic.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.h2.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.hsqldb.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.import_config.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.informix.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.mssql.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.mysql.nls,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.ext.mysql.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.netezza.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.oracle.nls,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.ext.oracle.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.phoenix.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.postgresql.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.sample.database,1.0.17 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.sample.database.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.sqlite.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.teradata.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.ui.locks.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.vertica.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ext.wmi.nls,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.ext.wmi.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.model.nls,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.rcp.feature,2.1.55 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.rcp.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.runtime.ide.core.nls,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.runtime.nls.feature,1.0.12 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.standalone.feature,5.0.2 No repository found containing: org.eclipse.update.feature,org.jkiss.dbeaver.standalone.nls.feature,1.0.12 No repository found containing: osgi.bundle,org.jkiss.dbeaver.ui.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.utils.nls,1.0.12 No repository found containing: osgi.bundle,org.jkiss.wmi.nls,1.0.12

sgrinko commented 6 years ago

может быть будет проще этот плагин включить в сборку заранее?

serge-rider commented 6 years ago

Well, there are two different issues here.

  1. To be able to install extension you have to install DBeaver in some non-write protected folder (e.g. not in Program Files on Windows). Errors you see are result of inability of Eclipsep platform to install new plugins.
  2. CE version isn't bundled with Marketplace. You can use Install New Software menu. All this stuff is described here: https://github.com/dbeaver/dbeaver/wiki/Optional-extensions
sgrinko commented 6 years ago

Мне удалось установить плагин через запуск под администратором. Согласен, что это было не очевидно... и стоило обратить на это внимание сразу. default Однако после попытки старта отладки, что-то всё же идет не так: default возможно, что проблема состоит в том, что я использую SSH тунель который стоит снаружи программы DBeaver и поэтому не удается установить коннект.... я прав? default ? PS. Пожалуйста пишите по русски тоже ответ.

ENG

I was able to install the plug-in by running under the administrator. I agree that it was not obvious ... and it was worth paying attention to it right away. default However, after trying to start debugging, something still goes wrong: default it's possible that the problem is that I'm using an SSH tunnel that stands outside the DBeaver program and therefore can not connect .... I'm right? default

sgrinko commented 6 years ago

Я попробовал переключиться на SSH тоннель через интерфейс программы, но запустить отладку так и не удалось.

ENG

I tried switching to the SSH tunnel through the program interface, but I could not start the debugging.

serge-rider commented 6 years ago

It should work (and it works) with SSH tunnel. Most of our test databases are remote and use SSH all the time. We have brand new WIKI article about PG debugger: https://github.com/dbeaver/dbeaver/wiki/PGDebugger

(sorry, it takes too much time to write messages in two languages, so let's use the one which is understandable by the most users)

sgrinko commented 6 years ago

В конце-концов мне удалось запустить отладчик. Конечно мне очень помогло описание в wiki, спасибо! Надеюсь, что в будущих версиях вы существенно облегчите этот процесс и он станет таким же простым как в PgAdmin III issue можно закрыть

ENG

In the end, I managed to start the debugger. Of course I was very helped by the description in the wiki, thanks! I hope that in future versions you will greatly facilitate this process and it will become as simple as in PgAdmin III issue can be closed

serge-rider commented 6 years ago

Great. Yep, we are working on that. Hopefully PG debugger will become fully functional till 5.1 release. And we'll include it in DBeaver CE distribution. Thanks for testing.