Mediaportal tv-server not working with installed MySQL (wamp-server) (1 Viewer)

[Drizzeh]

Hello everyone,

I've been using mediaportal in the past and it always worked great up untill today.

I have installed wamp-server, it's software that bunldes apache, php and MySQL (version 5.5.24) for easy installation, and cause I couldn't use pypMyAdmin there I tried uninstalling the MySQL version that came with the MediaPortal install (it was 5.1 I believe). Then the problems started.

I launched MediaPortal to watch EuroCup, but it woulnd't work . So I completely uninstalled and then I tried reinstalling it. After the install I try to launch 'TV-Server Configuration' and gives me following window.

From here on I have no idea on how to fix it after trying to fix it for couple hours now with Google. I have read that having localhost as hostname isn't the way to go but I don't now how to fix this. (I have MySQL workbench installed).


Can anyone help me? It would be much appreciated.

 

[mm1352000]

Hello Drizzeh

Can anyone help me? It would be much appreciated.

I will try to help.

This is what I do when using a pre-installed version of MySQL...

1. Create a schema for MP to use. I prefer to do this manually because then security is not so tricky to setup (don't have to give privileges to create schemas). Open workbench and connect to the DB instance ("open connection to start querying") with a user who has permission to create schemas - root should be fine. Click "add schema" on the left. Enter the name (remember this for later) and select the collation. I usually leave collation as default which corresponds with UTF-8 for me. If you anticipate needing interesting characters in your EPG then you may want to choose a different option.

2. Configure MySQL to allow TCP access. Go back to the workbench main menu and configure security for the DB instance (on the right). Go to the "options file" entry on the left, and on the "general" tab ensure that "don't allow connection with TCP/IP" is disabled. I usually also ensure that "enable support for named pipes" is enabled.

3. Allow access to the DB user that you will use for MP. Still in security configuration in workbench, go to the "users and privileges" entry on the left, and select the "login" sub-tab on the "server access management" tab. I usually create a dedicated user for MP, and allow access from any host (%). Not using the root user prevents potential remote access with root privileges - a security risk if there is any valuable data in the DB.

4. On the "administrative roles" sub-tab I untick everything (note: do *not* do this if you are going to use the root user unless you know what you are doing). On the "account limits" sub-tab I leave everything as zero.

5. On the "schema privileges" tab (not sub-tab) I grant "SELECT" on mysql and information_schema from any host to the MP user (note: do *not* do this if you are going to use the root user unless you know what you are doing). On the MediaPortal TV Server schema (whatever you called it in step 1) I enable everything except "GRANT OPTION" from any host. This enables the MP user to do whatever they like with the MP schema, except grant access to another user (which should be unnecessary - just for safety).

Now restart the MySQL service and start TV Server configuration.

In order from top to bottom, enter:
1. The actual IP address or host name of the computer (*not* localhost). It is recommended to use a static IP for the TV Server, so you would enter that IP address (for example 192.168.1.2). If you find static IP addresses confusing or complicated and just want something that works quickly then use the name of the computer. You can find the name by right clicking on any link to "my computer" and selecting properties. The "computer name" shown there is what you should use. Again: I *strongly* recommend using a static IP address. There are plenty of guides available with a quick Google.
2. The name of the MySQL service. Usually you don't have to change this.
3. The name that you gave to the MP TV Server schema.
4. The name of the user that you configured with access to the MP schema.
5. The corresponding password for the user.

Hopefully everything should work after this. If not, try temporarily turning off firewalls to ensure TV Server configuration is not being blocked from connecting.

mm