home
products
contribute
download
documentation
forum
Home
Forums
New posts
Search forums
What's new
New posts
All posts
Latest activity
Members
Registered members
Current visitors
Donate
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Search titles only
By:
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
MediaPortal 1
Support
General Support
Can't use TV or repair database
Contact us
RSS
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="doveman" data-source="post: 971994" data-attributes="member: 67412"><p>I still can't connect using the commandline Start Menu shortcut but using the Workbench I can login with root/Mediaportal and see mptvdb, mymusic32 and myvideos75 and I can login with xbmc/xbmc and see just mymusic32 and myvideos75, so it seems the users are OK so I don't understand why the commandline shortcut doesn't work using MediaPortal.</p><p> </p><p>Ah, I just tried clearing the stored password in Workbench and it still connected using root without prompting for a password. So I tried the commandline shortcut without entering a password, just pressing enter and it connected, so it seems the password has been wiped somehow. I'm surprised MP works still as I thought it would be using root/Mediaportal <img src="data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7" class="smilie smilie--sprite smilie--sprite5" alt=":confused:" title="Confused :confused:" loading="lazy" data-shortname=":confused:" /></p><p> </p><p>EDIT: I still can't connect to the 2nd instance on port 3307 I created though. I've posted below the my2.ini associated with it and the my.ini used by the working instance on port 3306 if you could take a look and see if there's anything obvious. The second instance my2.ini is pointed to datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data2" which is currently empty. Is this wrong and am I meant to create some files in there manually?</p><p> </p><p>[code][client]</p><p>port=3307</p><p>[mysql]</p><p>default-character-set=utf8</p><p>[mysqld]</p><p>port=3307</p><p>basedir="C:/Program Files/MySQL/MySQL Server 5.1/"</p><p>datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data2"</p><p>default-character-set=utf8</p><p>default-storage-engine=myisam</p><p>sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"</p><p>max_connections=100</p><p>query_cache_size=32M</p><p>table_cache=64</p><p>tmp_table_size=18M</p><p>thread_cache_size=4</p><p>thread_concurrency=4</p><p>myisam_max_sort_file_size=100M</p><p>myisam_max_extra_sort_file_size=100M</p><p>myisam_sort_buffer_size=64M</p><p>key_buffer_size=16M</p><p>read_buffer_size=2M</p><p>read_rnd_buffer_size=16M</p><p>sort_buffer_size=2M</p><p>innodb_additional_mem_pool_size=2M</p><p>innodb_flush_log_at_trx_commit=1</p><p>innodb_log_buffer_size=1M</p><p>innodb_buffer_pool_size=96M</p><p>innodb_log_file_size=50M</p><p>innodb_thread_concurrency=8</p><p>bind-address = 0.0.0.0</p><p>skip-name-resolve[/code]</p><p> </p><p>[code][client]</p><p>port=3306</p><p>[mysql]</p><p>default-character-set=utf8</p><p>[mysqld]</p><p>port=3306</p><p>basedir="C:/Program Files/MySQL/MySQL Server 5.1/"</p><p>datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data"</p><p>default-character-set=utf8</p><p>default-storage-engine=myisam</p><p>sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"</p><p>max_connections=100</p><p>query_cache_size=32M</p><p>table_cache=64</p><p>tmp_table_size=18M</p><p>thread_cache_size=4</p><p>thread_concurrency=4</p><p>myisam_max_sort_file_size=100M</p><p>myisam_max_extra_sort_file_size=100M</p><p>myisam_sort_buffer_size=64M</p><p>key_buffer_size=16M</p><p>read_buffer_size=2M</p><p>read_rnd_buffer_size=16M</p><p>sort_buffer_size=2M</p><p>innodb_additional_mem_pool_size=2M</p><p>innodb_flush_log_at_trx_commit=1</p><p>innodb_log_buffer_size=1M</p><p>innodb_buffer_pool_size=96M</p><p>innodb_log_file_size=50M</p><p>innodb_thread_concurrency=8</p><p>bind-address = 0.0.0.0</p><p>skip-name-resolve[/code]</p></blockquote><p></p>
[QUOTE="doveman, post: 971994, member: 67412"] I still can't connect using the commandline Start Menu shortcut but using the Workbench I can login with root/Mediaportal and see mptvdb, mymusic32 and myvideos75 and I can login with xbmc/xbmc and see just mymusic32 and myvideos75, so it seems the users are OK so I don't understand why the commandline shortcut doesn't work using MediaPortal. Ah, I just tried clearing the stored password in Workbench and it still connected using root without prompting for a password. So I tried the commandline shortcut without entering a password, just pressing enter and it connected, so it seems the password has been wiped somehow. I'm surprised MP works still as I thought it would be using root/Mediaportal :confused: EDIT: I still can't connect to the 2nd instance on port 3307 I created though. I've posted below the my2.ini associated with it and the my.ini used by the working instance on port 3306 if you could take a look and see if there's anything obvious. The second instance my2.ini is pointed to datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data2" which is currently empty. Is this wrong and am I meant to create some files in there manually? [code][client] port=3307 [mysql] default-character-set=utf8 [mysqld] port=3307 basedir="C:/Program Files/MySQL/MySQL Server 5.1/" datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data2" default-character-set=utf8 default-storage-engine=myisam sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=100 query_cache_size=32M table_cache=64 tmp_table_size=18M thread_cache_size=4 thread_concurrency=4 myisam_max_sort_file_size=100M myisam_max_extra_sort_file_size=100M myisam_sort_buffer_size=64M key_buffer_size=16M read_buffer_size=2M read_rnd_buffer_size=16M sort_buffer_size=2M innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=96M innodb_log_file_size=50M innodb_thread_concurrency=8 bind-address = 0.0.0.0 skip-name-resolve[/code] [code][client] port=3306 [mysql] default-character-set=utf8 [mysqld] port=3306 basedir="C:/Program Files/MySQL/MySQL Server 5.1/" datadir="C:/ProgramData/MySQL/MySQL Server 5.1/Data" default-character-set=utf8 default-storage-engine=myisam sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION" max_connections=100 query_cache_size=32M table_cache=64 tmp_table_size=18M thread_cache_size=4 thread_concurrency=4 myisam_max_sort_file_size=100M myisam_max_extra_sort_file_size=100M myisam_sort_buffer_size=64M key_buffer_size=16M read_buffer_size=2M read_rnd_buffer_size=16M sort_buffer_size=2M innodb_additional_mem_pool_size=2M innodb_flush_log_at_trx_commit=1 innodb_log_buffer_size=1M innodb_buffer_pool_size=96M innodb_log_file_size=50M innodb_thread_concurrency=8 bind-address = 0.0.0.0 skip-name-resolve[/code] [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
MediaPortal 1
Support
General Support
Can't use TV or repair database
Contact us
RSS
Top
Bottom
