Re: [pLog-General] A bug or my database problem

[Oscar R. <os...@re...>]

Hi!

> Thanks, Oscar.
> A fews things..... let me clear out first.
> localhost = 127.0.0.1
> 0.0.0.0  =  this host
> 255.255.255.255 = limited broadcast
> all ones in host ID = directed broadcast

Thanks, that's all very good to remember since all those concepts have 
become quite fuzzy for me since I learnt them... :)

>  When you do "netstat -anp"  you might see a lot of services listening 
> on
> 0.0.0.0 like 0.0.0.0:3306 for mysql, but it talks with 127.0.0.1:3306.
>
> Yes, my server already have php but I only have postgres installed. 
> So, I
> need to install mysql and php-mysql separately (also some lib-xyz.so 
> too).
> That is why I got complaint on my server.

Yes, indeed we use mysql as the database back-end. I don't think that 
much effort would be needed to port all the sql to be compatible with 
postgres. I am not very experienced in that but I know that some of the 
queries we use (though only a few) make use of features that are only 
available in mysql. If there is enough demand for adding support for 
postgres, we could think about it...

About this .so library, I never heard of it. I've installed php in many 
different unix systems and I never needed anything else than a working 
installation of mysql and php.

>
> Can a user join without creating own blog? ( Bypass new blog 
> registration)
>

As it is now, it is not possible. I decided to not include an option 
for users to join any blog for security reasons. Imagine that you go 
create a new user and then you're shown a list with all the blogs to 
which you can join... Being part of a blog means having access to all 
the posts so far, pictures, categories, etc, and if somebody with not 
so nice intentions joins a blog, don't know what could happen...

If anybody's up for modifying register.php for doing that, or perhaps 
for adding a config setting for doing that, please go ahead. I'm quite 
busy finishing 0.3 :) It shouldn't be very difficult and I can offer 
guidance if needed. Otherwise, I could take up that task after 0.3...

> Kyaw Moe
> Maryland Department of Public Safety and Correctional Services
> Information Technology and Communications Division
> Network Infrastructure Group
>
>
>
> -----Original Message-----
> From: Oscar Renalias [mailto:os...@re...]
> Sent: Wednesday, February 11, 2004 12:54 PM
> To: plo...@li...
> Subject: Re: [pLog-General] A bug or my database problem
>
>
> Hi!
>
>> When I tried plog-0.2.1, I found the following. Some of them are very
>> basic
>> but for php newbie like me, it took a few hours to finger out.
>
> Let's see...
>
>>
>> 1. In database server configuration, I have to use 0.0.0.0 as server
>> address
>> to work. There is no doc that clearly explain. (I tried with localhost
>> and
>> it didn't work.) - That might be mySQL newbie mistake or plog doc
>> error. I
>> simply don't know.
>
> That sounds very strange because 0.0.0.0 is not a valid network
> address. I don't remember if it's broadcast or what but that shouldn't
> definitely work like that. localhost means 127.0.0.1 which is the
> address of your very same machine (that is, points to yourself) First
> of all, try if something like "ping localhost" works. If not, have a
> look at the /etc/hosts file and make sure that you have something like
> this in it:
>
> 127.0.0.1 localhost
>
> Needless to mention, "ping 127.0.0.1" should _always_ work.
>
> I don't think that the official documentation should include this case
> because it is very odd, so to say.
>
>> 2. I need to load php-mysql package but that is not in require 
>> software
>> list.
>
> I don't understand this... Which php-mysql package do you mean? The
> description of pLog mentions that it needs a mysql database to store
> posts and so on, so I assumed that people would inmediately understand
> that a php compiled with support for mysql is needed. But thanks for
> the tip, I will try to make the documentation clearer regarding this.
>
>> 3. After the database initialized, I got error on plog main page.
>> "Fatal error: Call to a member function on a non-object in
>> /..../plog-0.2.1/tmp/default^post.template on line 12"
>> My admin page shows that message fine. So, I decided to copy some code
>> from
>> admin folder.
>> I replace line 12 of  /.../plog-0.2.1/templates/default/post.template
>> file
>> -
>> "{$smileys->parse($postText)}"
>> to  "{$post->getText()}"
>
> This is my very own mistake and it's my fault that went unnoticed.
> Basically I uploaded the package with a call to a plugin that I never
> released because never got completed. The plugin simply translated
> things like ":)" to a nicer icon representing the smiley... You can
> still use the "grey" style or the "lemons" style since I haven't seen
> the bug there. Thanks for letting us now about that!
>
>> 4. There is no link from main blog page to login page.
>>
>
> I did that for security. I know it's a little bit like "security
> through obscurity" and it can't be counted as a security measure "per
> se". If somebody wants to hack a pLog installation, probably they'll be
> able anyway but I just didn't want to let the world know where to find
> our admin interface.
>
> If you wish to have a link there, please feel free to edit the template
> and add it. After all, that's the meaning of freedom with templates:
> they can be modified to suit everybody's needs :)
>
> Thanks for your feedback and comments. They are really appreciated!
>
> Regards,
>
> Oscar.
>
>
>
>
>
>
> -------------------------------------------------------
> SF.Net is sponsored by: Speed Start Your Linux Apps Now.
> Build and deploy apps & Web services for Linux with
> a free DVD software kit from IBM. Click Now!
> http://ads.osdn.com/?ad_id=1356&alloc_id=3438&op=click
> _______________________________________________
> pLog-General mailing list
> pLo...@li...
> https://lists.sourceforge.net/lists/listinfo/plog-general
>