iceraven721 Posted May 5, 2011 Share Posted May 5, 2011 So I have the site set to go the last thing I have to do is set up the database. The first problem I had is that the site came with a .sql file to populate the database, however it is encrypted with a .gpg format. I have tried everything to decrypt it but I have had little luck getting it to work so now I am resulting to trying to manually rebuild the database for the system. (This isn't a major website, it is a smaller one that I found on google code so there is no "how to" and I cannot get in contact with the creator.) I was wondering if somebody could possibly point me in the right direction of how to go about analyzing the php files to determine how to rebuild the tables. I know a decent amount of php to work my way around things I am just stuck on the sql part. Any help is great! Thanks MySQL version 5.1.56 Quote Link to comment https://forums.phpfreaks.com/topic/235600-rebuilding-database-tables/ Share on other sites More sharing options...
mikosiko Posted May 5, 2011 Share Posted May 5, 2011 have you tried GNUPG ? http://www.gnupg.org/ Quote Link to comment https://forums.phpfreaks.com/topic/235600-rebuilding-database-tables/#findComment-1210913 Share on other sites More sharing options...
iceraven721 Posted May 5, 2011 Author Share Posted May 5, 2011 Yes. And I get an error that it can't decrypt it. Do I need more info than just the .gpg file to decrypt it? Quote Link to comment https://forums.phpfreaks.com/topic/235600-rebuilding-database-tables/#findComment-1210975 Share on other sites More sharing options...
mikosiko Posted May 5, 2011 Share Posted May 5, 2011 if the file was encrypted with a key or passcode you need to have it to decrypt. Quote Link to comment https://forums.phpfreaks.com/topic/235600-rebuilding-database-tables/#findComment-1210978 Share on other sites More sharing options...
iceraven721 Posted May 5, 2011 Author Share Posted May 5, 2011 It did have an sha1 checksum under the download. But I couldnt find a place to put it in the software from gnupg Quote Link to comment https://forums.phpfreaks.com/topic/235600-rebuilding-database-tables/#findComment-1210982 Share on other sites More sharing options...
iceraven721 Posted May 12, 2011 Author Share Posted May 12, 2011 I'm just up against a wall here. I am stuck and can't get it to work. Is there any easy way to get it decrypted or just rebuild the database by reading the php files? Quote Link to comment https://forums.phpfreaks.com/topic/235600-rebuilding-database-tables/#findComment-1214273 Share on other sites More sharing options...
gizmola Posted May 12, 2011 Share Posted May 12, 2011 It did have an sha1 checksum under the download. But I couldnt find a place to put it in the software from gnupg A checksum exists to validate the distribution. It is not a key. It's included so that people can run the checksum on the files they have and verify that someone didn't go in and screw around with the contents. If you don't have the password to decrypt the GPG file, you are out of luck. http://www.madboa.com/geek/gpg-quickstart/ I'm guessing from the way you're beating around the bush there is some reason that you don't have it, like this is a commercial package you didn't buy, or something like that. Please don't waste our time further. This forum is for people to learn PHP development. Quote Link to comment https://forums.phpfreaks.com/topic/235600-rebuilding-database-tables/#findComment-1214288 Share on other sites More sharing options...
iceraven721 Posted May 12, 2011 Author Share Posted May 12, 2011 Ah gotcha.... Thanks Quote Link to comment https://forums.phpfreaks.com/topic/235600-rebuilding-database-tables/#findComment-1214295 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.