The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Delete Account and Database Still Lives

Discussion in 'General Discussion' started by Curt, Feb 11, 2002.

  1. Curt

    Curt Well-Known Member

    Joined:
    Oct 16, 2001
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    6
    I delete an account with WHM that had a database associated with it today then I recreated an account with the same name and the old database still lives.

    Should the database associated with an account be getting deleted when the account is deleted in WHM?
     
  2. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    Is the database in the new naming scheme or is it ancient (pre- new naming scheme)

    Does it have the form &user_databasename& or is it just &databasename&....

    I have seen this feature work sporadically even when Mysql and cpanel is completely up to date- I am not sure what the lynchpin into getting this to function.

    It could be worth a bug report unless one already exists.....
    Probably has something to do with the fact that mysql is the only item that *isn't* encapsulated within user accounts. Makes it tough to tie those things together probably.


    ;)
     
  3. Curt

    Curt Well-Known Member

    Joined:
    Oct 16, 2001
    Messages:
    90
    Likes Received:
    0
    Trophy Points:
    6
    It was using what I assume to be the new/current naming scheme &user_databasename&. It was on an account and database that I created today then I killed the account and recreated the account with the same account name and the old database and database user was still there.

    I am currently on WHM 4.5.0 and Cpanel 4.4.0-66

    I just did not know if this was normal or not for my current load.
     
  4. moronhead

    moronhead Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    706
    Likes Received:
    0
    Trophy Points:
    16
    [quote:2d1cee9591][i:2d1cee9591]Originally posted by feanor[/i:2d1cee9591]

    Is the database in the new naming scheme or is it ancient (pre- new naming scheme)

    Does it have the form &user_databasename& or is it just &databasename&....

    [/quote:2d1cee9591]

    Is this new database naming scheme in a new build? Ours is still generating dbs in the usual user_databasename format.
     
  5. snowgod

    snowgod Well-Known Member

    Joined:
    Sep 23, 2001
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    I think Travis means the new db naming schema IS user_dbname

    Long ago, cpanel used to just create dbname (no prefix).
     
  6. AlaskanWolf

    AlaskanWolf Well-Known Member

    Joined:
    Aug 11, 2001
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Fremont CA
    and i thought i was the only one....seems to be true...u kill an account yet its db's still live on ;(

    i just submitted a bug report on this
     
  7. moronhead

    moronhead Well-Known Member

    Joined:
    Aug 12, 2001
    Messages:
    706
    Likes Received:
    0
    Trophy Points:
    16
    [quote:b519e1fc95][i:b519e1fc95]Originally posted by snowgod[/i:b519e1fc95]

    I think Travis means the new db naming schema IS user_dbname

    Long ago, cpanel used to just create dbname (no prefix).[/quote:b519e1fc95]

    Thanks for clearing this up. Feanor got me excited just for a second there! The &new& naming scheme for dbs and email accounts has been on at least since January 2001 as far as I can remember. :)
     
  8. xnull

    xnull Well-Known Member

    Joined:
    Sep 9, 2001
    Messages:
    156
    Likes Received:
    0
    Trophy Points:
    16
    I just noticed this yesterday as well..

    We've deleted around 10-15 accounts and all of their MySQL databases, log files, etc. etc. (literally everything but the DNS entry and /home folder) still exist..

    Quite a waste of space and some of these are causing bugs as well. We have always had the 'new' database naming scheme. Anybody have an idea how to find all of the delinquent files left behind from old accounts?
     
  9. feanor

    feanor Well-Known Member

    Joined:
    Aug 13, 2001
    Messages:
    836
    Likes Received:
    0
    Trophy Points:
    16
    Anything that I post is complete garbage, especially today.
    Thank you Adam for protecting the internet from stupidity being propagated via me.

    That IS what I meant yea.

    Like to see that working soon as well I would.

    ::yoda speech toggled to off::
     
  10. snowgod

    snowgod Well-Known Member

    Joined:
    Sep 23, 2001
    Messages:
    73
    Likes Received:
    0
    Trophy Points:
    6
    Ahh, you had the right idea Travis, most people don't even remember any other db scheme. That was awhile ago.
     
  11. bens

    bens Member

    Joined:
    Aug 15, 2001
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    I actually think this is a good thing in some cases.
    Say for example I change the person's username/domain name.
    If I delete the site and recreate it, I won't need to reset up the entire DB info.

    Of course, if I wanted to totally delete the site, then I'd rather it delete the DBs.

    Just my $0.02
     
  12. AlaskanWolf

    AlaskanWolf Well-Known Member

    Joined:
    Aug 11, 2001
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Fremont CA
    well when yah leave files there unknowningly....and your /var just happens to be filling to 100% because a ton load of old old customers db's...what are you to do???
     
  13. bens

    bens Member

    Joined:
    Aug 15, 2001
    Messages:
    24
    Likes Received:
    0
    Trophy Points:
    1
    Then I'd remove them.. :)
     
  14. AlaskanWolf

    AlaskanWolf Well-Known Member

    Joined:
    Aug 11, 2001
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Fremont CA
    well 2-3-4 weeks ago, no one even noticed it :(

    The bug that i submitted has been closed out as FIXED :)
     
  15. rpmws

    rpmws Well-Known Member

    Joined:
    Aug 14, 2001
    Messages:
    1,824
    Likes Received:
    5
    Trophy Points:
    38
    Location:
    back woods of NC, USA
    Is it fixed? I would hate to delete someone just to find out ... errr hehe:p
     
  16. Craig

    Craig Well-Known Member

    Joined:
    Aug 10, 2001
    Messages:
    171
    Likes Received:
    0
    Trophy Points:
    16
    I deleted an account today.. i belive its working ;)

    Craig
     
  17. AlaskanWolf

    AlaskanWolf Well-Known Member

    Joined:
    Aug 11, 2001
    Messages:
    537
    Likes Received:
    0
    Trophy Points:
    16
    Location:
    Fremont CA
    Yes it is, and BTW

    For whatever reason in the future, you want to keep the db's from not being deleted (IE: you need to quickly resetup an account or something)

    just go to shell and type in /scripts/killacct &username& and it will prompt you if you want to delete the db's for each acct

    I often use the shell since its quite faster then WHM
     
Loading...

Share This Page