You do not have access to the requested area/action.

Product Support
1

Hi,

When trying to modify forms (add action or field) i receive JavaScript message: You do not have access to the requested area/action. The same happens in Campaign builder, didn’t check a lot but Lists work well.



Nginx shows no errors

Browser console shows no errors



I have admin rights (first and only user)



Any ideas?



Using 1.2.3, downloaded today

2

Hi,
When trying to modify forms (add action or field) i receive JavaScript message: You do not have access to the requested area/action. The same happens in Campaign builder, didn’t check a lot but Lists work well.

Nginx shows no errors
Browser console shows no errors

I have admin rights (first and only user)

Any ideas?

Using 1.2.3, downloaded today

3

1.2.2 - problem is the same

There is no log file in app/logs

I had mautic installed before on the same server with the same settings. Before reinstall it was working like a charm.

4

This is nginx access log:

[28/Dec/2015:01:23:11 +0100] "GET /s/forms/field/new?type=captcha&tmpl=field&formId=1&_=1451262181604&mauticUserLastActive=1&mauticLastNotificationId=3 HTTP/1.1" 200 76 "http://mautic.dimmi.pl/s/forms/edit/1" "Mozilla/5.0 (Macintosh; Intel Mac OS X 10_9_5) AppleWebKit/601.3.9 (KHTML, like Gecko) Version/9.0.2 Safari/537.86.3"

I’ve got some errors in mautic logs now:

[2015-12-25 02:03:15] mautic.WARNING: Command `doctrine:migrations:version` exited with status code 255 [] [] [2015-12-25 02:03:15] mautic.ERROR: PDOException: SQLSTATE[28000] [1045] Access denied for user 'www-data'@'localhost' (using password: NO) (uncaught exception) at /home/dimmi/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php line 40 while running console command `doctrine:migrations:version` [] [] [2015-12-25 10:31:33] mautic.WARNING: IP LOOKUP: The file "/home/dimmi/mautic/app/cache/prod/../ip_data/GeoLite2-City.mmdb" does not exist or is not readable. [] [] [2015-12-25 10:31:33] mautic.WARNING: IP LOOKUP: The file "/home/dimmi/mautic/app/cache/prod/../ip_data/GeoLite2-City.mmdb" does not exist or is not readable. [] [] [2015-12-25 10:31:33] mautic.WARNING: IP LOOKUP: The file "/home/dimmi/mautic/app/cache/prod/../ip_data/GeoLite2-City.mmdb" does not exist or is not readable. [] []

This URL: http://mautic.dimmi.pl/s/forms/field/new?type=captcha&tmpl=field&formId=1&_=1451262181604&mauticUserLastActive=1&mauticLastNotificationId=3

Returns:

{"error":"You do not have access to the requested area/action."}

I guess this is the reason:

[2015-12-25 02:03:15] mautic.WARNING: Command `doctrine:migrations:version` exited with status code 255 [] []

When applying database credentials at installer, first time it just reloads and I have to put them again to work. www-data with no password are not these credentials, maybe it’s sending empty form at first?

5

I reinstalled from source - master branch, release 1.2.3, packages installed by composer. Same thing again.

This is in the logs now:

