Update failed, lost client information (not the files)

Discussion in 'Installation/Configuration' started by joosimol, Jan 18, 2010.

  1. joosimol

    joosimol New Member

    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.
     
  2. till

    till Super Moderator Howtoforge Staff HowtoForge Supporter ISPConfig Developer

    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.
     
  3. joosimol

    joosimol New Member

    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.
     
  4. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    Can you post the output of
    Code:
    ls -la /tmp/
    ?
     
  5. joosimol

    joosimol New Member

    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? :)
     
    Last edited: Jan 20, 2010
  6. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

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

    joosimol New Member

    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 */;
    
     
  8. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

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

    joosimol New Member

  10. falko

    falko Super Moderator Howtoforge Staff Moderator HowtoForge Supporter ISPConfig Developer

    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. :(
     
  11. joosimol

    joosimol New Member

    Yep, backups for wussies - so in other words, no. Perhaps here's a lesson to learn...

    Now the question is that what if I continue using this (fresh) install of ispconfig2 will it eventually overwrite the settings (with empty values or something) that work atm (firewall rules, databases, user folders, ssh/mysql/ftp logins, apache redirects, etc?!
     

Share This Page