LinuxQuestions.org
Visit the LQ Articles and Editorials section
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Distributions > Slackware
User Name
Password
Slackware This Forum is for the discussion of Slackware Linux.

Notices



Reply
 
Search this Thread
Old 12-04-2012, 09:40 AM   #16
willysr
Senior Member
 
Registered: Jul 2004
Location: Jogja, Indonesia
Distribution: Slackware-Current
Posts: 2,621

Rep: Reputation: 445Reputation: 445Reputation: 445Reputation: 445Reputation: 445

Have you installed all the deps? Missing some of them would make your workbench unable to connect to your mysql
 
Old 12-04-2012, 10:17 AM   #17
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,119

Rep: Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818
Quote:
Originally Posted by willysr View Post
Have you installed all the deps? Missing some of them would make your workbench unable to connect to your mysql
Yup, all of 'em in the sequence specified at SlackBuilds.org (all built from SlackBuilds and installed one-by-one as listed in the "this requires xxx."

Too, my user account (and the root MySQL user) has Attila the Hun permissions on the data bases to both localhost and the server.

[edit]
Forgot to mention, in /etc/rc.d/rc.mysqld:
Code:
# To allow outside connections to the database comment out the next line.
# If you don't need incoming network connections, then leave the line
# uncommented to improve system security.
#SKIP="--skip-networking"
As suggested by some instruction in the documentation. It's also commented out in /etc/mysqld/my.cnf.

Shouldn't have anything to do with anything but, also in /etc/mysql/my.cnf,
Code:
innodb_flush_log_at_trx_commit = 0
so commits will happen on loads at the default 1 second intervals (loads things a lot faster that way).
[/edit]

Last edited by tronayne; 12-04-2012 at 10:40 AM.
 
Old 12-04-2012, 12:29 PM   #18
Ook
Member
 
Registered: Apr 2004
Location: Hell, Arizona
Distribution: Slackware 14.1
Posts: 372

Original Poster
Rep: Reputation: 36
Quote:
Originally Posted by tronayne View Post
May I ask for a little help and advice?

