VectorLinux

Cooking up the Treats => New Package Requests => Topic started by: murphie on May 26, 2012, 10:08:13 pm

Title: Glom
Post by: murphie on May 26, 2012, 10:08:13 pm
Package Glom please - http://www.glom.org/wiki/index.php?title=Glom

I've been using the windows version for a while and it is at least as good as Filemaker if not better.
Title: Re: Glom
Post by: stretchedthin on June 09, 2012, 08:56:02 am
Is anybody working on this package?  Seems like a nice piece of software.
Title: Re: Glom
Post by: M0E-lnx on June 09, 2012, 09:18:17 am
I agree, but it wants a newer gtk3 that requires a toolchain upgrade on 32-bit vl7

Id like to see it on the repos though
Title: Re: Glom
Post by: stretchedthin on June 10, 2012, 01:29:56 am
What about an older version of Glom that would only require the gtk+3 we already have?
Title: Re: Glom
Post by: M0E-lnx on June 10, 2012, 04:29:38 pm
Can someone else give it a shot though? I did build the postgresql it wants for the backend but i really want to keep coding for the installers so we can get those out.
Title: Re: Glom
Post by: stretchedthin on June 10, 2012, 04:39:34 pm
Good point.  Guess I really want you to keep coding too. :-)

I'll see if I can take a look at it tomorrow.
Title: Re: Glom
Post by: stretchedthin on June 10, 2012, 11:46:19 pm
murphie  you still here.

Before I get started on this I want to make sure the guy who requested it is still around.  This one is a bear.
Title: Re: Glom
Post by: M0E-lnx on June 11, 2012, 05:22:17 am
haha... I thought it was too... but I really want that app on our repos ;)
Title: Re: Glom
Post by: sledgehammer on June 11, 2012, 04:36:58 pm
Quote
but I really want that app on our repos

Me too.

Title: Re: Glom
Post by: murphie on June 12, 2012, 05:19:47 pm
Yes I am still here :)  And thanks for working on this, I appreciate it. 
Title: Re: Glom
Post by: stretchedthin on June 13, 2012, 09:37:52 pm
OK, glom is in testing.   Little older version, so we didn't have to build the entire gtk3 toolchain, but let us know if it does the trick for you,

See announcement here...
http://forum.vectorlinux.com/index.php?topic=16384.0 (http://forum.vectorlinux.com/index.php?topic=16384.0)
Title: Re: Glom
Post by: sledgehammer on June 13, 2012, 10:37:13 pm
Thanks Stretchedthin!

Glom seemed to load fine, but I could not get it to work, nor would it find the help files.  I tried following the online instructions but got nowhere.  This means little as I don't know anything about linux databases such as postgresql, other than that permissions are important. 

I will sit back and watch this thread and, I hope, learn something.
Title: Re: Glom
Post by: sledgehammer on June 14, 2012, 10:56:13 am
I just reloaded glom.  Even though the two files in the repository seemed the same, except for a "2" in front of vl70 rather than a "1,"  and even though the "1" was the second file in gslapt (usually indicating newer), it showed "upgrade" when I "reloaded" and the upgraded Glom works.  I will continue to try it and report back. 

btw, gslapt now (after upgrade) only shows the one Glom file, being the 2vl70 program.

Stretchedthin, thanks a million.  If this works as I think it will, it will be a major improvement to my system.  Something I've been waiting for for years.
Title: Re: Glom
Post by: stretchedthin on June 14, 2012, 12:30:29 pm
vec7, M0E_lnx also had a piece of this one.  Not so bad in hindsight, but looked like a major undertaking at the start.

The 2 your refering to is the build number.  We rebuilt it last night so that the icon would show in the xfce menu and removed the old one.  Each time we rebuild a package but keep the same version we up the build number.
Hope to have time to play with this and move it to extra soon.

Hopefully the guy who requested it and make some comment as to how it is working.
Title: Re: Glom
Post by: M0E-lnx on June 14, 2012, 12:40:25 pm
I tried this, but for some reason, on the 32-bit VL the app starts, but when you create a new database file, it just loops over the startup process.  The problem appears to be that the postgresql daemon is not running.

Trying to run the postgresql daemon returns an error which I have not had time to debug.

Have not tried it on 64-bit

Does this work for anyone at all?

EDIT

FWIW,
I just re-installed to try the 2nd build of the package, and it is not pulling postgresql as a dependency.  IIRC, it should be pulling it.
Title: Re: Glom
Post by: murphie on June 14, 2012, 09:48:28 pm
Loops back to startup for me as well.
Title: Re: Glom
Post by: sledgehammer on June 14, 2012, 10:24:21 pm
I can't get it to work either.  Don't know why one of the examples displayed last night.

Title: Re: Glom
Post by: vector on June 15, 2012, 07:20:27 pm
Theres a build 3 in the repo would someone give that a shot see if any better luck?

Cheers,
Vec
Title: Re: Glom
Post by: murphie on June 15, 2012, 08:02:51 pm
Glom v 1.14.7-i586-3vl70 still loops back, right after stating it is starting the database.
Title: Re: Glom
Post by: sledgehammer on June 15, 2012, 09:56:06 pm
Somebody's doing something right.  See attached screenshots.  Got them from my machine, running build 3 of glom.  Not to sure what I did. 


I am out of sorts tomorrow but will look at this more on Sunday.  
Title: Re: Glom
Post by: sledgehammer on June 17, 2012, 11:07:13 pm
Well, I played with Glom quite a bit today.  I was able to get all the examples to open except the Film example.  However, I was unable to see a pattern in the opening process.  It seemed hit and miss.  I think the program is not working right but don't know for sure.  It might be that my unfamiliarity with postgres and linux databases generally (I still use dos foxpro 2.6) is the main problem.  Would be great if someone with more familiarity with glom would give it a try.  I am pretty sure that the example databases can be opened, given enough tries and a little luck.  

And, its possible that the program itself has bugs.  Again, would be great if someone who has used Glom could tell us what is going on in some detail.

I am probably the worse person in the world to be saying this, but I think the install still needs a little tweaking.  
Title: Re: Glom
Post by: sledgehammer on June 18, 2012, 10:00:45 am
Couple of other comments.

