Web Hosting Forum | Lunarpages

Author Topic: MySQL disconnect from IkonForum  (Read 4095 times)

Offline Madam Captain

  • Trekkie
  • **
  • Posts: 12
MySQL disconnect from IkonForum
« on: December 17, 2015, 08:01:54 AM »
I need some help.  I installed IkonBoard several years ago as my Info Forum software, then upgraded it to IkonForum.  I made the mistake of waiting to migrate it to something that has support and now the database is disconnected from the forum due to Lunarpages upgrade of the MySQL files.  In an attempt to allow me to reconnect them and migrate them to SMF software, Lunarpages has moved my account to a new server that does not have the upgrades.  Problem is that the database is still disconnected.  I am still getting this message:

[Thu Dec 17 07:54:45 2015] index.cgi: Can't connect to mySQL database. Access denied for user 'xxxxxx_xxxxxxxx'@'localhost' (using password: YES)

This error was reported at: Sources/iDatabase/mySQL.pm line 48.


I've found pearl editors and installed them, but I do not know what I am doing, so I'm reaching out for help.  So far Lunarpages tech support has only been able to read the error messages to me and tell me to contact my webmaster.  Well, duh, that's me!! 

I have the original files and a manual copy of the forum files.  Would it help to reinstall the original software?  Will it migrate to SMF without being connected and online?  Or am I just screwed and will have to rebuild the forum from scratch?  There is some good information on the forum that I don't want to lose or I would just start over.  I'm afraid that by the time I learn Pearl and how to edit this the MySQL files will be updated on this server as well.

Any assistance/guidance would be appreciated.
« Last Edit: December 19, 2015, 09:15:39 AM by MrPhil »

Offline Madam Captain

  • Trekkie
  • **
  • Posts: 12
Re: MySQL disconnect from IkonForum
« Reply #1 on: December 17, 2015, 09:58:34 AM »
I am trying to reinstall the forum software and I get this message:

Warning! Could not connect to the database with new settings: Can't connect to mySQL database. Access denied for user 'xxxxxxx_xxxxxxxx'@'localhost' (using password: YES) at /usr/lib/perl5/5.8.8/CGI/Carp.pm line 314.

Anyone know WHERE the MySQL database files are located?  I can't find them in file manager or via FTP so I can't figure out a port or command line address.
« Last Edit: December 19, 2015, 09:16:20 AM by MrPhil »

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6227
Re: MySQL disconnect from IkonForum
« Reply #2 on: December 17, 2015, 10:26:32 AM »
I'm not familiar with IkonForum, but I'll take some guesses.  This is a Perl based application, not PHP? I know that PHP is moving strongly away from the old MySQL library and towards its up-to-date MySQLi library for MySQL database access, but I don't know if Perl is doing anything similar. I will note that Perl 5.8 is quite ancient (the current version is at least 5.20), and possibly it doesn't support something in the current MySQL level. Have you asked the Ikon support whether you're up to date with their software, and if it would help to upgrade Perl to the current level? If this is a shared server, I don't know what you can do about Perl level, except to ask LP.

There are no MySQL files that you can access. It's all within the database server you're using, and you can't get to the individual files. Double check the database location, database name, user ID,  and user password associated with your MySQL database, and make sure they match what your IkonForum thinks they are. It's possible that you'll need to create a new user and password and use those, if you don't know the user and password already in use. This is the model used by PHP, and I'm assuming that Perl does roughly the same thing.
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline Madam Captain

  • Trekkie
  • **
  • Posts: 12
Re: MySQL disconnect from IkonForum
« Reply #3 on: December 17, 2015, 06:33:22 PM »
IkonForum no longer has support, and yes, I am remiss in not migrating it much sooner. I have no support to contact and am desperately trying to figure this out on my own.  Lunarpages doesn't (or can't) help me with the problem that essentially they caused.  (Yes, upgrades are necessary, but a little warning might have prevented my situation!)

Yes, it is Pearl based and I installed it back in 2008.  (You can still download the forum software off SourceForge.net for free.)  However, the forum was working just fine until the MySQL databases were updated on the Atlas server to the current version.  I wasn't given any warning and this has apparently caused an incompatibility. So a Lunarpages supervisor discovered--as I have--that there is migration software to SMF forums and upgrade from there.  They moved my account to another server, the big problem was that no one told me...for a month...when I accidentally discovered the support ticket info. 

I do not know the location of the MySQL files to point the software to.  I am starting to be afraid that when they updated the MySQL software they updated my database files and even though they have been moved to a not yet updated server, they are still the newest version that IkonForum can not use.  So other than starting over from scratch, I would need my database files prior to November 2015, and the ability to point the IkonForum files to them--which means URLs or addresses.  I would still migrate the software to something newer, but at least I wouldn't lose several years of information that is still usable today in the aviation world.

