VectorLinux
October 22, 2014, 04:07:48 am *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Visit our home page for VL info. To search the old message board go to http://vectorlinux.com/forum1. The first VL forum is temporarily offline until we can find a host for it. Thanks for your patience.
 
Now powered by KnowledgeDex.
   Home   Help Search Login Register  
Please support VectorLinux!
Pages: 1 2 [3]
  Print  
Author Topic: Glom  (Read 5778 times)
sledgehammer
Vectorian
****
Posts: 1425



« Reply #30 on: July 24, 2012, 07: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.  
Logged

VL7.0 xfce4 Samsung RF511
prince
Vectorite
***
Posts: 183


« Reply #31 on: July 25, 2012, 10: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.
« Last Edit: July 25, 2012, 11:07:18 pm by prince » Logged
sledgehammer
Vectorian
****
Posts: 1425



« Reply #32 on: July 26, 2012, 06: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.

Logged

VL7.0 xfce4 Samsung RF511
prince
Vectorite
***
Posts: 183


« Reply #33 on: July 26, 2012, 07: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.
Logged
sledgehammer
Vectorian
****
Posts: 1425



« Reply #34 on: July 26, 2012, 10: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. 
Logged

VL7.0 xfce4 Samsung RF511
sledgehammer
Vectorian
****
Posts: 1425



« Reply #35 on: July 28, 2012, 01: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

Logged

VL7.0 xfce4 Samsung RF511
sledgehammer
Vectorian
****
Posts: 1425



« Reply #36 on: July 28, 2012, 04: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:/~
Logged

VL7.0 xfce4 Samsung RF511
prince
Vectorite
***
Posts: 183


« Reply #37 on: July 29, 2012, 03: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
Logged
sledgehammer
Vectorian
****
Posts: 1425



« Reply #38 on: July 29, 2012, 06: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. 


Logged

VL7.0 xfce4 Samsung RF511
Chris530
Member
*
Posts: 32


« Reply #39 on: October 16, 2012, 07: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.
Logged
Pages: 1 2 [3]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines Valid XHTML 1.0! Valid CSS!