I used @willysr's SlackBuild to build mysql-workbench-gpl-5.2.44-x86_64-1wsr and it sorta-kinda works. I wonder if you could share what options you selected when initializing it; I'm pretty sure I had to use the first Ubuntu choice so MySQL Workbench could find /etc/rc.d/rc.mysql (the other choices are looking in /etc/rc[0-3].d and /etc/init.d and I didn't want to fool around with those).

MySQL is started on my systems at boot and, when I start MySQL Workbench, it looks as though mysql@localhost is working but then I can't seem to do anything (such as startup / shutdown).

I've probably missed something and have been through the documentation and done as much step-by-step troubleshooting I can think of.

Maybe a push in the right direction might help and I'd appreciate any hints you may have.

Thanks
Well, I'm not the expert here ... so ignoring my personal prejudices against ubuntu ( ) ...

Start workbench from a console (mysql-workbench) and see what it outputs to the console. Workbench expects to find mysql libraries in the "usual" place, and if it doesn't find them, it won't start, and it won't tell you why it won't start except for some message to the console. These messages can be rather cryptic, but they are a good place to start.

If you are using a SlackBuild script on Ubuntu, all bets are off - one of the ./configure options are --build=$ARCH-slackware-linux and I don't know what that would do under Ubuntu. The other settings AFAICT should work, maybe someone here that knows more about Slack versus Ubuntu can comment.

On Ubuntu, there is no /etc/rc.d directory, you probably want to use either /etc/rc[0-3].d or /etc/init.d.

Other then that, I'm not sure ... I like MySql-Workbench, but it is a serious pain in the freakin' arse to get working, it almost isn't worth the trouble. There are a lot of people out there having the tunnel manager error, caused by not having pycrypto installed, and there is nothing obvious that says that is where the problem is. I wasted too many hours trying to get it to work, only to get weird things like grey screen on startup, tunnel manager problems, weird python related build problems, etc. before I finally got it working.

Having said all that, what exactly do you mean "sorta-kinda" works? Exactly what doesn't work, and what to you do to get it to manifest?
 
Old 12-04-2012, 12:33 PM   #19
Ook
Member
 
Registered: Apr 2004
Location: Hell, Arizona
Distribution: Slackware 14.1
Posts: 372

Original Poster
Rep: Reputation: 36
Quote:
Originally Posted by willysr View Post
Have you installed all the deps? Missing some of them would make your workbench unable to connect to your mysql
I might comment that some of the dependencies have other dependencies, but missing certain dependencies (like pycrypto) will NOT stop it from building and installing, nor will there be any indication given that a dependency is missing until you run it. Then, missing dependencies can manifest by run-time errors.
 
Old 12-04-2012, 01:13 PM   #20
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,119

Rep: Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818
Quote:
Originally Posted by Ook View Post
I might comment that some of the dependencies have other dependencies, but missing certain dependencies (like pycrypto) will NOT stop it from building and installing, nor will there be any indication given that a dependency is missing until you run it. Then, missing dependencies can manifest by run-time errors.
Yeah, know that (and you walk the SlackBuilds tree taking note of every single "this is required" dependency for every single step along the way -- did that (actually, always do that).

By the way, I do not use Ubuntu (anything); notice the "Distribution?" Somehow or other that particular drop-down figures out where to find the MySQL stuff it needs to. I dunno, but I think there's a symbolic link lurking around somewhere other.

Anyway, onward and... downward? Nah, it'll work someday.
 
Old 12-04-2012, 01:20 PM   #21
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,119

Rep: Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818
Well, that was an interesting exercise:
Code:
/usr/local/bin/mysql-workbench*
fubar-trona-/home/trona: /usr/local/bin/mysql-workbench
Initializing AdvancedSidebar factory method
Initializing mforms factory
** Message: Gnome keyring daemon seems to not be available. Stored passwords will be lost once quit
Creating WBOptions
/bin/sh: ifconfig: command not found
Ready.

** Message: overview.home built-in command is being overwritten
Of course ifconfig isn't found: it's in /sbin and ordinary folk aren't supposed to mess with it! (And, no, I don't think I want to symbolic link it to /bin or /usr/bin.)

Hmm. The bind is getting cheesy.
 
Old 12-05-2012, 01:18 AM   #22
willysr
Senior Member
 
Registered: Jul 2004
Location: Jogja, Indonesia
Distribution: Slackware-Current
Posts: 2,621

Rep: Reputation: 445Reputation: 445Reputation: 445Reputation: 445Reputation: 445
here's what i got when running MySQL Workbench from console and everything works well :
Quote:
willysr@office:~$ mysql-workbench
Initializing AdvancedSidebar factory method
Initializing mforms factory
** Message: Gnome keyring daemon seems to not be available. Stored passwords will be lost once quit
Creating WBOptions
Ready.

** Message: overview.home built-in command is being overwritten
 
Old 12-05-2012, 09:26 AM   #23
tronayne
Senior Member
 
Registered: Oct 2003
Location: Northeastern Michigan, where Carhartt is a Designer Label
Distribution: Slackware 32- & 64-bit Stable
Posts: 3,119

Rep: Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818Reputation: 818
That's what I got running as root (which, of course, can find ifconfig). I'm going to keep digging and see what I come up, thanks.

I spent some time yesterday reclaiming my laptop from the Evil Empire. Had to reinstall Win7 on it early this year so I could run Turbotax (which would not run in Win7 in Virtualbox); gotta do them taxes. This year's Turbotax arrived a few days ago -- it does run in Win7 in VirtualBox! Oh, happy day, no more useless Windows boat anchor sitting there needing critical updates every blessed week.

Slackware 14 64-bit went on to a fully-wiped-clean disk, set it up, copied stuff from my main server, installed a couple of utilities and viola, pita the laptop lives!

I think I heard a sigh of relief.

So back to MySQL Workbench and see if I can get that going.

Thanks for you help and advice.
 
Old 12-31-2012, 11:58 AM   #24
Ook
Member
 
Registered: Apr 2004
Location: Hell, Arizona
Distribution: Slackware 14.1
Posts: 372

Original Poster
Rep: Reputation: 36
For those of you interested and/or following this thread: Oracle has released a new version of MySqlWorkBench that ... drum roll please ... supports data migration (!!). Workbench 5.2.45 is now available!

Unfortunately, it throws a bunch of compile errors related to lua. Upgrading to the current version of lua did not help. At this point I'm not sure if there is some weird dependency problem, or if their code is just buggy. So, alas, I'm stuck on the previous version for now, which compiles just fine.

grtpp_module_lua.cpp:75:16: error: 'LUA_GCSTOP' was not declared in this scope
grtpp_module_lua.cpp:75:29: error: 'lua_gc' was not declared in this scope
grtpp_module_lua.cpp:76:21: error: 'luaL_openlibs' was not declared in this scope
grtpp_module_lua.cpp:77:16: error: 'LUA_GCRESTART' was not declared in this scope
grtpp_module_lua.cpp: In function 'int call_traceback(lua_State*)':
grtpp_module_lua.cpp:253:46: error: 'lua_getfield' was not declared in this scope
grtpp_module_lua.cpp:258:25: error: 'lua_pushinteger' was not declared in this scope
make[4]: *** [grtpp_module_lua.lo] Error 1

Anyone have any suggestions as to the cause and resolution for these errors?
 
Old 12-31-2012, 12:35 PM   #25
Ook
Member
 
Registered: Apr 2004
Location: Hell, Arizona
Distribution: Slackware 14.1
Posts: 372

Original Poster
Rep: Reputation: 36
Moderate Please delete this post if you can, it is a duplicate post - got error when trying to post previous post, so I did it again and then they both showed up. Sorry!

Last edited by Ook; 12-31-2012 at 12:36 PM.
 
Old 01-03-2013, 03:39 AM   #26
willysr
Senior Member
 
Registered: Jul 2004
Location: Jogja, Indonesia
Distribution: Slackware-Current
Posts: 2,621

Rep: Reputation: 445Reputation: 445Reputation: 445Reputation: 445Reputation: 445
Quote:
Originally Posted by Ook View Post
For those of you interested and/or following this thread: Oracle has released a new version of MySqlWorkBench that ... drum roll please ... supports data migration (!!). Workbench 5.2.45 is now available!

Unfortunately, it throws a bunch of compile errors related to lua. Upgrading to the current version of lua did not help. At this point I'm not sure if there is some weird dependency problem, or if their code is just buggy. So, alas, I'm stuck on the previous version for now, which compiles just fine.

grtpp_module_lua.cpp:75:16: error: 'LUA_GCSTOP' was not declared in this scope
grtpp_module_lua.cpp:75:29: error: 'lua_gc' was not declared in this scope
grtpp_module_lua.cpp:76:21: error: 'luaL_openlibs' was not declared in this scope
grtpp_module_lua.cpp:77:16: error: 'LUA_GCRESTART' was not declared in this scope
grtpp_module_lua.cpp: In function 'int call_traceback(lua_State*)':
grtpp_module_lua.cpp:253:46: error: 'lua_getfield' was not declared in this scope
grtpp_module_lua.cpp:258:25: error: 'lua_pushinteger' was not declared in this scope
make[4]: *** [grtpp_module_lua.lo] Error 1

Anyone have any suggestions as to the cause and resolution for these errors?
Use Lua 5.1.x and it should work
I have built 5.2.45 and it's working fine on my machine
 
Old 01-04-2013, 02:30 AM   #27
tomtomjkw
Member
 
Registered: Jan 2008
Distribution: Slackware64-current
Posts: 128

Rep: Reputation: 31
Willy, did you succed on the multilib system? I'm stuck at libtool searching for liblzma in /usr/lib instead of /usr/lib64.
 
Old 01-04-2013, 09:57 AM   #28
willysr
Senior Member
 
Registered: Jul 2004
Location: Jogja, Indonesia
Distribution: Slackware-Current
Posts: 2,621

Rep: Reputation: 445Reputation: 445Reputation: 445Reputation: 445Reputation: 445
I'm using 32 bit machine, sorry
I have no multilib machine here
 
Old 01-11-2013, 12:15 PM   #29
Ook
Member
 
Registered: Apr 2004
Location: Hell, Arizona
Distribution: Slackware 14.1
Posts: 372

Original Poster
Rep: Reputation: 36
Quote:
Originally Posted by willysr View Post
Use Lua 5.1.x and it should work
I have built 5.2.45 and it's working fine on my machine
I have Lua 5.1.5, same errors. I'm using 64 bit slack, I think I'll slap the 32 bit version into a VM and see it builds there - maybe it is a multilib related issue?
 
Old 01-11-2013, 05:26 PM   #30
willysr
Senior Member
 
Registered: Jul 2004
Location: Jogja, Indonesia
Distribution: Slackware-Current
Posts: 2,621

Rep: Reputation: 445Reputation: 445Reputation: 445Reputation: 445Reputation: 445
It could be, but i'm not really sure since i don't have a multilib machine to proof that
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
[SOLVED] Problem installing mysql-workbench from Slackbuilds mitusf Slackware 1 10-15-2012 02:07 PM
Cannot compile mysql-workbench zeroberto Slackware 12 06-03-2011 07:13 AM
help building mod_python in freebsd, error: cannot find -lpython2.6 hedpe *BSD 1 04-16-2009 09:01 AM
LXer: Visual MySQL Database Design in MySQL Workbench LXer Syndicated Linux News 0 06-12-2008 08:00 PM
MySQL Workbench grahamtysall Linux - General 1 07-27-2007 04:30 PM


All times are GMT -5. The time now is 07:43 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration