Self Contained Web Server / Interface (1 Viewer)

[Gixxer]

When installing MP only some parts of MySQL are installed. You have to download and install the MySQL GUI Tools and after installing you have to run MySQL Administrator. That screen should lok familiar with the screens in the pdf.

Note that the default user is "root" and the (case sensitive) password is "MediaPortal"

great, then there is something more to install after all.

is there an official place where i can download the mysql gui tools so that i have not problems of version number?

thanks a lot

 

[P.Niem]

Take these: MySQL :: MySQL GUI Tools Downloads

 

[Gixxer]

Take these: MySQL :: MySQL GUI Tools Downloads

thanks for that.

one more...

what is the Server Host when going to MySQL?? and the port number???

sorry im totally lost in this one.

user is root
and password is MediaPortal

right?

 

[P.Niem]

I assume that you have single seat environment where TV-engine and MediaPortal front end run on the same computer. Then the server host name is "localhost" or "127.0.0.1". The port number can be any positive number below 65536. If you don't know what to choose, take 8080 which is also used in the example.

After you have finished setup, you want to try if all things work correctly. Then you have to start your favorite browser and enter the ip address or name followed by the port number like this "http:://localhost:8080".

 

[Gixxer]

I assume that you have single seat environment where TV-engine and MediaPortal front end run on the same computer. Then the server host name is "localhost" or "127.0.0.1". The port number can be any positive number below 65536. If you don't know what to choose, take 8080 which is also used in the example.

After you have finished setup, you want to try if all things work correctly. Then you have to start your favorite browser and enter the ip address or name followed by the port number like this "http:://localhost:8080".

no, i have multi seat i think

computer 1) tvserver + mediaportal + tv cards
computer 2) mediaportal client

i have tried

Server host: 127.0.0.1 and also localhost
Port: 8080 and 3306
User: root
Password: MediaPortal

when i put 8080 it just stays there doing nothing till i press cancel

when i put 3306 it gives me error "could not connect to specified instance"

oh, and mp and tvserver are working perfectly apart from this.

any clue on what is happening?

thanks !! ;

 

[Keldandorin]

Where can I find "Risu's Custom HTML Interface pages"?
/Håkan

 

[P.Niem]

Gixxer
If you have a multi seat environment. I think the best you do is to install the web interface on your first computer (TV-engine) In that case you have to choose localhost in the database tab of the web interface configuration (page 6 of the manual) Note that on this tab is a database login test button. What happens when you hit that button?

Any other computer can be used to access the web interface via your LAN or WAN. then you have to fill in the ip address (or hostname) of your first computer in the browser like this: http://192.1.1.33:8080. Note that you have to grant the web interface to be accessed through your firewalls. if you want to access the web interface from outside your house, the ip-address is translated by your adsl-modem in the NAT table.

Keldandorin
What do you mean with "Risu's Custom HTML Interface pages"?

 

[Gixxer]

@Gixxer
If you have a multi seat environment. I think the best you do is to install the web interface on your first computer (TV-engine) In that case you have to choose localhost in the database tab of the web interface configuration (page 6 of the manual) Note that on this tab is a database login test button. What happens when you hit that button?

Any other computer can be used to access the web interface via your LAN or WAN. then you have to fill in the ip address (or hostname) of your first computer in the browser like this: http://192.1.1.33:8080. Note that you have to grant the web interface to be accessed through your firewalls. if you want to access the web interface from outside your house, the ip-address is translated by your adsl-modem in the NAT table.

@Keldandorin
What do you mean with "Risu's Custom HTML Interface pages"?

hi P.niem, thanks for trying to help me out.

thats what i was doing, i installed web interface in the server computer, where the tv cards are.

however, when trying to create the sql user i can not connect.

i installed sql gui tools , and when i open it i try to connect with the info in my previous post without success.

i have to do this before configuring the web interface,right?

im completely lost

 

[anpe]

Hi!

Stumbled on some problems when installing this piece of software... Everything seems to work fine it connects to the database and i can login using my browser but when i push "Show Program Guide" all i see is my channels and no other epg data. if i go to "Tv service status" it says "Unable to connect to TV Service" what could be the problem? I get no other error or anything!

Thanks in advance!

 

[P.Niem]

anpe
Did you install a new SVN of the TV-engine? Last week I had a same of problem, because the schema (database name) has been changed from tvlibrary to mptvdbrc1. The old one still exists, but doesn't programmas anymore. Maybe you have the same problem. If you use MySQL as the TV Engine database, you can check this by running the MySQL Query Browser and login (connect) as user root / MediaPortal, but don't select a default schema. Ignore the warning. Then you see on the right side pane all the available schemas. If there is that mptvdbrc1, you can double click on it else choose tvlibrary. Then the query browser shows all the tables within this schema. Just double click again on, for example, setting and execute it (cntrl enter). The query browser shows a table with all the settings of the tv server. On the bottom you can see if the XMLTV has updated the guide.

Gixxer
If your TV server is working correctly there should be a database on your computer 1. First I assume you are using MySQL. When I run MySQL Administrator, I fill in the following fields:
Stored Connection: left blank (default)
Server Host: localhost (default)
Port: 3306 (default)
Username: root
Password: MediaPortal (THIS IS CASE SENSITIVE)
at Detail none of the boxes are checked (default)

Just hit the OK button and you should be able to connect. If you can't connect you get the error message and the possibility to use Ping. If you hit Ping you should see the replies of the Ping.

If this all went wrong you have a problem with your database and you have to resolve this problem first before going further with the Web Interface installation. In this case it has nothing to do with the Web interface.