Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

installation: patchdb.sh argument order

Help
ragsnas
2010-04-26
2013-04-26
  • ragsnas
    ragsnas
    2010-04-26

    The patchdb.sh help tells me to add the MySQL connection data as arguments, but that doesn't work because i do not know in hwat order and form i shall do that.

     
  • Graham Pitt
    Graham Pitt
    2010-04-26

    Hello,

    Enter the same arguments you would enter to the command line mysql command. I.e. if you login with the the mysql client like this:

         mysql -u root -p

    Then your command would be:

         ./patch.sh -u root -p

    So just replace the mysql application with the patch script.

    Thanks,

    Graham

     
  • ragsnas
    ragsnas
    2010-04-26

    Okay, but now it says:

    ERROR 1146 (42S02) at line 1: Table 'groogle.version' doesn't exist
    The installed schema is patched to version .
    

    ?8-o

     
  • Graham Pitt
    Graham Pitt
    2010-04-26

    Could you tell me the following:
    - which version of groogle you are installing?
    - What platform are you installing on?

    Also could you paste the full output from the patch script here?

    Thanks,

    Graham

     
  • ragsnas
    ragsnas
    2010-04-26

    I am using MAMP on a Mac Book with Snow Leopard OS. I try to install groogle 0.9.2.
    Before i use the patch, the database exists and is empty, aftwards it exists as well and is empty. I used the db root user with the patchdb.sh.
    The full output of the patchdb.sql is:

    =========================================================================
    Backing up existing groogle database to file 'groogle-1272272996.sql'
    If the upgrade fails, please file a bug and provide this database backup.
    =========================================================================
    ERROR 1146 (42S02) at line 1: Table 'groogle.version' doesn't exist
    The installed schema is patched to version .
    Patching finished.
    
     
  • Graham Pitt
    Graham Pitt
    2010-04-26

    Okay.  Try logging in with the mysql client:

    mysql -u root -p

    …. and dropping the groogle database.

    drop database groogle;
    drop user groogle;
    flush privileges;

    ….. then re-run the patch script.

    Thanks,

    Graham

     
  • ragsnas
    ragsnas
    2010-04-26

    The installed schema is patched to version 19.
    Patching finished.

    That worked. Should have thought of it myself!
    Thanks a lot for the fast help and for working on this project in general.

    Groogle is still not running though. The website still says "Eeeeeeeeeeek!" and that the database is sick. I did alter the db.php though and put in the data for the root account? Do i have to use the groogle account there? If so, what's the password it uses?

    <?php
    // The DSN for our domain model.
    $dsn = 'mysql://root:****@localhost/groogle';
    

    :(

     
  • Graham Pitt
    Graham Pitt
    2010-04-26

    The default dsn will connect to a default groogle install.

    $dsn = 'mysql://groogle:groogle@localhost/groogle';

    If this isn't connecting try to login using 'mysql -u groogle -h localhost -p' from the command line, giving groogle as  password.  If you cannot connect using that then your database is not listening on the loopback.  If can connect but you cannot login then the chances are there are some default account rules in your mysql database that are matching prior to the groogle account.

    Give it a try and let me know which it is.

    Thanks,

    Graham

     
  • Croco
    Croco
    2010-05-19

    I am able to connect using the command line but I can figure out what prevent the software from connecting.
    I am not able to find any other accounts associated with groogle.

    What do you think the problem is?

    Thanks in advance,

     
  • Croco
    Croco
    2010-05-19

    I cannot* figure out what prevents the software*

     
  • Croco
    Croco
    2010-05-19

    It seems I am getting some type of exception with the following message "Couldn't locate driver named mysql", does this help?

     
  • Graham Pitt
    Graham Pitt
    2010-05-19

    Hello,

    Firstly, have you restarted your web server?  Secondly, if you have or it doesn't help could you list the pecl/pear mysql modules you have installed? (pear list).  In your list of installed modules you should have MDB2_Driver_mysql.

    Thanks,

    Graham

     
  • Croco
    Croco
    2010-05-20

    # pear list
    Installed packages, channel pear.php.net:
    =========================================
    Package              Version State
    Archive_Tar          1.3.6   stable
    Auth                 1.6.2   stable
    Console_Getopt       1.2.3   stable
    File_Archive         1.5.4   stable
    HTML_Template_IT     1.2.1   stable
    Log                  1.12.0  stable
    MDB2                 2.4.1   stable
    MDB2_Driver_mysql    1.4.1   stable
    MIME_Type            1.2.0   stable
    Net_UserAgent_Detect 2.3.0   stable
    PEAR                 1.9.0   stable
    Structures_Graph     1.0.3   stable
    Text_Diff            1.1.1   stable
    XML_RPC              1.5.3   stable
    XML_Util             1.2.1   stable

    # pecl list
    Installed packages, channel pecl.php.net:
    =========================================
    Package Version State
    svn     1.0.0   stable

    As I read online I need to install pdo_mysql

    I will do that and check if that solves my problem.

    Thanks,

     
  • Croco
    Croco
    2010-05-21

    yep it seems I was missing the pdo_mysql

    works fine now

    Thanks,