Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > Installation/Configuration

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #11  
Old 3rd March 2006, 14:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,704
Thanks: 819
Thanked 5,321 Times in 4,174 Posts
Default

I'am speaking about the mysql users, not the ISPConfig login after the installation.

When you raun the ISPConfig installer, you are asked for the mysql username and password and you have to enter there a mysql user that has the priveliges to add databases and tables. You dont have to fill any mysql databases manually, this is done by the installer automatically.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Sponsored Links
  #12  
Old 3rd March 2006, 14:25
guidovanh guidovanh is offline
Senior Member
 
Join Date: Feb 2006
Location: Leusden, The Netherlands
Posts: 104
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by till
I'am speaking about the mysql users, not the ISPConfig login after the installation.

When you raun the ISPConfig installer, you are asked for the mysql username and password and you have to enter there a mysql user that has the priveliges to add databases and tables. You dont have to fill any mysql databases manually, this is done by the installer automatically.
Please enter your MySQL server: E.G. localhost
Please enter your MySQL user: E.G. root
Please enter your MySQL password: Your MySQL password


I entered the advised names:
MySQL server: localhost
MySQL user: root
and I entered a password
Reply With Quote
  #13  
Old 3rd March 2006, 16:32
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Run this on the command line:
Code:
mysql -u root -p
SHOW DATABASES;
quit;
What's the output of the SHOW DATABASES; command?
__________________
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
  #14  
Old 3rd March 2006, 16:38
guidovanh guidovanh is offline
Senior Member
 
Join Date: Feb 2006
Location: Leusden, The Netherlands
Posts: 104
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
What's the output of the SHOW DATABASES; command?
Code:
mysql> SHOW DATABASES;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| ispconfigdb        |
| mysql              |
| test               |
+--------------------+
4 rows in set (0.02 sec)
Regards,
Guido
Reply With Quote
  #15  
Old 3rd March 2006, 16:48
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

Ok, then do this:

Code:
mysql -u root -p
USE ispconfigdb;
SHOW TABLES;
quit;
What's the output?
__________________
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
  #16  
Old 3rd March 2006, 16:54
guidovanh guidovanh is offline
Senior Member
 
Join Date: Feb 2006
Location: Leusden, The Netherlands
Posts: 104
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
Code:
mysql -u root -p
USE ispconfigdb;
SHOW TABLES;
quit;
What's the output?
Code:
linux:/home/guido # mysql -u root -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 55 to server version: 5.0.18-standard

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SHOW TABLES;
ERROR 1046 (3D000): No database selected
mysql> USE ispconfigdb;
Database changed
mysql> SHOW TABLES;
ERROR 1018 (HY000): Can't read dir of './ispconfigdb/' (errno: 13)
mysql>
Regards,
Guido
Reply With Quote
  #17  
Old 3rd March 2006, 17:09
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
Default

What's the output of
Code:
ls -la /var/lib/mysql
and
Code:
ls -la /var/lib/mysql/ispconfigdb
?
__________________
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
  #18  
Old 3rd March 2006, 17:27
guidovanh guidovanh is offline
Senior Member
 
Join Date: Feb 2006
Location: Leusden, The Netherlands
Posts: 104
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Quote:
Originally Posted by falko
What's the output of
Code:
ls -la /var/lib/mysql
Code:
linux:/home/guido # ls -la /var/lib/mysql
totaal 20524
drwxr-xr-x   5 mysql mysql      312 2006-03-02 21:36 .
drwxr-xr-x  47 root  root      1232 2006-03-02 21:49 ..
-rw-rw----   1 mysql mysql 10485760 2006-02-27 22:08 ibdata1
-rw-rw----   1 mysql mysql  5242880 2006-03-02 21:36 ib_logfile0
-rw-rw----   1 mysql mysql  5242880 2006-02-17 23:44 ib_logfile1
drwx------   2 root  root      5472 2006-02-27 16:51 ispconfigdb
-rw-rw----   1 mysql root     10990 2006-03-03 15:15 linux.err
-rw-rw----   1 mysql mysql        5 2006-03-02 21:36 linux.pid
drwx--x--x   2 mysql mysql     1752 2006-02-17 23:44 mysql
srwxrwxrwx   1 mysql mysql        0 2006-03-02 21:36 mysql.sock
drwxr-xr-x   2 mysql mysql       48 2006-02-17 23:44 test
linux:/home/guido #
Reply With Quote
  #19  
Old 3rd March 2006, 17:30
guidovanh guidovanh is offline
Senior Member
 
