# problems with V5.0.15 fresh install

**URL:** <https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746>\
**Category:** Bugs\
**Created:** [January 17, 2015, 7:56am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746 "2015-01-17T07:56:49Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![cartman10mpi](https://forums.interworx.com/letter_avatar_proxy/v4/letter/c/eb8c5e/32.png) [@cartman10mpi](https://forums.interworx.com/u/cartman10mpi)\
**Post date:** [January 17, 2015, 7:56am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/1 "2015-01-17T07:56:49Z")

</div>

Hello guys  
I changed my server and tried to install a fresh version of interworx . Now i have big problems in a fresh CENTOS6.5 ınterworx 5.0.15 install .  
First of all after installation and entering license key i got :  
“replyCode: 500replyText: Generic Server Issue  
replyData:  
null”

after i log in to panel , system graphs are not working . (image attached)

when i try to import a backup file i got error :  
“B Error: connect failed [nativecode=Client does not support authentication protocol requested by server; consider upgrading MySQL client] \*\* mysql://iworx:fjt8wn1lkj@unix(/var/lib/mysql/mysql.sock)/mysql”

and when i go into mysql server page it just looks like running but no version information or settings available

What is wrong with interworx new installs ??? how can i install older versions of interworx ? im dealing with this for two days , websites are down and people are pissed off !!! help me urgent plzz  
all i did install a fresh interworx on a fresh centos 64 bit v6.5, and change the status of ip to shared and try to import backup .

Thanks

 ![i1.jpg](https://forums.interworx.com/uploads/default/original/1X/4623a46596d387513d8dd6ad7da49c83e8401f37.jpeg)

 ![i3.jpg](https://forums.interworx.com/uploads/default/original/1X/c3053445b25832ae6c284b690a1041dab2c29668.jpeg)

 ![i2.jpg](https://forums.interworx.com/uploads/default/original/1X/31b3f26c0a4bd8577067752630e5e0e061558e14.jpeg)

---

<div class="post-metadata">

**Author:** ![system](https://forums.interworx.com/uploads/default/original/2X/4/40ab17cc34b792a0172b48ad1333b9ba9299a9a1.png) [@system](https://forums.interworx.com/u/system)\
**Post date:** [January 17, 2015, 8:08am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/2 "2015-01-17T08:08:35Z")

</div>

This solution can solve the mysql problem: [http://forums.interworx.com/threads/8208-MySQL-Server-version-Unknown?p=26900#post26900](http://forums.interworx.com/threads/8208-MySQL-Server-version-Unknown?p=26900#post26900)

After fixing the mysql problem my graphs started to work. I don’t know why 😃

---

<div class="post-metadata">

**Author:** ![cartman10mpi](https://forums.interworx.com/letter_avatar_proxy/v4/letter/c/eb8c5e/32.png) [@cartman10mpi](https://forums.interworx.com/u/cartman10mpi)\
**Post date:** [January 17, 2015, 8:23am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/3 "2015-01-17T08:23:18Z")

</div>

i am still not sure how to fix it , any step by step solution on this?

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [January 17, 2015, 8:26am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/4 "2015-01-17T08:26:13Z")

</div>

Hi cartman10mpi

If your not too sure I would open a support ticket with IW (nodeworx, remote support) and let IW correct it for you.

If you do, please ensure you turn on remote access and include in the ticket that remote access has been enabled. It will auto disable in 24 hours.

I hope that helps

Many thanks

John

---

<div class="post-metadata">

**Author:** ![cartman10mpi](https://forums.interworx.com/letter_avatar_proxy/v4/letter/c/eb8c5e/32.png) [@cartman10mpi](https://forums.interworx.com/u/cartman10mpi)\
**Post date:** [January 17, 2015, 8:31am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/5 "2015-01-17T08:31:01Z")

</div>

i got the license from licensecart and as far as i know if the license is not directly from interworx , the support will not help me with it , i guess i need to contact licensecart support for this and again i am not sure when they will reply , i need to get this fixed fast ☹

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [January 17, 2015, 8:38am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/6 "2015-01-17T08:38:08Z")

</div>

Hi cartman10mpi

Mikes truly great with IW but as this is an IW install issue, I’m thinking they’ll correct it.

If you open an IW support ticket directly, please ensure you include this post.

If you open a ticket with licensecart, again please include this ticket but I know mike reads this forum regularly.

Please note though, if you need support for other issues, you would be best advised to go through licensecart, as it would not be an install failure due to IW.

I hope that helps

Many thanks

John

---

<div class="post-metadata">

**Author:** ![system](https://forums.interworx.com/uploads/default/original/2X/4/40ab17cc34b792a0172b48ad1333b9ba9299a9a1.png) [@system](https://forums.interworx.com/u/system)\
**Post date:** [January 17, 2015, 8:39am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/7 "2015-01-17T08:39:19Z")

</div>

This is John’s solution how I made. But as John wrote, if you are not too sure better to open a support ticket! If you want to do yourself, make backup!

1. Open iworx.ini file and check [mysql] section, there is the mysql password in rootdsn line (rootdsn=“mysql://iworx:XXXXXXXXXXX@unix(/var/lib/mysql/mysql.sock)/mysql”). XXXXXXXXXXX is your password 🙂
2. Open my.cnf file and append the following lines to [mysqld] section: old\_passwords=1 and skip-grant-tables
3. Restart mysql
4. mysql -u root  
5A. UPDATE mysql.user SET Password=PASSWORD(‘XXXXXXXXXXX’) WHERE User=‘iworx’;  
5B. quit
5. Change mysql root password in NodeWorx
6. Remove skip-grant-tables from my.cnf
7. Restart mysql

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [January 17, 2015, 8:42am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/8 "2015-01-17T08:42:13Z")

</div>

Hi dss

That’s a lovely post, detailing precisely what’s needed.

I wish I had wrote that but I’m on tapatalk from mobile, still onsite a clients, and not infront of pc, but doing things from memory

Many thanks for sharing

John

---

<div class="post-metadata">

**Author:** ![cartman10mpi](https://forums.interworx.com/letter_avatar_proxy/v4/letter/c/eb8c5e/32.png) [@cartman10mpi](https://forums.interworx.com/u/cartman10mpi)\
**Post date:** [January 17, 2015, 9:14am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/9 "2015-01-17T09:14:39Z")

</div>

Thank you very much guys , I did the step by Step guide and it works now , everything looks normal . I will start importing websites now .

I really love interworx and its community , having you guys is awesome . THANK YOU

---

<div class="post-metadata">

**Author:** ![system](https://forums.interworx.com/uploads/default/original/2X/4/40ab17cc34b792a0172b48ad1333b9ba9299a9a1.png) [@system](https://forums.interworx.com/u/system)\
**Post date:** [January 17, 2015, 9:28am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/10 "2015-01-17T09:28:25Z")

</div>

You’re welcome! Are the graphs working good after fixing mysql? What about the activation problem? Did you remove skip-grant-tables option? It’s very important! 🙂

---

<div class="post-metadata">

**Author:** ![cartman10mpi](https://forums.interworx.com/letter_avatar_proxy/v4/letter/c/eb8c5e/32.png) [@cartman10mpi](https://forums.interworx.com/u/cartman10mpi)\
**Post date:** [January 17, 2015, 10:02am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/11 "2015-01-17T10:02:57Z")

</div>

yes the graphs now working and i can successfully import websites , i already passed the activation so i am not sure if it is fixed or not . i removed the skip-grant-tables as you advised but old\_passwords=1 is still there in config file .

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [January 17, 2015, 10:48am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/12 "2015-01-17T10:48:44Z")

</div>

Hi dss and cartman10mpi

The graphs data is held in the MySQL I believe, so I would expect it to start showing as expected.

The old password =1 is required, remember there are 2 MySQL versions installed, 1 for IW (ver4) and 1 for hosing (ver 5). If you remove or change old password to 0, then you will encounter issues due to hashing difference. This is not insurmountable but unless you understand the differences, may stop you for a while.

Glad it’s all working now and welcome to the forums, there’s a good crowd here who are knowledgable and like to help where we can

Many thanks

John

---

<div class="post-metadata">

**Author:** ![system](https://forums.interworx.com/uploads/default/original/2X/4/40ab17cc34b792a0172b48ad1333b9ba9299a9a1.png) [@system](https://forums.interworx.com/u/system)\
**Post date:** [January 17, 2015, 10:50am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/13 "2015-01-17T10:50:27Z")

</div>

It’s OK! the old\_passwords parameter is required with this version of IW. The new version will handle the new mysql password hash as I see.

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [January 17, 2015, 12:06pm UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/14 "2015-01-17T12:06:55Z")

</div>

Hi dss

That’s excellent news, good to hear.

Do you mind checking if both MySQL are ver 5 on centos 7

Appreciate it when you have time

Many thanks

John

---

<div class="post-metadata">

**Author:** ![system](https://forums.interworx.com/uploads/default/original/2X/4/40ab17cc34b792a0172b48ad1333b9ba9299a9a1.png) [@system](https://forums.interworx.com/u/system)\
**Post date:** [January 17, 2015, 12:27pm UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/15 "2015-01-17T12:27:05Z")

</div>

Yes, I checked.

The current version uses: 5.1.73 for hosting and 4.0.21 for IW  
The alpha uses: 5.5.40 MariaDB for hosting and 5.5.30 (iworx-db-55, I don’t know what kind of server is it exactly, I didn’t check) for IW, both using new hash algorithm

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [January 17, 2015, 12:44pm UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/16 "2015-01-17T12:44:37Z")

</div>

Hi dss

Excellent news, even better thank you

This means the webmail program’s can be the latest versions, and I’m thinking php will be running neat latest stable version.

Many thanks

John

---

<div class="post-metadata">

**Author:** ![system](https://forums.interworx.com/uploads/default/original/2X/4/40ab17cc34b792a0172b48ad1333b9ba9299a9a1.png) [@system](https://forums.interworx.com/u/system)\
**Post date:** [January 17, 2015, 1:03pm UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/17 "2015-01-17T13:03:23Z")

</div>

I checked the versions:

Horde: 3.3.11  
RoundCube: 1.0.3  
SquirrelMail: 1.4.22  
Hosting php: 5.4.16  
IW php: 5.5.19

---

<div class="post-metadata">

**Author:** ![IWorx-Brett](https://forums.interworx.com/user_avatar/forums.interworx.com/iworx-brett/32/18_2.png) [@IWorx-Brett](https://forums.interworx.com/u/IWorx-Brett)\
**Post date:** [January 17, 2015, 8:00pm UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/18 "2015-01-17T20:00:26Z")

</div>

Thanks for your patience with this issue – it’s now resolved. If you see anything resembling it in the future, though, submit a ticket at [https://support.interworx.com](https://support.interworx.com)

---

<div class="post-metadata">

**Author:** ![d2d4j](https://forums.interworx.com/user_avatar/forums.interworx.com/d2d4j/32/16_2.png) [@d2d4j](https://forums.interworx.com/u/d2d4j)\
**Post date:** [January 18, 2015, 2:59am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/19 "2015-01-18T02:59:02Z")

</div>

Hi Brett

Excellent news, thanks.  
I have tested this and can confirm all is well and works as expected.  
Port 587 is not shown in Firewall, and not open after install - easily remedy by adding it into firewall though.  
You guys rock  
Many thanks  
John

---

<div class="post-metadata">

**Author:** ![system](https://forums.interworx.com/uploads/default/original/2X/4/40ab17cc34b792a0172b48ad1333b9ba9299a9a1.png) [@system](https://forums.interworx.com/u/system)\
**Post date:** [January 18, 2015, 3:57am UTC](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746/20 "2015-01-18T03:57:48Z")

</div>

[QUOTE=d2d4j;26923]Hi Brett

Excellent news, thanks.  
I have tested this and can confirm all is well and works as expected.  
Port 587 is not shown in Firewall, and not open after install - easily remedy by adding it into firewall though.  
You guys rock  
Many thanks  
John[/QUOTE]

I can confirm!

[Next page](https://forums.interworx.com/t/problems-with-v5-0-15-fresh-install/13746.md?page=2)
