Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

General Support: Install says it completes, but doesn't populate DB

Bottom of Page

1 to 10 of 10

  1.  
    • CommentAuthorguido666
    • CommentTimeJul 29th 2007 edited
     
    I created a DB, and created a user with full privileges for that DB. I run the _install.php, it says it completes (and gives me the admin password, and writes the plog-config.php file with correct entries). When I do a "SHOW TABLES;" in the DB, it's empty. (And obviously Plogger doesn't work.)

    I get to the page that says "Setup is now complete, your login is admin with password blah blah blah". I click proceed and it just takes me back to the same page. It does this in either IE7 or Opera9.

    Any ideas?
    • CommentAuthorguido666
    • CommentTimeJul 29th 2007
     
    I did a tail on the /var/log/httpd/error_log and Plogger generates no errors during the install pages. If you try to go to index.php (of Plogger) it generates "PHP Connect: mysql_connect() [<a href='function.mysql-connect'>function.mysql-connect</a>]: Access denied for user 'ploggeradmin'@'localhost' (using password: YES) in /var/www/html/plogger/plog-functions.php on line 415

    I logged into the DB with the ploggeradmin username (and password of course) successfully.
    • CommentAuthorguido666
    • CommentTimeJul 29th 2007
     
    Ok, more info. I was able to install Gallery2.2.2 just fine. I'm running MySQL 5.0.35. Gallery2 installs just like Plogger, upload some files, give some directories write permissions, give it DB login info, click through the install scripts.

    What is going wrong with Plogger? Someone please help.
    • CommentAuthorguido666
    • CommentTimeJul 31st 2007
     
    Anyone have any ideas? It sure seems like I'm doing everything right, but getting no where.

    This is a fresh install of Fedora Core 7. Like I said, other PHP / MySQL based software seems to work. Please help!
    • CommentAuthorguido666
    • CommentTimeAug 4th 2007
     
    Is there anyone that knows something about this? I really need someone's help.

    I completely reinstalled Fedora 7 fresh, same thing. Is this a problem with FC7? There is nothing else on the box crazy, MySQL / Apache. I again was able to run installers for other PHP web software (this time I tried phpBB3).
  6.  
    if you're using mysql login as the root user and:

    use mysql;
    select * from db;

    you should see a line with the username and database and it should list all permissions, if you don't see a line for this then your GRANT statements aren't working.

    i had some problems like this as well... i had to select the mysql database before running any GRANT satements for some reason, otherwise it would just create the user and not setup the permissions for the database.
    • CommentAuthorguido666
    • CommentTimeAug 4th 2007
     
    Yes, I see these lines. And just in case I made one entry for localhost, one for silicon (the server name), and one for the fully qualified domain name. (This was done before, not just now.)

    That's why I'm really perplexed it's not working. I'm a fairly competent linux user, and install these type of php/apache websites all the time. This one just refuses to do anything, and I really think I need some developer assistance. Do they read these forums?
    • CommentAuthorguido666
    • CommentTimeAug 4th 2007
     
    I go to _install.php, I type in the hostname, db name, password, etc. I click next. I get to this screen that says "Setup is complete. Your username is admin and your password is...", and the when I click the Proceed button, nothing happens (I just get returned to the same page). No tables are populated in the DB.
  9.  
    mysql has a bulit in command tracking... i forget how to enable it off the top of my head but i've used it before when i was having some trouble getting postfix to use mysql. It records every connection, query, and the results, helped me figure out i mispelled a table name in my postfix setup... you know you look at everything 50 times over... but i forgot it...

    you could restart mysql with this, run the install, and then restart mysql (back to normal) and then check out the log to see what queries were run and what problems it's having... i know it's frustrating when it just doesn't work like it's supposed to...
    • CommentAuthorjammindice
    • CommentTimeAug 10th 2007
     
    i looked up the general query log commands if you're still having problems.

    to start query logging:

    stop mysqld.
    run: mysqld --log=/log/location/query.log

    then just restart mysqld after the install script finishes and the query log should show bad authentications or at least why the insert statements aren't working to add tables.

1 to 10 of 10

  1.