Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 13th June 2006, 17:25
reddog reddog is offline
Junior Member
 
Join Date: May 2006
Location: Chicago, IL. USA
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default perfect setup suse 10 - phpmyadmin & mysql question

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!. 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
Reply With Quote
Sponsored Links
  #2  
Old 14th June 2006, 01:41
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
Default

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.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 14th June 2006, 02:31
reddog reddog is offline
Junior Member
 
Join Date: May 2006
Location: Chicago, IL. USA
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hello falko, thank you for the reply !

Quote:
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.
i have just created a web1_db1 database, and i also just had an epiphany ! am i populating the web1_db1 with the tables i need to use for drupal or nuke?


Quote:
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.
no problems there, the root sql password is in place,
Quote:
so i re-installed last night, everything went perfect.
Reply With Quote
  #4  
Old 14th June 2006, 19:31
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
Default

Quote:
Originally Posted by reddog
i have just created a web1_db1 database, and i also just had an epiphany ! am i populating the web1_db1 with the tables i need to use for drupal or nuke?
Yes, unless there's an installer in drupal or nuke which does it for you.
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 16th June 2006, 05:48
reddog reddog is offline
Junior Member
 
Join Date: May 2006
Location: Chicago, IL. USA
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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 = '';  << i'm kinda lost there i think it should be "web1_"

/**
 * 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.

Quote:
[client 192.168.1.1] PHP Warning: main() [<a href='function.main'>function.main</a>]: open_basedir restriction in effect. File(/usr/share/php
5/includes/bootstrap.inc) is not within the allowed path(s): (/var/www/web1/) in /var/www/web1/web/index.php on line 12
[client 192.168.1.1] PHP Warning: main(includes/bootstrap.inc) [<a href='function.main'>function.main</a>]: failed to open stream: Operation
not permitted in /var/www/web1/web/index.php on line 12
[client 192.168.1.1] PHP Warning: main() [<a href='function.include'>function.include</a>]: Failed opening 'includes/bootstrap.inc' for inclu
sion (include_path='/usr/share/php5') in /var/www/web1/web/index.php on line 12
[client 192.168.1.1] PHP Fatal error: Call to undefined function drupal_page_header() in /var/www/web1/web/index.php on line 13
[client 192.168.1.1] PHP Warning: main() [<a href='function.main'>function.main</a>]: open_basedir restriction in effect. File(/usr/share/php
5/includes/bootstrap.inc) is not within the allowed path(s): (/var/www/web1/) in /var/www/web1/web/index.php on line 12
[client 192.168.1.1] PHP Warning: main(includes/bootstrap.inc) [<a href='function.main'>function.main</a>]: failed to open stream: Operation
not permitted in /var/www/web1/web/index.php on line 12
[client 192.168.1.1] PHP Warning: main() [<a href='function.include'>function.include</a>]: Failed opening 'includes/bootstrap.inc' for inclu
sion (include_path='/usr/share/php5') in /var/www/web1/web/index.php on line 12
I appreciate you guys helpin this newb out ( theres that word again)
Reply With Quote
  #6  
Old 16th June 2006, 18:52
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
Default

Quote:
Originally Posted by reddog
Ok, so now that i'm over my issue with creating databases. i have another issue, this may be related, or it may not.
$db_prefix is optional, you can leave that empty.

Quote:
Originally Posted by reddog
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 = '';  << i'm kinda lost there i think it should be "web1_"

/**
 * 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.
Please disable PHP Safe Mode for that web site in ISPConfig. Then have a look here:
http://www.howtoforge.com/forums/sho...upal+.htaccess
http://www.howtoforge.com/forums/sho...upal+.htaccess
http://www.howtoforge.com/forums/sho...upal+.htaccess
http://www.howtoforge.com/forums/sho...upal+.htaccess
http://www.howtoforge.com/forums/sho...upal+.htaccess
http://www.howtoforge.com/forums/sho...upal+.htaccess
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #7  
Old 16th June 2006, 19:58
reddog reddog is offline
Junior Member
 
Join Date: May 2006
Location: Chicago, IL. USA
Posts: 28
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Please disable PHP Safe Mode for that web site in ISPConfig. Then have a look here:
http://www.howtoforge.com/forums/sho...upal+.htaccess
Hello falko,

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

httpd.conf
Quote:
###############ispconfig_log###############
LogFormat "%v||||%b||||%h %l %u %t \"%r\" %>s %b \"%{Referer}i\" \"%{User-Agent}i\"" combined_ispconfig
CustomLog "|/root/ispconfig/cronolog --symlink=/var/log/httpd/ispconfig_access_log /var/log/httpd/ispconfig_access_log_%Y_%m_%d" combined_ispc
onfig

<Directory /var/www/*/web>
Options +Includes -Indexes +FollowSymlinks
AllowOverride All
AllowOverride Indexes AuthConfig Limit FileInfo
Order allow,deny
Allow from all
<Files ~ "^\.ht">
Deny from all
</Files>
</Directory>

