search

talek / vorax4

A simple yet powerful IDE for Oracle databases, built on top of the widely known Vim editor and Oracle SqlPLUS.
http://talek.github.io/vorax4
MIT License
53 stars 11 forks source link

Connection issues #78

Closed lagumen closed 7 years ago

lagumen commented 7 years ago

I have encountered these errors while logging in to SQLPlus;

Error detected while processing function vorax#sqlplus#Connect[2]..84_PrepareCstr: line 3: E117: Unknown function: vorax#ruby#ParseConnectionString E15: Invalid expression: vorax#ruby#ParseConnectionString(cstr)

Here's my current environment; :ruby p RUBY_VERSION :"2.4.0" :version VIM - Vi IMproved 8.0 (2016 Sep 12, compiled May 10 2017 21:49:13) Included patches: 1-586 Compiled by lagumen@ufc3fdb4521ef5913559e Huge version without GUI. Features included (+) or not (-): +acl +cmdline_hist -ebcdic -gettext +listcmds +mouse_sgr +persistent_undo +smartindent +textobjects +wildmenu +arabic +cmdline_info +emacs_tags -hangul_input +localmap -mouse_sysmouse +postscript +startuptime +timers +windows +autocmd +comments +eval +iconv -lua +mouse_urxvt +printer +statusline +title +writebackup -balloon_eval +conceal +ex_extra +insert_expand +menu +mouse_xterm +profile -sun_workshop -toolbar -X11 -browse +cryptv +extra_search +job +mksession +multi_byte +python +syntax +user_commands -xfontset ++builtin_terms +cscope +farsi +jumplist +modify_fname +multi_lang -python3 +tag_binary +vertsplit -xim +byte_offset +cursorbind +file_in_path +keymap +mouse -mzscheme +quickfix +tag_old_static +virtualedit -xpm +channel +cursorshape +find_in_path +lambda -mouseshape +netbeans_intg +reltime -tag_any_white +visual -xsmp +cindent +dialog_con +float +langmap +mouse_dec +num64 +rightleft -tcl +visualextra -xterm_clipboard -clientserver +diff +folding +libcall -mouse_gpm +packages +ruby +termguicolors +viminfo -xterm_save -clipboard +digraphs -footer +linebreak -mouse_jsbterm +path_extra +scrollbind +terminfo +vreplace +cmdline_compl -dnd +fork() +lispindent +mouse_netterm -perl +signs +termresponse +wildignore system vimrc file: "$VIM/vimrc" user vimrc file: "$HOME/.vimrc" 2nd user vimrc file: "~/.vim/vimrc" user exrc file: "$HOME/.exrc" defaults file: "$VIMRUNTIME/defaults.vim" fall-back for $VIM: "/usr/local/share/vim"

4.4.0-77-generic #98-Ubuntu SMP Wed Apr 26 08:34:02 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

Ubuntu 16.04 LTS

talek commented 7 years ago

That's odd... Is Vorax installed correctly? Is it the last version from github?

lagumen commented 7 years ago

Not sure if it is installed correctly but all dependencies I believe is in. How would i know which current control version is in my system? is there a line command for it?

talek commented 7 years ago

:echo g:vorax_version

lagumen commented 7 years ago

4.3.31

talek commented 7 years ago

It should be 4.3.55... How did you install it?

lagumen commented 7 years ago

---thru Vundle {Plugin 'vim-scripts/vorax'} ---installed some pre-requisites Ubuntu packages {ruby-dev, libxslt-dev, i.e} ---also installed ruby gems needed by Vorax:

sudo gem install nokogiri --no-rdoc --no-ri -- --use-system-libraries sudo gem install childprocess --no-rdoc --no-ri sudo gem install rubytree --no-rdoc --no-ri sudo gem install ferret --no-rdoc --no-ri

how can i get it to the latest control version? [4.3.55]

talek commented 7 years ago

Through vundle update I presume... I will try to reproduce it on a Ubuntu VM to see if I get the same error.

lagumen commented 7 years ago

I did the bundle update but to no avail

lagumen commented 7 years ago

*vundle

talek commented 7 years ago

please use talek/vorax4 as a plugin source within your vundle configuration

lagumen commented 7 years ago

just did .., now it's on ver 4.3.55 but still getting these;

Error detected while processing function vorax#sqlplus#Connect[2]..84_PrepareCstr: line 3: E117: Unknown function: vorax#ruby#ParseConnectionString E15: Invalid expression: vorax#ruby#ParseConnectionString(cstr) Press ENTER or type command to continue

lagumen commented 7 years ago

..., and this is the Oracle ver that is currently in my system;

» |$hostname 9:17:45| /home/local/lagumen/sqlplus sys / as sysdba

LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 11-MAY-2017 09:22:56

Copyright (c) 1991, 2011, Oracle. All rights reserved.

TNS-01106: Listener using listener name LISTENER has already been started alter system register; alter system set local_listener = '(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))' scope=memory;

SQL*Plus: Release 11.2.0.2.0 Production on Thu May 11 09:22:56 2017

Copyright (c) 1982, 2011, Oracle. All rights reserved. Enter user-name: sys / as sysdba Enter password:

Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production

SQL>

talek commented 7 years ago

It's working on my ubuntu VM:

talek@talek-VirtualBox:~$ cat /etc/issue
Ubuntu 16.04.2 LTS \n \l

sudo apt-get install vim-nox sudo apt-get install git sudo apt-get install ruby-dev libxslt-dev sudo gem install nokogiri --no-rdoc --no-ri -- --use-system-libraries sudo gem install childprocess --no-rdoc --no-ri sudo gem install rubytree --no-rdoc --no-ri sudo gem install ferret --no-rdoc --no-ri sudo apt-get install alien libaio1

