Troels Richter help

This is the place to report bugs and get support. When posting in this forum, please always provide as much detail as possible.

Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum, do not report it as a bug.

This is the place to report bugs and get support

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.
Please do not report problems with a custom build or custom code in this forum. If you are producing your own build from the source code and have problems or questions, ask in the developer forum.
This thread is closed to new posts. You must sign in to post in the forums.
2/10/2005 2:09:06 PM
Gravatar
Total Posts 18444

Troels Richter help

Troels, sorry I had a data loss incident and lost your recent posts. Not sure if you saw my responses to your last post.

Your site works if you put pageid=1 in the url

You need to configure apache to automatically serve Default.aspx in your httpd.conf file and make sure all the rows in mp_Pages has a SiteID = 1 and make sure there is a row in the mp_Sites table with SiteID = 1

2/14/2005 12:57:59 AM
Gravatar
Total Posts 3

Re: Troels Richter help

the rows in the database looks fine, but it still not works.

http://sharpdev.dk/troelsrichter

Again it looks like a DB connection error, but when i try to connect  with phpMyAdmin it works just fine.
2/14/2005 5:20:01 AM
Gravatar
Total Posts 18444

Re: Troels Richter help

Is your database on the same machine as the web server?
Is PHPMyAdmin using the same connection user and password?
MySQL has very granular permissions, users must have permission to connect from specific hosts. If its on the same machine as the apche, it should work using localhost root and blank password
2/14/2005 7:10:14 AM
Gravatar
Total Posts 3

Re: Troels Richter help

Is your database on the same machine as the web server? Yes
Is PHPMyAdmin using the same connection user and password? yes, I have created a mojo user with permission to the mojoportal database.

MySQL has very granular permissions, users must have permission to connect from specific hosts. If its on
 the same machine as the apche, it should work using localhost root and blank password. I will not use root user  with this application. The mojo user is tested with phpmyadmin (localhost), so I can't see why the user should be the problem.

2/14/2005 7:21:02 AM
Gravatar
Total Posts 18444

Re: Troels Richter help

I'm not suggesting using the root user permanently, just to see if it works. I agree if the mojouser works in phpmyadmin it should work also in mojoportal if they are both using localhost. I would assume phpmyadmin is using tcp/ip to connect but I don't know for sure. I do know that mySQL has to be configured to allow tcp/ip connections and the user must be able to connect from the specific host. I think the error is telling the truth, there is some kind of permission problem. Something is different about how phpmyadmin is connecting than the way mojoportal is connecting. You are making your connection string in the web.config mySqlConnectionString entry right? not the ConnectionString entry?
2/14/2005 8:00:21 AM
Gravatar
Total Posts 3

Re: Troels Richter help

Now I've tried with my root user, restarted apache, but error message is the same.

Maybe it's easier if I creates a user for you on my server?
2/14/2005 12:40:07 PM
Gravatar
Total Posts 18444

Re: Troels Richter help

I'm happy to help any way I can. I've never logged in remotely to a linux machine before though so be sure and send me instructions if you want me to try it. You can reach me at joe_audette at yahoo dot com
You must sign in to post in the forums. This thread is closed to new posts.