Self Contained Web Server / Interface - Page 42

Gixxer · 2008-05-17, 08:52

Quote:

Originally Posted by P.Niem

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 · 2008-05-18, 12:22

Take these: MySQL :: MySQL GUI Tools Downloads

Gixxer · 2008-05-18, 14:03

Quote:

Originally Posted by P.Niem

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 · 2008-05-19, 07:24

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 · 2008-05-19, 18:12

Quote:

Originally Posted by 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".

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 · 2008-05-19, 22:10

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

P.Niem · 2008-05-20, 07:25

@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 · 2008-05-20, 18:16

Quote:

Originally Posted by 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"?

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 · 2008-05-20, 23:41

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 · 2008-05-21, 08:02

@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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
TVE3 Web User Interface	goatse	Development	29	2008-05-12 17:14
Web Interface	tucholka	MediaPortal 1 Talk	1	2007-04-16 14:44
Updated interface for MP Web Controller	quiller	Skins	0	2007-01-21 07:14
Web Interface like xbmc?	brandenpro	Plugins	1	2005-09-05 08:19
Web Interface......	spo	General Development (no feature request here!)	24	2004-11-07 11:33

2008-05-18, 12:22	#412 (permalink)
P.Niem Portal Member Join Date: Jan 2008 Posts: 25 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	Take these: MySQL :: MySQL GUI Tools Downloads

2008-05-19, 07:24	#414 (permalink)
P.Niem Portal Member Join Date: Jan 2008 Posts: 25 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	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".

2008-05-19, 22:10	#416 (permalink)
Keldandorin Portal Member Join Date: Apr 2006 Location: Sweden Posts: 22 Thanks: 1 Thanked 1 Time in 1 Post Country:	Where can I find "Risu's Custom HTML Interface pages"? /Håkan

2008-05-20, 07:25	#417 (permalink)
P.Niem Portal Member Join Date: Jan 2008 Posts: 25 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	@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"?

2008-05-20, 23:41	#419 (permalink)
anpe Portal Member Join Date: Sep 2007 Posts: 15 Thanks: 0 Thanked 0 Times in 0 Posts Country:	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!

2008-05-21, 08:02	#420 (permalink)
P.Niem Portal Member Join Date: Jan 2008 Posts: 25 Thanks: 0 Thanked 0 Times in 0 Posts Country: My System	@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.