nuSoap won't install

[Dave]

Hi,
I'm running cmsms on several sites and am having a problem running an upgrade on one of them. I was using 0.13 and have tried to do the upgrade to 1.0.2. One of my sites the transition was seemless, no problems at all. With the second, I am able to get the site back up and running but no menus (I know this is a template problem, I'm not worried about it). The problem is in the Module manager. I click to install nuSoap and the process runs, reports that it has installed, but is still listed as not installed and Module Manager is still reporting a missing dependency. Here is a screen shot:



Has anyone experienced this?

versions:
php 5.1.4
os x server 10.4.7
cmsms 1.0.2

other info,
clean install works fine
other site on same machine upgrade worked
have double checked all permissions and have reproduced problem with several tests

Thanks in advance,

Dave

[pruttemor]

I've got exactly the same problem, but I'm a newbie and can't help you at all. Please write the solution, when you (or anyone else) has an answer.

[MoonMind]

Same problem here, too - I had an issue with PHP safe_mode, but that's solved now - and other modules install alright now, but nuSOAP won't. Any new insights or solutions as of yet?

M.

[Dave]

Still no help here, is this a bug?

Does it need to b e reported somewhere else?

Also, I'm using Mysql 5.0.24 if that is needed.

Any help out there?

[calguy1000]

We've tried to reproduce this error, but can't.  on our sites we can uninstall/reinstall nuSOAP and it's dependant modules with no difficulties.  This is weird, as the install in nuSOAP doesn't really do anything.  it's pretty bare actually.  maybe finding out the permissions of the directory may help, or turning on debug mode and trying to install?

[Dave]

I think I found the problem, it appears that the permissions on the databse user were only set to create, insert, update, delete. Once I increased the permissions and ran the upgrade I was able to install the nuSoap module as well as the module manager.

What are the appropriate permissions for the database user?

I've not had this problem before.

[calguy1000]

grant all permissions to the database user that you specify in the cms install.

the database user needs to be able to create, insert, delete, update, alter the table, etc, etc.  just grant all privileges that's the correct way.

[Dee]

INSERT,SELECT,UPDATE,DELETE,CREATE,ALTER,DROP seems to be enough (at least that works without problems here)

[tsw]

INDEX might also be needed

that leaves us with REFERENCES being the only one not granted...

so I think its just as safe to use ALL

[Dave]

Ok, I think I've figured out what happened here.

We recently moved to a new MySql Server and in the process changed the mysql user that accesses the database. Then we only gave that user create, insert, update, delete permissions which allowed the site to run fine.

Next, we ran the upgrade on the site to 1.02 and everything appeared to work until I tried to install NuSoap (actually, I found installing any Module would fail without error).

I "fixed" this by giving the mysql user all permissions, went into the database and edited the version number in the version table from 25 back to 19, and re-ran the install/upgrade.php.

Everything seems ok now.