Join Date: Feb 2006
Location: Leusden, The Netherlands
Posts: 104
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Code:
linux:/home/guido # ls -la /var/lib/mysql/ispconfigdb
totaal 1209
drwx------  2 root  root    5472 2006-02-27 16:51 .
drwxr-xr-x  5 mysql mysql    312 2006-03-02 21:36 ..
-rw-rw----  1 root  root      65 2006-02-27 16:51 db.opt
-rw-rw----  1 root  root    8806 2006-02-27 16:51 del_status.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 del_status.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 del_status.MYI
-rw-rw----  1 root  root    8678 2006-02-27 16:51 dns_a.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 dns_a.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 dns_a.MYI
-rw-rw----  1 root  root    8666 2006-02-27 16:51 dns_cname.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 dns_cname.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 dns_cname.MYI
-rw-rw----  1 root  root    8970 2006-02-27 16:51 dns_dep.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 dns_dep.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 dns_dep.MYI
-rw-rw----  1 root  root    9040 2006-02-27 16:51 dns_isp_dns.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 dns_isp_dns.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 dns_isp_dns.MYI
-rw-rw----  1 root  root    8720 2006-02-27 16:51 dns_mx.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 dns_mx.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 dns_mx.MYI
-rw-rw----  1 root  root    8904 2006-02-27 16:51 dns_nodes.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 dns_nodes.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 dns_nodes.MYI
-rw-rw----  1 root  root    8714 2006-02-27 16:51 dns_secondary.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 dns_secondary.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 dns_secondary.MYI
-rw-rw----  1 root  root    8906 2006-02-27 16:51 dns_spf.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 dns_spf.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 dns_spf.MYI
-rw-rw----  1 root  root    8874 2006-02-27 16:51 doctype.frm
-rw-rw----  1 root  root  243800 2006-02-27 16:51 doctype.MYD
-rw-rw----  1 root  root    4096 2006-02-27 22:08 doctype.MYI
-rw-rw----  1 root  root    8780 2006-02-27 16:51 groups.frm
-rw-rw----  1 root  root      36 2006-02-27 16:51 groups.MYD
-rw-rw----  1 root  root    4096 2006-02-27 22:08 groups.MYI
-rw-rw----  1 root  root    8746 2006-02-27 16:51 help_documents.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 help_documents.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 help_documents.MYI
-rw-rw----  1 root  root    8904 2006-02-27 16:51 help_nodes.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 help_nodes.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 help_nodes.MYI
-rw-rw----  1 root  root    8936 2006-02-27 16:51 help_tickets.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 help_tickets.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 help_tickets.MYI
-rw-rw----  1 root  root    8756 2006-02-27 16:51 isp_com.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_com.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_com.MYI
-rw-rw----  1 root  root    8970 2006-02-27 16:51 isp_dep.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_dep.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_dep.MYI
-rw-rw----  1 root  root    8992 2006-02-27 16:51 isp_dienste.frm
-rw-rw----  1 root  root      44 2006-02-27 16:51 isp_dienste.MYD
-rw-rw----  1 root  root    3072 2006-02-27 22:08 isp_dienste.MYI
-rw-rw----  1 root  root    9252 2006-02-27 16:51 isp_fakt_artikel.frm
-rw-rw----  1 root  root     396 2006-02-27 16:51 isp_fakt_artikel.MYD
-rw-rw----  1 root  root    3072 2006-02-27 22:08 isp_fakt_artikel.MYI
-rw-rw----  1 root  root    8970 2006-02-27 16:51 isp_fakt_dep.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_fakt_dep.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_fakt_dep.MYI
-rw-rw----  1 root  root    8904 2006-02-27 16:51 isp_fakt_nodes.frm
-rw-rw----  1 root  root     556 2006-02-27 16:51 isp_fakt_nodes.MYD
-rw-rw----  1 root  root    5120 2006-02-27 22:08 isp_fakt_nodes.MYI
-rw-rw----  1 root  root    8820 2006-02-27 16:51 isp_fakt_rechnung.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_fakt_rechnung.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_fakt_rechnung.MYI
-rw-rw----  1 root  root    8996 2006-02-27 16:51 isp_fakt_record.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_fakt_record.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_fakt_record.MYI
-rw-rw----  1 root  root    8816 2006-02-27 16:51 isp_firewall.frm
-rw-rw----  1 root  root     392 2006-02-27 16:51 isp_firewall.MYD
-rw-rw----  1 root  root    3072 2006-02-27 22:08 isp_firewall.MYI
-rw-rw----  1 root  root    8770 2006-02-27 16:51 isp_htaccess.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_htaccess.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_htaccess.MYI
-rw-rw----  1 root  root    8778 2006-02-27 16:51 isp_isp_actions.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_actions.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_actions.MYI
-rw-rw----  1 root  root    8606 2006-02-27 16:51 isp_isp_admin.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_admin.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_admin.MYI
-rw-rw----  1 root  root    8862 2006-02-27 16:51 isp_isp_datenbank.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_datenbank.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_datenbank.MYI
-rw-rw----  1 root  root    9046 2006-02-27 16:51 isp_isp_domain.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_domain.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_domain.MYI
-rw-rw----  1 root  root   14020 2006-02-27 16:51 isp_isp_kunde.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_kunde.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_kunde.MYI
-rw-rw----  1 root  root   20110 2006-02-27 16:51 isp_isp_reseller.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_reseller.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_reseller.MYI
-rw-rw----  1 root  root    9826 2006-02-27 16:51 isp_isp_user.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_user.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_user.MYI
-rw-rw----  1 root  root   15680 2006-02-27 16:51 isp_isp_web.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_web.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_web.MYI
-rw-rw----  1 root  root    9722 2006-02-27 16:51 isp_isp_web_template.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_isp_web_template.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_isp_web_template.MYI
-rw-rw----  1 root  root    8978 2006-02-27 16:51 isp_monitor.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_monitor.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_monitor.MYI
-rw-rw----  1 root  root    8904 2006-02-27 16:51 isp_nodes.frm
-rw-rw----  1 root  root     140 2006-02-27 16:51 isp_nodes.MYD
-rw-rw----  1 root  root    5120 2006-02-27 22:08 isp_nodes.MYI
-rw-rw----  1 root  root   31534 2006-02-27 16:51 isp_server.frm
-rw-rw----  1 root  root    8644 2006-02-27 16:51 isp_server_ip.frm
-rw-rw----  1 root  root      24 2006-02-27 16:51 isp_server_ip.MYD
-rw-rw----  1 root  root    4096 2006-02-27 22:08 isp_server_ip.MYI
-rw-rw----  1 root  root     824 2006-02-27 16:51 isp_server.MYD
-rw-rw----  1 root  root    4096 2006-02-27 22:08 isp_server.MYI
-rw-rw----  1 root  root    8606 2006-02-27 16:51 isp_serverstatus.frm
-rw-rw----  1 root  root      17 2006-02-27 16:51 isp_serverstatus.MYD
-rw-rw----  1 root  root    3072 2006-02-27 22:08 isp_serverstatus.MYI
-rw-rw----  1 root  root    8814 2006-02-27 16:51 isp_traffic.frm
-rw-rw----  1 root  root    8770 2006-02-27 16:51 isp_traffic_ip.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_traffic_ip.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_traffic_ip.MYI
-rw-rw----  1 root  root       0 2006-02-27 16:51 isp_traffic.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 isp_traffic.MYI
-rw-rw----  1 root  root    8908 2006-02-27 16:51 listtype.frm
-rw-rw----  1 root  root    4528 2006-02-27 16:51 listtype.MYD
-rw-rw----  1 root  root    4096 2006-02-27 22:08 listtype.MYI
-rw-rw----  1 root  root    8762 2006-02-27 16:51 login.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 login.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 login.MYI
-rw-rw----  1 root  root    8970 2006-02-27 16:51 multidoc_dep.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 multidoc_dep.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 multidoc_dep.MYI
-rw-rw----  1 root  root    8904 2006-02-27 16:51 multidoc_nodes.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 multidoc_nodes.MYD
-rw-rw----  1 root  root    1024 2006-02-27 16:51 multidoc_nodes.MYI
-rw-rw----  1 root  root    9122 2006-02-27 16:51 session.frm
-rw-rw----  1 root  root       0 2006-02-27 16:51 session.MYD
Reply With Quote
  #20  