Thanks for replying.  I'll try to figure this out for a few more days before giving up.

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6227
Re: MySQL disconnect from IkonForum
« Reply #4 on: December 18, 2015, 05:52:44 AM »
If SMF has tools to import from IkonForum into SMF, you should need only the database (and not a working IkonForum system). SMF is currently maintained and can handle the new database level. Your control panel (cPanel or LPCP) can show you the database name, location (if not localhost), and what users you have defined for it. You may need to create a new password if you don't remember the old one, although that information should be in the IkonForum files somewhere. You should be able to browse through the IkonForum database, once you've found it, with phpMyAdmin; and you can see if it looks intact.

LP does give notice of upcoming upgrades, although the messages can be confusing to some, and the given schedule is only a guess (I've seen upgrades happen sometimes early and often late). Is your current email on file with your account?

To do anything with your old IkonForum database, all you will need is the database name (which you can get from your cPanel or LPCP), the server location (if not localhost, it should be available from somewhere in your control panel or from support), and a user name and password (which you can create anew in your cPanel or LPCP if you can't find them in the control panel or in the IkonForum configuration file). Don't forget to grant privileges to any new user you create.
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline Madam Captain

  • Trekkie
  • **
  • Posts: 12
Re: MySQL disconnect from IkonForum
« Reply #5 on: December 18, 2015, 10:08:55 AM »
I am perplexed.  Decided to load SMF 2.0 this morning (there is a converter for IkonForum to 2.0).  Using FTP client I uploaded both the 2.0 installer and the converter zips.  Decided to extract them via cPanel, except that when I logged into cPanel, the files were not there.  I uploaded manually via cPanel and extracted the installer.  The installer would not run via browser as advertised. 

Extracted and uploaded installer files via FTP.  Got the installer to run, but got a critical error:
Critical Error!
Cannot connect to the database server with the supplied data.

If you are not sure about what to type in, please contact your host.
Access denied for user 'xxxxxxx_xxxxxxxx'@'localhost' (using password: YES)


I've tried every combination of file names and passwords that I can think of--even changed the MySQL password so that I would be sure, but can't get past this message:
Critical Error!
The installer was unable to access the "xxxxxxx_smf" database. With some hosts, you have to create the database in your administration panel before SMF can use it. Some also add prefixes - like your username - to your database names.
(I tried just smf, and got further with main account passwords than the MySQL passwords)

So, I uploaded an shtml file off of my current website via FTP and I can see it in the Forum/SMF folder via FTP.  It is NOT showing in the cPanel file manager--even after refreshing the screen.  SMF can not find the database files.  I'm starting to think there are 2 different accounts and my FTP manager is going to the one that works while cPanel is not.  Thoughts anyone?
« Last Edit: December 19, 2015, 09:17:24 AM by MrPhil »

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6227
Re: MySQL disconnect from IkonForum
« Reply #6 on: December 18, 2015, 10:32:29 AM »
I see you are using "localhost" as the database location. Can you confirm that is correct, and it's not supposed to be a named DB server? I think all the LPCP accounts use a named server. "xxxxxxx" is your LP account name, and "xxxxxxxx" is the user you created? You granted this user adequate permissions to use the database?

You manually created the "smf" database, as well as its user (with permissions)? I don't think programs such as SMF or IkonForum are allowed to create a database, although they can create tables etc. within a database.

Does the SHTML file you uploaded start with a dot (.)? If so, you may need to tell your control panel (are you on cPanel or LPCP?... they're different!) to show "hidden" files (starting with ".").

There are no "database files" for you to look at. You only have access to the database system via its interface (control panel, phpMyAdmin, and MySQL/MySQLi libraries).
« Last Edit: December 19, 2015, 09:17:59 AM by MrPhil »
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline Madam Captain

  • Trekkie
  • **
  • Posts: 12
Re: MySQL disconnect from IkonForum
« Reply #7 on: December 18, 2015, 11:03:58 AM »
This is a basic account and I am using cPanel.  Don't know what LPCP accounts are.  I have repeatedly asked support to resend me the account info since they moved my account to a new server (without telling me) and to date I have received nothing from support other than they don't support 3rd party software.

No "." starts to the file name.  It was simply a resume file with a SSI counter on it to test seeing the file on both connections.
"xxxxxxx" is the name Lunarpages gave my account when I first signed up years ago.  On cPanel the MySQL databases all come up with that prefix as do all the users. I gave myself all privileges for the database access. (Of course, I should probably change that now that I've posted on a public forum!)

 SMF installation instructions talks about permissions but never actually tells you what the permission code should be.  I've given the installer and folders 755 permission.  The binary upload from FTP gave some files 644 permissions.

I am trying to install SMF version 2, not the latest.  Would the MySQL database updated files not be recognized by that version as they are not recognized by IkonForum software?  Bottom line is that I can find nothing that tells me WHERE the database files are, so localhost is all I can use.  Guess I'm stuck without having the software find and use the database file that currently has nothing in it.


« Last Edit: December 19, 2015, 09:18:24 AM by MrPhil »

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6227
Re: MySQL disconnect from IkonForum
« Reply #8 on: December 19, 2015, 08:05:36 AM »
cPanel is a commercially sold control panel used for shared servers. I asked because a lot of people use it as a generic term for "control panel", when it is in fact it is a specific product name. Lunarpages used to use it exclusively, and it's still on all the old servers. "LPCP" is LunarPages Control Panel, a homebrewed control panel that LP has been using on all its new servers for several years now. If you're on a Linux-based shared server, you have one or the other. It will tell you when you sign on to your control panel.

I think all the cPanel servers used "localhost" (i.e., the MySQL server was running on the same physical machine as the sites themselves), while the LPCP servers offload MySQL server duties onto a separate, named machine (e.g., SQL012.lunariffic.com). Support should certainly be able to tell you where your MySQL server is, if it's not spelled out in your server control panel. If there's confusion, perhaps you're asking the question in a very confused manner (talking about "MySQL files", which are irrelevant to you).

By the way, it's a good idea NOT to give out your LP account name in public, but that's water under the bridge now. Someone knowing your account name and database and user names might guess your password and use that information to access your database and do damage or spy. At the least, don't keep sensitive information on it, such as financial information (never keep credit card numbers on your database, unless you pay for an expensive PCI-DSS security audit).

755 and 644 are the normal default permissions for directories and files. In some cases you may need or want to restrict those permissions to prevent a program from overwriting directories or files.

I haven't looked at SMF for a while, but 2.something is the current version. I don't think they're at version 3 yet.

You don't have or need access to MySQL files. You may just be confusing tech support by continuing to talk about the files, rather than access to your database. For SMF to import and convert the database, it does not need a working IkonForum installation, just a working database.
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

Offline Madam Captain

  • Trekkie
  • **
  • Posts: 12
Re: MySQL disconnect from IkonForum
« Reply #9 on: December 19, 2015, 09:03:10 AM »
Thanks for the info.  Fortunately, there is no sensitive info on those databases, but I realized after I posted that it was a security risk.  If I could edit the posts I'd take it out...

My hunch that there were two accounts proved correct as LP moved my account but I never got the notice.  I have been able to access database files for SMF installation after getting to the correct cPanel.  However, my converter has hung up on Step 1 with an error message of:
Converting members...Wrong value type sent to the database. Integer expected. (last_login)

At this point I'd be happy with just importing the data (forums, categories, and skin).  It's a free forum so it's not too much to ask members to re-register.  I can see the code in the phpMyAdmin, but I have no idea how to edit, import or export.  I see where it can be done for other boards, but I don't know what I'm doing.  I do have backups of the databases, but I need a resource for how to code it.

[I have edited out your account name and user name, as requested, but this doesn't prevent some bad guy from having saved the information from earlier. I would at least go to new database names and user names, and assume that the account name is already out there somewhere. In the future, all you have to do at any time is click on the "Modify" button if you need to scrub sensitive information out of a post. -- MrPhil]
« Last Edit: December 19, 2015, 09:22:49 AM by MrPhil »

Offline MrPhil

  • Senior Moderator
  • Berserker Poster
  • *****
  • Posts: 6227
Re: MySQL disconnect from IkonForum
« Reply #10 on: December 19, 2015, 09:32:52 AM »
I don't know what went wrong with your conversion from IkonForum to SMF. You could ask on the SMF support forum (www.simplemachines.org/community), and if someone is still supporting this converter, they should be able to guide you through the process. At the very least, your users, categories, and posts should be saved and moved over. I doubt any "skins" can be saved -- you may have to pick something similar from what's offered by SMF.

Frankly, if you're getting a message about problems with transferring a last-login date over, you may be attempting to convert a very old IkonForum format that SMF doesn't recognize, or otherwise there's some sort of incompatibility (maybe IkonForum stored the date as a string, like 12/19/2015, instead of the timestamp integer format). Again, if the converter is supported, they may be able to figure out what's wrong.

All this assumes, of course, that your IkonForum database wasn't corrupted during all the recent fooling around with it. If it was, did you preserve any backups from before that? LP won't have anything beyond a few days to maybe a week old, at best, and will charge you a fee to restore what it has. If your database was corrupted to the point where SMF can't deal with it, perhaps you could manually recreate your users and categories in SMF, and then cut and paste posts out of phpMyAdmin into SMF. It's a lot of work, and requires the ability to figure out what post goes with what thread and what thread goes in what category, which could require some expertise in the internals of IkonForum. Only you can decide if it's worth the effort.
« Last Edit: December 19, 2015, 09:36:49 AM by MrPhil »
Visit My Site

E-mail Me
  
-= From the ashes shall rise a sooty tern =-

 

Share |