How to config Trackable Links (not from localhost:8080)?

[ohho]

The trackable links are all http://localhost:8080/.../...

Where can I config/change this host information?

[maschoff]

Have a look at the documentation (install & admin guide) and search for expression "localhost:8080".

[jasons]

Hello,
I tried this and still no luck.
mysql> update company_tbl set rdir_domain = "http://mydomain.com:8080"

Is there any thing else i should be doing.
Because of this all links point to http://localhost:8080/r.html?uid=1.c.3.17.wdzsdj7a98
I have to disable the trackable links to make it work. Any help would be greatly appreciated.

Thanks,
Jason

[maschoff]

Please check with "select * from company_tbl" that field rdir_domain was really changed to your value.

[jasons]

Thanks for such a prompt reply.

I checked the table and i believe the info is there:
{
company_id int(11) No Primary 0
shortname varchar(255) No None
description varchar(255) No None
status varchar(10) No None
timestamp timestamp No None CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP
creator_company_id int(11) No None 0
xor_key varchar(20) No None
creation_date timestamp No None 0000-00-00 00:00:00
notification_email varchar(255) No None
rdir_domain varchar(255) No None http://proxxx.cilaucxxx.com:8080
mailloop_domain varchar(200) No None
mailtracking int(11) unsigned No None 0
max_login_fails int(3) No None 3
login_block_time int(5) No None 300
uid_version int(2) Yes None NULL
max_recipients int(11) Yes None 1000000
}

I am not sure why it is not getting the data.
Please let me know your thoughts.
Thanks
Jason

[maschoff]

Why is your company_id zero? Didn't you set up the content of the OpenEMM database with file openemm-2013.sql?

[jasons]

Not sure why the Value is 0, but i did use openemm-2013.sql.

What value should there?

[maschoff]

1 - have a look at the content of openemm-2013.sql.

[jasons]

OK, its # 1
I will add that.

[jasons]

Did not fix the problem.

[maschoff]

Sure. If you take a look at openemm-2013.sql you will notice that other information are missing from your table company_tbl as well (and probably from other tables). if you do not set up the OpenEMM database completely, the software can not work.

[jasons]

Thanks for the info, do i need to reinstall everything or could i use openemm-2013.sql to fix the corrupt db.

[maschoff]

No need to re-install the software if only your database is correupt.

[jasons]

Ok thanks, so i will rebuild the db using the openemm-2013.sql file.
Please let me know if i need to do something else.