Old 3rd March 2006, 17:32
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,739 Times in 2,574 Posts
 
Default

Quote:
Originally Posted by guidovanh
Code:
linux:/home/guido # ls -la /var/lib/mysql
totaal 20524
drwxr-xr-x   5 mysql mysql      312 2006-03-02 21:36 .
drwxr-xr-x  47 root  root      1232 2006-03-02 21:49 ..
-rw-rw----   1 mysql mysql 10485760 2006-02-27 22:08 ibdata1
-rw-rw----   1 mysql mysql  5242880 2006-03-02 21:36 ib_logfile0
-rw-rw----   1 mysql mysql  5242880 2006-02-17 23:44 ib_logfile1
drwx------   2 root  root      5472 2006-02-27 16:51 ispconfigdb
-rw-rw----   1 mysql root     10990 2006-03-03 15:15 linux.err
-rw-rw----   1 mysql mysql        5 2006-03-02 21:36 linux.pid
drwx--x--x   2 mysql mysql     1752 2006-02-17 23:44 mysql
srwxrwxrwx   1 mysql mysql        0 2006-03-02 21:36 mysql.sock
drwxr-xr-x   2 mysql mysql       48 2006-02-17 23:44 test
linux:/home/guido #
Please run
Code:
chown -R mysql:mysql /var/lib/mysql/ispconfigdb
chmod 711 /var/lib/mysql/ispconfigdb
and try again.
__________________
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
cannot access ispconfig site Nu2Linux Installation/Configuration 13 3rd January 2009 15:29
Users and websites aren't created Glorfindel Installation/Configuration 9 23rd February 2006 04:20
42goISP vs. ISPConfig nveid General 1 16th January 2006 09:07
Mirroring ISPConfig with DRBD rodriglm General 5 2nd January 2006 12:48
cant connect to ispconfig kingkunt Installation/Configuration 5 14th December 2005 17:23


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


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