Medsphere.org: Getting the MYSQL package for FM...

Up to Discussions in FM Projection

1,458 Views 15 Replies Last post: Jul 13, 2010 11:09 PM by rdevendra

1 2 Previous Next

Richard Braman

21 posts since
Feb 4, 2010

Currently Being Moderated

Feb 8, 2010 10:05 AM

Getting the MYSQL package for FM projection

Juts working on getting FM projection going so far I have downloaded , loaded, and installed the KIDS file and now I am working on getting the Mysql piece

I am working off of the PPS instructions on

https://launchpad.net/~fm-projection+team/+archive/ppa

I am on ubuntu jaunty so i added the following lines to my sources.list

deb http://ppa.launchpad.net/fm-projection+team/ppa/ubuntu jaunty main 
deb-src http://ppa.launchpad.net/fm-projection+team/ppa/ubuntu jaunty main 

I added the keys like this:

sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys D69FB939
[sudo] password for openvista: 
Executing: gpg --ignore-time-conflict --no-options --no-default-keyring --secret-keyring /etc/apt/secring.gpg --trustdb-name /etc/apt/trustdb.gpg --keyring /etc/apt/trusted.gpg --keyserver keyserver.ubuntu.com --recv-keys D69FB939
gpg: requesting key D69FB939 from hkp server keyserver.ubuntu.com
gpg: key D69FB939: public key "Launchpad PPA for FM Projection" imported
gpg: Total number processed: 1
gpg:               imported: 1  (RSA: 1)

and ran sudo apt-get update

Now, what is the package name to apt-get install. I tried

sudo apt-get install mysql-dfsg-5.1

but that returned package not found

Jonathan Tai

341 posts since
Jul 24, 2008

Currently Being Moderated

1. Feb 8, 2010 10:13 AM

in response to: Richard Braman

Re: Getting the MYSQL package for FM projection

Hi Richard, mysql-dfsg-5.1 is the name of the source package. I think you want to

apt-get install mysql-server-5.1

Jonathan Tai

341 posts since
Jul 24, 2008

Currently Being Moderated

2. Feb 8, 2010 12:23 PM

in response to: Jonathan Tai

Re: Getting the MYSQL package for FM projection

That's odd. I think during the installation it prompts you to set a password, but if you just leave it blank, it doesn't set one.

When you uninstalled, did you use --purge? (apt-get remove --purge mysql-server-5.1 or dpkg --purge mysql-server-5.1) If you didn't, I don't think it wipes out the initial database that it created.

jeff.apple

36 posts since
Sep 26, 2008

Currently Being Moderated

3. Feb 8, 2010 12:24 PM

in response to: Jonathan Tai

Re: Getting the MYSQL package for FM projection

Nothing has been changed with regard to basic authentication and authorization for the server itself. I did a quick Google search on "mysql default password" and had a couple of interesting hits. Please see http://www.debian-administration.org/articles/442 for example.

Richard Braman

21 posts since
Feb 4, 2010

Currently Being Moderated

4. Feb 8, 2010 12:49 PM

in response to: jeff.apple

Re: Getting the MYSQL package for FM projection

My command line is appending some wired stuff automatically

I got it working after i followed Jon's advice. It may be useful to delete these posts as they may be confusing

Jonathan Tai

341 posts since
Jul 24, 2008

Currently Being Moderated

5. Feb 8, 2010 1:01 PM

in response to: Richard Braman

Re: Getting the MYSQL package for FM projection

Glad you got it working. I don't think we want to delete these, since someone may have the same issues in the future.

Sam Habiel

27 posts since
Jun 5, 2009

Currently Being Moderated

6. May 18, 2010 2:58 PM

in response to: Jonathan Tai

Re: Getting the MYSQL package for FM projection

Guess what? I had the same exact issue!!!

It would be helpful to tell us how to do that in the installation document.

rdevendra

4 posts since
Jun 28, 2010

Currently Being Moderated

7. Jul 5, 2010 5:44 AM

in response to: Jonathan Tai

Re: Getting the MYSQL package for FM projection

Hi Jonathan,

I tried installing the package with apt-get install mysql-server-5.1 on ubuntu 10.04

It did install the mysql-server, but I am not sure if it is the mysql package for file man or the standard mysql-server.

how do I verify if correct package is installed?

I proceded with it...after setting up FM Visualizer and setting the connection parameter I get the following error

I think the apt-get was not able to get hold of the right mysql engine..am I doing the right thing?

C:\Documents and Settings\drahul\Desktop\fm-projection\fmvis>java -jar fmvis.jar

