I downloaded Blogg-X and would like to use it in my site. However, I cannot get the Java connection to work. I assume the product works on a hosted connection. Could you show how the servername should appear? My current servername is http://mysite.com
Also do I need a connection name somewhere? Paul Earley
Paul, I guess I didn't really explain the config portion at all on the main page. Below is an image which should help. Basically the settings Blogg-X needs are the same that Joomla/Mambo uses. If you log into your Joomla/Mambo administration interface and select "Global Configuration" the "database" tab should have all the information. Here is an image:
I will also put the information on the main Blogg-X page to help others out.
I hope you enjoy the program and it becomes useful.
Sorry but I cannot make it work. In my server, for Joomla sites I'm connecting to localhost. I need to provide an IP pr URL to make the connection with bloggX I've tried with the IP or the domain name without luck. Can you explain how to connect to a remote server? I have 20 o 30 jommla sites running there, all of them with the same mysql user / pass. Thank you
Hi, I have problems to make it work as well. I'm testing Blogg-X on my local Windows box using default username and password for MySQL. I've tried IP address and "localhost" as server name but no luck. When I click "Update categories" I get error message saying "An error was encountered when trying" and that's all. Can't really see what this really promising app was trying. Any ideas?
Sergio... Are you using a hosting provider for all the sites or are they run from a local computer that you administer? If hosted you may need to contact the tech support team of the provider or look through their FAQ to see if they state what the address is of the sql server and to be sure they support "remote database connections". If they want to know, Blogg-X is using the JDBC database connector from the MySQL team. I know my hosting provider has the SQL servers on separate systems from my dedicated IP address so I have to use the IP or name of the SQL server.
Markku... I'm guessing you are probably having the same problem as Sergio. A quick email to the tech support guys should help out here.
Below is an example of my servers mySQL address (changed of course slightly but you should get the idea)
mysql12.hostingcompany.com
As far as the "An error was encountered when trying" thats my fault for not cleaning the message up, this means the database connection has failed. I will fix the error message so it's actually useful.
And thanks for your reply. However I'm testing Blogg-X on my Windows laptop where MySQL, Apache, PHP, Joomla! site/s and Blogg-X are all running on the same computer, but I just can't connect to local database/s.
My host supports "remote database connections" but I haven't tried that yet. My assumption is that if Blogg-X works on my local environment then I can start using/testing it it with remote db's as well. Just wondering, should I configure JDBC drivers somehow in order to make them work?
Markku... try using the following for the servername:
localhost:3306
I believe 3306 is the default port for MySQL but if you have changed it substitute your change in for 3306. I don't have a local MySQL database running but I will see about installing one and try it here locally.
I installed a local windows MySQL server and created some test databases and tables within. Using "localhost" as the hostname in Blogg-X did connect me to the database. One note though I had to use the root account on my MySQL server, so one would have to use the username/password of an administrator for the database in Blogg-X settings.
Ok so it seems to find the datebase, but is hving issues actually syncing up to the database, any thoughts on this one?
Are you getting any errors? If so what is the message. Also is this a local database on a local computer or a hosted site? Can you explain what you mean by "syncing up to the database"? Any other information would greatly help me in helping you.
using "localhost" or anything that is not valid, I get "An error was encountered while trying to establish a database connection to jdbc:mysql://localhost/crbatch_joomla", when I click on update categories...
using valid domain, I get, "An error was encountered while trying"...
Seems to me like it is seeing the database with the valid domain, and I know the username and password are correct for the database....
CRBatchelor... What is the "Database Prefix" that you are using for your tables? Is it the default "mos_" or do you have another? If yours is different then that's the problem. I will add the ability to specify the database prefix into the program as this may affect others.
As for the unhelpful error message: "An error was encountered while trying"
This is my fault, for missing the incomplete message before compiling the code. Basically what the problem is that when trying to determine the sites categories the sql queries are failing most likely do to a change in the database prefix. Also do you know approximately how many categories you would have? More than say 10?
Let me know and I will see about adding the database prefix as soon as possible.
Thanks for the tip, I was using different prefix than the default "mos_". Now Blog-x works fine on my local environment, next thing is to try remote connections.
Ok, that solved it... It was the prefix that was different than what it was looking for. I just did a fresh install of Joomla, and it's default is jos not the old mambo mos.... All looks to be working now.... Thanks!
Author
Logged
