Welcome to Pandora FMS Community!

Find answers, ask questions, and connect with our community around the world.

  • MYSQL Error

    Posted by mkaylor on July 16, 2008 at 15:03

    I’m new to Pandora. Had a lot of things that I was confused on so I decided to start over. Did a fresh install and I get this error from the pandora_console.

    get_db_all_rows_sql (“SELECT nivel FROM `tusuario` WHERE `id_usuario` = ‘admin’ LIMIT 1 LIMIT 1”) :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 ‘LIMIT 1’ at line 1

    Can someone point me to the right direction. I have blown away the database and reinstalled it about 20 times with no luck.

    I’m trying to install 1.3.1 on an Ubuntu 8.04 Server.

    Thanks for the help,
    Mike

    manu replied 16 years, 7 months ago 3 Members · 6 Replies
  • 6 Replies
  • manu

    Member
    July 17, 2008 at 01:30
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Is that the official 1.3.1 tar.gz or it is the trunk/ version?

  • raul

    Member
    July 17, 2008 at 06:30
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    I have searched in ALL the code the “LIMIT 1 LIMIT 1” string and haven’t found anything, so, I don’t know why it is duplicated.

    Where do you see the

    get_db_all_rows_sql ("SELECT nivel FROM `tusuario` WHERE `id_usuario` = 'admin' LIMIT 1 LIMIT 1"):.... 

    Error?

  • mkaylor

    Member
    July 17, 2008 at 08:56
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Thanks for the help!!!

    I did use the trunk version of 1.3.1. I thought that was the one to use. I will go back and try the other. As far as were I see it on the screen, it says it 7 times under the Operations Menu.

    Even though it logs me in OK, It also says this at the bottom of the page:

    You don’t have access to this page

    No access

    Access to this page is restricted to authorized users only, please contact system administrator if you need assistance.
    Please know that all attempts to access this page are recorded in security logs of Pandora System Database

  • manu

    Member
    July 17, 2008 at 09:11
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    Hi,

    Keep in mind we’re working everyday in the trunk version (for instance today several commits have been done), so you might want to “svn update” or just download the official and stable 1.3.1 and play with it till the 2.0 is released.
    You choose 🙂

  • mkaylor

    Member
    July 17, 2008 at 10:04
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    I think that was my mistake. I downloaded the stable version, reinstalled and it all works now. I thought the trunk version was the stable version. Thanks for the help!! Please keep up the great work!!

    Mike

  • manu

    Member
    July 18, 2008 at 01:25
    0 Karma points
    Community rank: tentacle-noob-1 Tentacle noob
    Like it
    Up
    0
    Down
    Drop it
    ::

    I’m glad you sorted it out!
    The trunk version is pretty stable I have to say, but since we’re committing new changes everyday, database schema might change as well as other console things, therefore if you wanna use the trunk version to have the latest things you gotta be careful.

    Enjoy PandoraFMS!
    Manu