log4j:WARN No appenders could be found for logger (com.medsphere.vistarpc.RPCBrokerConnection).
log4j:WARN Please initialize the log4j system properly.
Exception in thread "AWT-EventQueue-0" java.lang.NullPointerException
        at com.medsphere.fileman.FMQueryFiles.execute(FMQueryFiles.java:34)
        at com.medsphere.fmvis.database.fm.FMSchemaModel.getFileList(FMSchemaMod
el.java:130)
        at com.medsphere.fmvis.ui.model.FMFileListModel.loadFiles(FMFileListMode
l.java:45)
        at com.medsphere.fmvis.ui.model.FMFileListModel.<init>(FMFileListModel.j
ava:37)
        at com.medsphere.fmvis.ui.view.MainFrame.getFileTree(MainFrame.java:117)

        at com.medsphere.fmvis.ui.view.MainFrame.<init>(MainFrame.java:88)
        at com.medsphere.fmvis.ui.controller.FileNav.<init>(FileNav.java:47)
        at com.medsphere.fmvis.ui.controller.FileNav.<init>(FileNav.java:41)
        at com.medsphere.fmvis.FMVisApp$2.run(FMVisApp.java:58)
        at java.awt.event.InvocationEvent.dispatch(Unknown Source)
        at java.awt.EventQueue.dispatchEvent(Unknown Source)
        at java.awt.EventDispatchThread.pumpOneEventForFilters(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForFilter(Unknown Source)
        at java.awt.EventDispatchThread.pumpEventsForHierarchy(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.pumpEvents(Unknown Source)
        at java.awt.EventDispatchThread.run(Unknown Source)

Jonathan Tai

341 posts since
Jul 24, 2008

Currently Being Moderated

8. Jul 6, 2010 4:16 PM

in response to: rdevendra

Re: Getting the MYSQL package for FM projection

Hi Rahul,

Unfortunately, we do not have MySQL with FM Projection properly packaged for Ubuntu 10.04 yet. We are planning to move to a plugin architecture, where we can ship a plugin that provides the storage engine instead of shipping a specialized build of MySQL Server. The actual development work for this is complete, but the packaging has not caught up yet. In the meantime, it may be easier for you to just keep the official MySQL Server package installed and just drop in a precompiled plugin .so file. Are you running 32-bit or 64-bit Ubuntu?

I think the error that you're getting is because the RPC broker is either not running or not configured correctly and has nothing to do with MySQL, but I'm not 100% sure on that.

rdevendra

4 posts since
Jun 28, 2010

Currently Being Moderated

9. Jul 7, 2010 12:05 AM

in response to: Jonathan Tai

Re: Getting the MYSQL package for FM projection

Jonathan, Thats cool, plugin architecture would be just great.

I am running Ububtu Server 10.0 x86-64. Where do I find the plugin .so file you are refering to?

The above mentioned error was because of the missing menu option which I got working after installation of the kids

and have posted here.

Jonathan Tai

341 posts since
Jul 24, 2008

Currently Being Moderated

10. Jul 7, 2010 12:35 PM

in response to: rdevendra

Re: Getting the MYSQL package for FM projection

I've attached a freshly-compiled version for Ubuntu 10.04 LTS x86_64. The installation takes a few steps:

Put the file in ~~/usr/local/mysql/plugin~~ /usr/lib/mysql/plugin, chown'd root:root chmod 644.
In that directory, create ha_fileman.so and ha_fileman.so.0 symlinks to the ha_fileman.so.0.0.0 file, just like the existing symlinks for ha_innodb_plugin.so.0.0.0.
The default app armor profile for MySQL Server, /etc/apparmor.d/usr.sbin.mysqld, does not allow MySQL to read the plugins directory. Edit the file and add /usr/lib/mysql/plugin/* mr
Reload the app armor profile with sudo apparmor_parser -r /etc/apparmor.d/usr.sbin.mysqld
At a MySQL root prompt, run the query INSTALL PLUGIN fileman SONAME 'ha_fileman.so' to install the plugin

Attachments:

ha_fileman.so.0.0.0.zip (34.4 K)

jeff.apple

36 posts since
Sep 26, 2008

Currently Being Moderated

11. Jul 7, 2010 12:50 PM

in response to: Jonathan Tai

Re: Getting the MYSQL package for FM projection

Just an FYI, I have update the respoitory with changes to the build process. Under Linux, it was not building correct, runnable plugins. You may want to rebuild using revision 7.

Jonathan Tai

341 posts since
Jul 24, 2008

Currently Being Moderated

12. Jul 7, 2010 12:54 PM

in response to: jeff.apple

Re: Getting the MYSQL package for FM projection

Revision 7 of mainline? The plugin I attached here was from revision 6 of your plugin branch.

jeff.apple

36 posts since
Sep 26, 2008

Currently Being Moderated

13. Jul 7, 2010 12:56 PM

in response to: Jonathan Tai

Re: Getting the MYSQL package for FM projection

Yes, revision 7 or mainline. I didn't post for review since it's very simple stuff, and the existing didn't work anyway.

Jonathan Tai

341 posts since
Jul 24, 2008

Currently Being Moderated

14. Jul 7, 2010 12:59 PM

in response to: jeff.apple

Re: Getting the MYSQL package for FM projection

Since r6 of mainline brings in the new CIA broker stuff (which comes with the new config file format, etc.) I think I'll wait to get that documented better before we start distributing it. Probably when/after we get this packaging stuff sorted out.

Go to original post 1 2 Previous Next

Go to original post

Feb 8, 2010 10:05 AM

Getting the MYSQL package for FM projection

Actions

More Like This

Bookmarked By (0)