[code][2015-12-28 01:06:55] mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALDBALException: “An exception occurred while executing ‘SELECT u0_.is_published AS is_published0, u0_.date_added AS date_added1, u0_.created_by AS created_by2, u0_.created_by_user AS created_by_user3, u0_.date_modified AS date_modified4, u0_.modified_by AS modified_by5, u0_.modified_by_user AS modified_by_user6, u0_.checked_out AS checked_out7, u0_.checked_out_by AS checked_out_by8, u0_.checked_out_by_user AS checked_out_by_user9, u0_.id AS id10, u0_.username AS username11, u0_.password AS password12, u0_.first_name AS first_name13, u0_.last_name AS last_name14, u0_.email AS email15, u0_.position AS position16, u0_.timezone AS timezone17, u0_.locale AS locale18, u0_.last_login AS last_login19, u0_.last_active AS last_active20, u0_.online_status AS online_status21, u0_.preferences AS preferences22, r1_.is_published AS is_published23, r1_.date_added AS date_added24, r1_.created_by AS created_by25, r1_.created_by_user AS created_by_user26, r1_.date_modified AS date_modified27, r1_.modified_by AS modified_by28, r1_.modified_by_user AS modified_by_user29, r1_.checked_out AS checked_out30, r1_.checked_out_by AS checked_out_by31, r1_.checked_out_by_user AS checked_out_by_user32, r1_.id AS id33, r1_.name AS name34, r1_.description AS description35, r1_.is_admin AS is_admin36, r1_.readable_permissions AS readable_permissions37, u0_.role_id AS role_id38 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE u0_.username = ? OR u0_.email = ?’ with params [“patryk”, “patryk”]: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected” at /home/dimmi/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 {“exception”:"[object] (Doctrine\DBAL\DBALException(code: 0): An exception occurred while executing ‘SELECT u0_.is_published AS is_published0, u0_.date_added AS date_added1, u0_.created_by AS created_by2, u0_.created_by_user AS created_by_user3, u0_.date_modified AS date_modified4, u0_.modified_by AS modified_by5, u0_.modified_by_user AS modified_by_user6, u0_.checked_out AS checked_out7, u0_.checked_out_by AS checked_out_by8, u0_.checked_out_by_user AS checked_out_by_user9, u0_.id AS id10, u0_.username AS username11, u0_.password AS password12, u0_.first_name AS first_name13, u0_.last_name AS last_name14, u0_.email AS email15, u0_.position AS position16, u0_.timezone AS timezone17, u0_.locale AS locale18, u0_.last_login AS last_login19, u0_.last_active AS last_active20, u0_.online_status AS online_status21, u0_.preferences AS preferences22, r1_.is_published AS is_published23, r1_.date_added AS date_added24, r1_.created_by AS created_by25, r1_.created_by_user AS created_by_user26, r1_.date_modified AS date_modified27, r1_.modified_by AS modified_by28, r1_.modified_by_user AS modified_by_user29, r1_.checked_out AS checked_out30, r1_.checked_out_by AS checked_out_by31, r1_.checked_out_by_user AS checked_out_by_user32, r1_.id AS id33, r1_.name AS name34, r1_.description AS description35, r1_.is_admin AS is_admin36, r1_.readable_permissions AS readable_permissions37, u0_.role_id AS role_id38 FROM users u0_ LEFT JOIN roles r1_ ON u0_.role_id = r1_.id WHERE u0_.username = ? OR u0_.email = ?’ with params [“patryk”, “patryk”]:nnSQLSTATE[3D000]: Invalid catalog name: 1046 No database selected at /home/dimmi/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php:91, PDOException(code: 3D000): SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected at /home/dimmi/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Connection.php:694)"} []
[2015-12-28 01:08:09] mautic.ERROR: DoctrineDBALDBALException: An exception occurred while executing ‘SHOW FULL TABLES WHERE Table_type = ‘BASE TABLE’’: SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (uncaught exception) at /home/dimmi/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 while running console command doctrine:migrations:version [] []

[/code]

6

I think the problem is in

mautic.ERROR: PDOException: SQLSTATE[28000] [1045] Access denied for user 'www-data'@'localhost'

and

No database selected

But I have no explanation for why Mautic works in some areas and does not in others. Maybe try to clear the cache (remove the app/cache folder)

7

Clearing cache did not help.

According to logs, Mautic is trying to log into database with empty credentials in installer form and it fall backs to default nginx user ‘www-data’ with no password and no database selected.

Is there any way I can write database credentials manually in some config file and run database migrations by myself?

8

This is Mautic error log when setting root credentials to mysql database:

[2015-12-29 22:50:06] mautic.ERROR: DoctrineDBALDBALException: An exception occurred while executing 'SHOW FULL TABLES WHERE Table_type = 'BASE TABLE'':  SQLSTATE[3D000]: Invalid catalog name: 1046 No database selected (uncaught exception) at /home/dimmi/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/DBALException.php line 91 while running console command `doctrine:migrations:version` [] []
9

I have this problem too in campaign builder.

I check mautic error log and it says “$HTTP_RAW_POST_DATA is deprecated”.
I set always_populate_raw_post_data to -1 and also remove cache folder.
But the error still exists.

Do you have another solutions?

10

The installation process writes the database credentials to app/config/local.php file. Take a look there. Also, clear cache every time you modify a config file so Mautic knows about the change.

11

@dulabs Your error is not related to the error described in this thread. It would be better to create a new one.

Anyway, have you restarted the server after the PHP configuration change?

12

Hi,

I managed to solve my problem. During install I disabled SSL connection (I’m using let’s encrypt certificate) and turned it back on when finished install.

Forms and Leads seem to work now.

Thanks for help.