<Directory /var/www/*/user/*/web>
Options +Includes -Indexes
AllowOverride All
AllowOverride Indexes AuthConfig Limit FileInfo
Order allow,deny
Allow from all
<Files ~ "^\.ht">
Deny from all
</Files>
</Directory>
and just for some extra info; apache2/error_log

Quote:
[Fri Jun 16 11:00:27 2006] [notice] Graceful restart requested, doing restart
[Fri Jun 16 11:00:28 2006] [notice] Apache/2.0.54 (Linux/SUSE) configured -- resuming normal operations
[Fri Jun 16 11:00:28 2006] [warn] long lost child came home! (pid 11045)
[Fri Jun 16 11:02:51 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:02:51 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:02:53 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:02:53 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:02:55 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:02:55 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:16:54 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:16:54 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:17:40 2006] [notice] Graceful restart requested, doing restart
[Fri Jun 16 11:17:40 2006] [notice] Apache/2.0.54 (Linux/SUSE) configured -- resuming normal operations
[Fri Jun 16 11:17:40 2006] [warn] long lost child came home! (pid 19670)
[Fri Jun 16 11:18:24 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:18:24 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:18:26 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:18:26 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:23:35 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:23:35 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:23:36 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:23:36 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:23:38 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:23:38 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:26:42 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:26:42 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:26:44 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:26:44 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:27:53 2006] [notice] caught SIGTERM, shutting down
[Fri Jun 16 11:27:54 2006] [notice] suEXEC mechanism enabled (wrapper: /usr/sbin/suexec2)
[Fri Jun 16 11:27:54 2006] [notice] Apache/2.0.54 (Linux/SUSE) configured -- resuming normal operations
[Fri Jun 16 11:28:04 2006] [error] an unknown filter was not added: PHP
[Fri Jun 16 11:28:04 2006] [error] an unknown filter was not added: PHP
thank you helping !!
Reply With Quote
  #8  
Old 17th June 2006, 13:59
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,748 Times in 2,579 Posts
 
Default

Have a look here: http://www.howtoforge.com/forums/sho...che2_php%22%5D
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
tlsmgr webmail problem, suse 9.3 perfect setup dschmid Installation/Configuration 44 2nd April 2006 19:55
Is there also a Perfect Setup for SuSE 9.1 bluegrass Installation/Configuration 7 18th January 2006 18:16
The Perfect Setup - SUSE 9.3 (firewall?!) bogdinator HOWTO-Related Questions 7 12th December 2005 13:31
The Perfect Setup Suse 9.3 - Postfix problems new_bee05 HOWTO-Related Questions 20 25th November 2005 03:30
MYSQL and the perfect setup 9.2 Suse pkfrizzlefry HOWTO-Related Questions 7 21st May 2005 21:12


All times are GMT +2. The time now is 17:17.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.