nuBuilder Forum

I'm affraid I cannot install nuBuilder Forte in my Cpanel hosting account because when I try to import the database I see some errors related to the need of a root MySQL user. I even tried to change the sql file to my MySQL db user on cpanel with no success.

This is my post about this subject
http://forums.nubuilder.cloud/viewtopic.php?f=19&t=9192

Can someone confirm that is not possible to use nuBuilder Forte in a shared Cpanel hosting account?

Thank you in advance!

I'm using nuBuilder in a shared cPanel hosting account. What errors do you get when importing the sql file?

I just modified the statement on sql file using sed on terminal as below:
After this change the file can be imported with no problems.

Celson,

Thanks for letting people know.

Steven

Steve, I just can't guarantee this piece I've stripped from clause will not cause some problem on nuBuilder.

Celson wrote:I just modified the statement on sql file using sed on terminal as below:

Code: Select all

sed -i 's/CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW/CREATE VIEW/g' nubuilder4.sql

After this change the file can be imported with no problems.

How is this different from the solution given by me in this thread?
http://forums.nubuilder.cloud/viewtopic.php?f=19&t=9192

If I understand correctly, "the command sed -i [..]"
Replaces
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW
with
CREATE VIEW

...and that's exactly what I proposed.

It's not a different solution. This is YOUR solution I just turned into a sed command in order to make it easy for other readers.

On first time I got your solution ...

You are right, I noticed that too. That's why I made a fresh install because at that time I had no idea what caused it. Having no root access in my DB, it would be best to have this "ALGORITHM=UNDEFINED.." removed.

I did'nt understand and stripped only part of the clause (ALGORITHM=UNDEFINED) so the error was not solved.

Then I tried again, by erasing all but the CREATE VIEW, and it worked like a charm.

All right, thanks for the clarification!

BTW, I still don't understand why this ALGORITHM is there...Everytime I pull an update I need to remove it.
ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER

Its just part of a phpMyAdmin export.

Steven