perfect setup suse 10 - phpmyadmin & mysql question

Discussion in 'Server Operation' started by reddog, Jun 13, 2006.

  1. reddog

    reddog New Member

    hello all,

    well, about a week ago i did the perfect setup for suse10. i wasnt totally happy with the install, so i re-installed last night, everything went perfect.

    i installed ipsconfig to its own FQDN, and that runs on 192.168.1.151. No problems there. Then i create a new site from ispconfig, i'll call that site www.mysite.com, it is a FQDN as well, and i set it up to run on 192.168.1.152.

    I also created an admin for mysite.com to manage the site from ispconfig, as well as a few new email acccounts for mysite.com. The problem comes when i want to login into phpmyadmin, i try two ways: Through ispconfig using the username and password i created for admin to mysite.com, except when i use the password to access phpmyadmin the login is rejected, when i dont use the password, i get logged in...huh!:eek:. As well as no privledges to create a new database for drupal, or nuke or whatever. I get the same results when directly accessing phpmyadmin: https://192.168.1.151:81/phpmyadmin/index.php.

    Why is there no password required? when i setup a password with the user account. Also, why doesnt the user or site have privledges to create databases?

    sorry for the long winded question!! Any help would be greatly appreciated !

    Thanks
    Red
     
  2. falko

    falko Super Moderator ISPConfig Developer

    You must log in with the MySQL user name and password, not with the username of the client or an email user, etc.
    When you create a database with ISPConfig, you have a database name like web1_db1 and a username like web1_u1. web1_u1 is the username you have to log in with.

    When you log in with the user root, and no password is required, then that means that you didn't set a password with the mysqladmin command during the inititla setup. You should change that asap.
     
  3. reddog

    reddog New Member

    hello falko, thank you for the reply !

    i have just created a web1_db1 database, and i also just had an epiphany:eek: ! am i populating the web1_db1 with the tables i need to use for drupal or nuke?


    no problems there, the root sql password is in place,
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Yes, unless there's an installer in drupal or nuke which does it for you. :)
     
  5. reddog

    reddog New Member

    Ok, so now that i'm over my issue with creating databases. i have another issue, this may be related, or it may not.

    i tried installing drupal: did'nt work, all i get is a plain white page when i browse to the site, Drupals' database is setup under web1_db1, drupals' setting.php file was edited accordingly,(i'll include a sample below) and the files uploaded to /var/www/web1/web, (this is because im under a shared ip, and the web1_username is the admin for this site, set in ispconfig)

    a portion of Drupals settings.php:
    Code:
    $db_url = 'mysql://web1_u1:web1_db1_password@localhost/web1_db1';
    $db_prefix = '';  [COLOR="Red"]<< i'm kinda lost there i think it should be "web1_"
    [/COLOR]
    /**
     * Base URL:
     *
     * The URL of your website's main page. It is not allowed to have
     * a trailing slash; Drupal will add it for you.
     */
    $base_url = 'http://www.mysite.com';

    so when drupal didnt work, i thought i would revert to something i know how to install for sure, and thats php-nuke, because i have setup many nuke sites. Anyways, i got the same result, a plain white page......so i checked the error.log from, /var/www/web1/log, but i have no idea what this all means, could you guys please take a peek at it Maybe you can figure out whats up.....PLEASE !!

    I didnt include the whole file, because it became repetative.

    I appreciate you guys helpin this newb out :)eek: theres that word again)
     
  6. falko

    falko Super Moderator ISPConfig Developer

    $db_prefix is optional, you can leave that empty.

    Please disable PHP Safe Mode for that web site in ISPConfig. Then have a look here:
    http://www.howtoforge.com/forums/showthread.php?t=788&highlight=drupal .htaccess
    http://www.howtoforge.com/forums/showthread.php?t=4179&highlight=drupal .htaccess
    http://www.howtoforge.com/forums/showthread.php?t=38&highlight=drupal .htaccess
    http://www.howtoforge.com/forums/showthread.php?t=1897&highlight=drupal .htaccess
    http://www.howtoforge.com/forums/showthread.php?t=2588&highlight=drupal .htaccess
    http://www.howtoforge.com/forums/showthread.php?t=299&highlight=drupal .htaccess
     
  7. reddog

    reddog New Member

    Hello falko,

    well, i disabled php safe mode, as well as editing httpd.conf.....still not working though:(

    httpd.conf
    and just for some extra info; apache2/error_log

    thank you helping !!
     
  8. falko

    falko Super Moderator ISPConfig Developer

Share This Page