HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Installation/Configuration (http://www.howtoforge.com/forums/forumdisplay.php?f=16)
-   -   Update failed, lost client information (not the files) (http://www.howtoforge.com/forums/showthread.php?t=42779)

joosimol 18th January 2010 22:13

Update failed, lost client information (not the files)
 
I was updating to the latest stable version of ispconfig2 but the update didn't completely so swell, I googled the error message (I think it was mysql-related) and got a fix and ran the whole update again...got further but still errors with mysql. (I can't link any of these errors because I did all of this almost a week ago and just now got the time for this solving.)

The problem is now that I can start the ispconfig daemon but it acts like it's first time on. Only login that works is admin/admin and there's no clients or sites or anything, firewall rules it's all gone!
I guess the problem lies in the db_ispconfig? I have no backup of it so what to do (or does the update take a backup)? Apache and everything works fine, sites and logins are fine but just not the ispconfig part. HELP!

I can run the ispconfig update once more to see what error messages I end up if necessary...and provide any logs you may need of course.

till 19th January 2010 11:39

The problem was that you run the setup script a second time without creating the /root/ispconfig folder before. So the setup assumed that no ispconfig is installed and it was run in install instead of update mode.

Take a look in the /tmp and /root/ folder if there are any backups as ISPConfig makes a backup before it upgrades the server.

joosimol 19th January 2010 15:17

I don't think the setup ran in install mode, it never asked me about where everything was... There are two .tar.gz files and .sql file in /tmp/ but the sql file is really small and the tar ball that should be ispconfig rather then the user files is also very very small. In /root/ there's only certs.

If it ran in install mode shouldn't all the user files and logins be gone too?!

If I now start using this install of ispconfig2 will it overwrite the existing logins? I have only changed admin password from it for now. I mean if I recreate the situation I had...will it make things even worse? :D Everything is fine but ispconfig is nullified, that's the main problem.
Can't it recreate the rules/settings I had put from the raw confs of my system? Even firewall rules still apply as ispconfig says there none.

falko 20th January 2010 13:40

Can you post the output of
Code:

ls -la /tmp/
?

joosimol 20th January 2010 13:53

Sure.
Code:

total 2595992
drwxrwxrwt  5 root        root              36864 2010-01-20 13:10 .
drwxr-xr-x 21 root        root              4096 2009-11-01 16:11 ..
-rw-------  1 root        root                765 2010-01-13 13:36 existing_db_01_13_2010__13_36_22.sql
-rw-------  1 root        root                765 2010-01-13 18:23 existing_db_01_13_2010__18_23_54.sql
-rw-------  1 root        root        1316310348 2010-01-13 12:41 home_admispconfig_01_13_2010__13_36_22.tar.gz
-rw-------  1 root        root        1319100911 2010-01-13 17:26 home_admispconfig_01_13_2010__18_23_54.tar.gz
drwxrwxrwt  2 root        root              4096 2009-11-01 16:11 .ICE-unix
-rw-------  1 root        root                182 2010-01-13 12:34 root_ispconfig_01_13_2010__13_36_22.tar.gz
-rw-------  1 root        root          18930123 2010-01-13 17:19 root_ispconfig_01_13_2010__18_23_54.tar.gz
-rw-------  1 root        root                  0 2010-01-15 23:59 sess_0180cf98bbe21917d6706bcd3df9bad8
-rw-------  1 root        root                  0 2010-01-15 00:30 sess_0610e618497c57d4373eb33e613cbbf0
-rw-------  1 root        root                  0 2010-01-11 00:30 sess_096f16cc3b724bd9cee467fe0e7e6aee
-rw-------  1 root        root                  0 2010-01-17 23:59 sess_0c4c5968e9a550f023c6e5311e37f5fb
-rw-------  1 root        root                  0 2010-01-11 02:05 sess_1020502cd24099975f4668f120681885
-rw-------  1 root        root                  0 2010-01-12 23:59 sess_17429bec60513e25cec173e486f7584e
-rw-------  1 root        root                  0 2010-01-10 23:59 sess_17a102a22d67c57a1d59477891e52d75
-rw-------  1 root        root                  0 2010-01-12 02:05 sess_19db9606a178bfa1273104fc5240fe38
-rw-------  1 root        root                  0 2010-01-15 15:15 sess_1be78dc2ea9e246b4401cf9afe854e46
-rw-------  1 root        root                  0 2010-01-16 00:30 sess_1d4402e33ff7f07b7a2ff04ce10e0ae0
-rw-------  1 root        root                  0 2010-01-13 23:59 sess_28b794e108a9bac85fd487a492045b7a
-rw-------  1 root        root                  0 2010-01-13 18:24 sess_292a4d3146176986e8b2b9edc0da13dc
-rw-------  1 root        root                  0 2010-01-09 03:15 sess_2abc4cbf16dda10295f8a73090a3aa8f
-rw-------  1 root        root                  0 2010-01-12 04:00 sess_2bdf914ca23294073632516fa7390efd
-rw-------  1 root        root                  0 2010-01-12 23:59 sess_2c79ed1372817cf98c3ac74504864eb4
-rw-------  1 root        root                  0 2010-01-14 04:00 sess_2e7f9c83669479590fc506de1330d4b1
-rw-------  1 root        root                  0 2010-01-14 23:59 sess_335286f132f6be4511278b86b207e8f0
-rw-------  1 root        root                  0 2010-01-13 23:59 sess_336357eebe50df200feb1133a3c155cd
-rw-------  1 root        root                  0 2010-01-14 23:59 sess_336d1c66a350c903b564448eacf6ee63
-rw-------  1 root        root                  0 2010-01-13 16:29 sess_3687496e0f0237bdaf0f814e97e3f6a2
-rw-------  1 root        root                  0 2010-01-13 03:15 sess_370b3a88112fa6c45c322664c99a5fa2
-rw-------  1 root        root                  0 2010-01-08 03:15 sess_387fc75479701a5fed57ef271d481527
-rw-------  1 root        root                  0 2010-01-10 00:30 sess_3cb3759a49b1a8cfe9aab7bccd132743
-rw-------  1 root        root                  0 2010-01-13 13:37 sess_43cf8bb9a4be5bf6d970729f0747df92
-rw-------  1 root        root                  0 2010-01-16 02:05 sess_4631b4714c177b8d300867fa9b237eb2
-rw-------  1 root        root                  0 2010-01-09 15:15 sess_4c67efaf14b93d56e9e3f05812e0c88c
-rw-------  1 root        root                  0 2010-01-10 15:15 sess_4e0b40b97092123ca4114510f176b272
-rw-------  1 root        root                  0 2010-01-15 00:40 sess_4e4686b647d0e031a050c3d9ec0cb1e3
-rw-------  1 root        root                  0 2010-01-08 23:59 sess_4e52902bf1b88d86235ccc6e8fb20026
-rw-------  1 root        root                  0 2010-01-13 13:37 sess_4e7a4c0c9c8284e9e6b46c27de3f4ca2
-rw-------  1 root        root                  0 2010-01-09 00:40 sess_5221c9c1d7703c5e43227c4e9daae09f
-rw-------  1 root        root                  0 2010-01-12 03:15 sess_53a9248c10211679d03cca49bf65d62d
-rw-------  1 root        root                  0 2010-01-10 23:59 sess_5a8804d10e14c8f9216d8797cb20ebbd
-rw-------  1 root        root                  0 2010-01-14 02:05 sess_5dccd5cbbbbd83b7c328aac3ee372570
-rw-------  1 root        root                  0 2010-01-08 04:00 sess_5e0a8c6a643e9e752e199478be500088
-rw-------  1 root        root                  0 2010-01-12 23:59 sess_5edfa7eeffbd330e453af9b2d91be87e
-rw-------  1 root        root                  0 2010-01-09 00:30 sess_5f15f7b192a26f76f5e64528de4f86d1
-rw-------  1 root        root                  0 2010-01-18 02:05 sess_642c8dbfda2796d717edfac76bf0b9dc
-rw-------  1 admispconfig admispconfig        58 2010-01-18 22:55 sess_65ad61f04ceb4f7ea01f9c1f7414094c
-rw-------  1 root        root                  0 2010-01-18 04:00 sess_66254b4dd578551f31a8f72a01f7a090
-rw-------  1 root        root                  0 2010-01-17 02:05 sess_68b06e8a737f0885bd2ad4d0a25cdaaa
-rw-------  1 root        root                  0 2010-01-11 03:15 sess_6a410589d0640672f7390f6ee623e424
-rw-------  1 root        root                  0 2010-01-13 18:45 sess_6b72b38d1ade3d6312b0b4a4600e3aa0
-rw-------  1 root        root                  0 2010-01-13 02:05 sess_6d227d967fc31464dfcb72947e97ed56
-rw-------  1 root        root                  0 2010-01-08 02:05 sess_6d5a429ff1f20c8342785a01e145702e
-rw-------  1 root        root                  0 2010-01-15 02:05 sess_6da6af04c304d9f1fc24a7640303f0e4
-rw-------  1 root        root                  0 2010-01-11 23:59 sess_6e75e530bc870bf94e17544a52d7dec7
-rw-------  1 root        root                  0 2010-01-14 00:30 sess_6f07ec703f43053ee57750fa1598ab03
-rw-------  1 root        root                  0 2010-01-09 04:00 sess_70b3b17e9dc572a9af3ea9144d4c9fb9
-rw-------  1 root        root                  0 2010-01-13 18:23 sess_73ffa71aa0deba438249a955a8633353
-rw-------  1 root        root                  0 2010-01-13 00:40 sess_781eea35f57d6edff030526568583660
-rw-------  1 root        root                  0 2010-01-12 15:15 sess_79f507e8837d838865072337c0e07cb0
-rw-------  1 root        root                  0 2010-01-13 16:08 sess_7b7fa25707f08c30979e71c87a1fd424
-rw-------  1 root        root                  0 2010-01-10 23:59 sess_7df6dc77758fa67099b975da9255aa9e
-rw-------  1 root        root                  0 2010-01-17 15:15 sess_7e4d6749c65aeb2b15b7beb49904808d
-rw-------  1 root        root                  0 2010-01-14 04:00 sess_7e82edb31ce317b268215b83d4e17b9d
-rw-------  1 root        root                  0 2010-01-10 02:05 sess_8422e8f404e1df51085acdcc1e5a7ab8
-rw-------  1 root        root                  0 2010-01-18 04:00 sess_859de0744f01d2482b800438cf94f3ee
-rw-------  1 root        root                  0 2010-01-09 23:59 sess_8c6f9bf064f703bbc695ef4bc4e9b636
-rw-------  1 root        root                  0 2010-01-12 00:30 sess_8de6402b4c3ef726bca45d23e1cf782e
-rw-------  1 root        root                  0 2010-01-11 04:00 sess_94ef216b142827792a243d26f47ae7f2
-rw-------  1 root        root                  0 2010-01-08 15:15 sess_972bc370d2063ed7603c87f7b019cfe0
-rw-------  1 root        root                  0 2010-01-11 23:59 sess_97a2edc42bb5bc4212a955c6e2d55347
-rw-------  1 root        root                  0 2010-01-16 23:59 sess_9883b0c93183bb9628c2a898c7f390b5
-rw-------  1 root        root                  0 2010-01-13 04:00 sess_99863f9a86938cfb87cff8ccaaa38a74
-rw-------  1 root        root                  0 2010-01-15 23:59 sess_9a9bfc66f57302aa7abab4656fc9638d
-rw-------  1 root        root                  0 2010-01-17 23:59 sess_9d831199194ebd37a624ab0c7454943d
-rw-------  1 root        root                  0 2010-01-09 23:59 sess_9de9e206f066bafb96c9f32687311bfc
-rw-------  1 root        root                  0 2010-01-11 23:59 sess_a0081be4558881469321909dadd2d26f
-rw-------  1 root        root                  0 2010-01-07 23:59 sess_a024bd12c70cad6e8fdcf0e2524641c0
-rw-------  1 root        root                  0 2010-01-17 04:00 sess_a110d68760ba0560a0b18ce11e391011
-rw-------  1 root        root                  0 2010-01-17 00:40 sess_a11b4388ab560055ee9be39412e90471
-rw-------  1 root        root                  0 2010-01-13 16:10 sess_a2b3aa04750265178296b1f988b7d155
-rw-------  1 root        root                  0 2010-01-10 03:15 sess_a41349db194250a85c2b8a009538e573
-rw-------  1 root        root                  0 2010-01-15 04:00 sess_a861cb3546cbf19ecb419df2822f8e07
-rw-------  1 root        root                  0 2010-01-11 00:40 sess_a9436db48dcc9b1ad75651193c67e84e
-rw-------  1 root        root                  0 2010-01-15 23:59 sess_a9a66a5f23d0d0b8cc9a6cce5fdcfbff
-rw-------  1 root        root                  0 2010-01-17 03:15 sess_a9edbadf10a6a7e2abac5f1fdb504215
-rw-------  1 root        root                  0 2010-01-13 15:15 sess_b2374ad3d597a8292d7c20e6155fca40
-rw-------  1 root        root                  0 2010-01-16 15:15 sess_bb02cac3275a11885194bf94d5ae8cb4
-rw-------  1 admispconfig admispconfig    359903 2010-01-18 23:00 sess_bc5a2c7ab8815f6fe5200adba4d867f0410596e1
-rw-------  1 root        root                  0 2010-01-07 23:59 sess_c0ed1a039e2c0df67d424258675d330f
-rw-------  1 root        root                  0 2010-01-13 23:59 sess_c47605fff41f7c4cdcf165870cb3c26e
-rw-------  1 root        root                  0 2010-01-09 23:59 sess_c727c3c0e2f041ab6d45ed9d158d2f64
-rw-------  1 root        root                  0 2010-01-13 00:30 sess_c8e78927d5906824d988eb4be3183840
-rw-------  1 root        root                  0 2010-01-18 22:57 sess_c9f4b97fa42561784921eefaf186eb0b
-rw-------  1 root        root                  0 2010-01-14 00:40 sess_cb359e4a88b8b5699620a7f272a5b252
-rw-------  1 root        root                  0 2010-01-17 23:59 sess_cb4693bd2687d229a8e589ab7b59b8be
-rw-------  1 root        root                  0 2010-01-08 23:59 sess_ccc579088536f4de436aebf648527a8f
-rw-------  1 root        root                  0 2010-01-16 23:59 sess_ccd01e554082580f7d6870ee16bce74a
-rw-------  1 root        root                  0 2010-01-18 22:46 sess_cf378d94a0472adc96f0e68ff4216feb
-rw-------  1 root        root                  0 2010-01-09 02:05 sess_d079fa273b08bcf5a862df03c0946e0f
-rw-------  1 admispconfig admispconfig    460507 2010-01-18 22:47 sess_d2434e6d2d1189bef7343a2c5b6ae53bf45dd680
-rw-------  1 root        root                  0 2010-01-16 00:40 sess_d336b59dc3923e259be01c236b8cb77b
-rw-------  1 root        root                  0 2010-01-10 04:00 sess_d48c8a3a5fe4dca3d1a5603904939969
-rw-------  1 root        root                  0 2010-01-14 23:59 sess_d5dc249eb2b6c4829d16d4b2f0234e06
-rw-------  1 root        root                  0 2010-01-17 00:30 sess_d6c1e1e24e43e13d7806870706c47579
-rw-------  1 root        root                  0 2010-01-08 23:59 sess_d95e7860cc80c600583326f55170dbe3
-rw-------  1 root        root                  0 2010-01-17 04:00 sess_da9a4776c4dab34d3c7dc3084f4b0cb9
-rw-------  1 root        root                  0 2010-01-13 13:36 sess_daecca7350d322c49c53c52a1da3f4c4
-rw-------  1 root        root                  0 2010-01-16 23:59 sess_dce2fd35c517e5e601514fef9e3f64d1
-rw-------  1 root        root                  0 2010-01-12 00:40 sess_e1b67ec2d5c5ccf9b274a50c80c2866e
-rw-------  1 admispconfig admispconfig        25 2010-01-18 23:00 sess_e23c9a1bda3113280145f35f69100383
-rw-------  1 root        root                  0 2010-01-16 04:00 sess_e3505ade56fde40f988bf8a438f41a9f
-rw-------  1 root        root                  0 2010-01-08 00:40 sess_e5b33eecbc75b639f153a7ef621182c2
-rw-------  1 root        root                  0 2010-01-13 18:24 sess_e6223c6975422c15396cc42ef9bb4957
-rw-------  1 root        root                  0 2010-01-14 15:15 sess_e72c3ac17a104e3f2d68ad06f2a14fe0
-rw-------  1 root        root                  0 2010-01-15 04:00 sess_e9f011d09a86da1dd03597342257a0b7
-rw-------  1 root        root                  0 2010-01-13 16:19 sess_eb70618a2b287e0a92bac66412874e54
-rw-------  1 root        root                  0 2010-01-08 00:30 sess_ebe1771255284e955c18d026101b67be
-rw-------  1 root        root                  0 2010-01-18 00:30 sess_ec57192bb59262695c6d5f8ec7bfb850
-rw-------  1 root        root                  0 2010-01-11 15:15 sess_ec839d3e49b35740f9f23ec3fe64ffcd
-rw-------  1 root        root                  0 2010-01-07 23:59 sess_ef444a4bb6cb0cab88a2979dbc9e8b33
-rw-------  1 root        root                  0 2010-01-14 03:15 sess_f1eadbc8a136b80f17ed15ffd329b1e6
-rw-------  1 root        root                  0 2010-01-16 03:15 sess_f228eac40bd66afd770cd0c0dfc9690d
-rw-------  1 root        root                  0 2010-01-18 15:15 sess_f5fd985342843899be4ed0ce29700077
-rw-------  1 root        root                  0 2010-01-16 04:00 sess_f9369b03c1185dbe15a9fee8cdc44365
-rw-------  1 root        root                  0 2010-01-10 00:40 sess_fc00a4d328ed6843e2079c0cde242a7a
-rw-------  1 root        root                  0 2010-01-15 03:15 sess_fe05da331d1a1f80f86b8f37fd5161cd
-rw-------  1 root        root                  0 2010-01-18 03:15 sess_fe22251fca50ec199cba4fdbaeddb2a7
-rw-------  1 root        root                  0 2010-01-18 00:40 sess_fe8ea3472d02c8c745b48d219296a061
-rw-------  1 root        root                  0 2010-01-13 16:54 .spamassassin311291MAyUCtmp
-rw-------  1 root        root                  0 2010-01-13 16:54 .spamassassin31132d6G6Kstmp
drwxr-xr-x  2 root        root              4096 2009-11-02 02:20 .webmin
drwxrwxrwt  2 root        root              4096 2009-11-01 16:11 .X11-unix

Dunno if I was dumb but I ran the setup process once more to get these errors:
Code:

All prerequisites are fulfilled.
Here we go...

Connected successfully to db db_ispconfig
Restarting some services...
./setup2: line 1143: [: ==: unary operator expected
Shutting down ISPConfig system...
/root/ispconfig/httpd/bin/apachectl stop: httpd (no pid file) not running
ISPConfig system stopped!
Starting ISPConfig system...
Syntax error on line 1073 of /root/ispconfig/httpd/conf/httpd.conf:
ServerName takes one argument, The hostname of the server
/root/ispconfig/httpd/bin/apachectl startssl: httpd could not be started
No results found!ISPConfig system is now up and running!
Congratulations! Your ISPConfig system is now installed. If you had to install quota, please take the steps described in the installation manual. Otherwise your system is now available without reboot.

Helps? :)

falko 21st January 2010 15:23

The SQL dumps really look a bit small. What's in /tmp/existing_db_01_13_2010__18_23_54.sql?

joosimol 21st January 2010 16:43

Code:

-- MySQL dump 10.11
--
-- Host: localhost    Database: db_ispconfig
-- ------------------------------------------------------
-- Server version      5.0.32-Debian_7etch11-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;


falko 22nd January 2010 15:32

Ok, that's an empty SQL dump... :( Does the original ISPConfig database with your data still exist, or is it empty as well?

joosimol 24th January 2010 08:55

http://www.johnnys.fi/db_ispconfig.sql
Seems default to me. Ideas? :D

falko 25th January 2010 13:49

At least the isp_isp_user and isp_isp_web tables are empty. If you have no backup of the previous working database, there's no fix. :(


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

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