CiviCRM Community Forums (archive)

Hi!

I have a new installation of CiviCRM 4.2.6 on a Joomla 2.5-site, where I can do a lot of configuration, such as setting mail adresses, I can sync contacts with Joomla and in that way get a number of contacts. However, when I try to manually add a contact, I get a DB error. Insufficient permissions (see more in detail below). The same if I try to set up a new mailing. Or if I try to import a CSV file with contacts.

I have checked the database details in administrator/components/com_civicrm/civicrm.settings.php, and they seem right (right user, right database name).  The log entry is below.

What to check or do?


Magnus


Dec 29 15:42:20  [info] $Fatal Error Details = Array
(
    [callback] => Array
        (
             => CRM_Core_Error[1] => handle
        )
[code] => -26
    [message] => DB Error: insufficient permissions
    [mode] => 16
    [debug_info] => CREATE TEMPORARY TABLE X_1
            (contact_id int primary key)
            ENGINE=HEAP [nativecode=1044 ** Access denied for user 'agslo2'@'localhost' to database 'agslo2']
    [type] => DB_Error
    [user_info] => CREATE TEMPORARY TABLE X_1
            (contact_id int primary key)
            ENGINE=HEAP [nativecode=1044 ** Access denied for user 'agslo2'@'localhost' to database 'agslo2']
    [to_string] => [db_error: message="DB Error: insufficient permissions" code=-26 mode=callback callback=CRM_Core_Error::handle prefix="" info="CREATE TEMPORARY TABLE X_1
            (contact_id int primary key)
            ENGINE=HEAP [nativecode=1044 ** Access denied for user 'agslo2'@'localhost' to database 'agslo2']"]
)


Hi!

Thanks for your reply! However, this is a hosted service, and I have only one user. So this is the same user that created all the civicrm-tables on installation. Further, I can log in via PhpMyadmin, with this user, and there create a new table. I feel at loss. What can I check or try?

Magnus

Hi!

Got my permissions adjusted today by the host, and that fixed the problem. Thanks a lot!!

Magnus