When I go to the glom site (http://www.glom.org/wiki/index.php?title=Screenshots#Connecting) it seems to indicate that the examples come populated with fields.

However, the examples I get when running glom have no such fields and when I try to input data I get a "no primary key value" error.

Also, the screen shown when clicking on Open Existing Document>Select File seems unreliable in that it shows some of the same .glom files both in a folder and separately, outside the folder.

And, as I may have said, I can't get the film example database to open at all.

John
Title: Re: Glom
Post by: sledgehammer on July 03, 2012, 12:30:22 am
I suspect that one of my problems with glom, if not THE problem, is that I don't know how to start postgresql.

Quote
vector:/~
johwhi:$ /sbin/service postgresql start
service postgresql is not active.

Any suggestions?

Before running the foregoing, I added
Quote
ntpd -qg &

# Startup postgresql
if [ -x /etc/rc.d/rc.postgresql ]; then
/etc/rc.d/rc.postgresql start
fi

to /etc/rc.d/rc.local

and I added rc.local_shutdown  to /etc/rc.d

Quote
# Stop postgres
if [ -x /etc/rc.d/rc.postgresql ]; then
/etc/rc.d/rc.postgresql stop
fi

But I still get the above "service postgresql is not active." error.

/etc/rc.d/rc.postgresql is active (at least its bright green with an asterisk behind it)
Title: Re: Glom
Post by: uelsk8s on July 03, 2012, 06:45:40 am
In VL we have 2 styles of init scripts the Slackware style scripts in /etc/rc.d/ and the scripts in /etc/rc.d/init.d/
The service script manages the startup scripts in /etc/rc.d/init.d/
The error: "service postgresql is not active." simple means that the service script does not know about the postgresql startup script.

If you were to copy /etc/rc.d/rc.postgresql to /etc/rc.d/init.d/postgresql and then add the service with vasm or vsrvset or even service, then what you would have would be equivalent to the lines you added to rc.local and rc.local_shutdown.


HTH,
Uelsk8s
Title: Re: Glom
Post by: sledgehammer on July 03, 2012, 08:46:31 am
Thanks much uelsk8s

I'm making progress, i.e. following your instructions I was able to start postgresql in vasm:

Quote
vector:/~
johwhi:$ /sbin/service postgresql status       
PostgreSQL is running
Warning: Missing pid file /var/lib/pgsql/data/postmaster.pid
vector:/~

I still don't think I have glom connected to postgresql, and will look into that matter tonight or tomorrow.  Perhaps I will have a glom 4th of July.
Title: Re: Glom
Post by: sledgehammer on July 04, 2012, 11:03:31 pm
I have heard that glom can use sqlite.  Having no luck so far with postgresql, I thought I would try to see if Glom would recognize sqlite.  Went to the repositories, and it shows that sqlite is installed on my system, but gslapt won't allow me to reload it or remove it.  It seems to just exist and I can't recall how it got onto my system.

Title: Re: Glom
Post by: Chris530 on July 09, 2012, 07:45:11 am
Why not use Kexi instead of Glom?  It's now been glued into Calligra aka KOffice suite and Calligra is in the repo.
Title: Re: Glom
Post by: sledgehammer on July 15, 2012, 10:16:10 pm
Chris530,

Thanks for the Kexi suggestion.  It has some very good points.  A drawback though is that if you change the database design after inputting data all data in the table changed is lost.  

Glom does not appear to have that problem (I have been testing glom 1.2.1 on a ubuntu machine).

However, I would hope to get glom up and running on my machine which is Vector.

The version in the repositories does not, best I can tell, connect to the postgresql database.  At least it won't save data.

I tried installing the slackware version on the glom site (older version for slackware 13.0) and got the following errors:

(images are backwards but I don't know how to reorder them...added)

On installpkg:
(http://)
(http://)

On trying to run glom:

(http://)
Title: Re: Glom
Post by: sledgehammer on July 15, 2012, 10:24:32 pm
Here is the error message when I try to run glom from the vector repositories:

PS  I tried installing glom-1.21.8.tar.xz from sourceforge but it extracted to a .tar file and I don't know how to install a .tar file from source.

Title: Re: Glom
Post by: sledgehammer on July 21, 2012, 08:34:15 am
Ok,

Figured out how to install from .xz BUT on ./configure notice that glom needs a lot of gnome files that are not in the VL repositories  (or, more accurately, the required version of which is not in the vector repositories).

So, anyone know how I would install a recent version of gnome on my VL system, where I could still run xfce but would also have the necessary gnome files to run glom?  The sole purpose of installing gnome would be to get those files.  I do not want to run gnome.

John

Title: Re: Glom
Post by: sledgehammer on July 24, 2012, 08:15:59 am
So, back to the topic, which is, I believe, the testing of glom as it exists in the VL 7 testing repository.   

And as to this issue, I think it probably is working fine as a program, but that I don't know how to connect it to the postgresql database (and therefore data is not saved).

I am now using kexi, as Chris530 suggested, and it is pretty slick.  But it has some glitches and, from what I read, glom is probably a better database for my purposes, given my limited knowledge of linux databases.  

Anyway, this is just a report.  If anyone knows postgresql, I bet he or she could tell us how to connect glom to it.  If not, I will try to figure it out as time permits.  
Title: Re: Glom
Post by: prince on July 25, 2012, 11:12:23 pm
Hi there,

Glom re-connects to the database server
when it loads a previous Glom document. The document is in XML
format.

Glom uses the PostgreSQL database backend but it can not edit
databases that it did not create, because it uses only a simple
subset of Postgres functionality.

However, glom Recommends: postgresql-8.2, so that it is handled as a dependency by all the standard packaging frontends.
Title: Re: Glom
Post by: sledgehammer on July 26, 2012, 07:53:43 am
Prince,

Thanks for the comments. 

Would you do me a huge favor and install glom from the VL7 testing repository and see if you can, either when using the sample databases provided or otherwise, get glom to save data that you input?  If you can get it to do that, would you then please reply, showing exactly what you did?  I am not trying to get glom to access another database.  I just can't get it to save data that I input on glom.

Title: Re: Glom
Post by: prince on July 26, 2012, 08:46:02 pm
I don't have the full functionality of my keyboard. I'm awaiting a replacement.

Meanwhile, if I can help, I would last try the command: pg **dump.

The asterisks are actually supposed to be an underscore.  That key, the plus key, among other keys
aren't working for me, right now.

The command extract a PostgreSQL database into a script file or other archive file.
Title: Re: Glom
Post by: sledgehammer on July 26, 2012, 11:40:59 pm
I'l probably need to wait until your keyboard is fixed.  I don't know what to do with pg __dump, where and when to put it, etc., though trying it made me think of a couple of things I might try this weekend.

Thanks again. 
Title: Re: Glom
Post by: sledgehammer on July 28, 2012, 02:39:08 pm
Still trying to get glom to work.  Thought I might post the following in hopes that it gives someone an idea of something I might try:

Quote
vector:/~
johwhi:$ glom
I/O warning : failed to load external entity "/usr/libgda-4.0/config"

** (glom:7192): WARNING **: Trying to register gtype 'GdaEasyCreateTableFlag' as flags when in fact it is of type 'GEnum'
/usr/share/themes/MurrinaBlue/gtk-2.0/gtkrc:83: Murrine configuration option "scrollbar_color" is no longer supported and will be ignored.
/usr/share/themes/MurrinaBlue/gtk-2.0/gtkrc:83: Murrine configuration option "hilight_ratio" will be deprecated in future releases. Please use "highlight_shade" instead.
ConnectionPool::get_and_connect(): m_backend is null.
ConnectionPool::get_and_connect(): m_backend is null.
ConnectionPool::get_and_connect(): m_backend is null.
The files belonging to this database system will be owned by user "johwhi".
This user must also own the server process.

The database cluster will be initialized with locales
  COLLATE:  C
  CTYPE:    en_US
  MESSAGES: en_US
  MONETARY: en_US
  NUMERIC:  en_US
  TIME:     en_US
The default database encoding has accordingly been set to LATIN1.
The default text search configuration will be set to "english".

fixing permissions on existing directory /home/johwhi/glom/today/glom_postgres_data/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 24MB
creating configuration files ... ok
creating template1 database in /home/johwhi/glom/today/glom_postgres_data/data/base/1 ... ok
initializing pg_authid ... ok
setting password ... ok
initializing dependencies ... ok
creating system views ... ok
loading system objects' descriptions ... ok
creating collations ... ok
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the -A option the
next time you run initdb.

Success. You can now start the database server using:

    /usr/bin/postgres -D /home/johwhi/glom/today/glom_postgres_data/data
or
    /usr/bin/pg_ctl -D /home/johwhi/glom/today/glom_postgres_data/data -l logfile start

Frame_Glom::connection_request_password_and_choose_new_database_name(): unused database name successfully found: glom_example_lessonplanner_v2
SUGGEST META UPDATE Returned FALSE: column t.tgisconstraint does not exist
LINE 1: ... = t.tgrelid AND (t.tgtype & em.num) <> 0 AND NOT t.tgiscons...
                                                             ^
SUGGEST META UPDATE Returned FALSE: column t.tgisconstraint does not exist
LINE 1: ... = t.tgrelid AND (t.tgtype & em.num) <> 0 AND NOT t.tgiscons...
                                                             ^
SUGGEST META UPDATE Returned FALSE: column t.tgisconstraint does not exist
LINE 1: ... = t.tgrelid AND (t.tgtype & em.num) <> 0 AND NOT t.tgiscons...
                                                             ^
Base_DB::add_standard_tables(): caught exception: column t.tgisconstraint does not exist
LINE 1: ... = t.tgrelid AND (t.tgtype & em.num) <> 0 AND NOT t.tgiscons...
                                                             ^
waiting for server to shut down.... done
server stopped
Application::on_document_load(): recreate_database_from_example() failed.
vector:/~

and:

Quote
vector:/~
johwhi:$ /usr/bin/postgres -D /home/johwhi/glom/today/glom_postgres_data/data
FATAL:  could not open lock file "/tmp/.s.PGSQL.5432.lock": Permission denied
vector:/~

Having postgresql enabled for user level 4 in vasm or not enabled does not seem to make any difference.

John

Title: Re: Glom
Post by: sledgehammer on July 28, 2012, 05:10:06 pm
And here's some more, done outside of glom:

Quote
johwhi:$ createuser -P
Enter name of role to add: johwhi
Enter password for new role:
Enter it again:
Shall the new role be a superuser? (y/n) y
createuser: could not connect to database postgres: could not connect to server: Connection refused
   Is the server running locally and accepting
   connections on Unix domain socket "/tmp/.s.PGSQL.5432"?
vector:/~
Title: Re: Glom
Post by: prince on July 29, 2012, 04:02:14 pm
Pardon me, I didn't make that  pg***dump command clear. It's from PostgreSQL's website:


http://www.postgresql.org/docs/9.1/static/app-pgdump.html
Title: Re: Glom
Post by: sledgehammer on July 29, 2012, 07:32:36 pm
Thanks, Prince.

Glom may be a casualty of slackware's move away from gnome.  I hope not. I sure can't get it to work right, either internally or externally, but I suspect someone on this forum, someone a lot smarter than me, will eventually figure it out.  It would be good to have it working in Vector, even if the version is somewhat dated. 

Basically, when trying to run glom locally, I first shut down postgresql (it starts on boot).  Glom seems to start it but stops it just as I try to save.

If I turn the system postgresql on, I can't connect to the external postgres as I don't know how to set up the password properly. 

In short, I am 99% there on both external and internal glom, but that last 1% is a bear. 


Title: Re: Glom
Post by: Chris530 on October 16, 2012, 08:56:42 pm
I can now see why you want it sledgehammer, I just installed it on a laptop with Arch and it is a great program.  Will be nice to see this on Vector.