Re: [SLE] Do databases work in OOo? [solved]

From: Carlos E. R. (robin1.listas_at_tiscali.es)
Date: 11/17/05

  • Next message: Donn Washburn: "Re: [SLE] Accessing the USB devices" 
    Date: Thu, 17 Nov 2005 02:45:52 +0100 (CET)
To: SLE <suse-linux-e@suse.com>

    -----BEGIN PGP SIGNED MESSAGE-----
    Hash: SHA1

    The Tuesday 2005-11-15 at 20:54 -0800, Scott Leighton wrote:

    > Try using the ip number of your local machine instead
    > of localhost. I couldn't connect here with localhost, but
    > could by using the machine's ip 192.168.1.2 ( I have
    > a suspicion that my mysql install doesn't listen on localhost,
    > but uses sockets instead, maybe that's why).

    Ah! Yes, I get something different now:

      SQL Status: 28000
      Error code: 1045
      
      Access denied for user 'cer'@'nimrodel.valinor' (using password: YES)

    which is weird. Very weird, that same password works with phpmyadmin.

      nimrodel:~ # netstat -A inet -l |egrep mysql
      tcp 0 0 nimrodel.valinor:mysql *:* LISTEN
      nimrodel:~ # netstat -A inet -n -l |egrep 3306
      tcp 0 0 192.168.100.2:3306 0.0.0.0:* LISTEN

    Ah! User "cer" in mysql is defined for "localhost", not the full name...
    lets change it. [...] Yes, I can access it using OOo now. Bingo!

    Rekall doesn't seem to complain with the change, nor phpmyadmin.

    Weird! Why did it work previously? What changed?

    Now I have a different problem... I try to create a Table_view (with a
    single field, for just testing), and it will not save (although it
    displays correctly):

      SQL Status: 42000
      Error code: 1064

      You have an error in your SQL syntax; check the manual that corresponds to
      your MySQL server version for the right syntax to use near 'VIEW `View1`
      AS SELECT `Titulo` FROM `Libros` `Libros`' at line 1

    I use rekall or OOo because I have no idea at all of sql; now it seems
    that OOo creates broken SQL!

    Then I got instead a Query/view - but it seems I can not add data to the
    database through a query-view; my tables are linked, so I need to
    indicate the relationships, but if I do then I can not add data... too
    bad, it is unworkable, I wanted a functionality like "access". I can do it
    with rekall, though.

    Arghh! I wonder if there is a manual on using OOo with mysql...

    - --
    Cheers,
           Carlos Robinson

    -----BEGIN PGP SIGNATURE-----
    Version: GnuPG v1.4.0 (GNU/Linux)
    Comment: Made with pgp4pine 1.76

    iD8DBQFDe+DdtTMYHG2NR9URAg8IAJ9PIDhpV89SrVUUudFpYPN41/mPuACeL1TG
    gZGjRWfegM1PgV8LGJ2pDf4=
    =Q5nC
    -----END PGP SIGNATURE----- 

    -- 
Check the headers for your unsubscription address
For additional commands send e-mail to suse-linux-e-help@suse.com
Also check the archives at http://lists.suse.com
Please read the FAQs: suse-linux-e-faq@suse.com
  • Next message: Donn Washburn: "Re: [SLE] Accessing the USB devices"