talek@talek-VirtualBox:/bin$ cat ~/.vimrc 
" Use VIM settings instead of vi
set nocompatible

" This file is in unicode
scriptencoding utf-8

" [ADDONS MANAGEMENT]

filetype off
set rtp+=~/.vim/bundle/vundle
call vundle#rc()

Bundle 'gmarik/vundle'
Bundle 'talek/vorax4'

filetype plugin indent on

Install Oracle XE on your Ubuntu box.... . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh

Launch vim and connect using the following Vorax command:

:VORAXConnect system@XE

vorax_ubuntu

Please ensure you don't have some leftovers in your vundle bundle directory. My vundle folder look like this:

talek@talek-VirtualBox:/bin$ ls -al ~/.vim/bundle/
total 16
drwxrwxr-x  4 talek talek 4096 mai 12 18:31 .
drwxrwxr-x  3 talek talek 4096 mai 12 18:26 ..
drwxrwxr-x 11 talek talek 4096 mai 12 18:30 vorax4
drwxrwxr-x  8 talek talek 4096 mai 12 18:30 vundle

My vim version:

talek@talek-VirtualBox:/bin$ vim --version
VIM - Vi IMproved 7.4 (2013 Aug 10, compiled Nov 24 2016 16:44:48)
Included patches: 1-1689
Extra patches: 8.0.0056
Modified by pkg-vim-maintainers@lists.alioth.debian.org
Compiled by pkg-vim-maintainers@lists.alioth.debian.org
Huge version without GUI.  Features included (+) or not (-):
+acl             +farsi           +mouse_netterm   +tag_binary
+arabic          +file_in_path    +mouse_sgr       +tag_old_static
+autocmd         +find_in_path    -mouse_sysmouse  -tag_any_white
-balloon_eval    +float           +mouse_urxvt     +tcl
-browse          +folding         +mouse_xterm     +terminfo
++builtin_terms  -footer          +multi_byte      +termresponse
+byte_offset     +fork()          +multi_lang      +textobjects
+channel         +gettext         -mzscheme        +timers
+cindent         -hangul_input    +netbeans_intg   +title
-clientserver    +iconv           +packages        -toolbar
-clipboard       +insert_expand   +path_extra      +user_commands
+cmdline_compl   +job             +perl            +vertsplit
+cmdline_hist    +jumplist        +persistent_undo +virtualedit
+cmdline_info    +keymap          +postscript      +visual
+comments        +langmap         +printer         +visualextra
+conceal         +libcall         +profile         +viminfo
+cryptv          +linebreak       -python          +vreplace
+cscope          +lispindent      +python3         +wildignore
+cursorbind      +listcmds        +quickfix        +wildmenu
+cursorshape     +localmap        +reltime         +windows
+dialog_con      +lua             +rightleft       +writebackup
+diff            +menu            +ruby            -X11
+digraphs        +mksession       +scrollbind      -xfontset
-dnd             +modify_fname    +signs           -xim
-ebcdic          +mouse           +smartindent     -xsmp
+emacs_tags      -mouseshape      +startuptime     -xterm_clipboard
+eval            +mouse_dec       +statusline      -xterm_save
+ex_extra        +mouse_gpm       -sun_workshop    -xpm
+extra_search    -mouse_jsbterm   +syntax          
   system vimrc file: "$VIM/vimrc"
     user vimrc file: "$HOME/.vimrc"
 2nd user vimrc file: "~/.vim/vimrc"
      user exrc file: "$HOME/.exrc"
  fall-back for $VIM: "/usr/share/vim"
Compilation: gcc -c -I. -Iproto -DHAVE_CONFIG_H   -Wdate-time  -g -O2 -fPIE -fstack-protector-strong -Wformat -Werror=format-security -U_FORTIFY_SOURCE -D_FORTIFY_SOURCE=1      
Linking: gcc   -L. -Wl,-Bsymbolic-functions -Wl,-z,relro -fstack-protector -rdynamic -Wl,-export-dynamic -Wl,-E  -Wl,-Bsymbolic-functions -fPIE -pie -Wl,-z,relro -Wl,-z,now -Wl,--as-needed -o vim        -lm -ltinfo -lnsl  -lselinux  -lacl -lattr -lgpm -ldl  -L/usr/lib -llua5.2 -Wl,-E  -fstack-protector-strong -L/usr/local/lib  -L/usr/lib/x86_64-linux-gnu/perl/5.22/CORE -lperl -ldl -lm -lpthread -lcrypt  -L/usr/lib/python3.5/config-3.5m-x86_64-linux-gnu -lpython3.5m -lpthread -ldl -lutil -lm -L/usr/lib/x86_64-linux-gnu -ltcl8.6 -ldl -lz -lpthread -lieee -lm -lruby-2.3 -lpthread -lgmp -ldl -lcrypt -lm

Ruby version (from vim):

:ruby p RUBY_VERSION
"2.3.1"
lagumen commented 7 years ago

After diving deep on the root cause.., i found out that I had two versions of ruby installed. One compiled (2.4.0) and (2.3.1) thru RVM. I also had a compiled version of vim 8.0

Decided to start it out clean slate {rvm implode}, and removed all compiled version with "make uninstall". Hunted down any other trailing file remnants in my systems (purged and ack-grep). I also purged my Vundle packages [deleted all directories under .vim/bundle] and re-installed/update plugin repos thru vim plugin. Voila! screenshot

lagumen commented 7 years ago

Thank you Talek! You saved my day! .., not to mention that i am already way behind on all test modules from my dev class! :-) ..., thank you!!!!