Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 3 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 21st February 2012, 09:11
nicotinovich nicotinovich is offline
Junior Member
 
Join Date: Feb 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Problem with add database after update

Hi!
Config:
Debian 5.0 Lenny, apache 2.2.9-10+lenny12, mysql 5.0.51a
ISPConfig 3.0.4.3

After update to 3.0.4.3 ISPConfig can't create database(from webinterface) ether under client or admin. ispconfig user can access to mysql db dbispconfig, but in /var/log/ispconfig/ispconfig_.log i see: \\\\dbispconfig.sys_log\\\\dosn\\\'t exist\\
No errors in ispconfig monitor:
Сервер: lennywebserv (Debian Lenny)
ISPConfig 3.0.4.3
Состояние: ok (0 неизвестно, 0 info, 0 warnings, 0 critical, 0 errors)
No errors from mysql in syslog and no errors in apache2/error.log

Can anybody help?
Reply With Quote
Sponsored Links
  #2  
Old 21st February 2012, 10:48
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

There seem to be database tables missing in your ispconfig database. From which ispconfig version did you update to 3.0.4.3?
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #3  
Old 21st February 2012, 11:04
nicotinovich nicotinovich is offline
Junior Member
 
Join Date: Feb 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

update from 3.0.2.2
All tables a there.
mysql> show tables;
+-----------------------+
| Tables_in_dbispconfig |
+-----------------------+
| attempts_login |
| client |
| client_template |
| country |
| cron |
| dns_rr |
| dns_slave |
| dns_soa |
| dns_template |
| domain |
| firewall |
| ftp_user |
| help_faq |
| help_faq_sections |
| iptables |
| mail_access |
| mail_content_filter |
| mail_domain |
| mail_forwarding |
| mail_get |
| mail_mailinglist |
| mail_relay_recipient |
| mail_traffic |
| mail_transport |
| mail_user |
| mail_user_filter |
| monitor_data |
| openvz_ip |
| openvz_ostemplate |
| openvz_template |
| openvz_traffic |
| openvz_vm |
| remote_session |
| remote_user |
| server |
| server_ip |
| shell_user |
| software_package |
| software_repo |
| software_update |
| software_update_inst |
| spamfilter_policy |
| spamfilter_users |
| spamfilter_wblist |
| support_message |
| sys_config |
| sys_datalog |
| sys_dbsync |
| sys_filesync |
| sys_group |
| sys_ini |
| sys_log |
| sys_remoteaction |
| sys_session |
| sys_user |
| web_database |
| web_domain |
| web_folder |
| web_folder_user |
| web_traffic |
| webdav_user |
+-----------------------+
61 rows in set (0.00 sec)

ispconfig user have privilegies to access dbispconfig
Reply With Quote
  #4  
Old 21st February 2012, 11:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Maybe a table is corrupted. you should select all tables in phpmyadmin and choose to repair them.

Another possibility is that you cahnged the mysql root password without changing it in ispconfig too. Check that the correct mysql root password is set in the file /usr/local/ispconfig/server/lib/mysql_clientdb.conf
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #5  
Old 21st February 2012, 11:59
nicotinovich nicotinovich is offline
Junior Member
 
Join Date: Feb 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

root password correct and didn't changed.

After repair:
Table Op Msg_type Msg_text
dbispconfig.attempts_login repair status OK
...
dbispconfig.web_traffic repair status OK

nothing changed, still can't create db

ispconfig access dbispconfig when I create db, but not create new db under the root accaunt
ID User Host Database Command Time Status SQL query
Kill 2264 ispconfig localhost:54822 dbispconfig Sleep 20981 --- ---

Last edited by nicotinovich; 21st February 2012 at 12:13. Reason: add
Reply With Quote
  #6  
Old 21st February 2012, 12:04
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 34,586
Thanks: 792
Thanked 4,983 Times in 3,903 Posts
Default

Next step:

http://www.faqforge.com/linux/debugg...-of-a-failure/
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
  #7  
Old 21st February 2012, 12:19
nicotinovich nicotinovich is offline
Junior Member
 
Join Date: Feb 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

config:
# cat lib/mysql_clientdb.conf
<?php

$clientdb_host = 'localhost';
$clientdb_user = 'root';
$clientdb_password = 'secret';

?>

with $clientdb_password I can connect as root to mysql via console or phpmyadmin
Reply With Quote
  #8  
Old 21st February 2012, 12:39
nicotinovich nicotinovich is offline
Junior Member
 
Join Date: Feb 2012
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Now ISPConfig works!!!
Problem was with crontab.
Thanks till.
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
Horde Groupware Webmail Edition ByteMe Networking Tips/Tricks/Mods 17 20th December 2012 10:12
Problem after update. DKLeader Installation/Configuration 3 15th January 2012 12:09
Virtual Users And Domains With Postfix, Courier, MySQL And SquirrelMail -Ubuntu 8.04 c4rdinal HOWTO-Related Questions 112 23rd August 2011 10:49
Package update problem liblzo.so.1 ISPConfig 3 what to use Centos, Debian, Ubuntu? usul Installation/Configuration 1 16th March 2010 08:49
Virtual users... Ubuntu 8.04 spaceuser HOWTO-Related Questions 12 19th June 2008 08:04


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


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