# email url tracking NOT WORKING

**URL:** <https://forum.mautic.org/t/email-url-tracking-not-working/3751>\
**Category:** Product Support\
**Created:** [May 12, 2016, 7:01pm UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751 "2016-05-12T19:01:26Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![valentyn-md](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@valentyn-md](https://forum.mautic.org/u/valentyn-md)\
**Post date:** [May 12, 2016, 7:01pm UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/1 "2016-05-12T19:01:26Z")

</div>

hi team, I just want to work with very simple standard features, that you created many months ago,  
  
and I can see “opens” activity.  
  
I see that url correctly added to mail,  
  
but whe user click on link, I see next in logs:

Code:

p\_data/GeoLite2-City.mmdb" does not exist or is not readable. [] [] [2016-05-12 19:51:52] mautic.WARNING: IP LOOKUP: The file "/var/www/mautic/mautic14/app/cache/prod/../ip\_data/GeoLite2-City.mmdb" does not exist or is not readable. [] [] [2016-05-12 19:51:52] mautic.WARNING: IP LOOKUP: The file "/var/www/mautic/mautic14/app/cache/prod/../ip\_data/GeoLite2-City.mmdb" does not exist or is not readable. [] [] [2016-05-12 19:51:52] mautic.WARNING: IP LOOKUP: The file "/var/www/mautic/mautic14/app/cache/prod/../ip\_data/GeoLite2-City.mmdb" does not exist or is not readable. [] []

  
Permission of mautic folder is 777 , I checked it twice. There are no such files as GeoLite2-City.mmdb,  
this folder is empty.  
Ofcourse I fetched IP Lookup like in docs before testing mails:  
http://prntscr.com/b3bcth  
  
So it's really very bad, simple features still not working.(

---

<div class="post-metadata">

**Author:** ![valentyn-md](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@valentyn-md](https://forum.mautic.org/u/valentyn-md)\
**Post date:** [May 12, 2016, 7:01pm UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/2 "2016-05-12T19:01:26Z")

</div>

hi team, I just want to work with very simple standard features, that you created many months ago,  
and I can see “opens” activity.  
I see that url correctly added to mail,  
but whe user click on link, I see next in logs:

`
p_data/GeoLite2-City.mmdb" does not exist or is not readable. [] []
[2016-05-12 19:51:52] mautic.WARNING: IP LOOKUP: The file "/var/www/mautic/mautic14/app/cache/prod/../ip_data/GeoLite2-City.mmdb" does not exist or is not readable. [] []
[2016-05-12 19:51:52] mautic.WARNING: IP LOOKUP: The file "/var/www/mautic/mautic14/app/cache/prod/../ip_data/GeoLite2-City.mmdb" does not exist or is not readable. [] []
[2016-05-12 19:51:52] mautic.WARNING: IP LOOKUP: The file "/var/www/mautic/mautic14/app/cache/prod/../ip_data/GeoLite2-City.mmdb" does not exist or is not readable. [] []`

Permission of mautic folder is 777 , I checked it twice. There are no such files as GeoLite2-City.mmdb,  
this folder is empty.  
Ofcourse I fetched IP Lookup like in docs before testing mails:  
[http://prntscr.com/b3bcth](http://prntscr.com/b3bcth)

So it’s really very bad, simple features still not working.(

---

<div class="post-metadata">

**Author:** ![valentyn-md](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@valentyn-md](https://forum.mautic.org/u/valentyn-md)\
**Post date:** [May 13, 2016, 5:53am UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/3 "2016-05-13T05:53:04Z")

</div>

[quote=10306:@MxyzptlkFishStix]Clear your cache.

[https://www.youtube.com/watch?v=1Ks3exjrijw[/quote]](https://www.youtube.com/watch?v=1Ks3exjrijw%5B/quote%5D)

Hi! unfortunately I have the same problem, see what I did (I don’t lie)  
in log you can see errors after clicking on link im email letter:

root@mdt1 /var/www/mautic/mautic14 # chmod 777 . -R  
root@mdt1 /var/www/mautic/mautic14 # rm -rf app/cache/  
root@mdt1 /var/www/mautic/mautic14 # chmod 777 . -R  
root@mdt1 /var/www/mautic/mautic14 # tail app/logs/mautic\_prod-2016-05-13.php -f  
[2016-05-13 06:48:14] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []  
[2016-05-13 06:48:14] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []  
[2016-05-13 06:48:14] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []  
[2016-05-13 06:48:39] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []  
[2016-05-13 06:49:36] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []  
[2016-05-13 06:50:15] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []  
[2016-05-13 06:50:15] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []  
[2016-05-13 06:50:15] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []  
[2016-05-13 06:50:38] mautic.WARNING: IP LOOKUP: The file “/var/www/mautic/mautic14/app/cache/prod/…/ip\_data/GeoLite2-City.mmdb” does not exist or is not readable. [] []

I really need help, I just want to make mass mailling, may be I can pay someone, who can fix it? Please help

---

<div class="post-metadata">

**Author:** ![escopecz](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/escopecz/32/370_2.png) [@escopecz](https://forum.mautic.org/u/escopecz)\
**Post date:** [May 13, 2016, 6:11am UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/4 "2016-05-13T06:11:07Z")

</div>

Check the step 3 here: [https://mautic.org/docs/en/setup/getting\_started.html](https://mautic.org/docs/en/setup/getting_started.html)

---

<div class="post-metadata">

**Author:** ![valentyn-md](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@valentyn-md](https://forum.mautic.org/u/valentyn-md)\
**Post date:** [May 14, 2016, 1:01pm UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/5 "2016-05-14T13:01:14Z")

</div>

[quote=10360:@MxyzptlkFishStix]Why in the world are you setting world writeable permissions on a web server directory?

=====

To clear the cache via the command line, you should be using

```auto
rm -rf app/cache/*
```

instead of

```auto
rm -rf app/cache/
```

The latter deletes the app/cache folder completely and I doubt your webserver user has permission to recreate it. Unless you have world writeable perms for your entire Mautic webroot. Everything except the files and directories below are owned by the root user. Directories have 755 perms and files have 644 perms.

Directories/files owned by webserver user:

```auto
app/config/local.php
app/cache
app/logs
app/spool
media/dashboards
media/images
translations
files directory outside of mautic webroot
```

Once you sort those things out, run the command below from the command line.

```auto
php app/console mautic:iplookup:download
```

Hi! Thanks for quick answer!

I did like you told and currently I still can’t see tracked “open” events, and now I can’t see any logs why these happens  
May be after filepermission changes some cron jobs not running?  
can you please add in Mautic docs clear info about how to setup permissions. Why do you recommend to use root permission on all folders? In this case which user should run cron jobs?

If you will provide clear instcructions how to setup permission in docs (like for example in Symfony2 manual) you will reduct 50% of requests on this forum. Thanks

---

<div class="post-metadata">

**Author:** ![valentyn-md](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@valentyn-md](https://forum.mautic.org/u/valentyn-md)\
**Post date:** [May 14, 2016, 1:02pm UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/6 "2016-05-14T13:02:11Z")

</div>

[quote=10387:@valentyn-md]Hi! Thanks for quick answer!

I did like you told and currently I still can’t see tracked “open” events, and now I can’t see any logs why these happens  
May be after filepermission changes some cron jobs not running?  
can you please add in Mautic docs clear info about how to setup permissions. Why do you recommend to use root permission on all folders? In this case which user should run cron jobs?

If you will provide clear instcructions how to setup permission in docs (like for example in Symfony2 manual) you will reduce 50% of requests on this forum. Thanks[/quote]

---

<div class="post-metadata">

**Author:** ![valentyn-md](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@valentyn-md](https://forum.mautic.org/u/valentyn-md)\
**Post date:** [May 14, 2016, 6:28pm UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/7 "2016-05-14T18:28:21Z")

</div>

> [@10390:@MxyzptlkFishStix](#):
>
> MxyzptlkFishStix

Hi Dear MxyzptlkFishStix ,  
I have my own Dedicated Server,  
I have Ubuntu 14.04.1 LTS n l  
I have standard LAMP , apache user and group - www-data

---

<div class="post-metadata">

**Author:** ![valentyn-md](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@valentyn-md](https://forum.mautic.org/u/valentyn-md)\
**Post date:** [May 15, 2016, 11:15am UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/8 "2016-05-15T11:15:34Z")

</div>

Also , may be it’s because I am using PostMark service for email transport?  
PostMark tracking events good, but custom routers for treacking of mautic not tracking events.

---

<div class="post-metadata">

**Author:** ![valentyn-md](https://avatars.discourse-cdn.com/v4/letter/v/3ec8ea/32.png) [@valentyn-md](https://forum.mautic.org/u/valentyn-md)\
**Post date:** [May 15, 2016, 5:24pm UTC](https://forum.mautic.org/t/email-url-tracking-not-working/3751/9 "2016-05-15T17:24:13Z")

</div>

> [@10390:@MxyzptlkFishStix](#):
>
> Are you on a shared host or VPS/Dedicated?

Please help me with this last taks, Please check my answers.

[quote]Hi Dear MxyzptlkFishStix ,  
I have my own Dedicated Server,  
I have Ubuntu 14.04.1 LTS n l  
I have standard LAMP , apache user and group - www-data[/quote]

I really need help with this, it’s final step to make my mass mail. Can we spaek in skype? I will pay you your hourly rate.
