Koozali.org: home of the SME Server
Legacy Forums => General Discussion (Legacy) => Topic started by: Drifting on April 17, 2004, 07:37:14 PM
-
Followed Howto on this site, created a user with Update,Create,delete. well that was as near as I could work out as the Howto said "Create a mysql user with the access rights to create, modify, and delete mysql dbases"
Anyway the wizard ran fine, but at the last stage I got the following: -
Failed inserting 1 entries to table xoops_bannerclient.
Failed inserting 6 entries to table xoops_configcategory.
Failed inserting 27 entries to table xoops_configoption.
Failed inserting 1 entries to table xoops_imgset.
Failed inserting 1 entries to table xoops_imgset_tplset_link.
Failed inserting 7 entries to table xoops_ranks.
Failed inserting 17 entries to table xoops_smiles.
Failed inserting 3 entries to table xoops_groups.
Failed inserting 2 entries to table xoops_groups_users_link.
Failed inserting 55 entries to table xoops_group_permission.
Failed inserting 3 entries to table xoops_banner.
Failed inserting 1 entries to table xoops_tplset.
Failed inserting 1 entries to table xoops_modules.
Failed inserting 26 entries to table xoops_tplfile.
Failed inserting 26 entries to table xoops_tplsource.
Failed inserting 12 entries to table xoops_newblocks.
Failed inserting 1 entries to table xoops_users.
Failed inserting 71 entries to table xoops_config.
This is not a life or death problem, I am just on a learning curve and playing.
Paul.
-
Pretty sure you have just omitted to grant the permissions;
1. Log into the sme server (ssh)
2. fire your mysql client
3. grant all on [database].* to [user]@localhost;
where;
* database would equal xoops database
* user would equal xoops user
-
That was it, thanks :-D
Now what are the exact rights I should set for the xoops database user? Would like it to be secure if possible ;-)
Paul.