Re: [Opensim-dev] Please help evaluate/test PostgreSql support for OpenSimulator
Fernando's contributions have been merged into git master so a fresh pull from there will now include his postgresql support. Please try it :) Also, *please remember* that git master is a development repository and should *never* be used in a production environment! ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev
Re: [Opensim-dev] PostgreSQL data module for OpenSim
What are the advantages of of using PostgreSQL for Opensim in comparison to mysql? Perfomance? Memory usage? Anything else? As far as I know, both have improved over the years and for me, as an average user and not a database guru, they are about the same. In other words, why should I switch if I have everything in place with MySQL? On Sat, Oct 12, 2013 at 4:00 AM, Fernando Francisco de Oliveira ferna...@oliveira.eti.br wrote: I hope so. I want to see it in production soon. cant wait to compile it from oficial repository :) I'm working on the database migration tool, and it is almost done. (mysql to postgresql) or any direction (even sqlite to postgres), mssql to postgres. as prototype its fixed to mysql to postgres, but adding the database plugin, like opensim itself, it can be done only configuring the INI file. like this: [Setup] Databases = myopensim,osmyothersim [DatabaseOrigin] StorageProvider = OpenSim.Data.MySQL.dll ConnectionString = Data Source=localhost;User ID=root;Password=***;Old Guids=true;Database= [DatabaseTarget] StorageProvider = OpenSim.Data.PGSQL.dll ConnectionString = User ID=postgres;Password=***;Host=localhost;Port=5432;Database= Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/11 James Hughes jam...@bluewallgroup.com On 10/10/2013 10:09 PM, Fernando Francisco de Oliveira wrote: Hello I just requested a push from my fork of opensim to the nebadon git opensim repository, that I created the PostgreSQL project to use this database in opensim. https://github.com/ffoliveira/**opensimulator/tree/PostgreSQLhttps://github.com/ffoliveira/opensimulator/tree/PostgreSQL I already have a Mantis Account. I hope the code and it's use may improve opensim performance and gain more users. Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_**lands http://twitter.com/oliveira_lands Thanks Fernando. I have always been suspect of projects that had no PgSQL support :) I think it will be a nice addition to our little project. BlueWall __**_ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/**mailman/listinfo/opensim-devhttps://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev
Re: [Opensim-dev] Missing God Mode / Maptiles [ 0.8.0 Dev (Opensim Distribution) 31246ec 2013-10-05 ]
Dear Neb, tahank you soo much ; while tailoring the opensim.ini to the new values i relly forgot to add the [Permissions] and [Map] Header ; /me so stupid ... best regards, Word _ Von: opensim-dev-boun...@lists.berlios.de [mailto:opensim-dev-boun...@lists.berlios.de] Im Auftrag von Michael Emory Cerquoni Gesendet: Samstag, 12. Oktober 2013 00:12 An: opensim-dev@lists.berlios.de Betreff: Re: [Opensim-dev] Missing God Mode / Maptiles [ 0.8.0 Dev (Opensim Distribution) 31246ec 2013-10-05 ] It has been moved to the [Permissions] section please compare against the new OpenSim.ini.example you will need to update your ini files. On Fri, Oct 11, 2013 at 5:50 PM, drWhiet drwh...@spacefriends.de wrote: Dear Devs, since i have installed the 0.8.0 Dev (Opensim Distribution) 31246ec 2013-10-05 i miss a feature i had before and i need. In the opensim.ini i use(d) the following settings allow_grid_gods = true region_owner_is_god = true region_manager_is_god = true parcel_owner_is_god = true Only i, as the owner can enter User level 2000+ (or the God mode). My colleague which is added as Estate Manager can not assume God Mode. I also think that something is wrong with the MapImageModule = Warp3DImageModule But cabt figure out whats wrong ; Maptiles are looking and prims are shown on the maptiles although i set DrawPrimOnMapTile = false (All on Windows 2008 Server 64 bit) Anybody elese experience/heard of these issues. Best regards, Wordfromthe Wise ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev -- Michael Emory Cerquoni ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev
Re: [Opensim-dev] PostgreSQL data module for OpenSim
my intention with the project was to add new features and not replace them. With a database like postgresql, we can cover more users, and many of them in the corporate environment. Database migration is an option, and I'm working on a tool to cover who want to do it. I saw some advantages using postgresql, but it's necessary to do more benchmarks to see how its behavior under pressure. This was a little test : https://docs.google.com/document/d/1iPjAItQPNQCUagROLogf6GZH3NdPE_Wtn2KtAIhYwyE/edit?usp=sharingless Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/12 Shy Robbiani shy.robbi...@gmail.com What are the advantages of of using PostgreSQL for Opensim in comparison to mysql? Perfomance? Memory usage? Anything else? As far as I know, both have improved over the years and for me, as an average user and not a database guru, they are about the same. In other words, why should I switch if I have everything in place with MySQL? On Sat, Oct 12, 2013 at 4:00 AM, Fernando Francisco de Oliveira ferna...@oliveira.eti.br wrote: I hope so. I want to see it in production soon. cant wait to compile it from oficial repository :) I'm working on the database migration tool, and it is almost done. (mysql to postgresql) or any direction (even sqlite to postgres), mssql to postgres. as prototype its fixed to mysql to postgres, but adding the database plugin, like opensim itself, it can be done only configuring the INI file. like this: [Setup] Databases = myopensim,osmyothersim [DatabaseOrigin] StorageProvider = OpenSim.Data.MySQL.dll ConnectionString = Data Source=localhost;User ID=root;Password=***;Old Guids=true;Database= [DatabaseTarget] StorageProvider = OpenSim.Data.PGSQL.dll ConnectionString = User ID=postgres;Password=***;Host=localhost;Port=5432;Database= Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/11 James Hughes jam...@bluewallgroup.com On 10/10/2013 10:09 PM, Fernando Francisco de Oliveira wrote: Hello I just requested a push from my fork of opensim to the nebadon git opensim repository, that I created the PostgreSQL project to use this database in opensim. https://github.com/ffoliveira/**opensimulator/tree/PostgreSQLhttps://github.com/ffoliveira/opensimulator/tree/PostgreSQL I already have a Mantis Account. I hope the code and it's use may improve opensim performance and gain more users. Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_**lands http://twitter.com/oliveira_lands Thanks Fernando. I have always been suspect of projects that had no PgSQL support :) I think it will be a nice addition to our little project. BlueWall __**_ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/**mailman/listinfo/opensim-devhttps://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev
Re: [Opensim-dev] PostgreSQL data module for OpenSim
Interesting. I'll give it a try on my test sims and watch memory consumption as memory limitations are often an issue for some virtual server installs. And yes, it's always good to have options. I'm glad to see it in the git master :) On Sat, Oct 12, 2013 at 3:39 PM, Fernando Francisco de Oliveira ferna...@oliveira.eti.br wrote: my intention with the project was to add new features and not replace them. With a database like postgresql, we can cover more users, and many of them in the corporate environment. Database migration is an option, and I'm working on a tool to cover who want to do it. I saw some advantages using postgresql, but it's necessary to do more benchmarks to see how its behavior under pressure. This was a little test : https://docs.google.com/document/d/1iPjAItQPNQCUagROLogf6GZH3NdPE_Wtn2KtAIhYwyE/edit?usp=sharingless Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/12 Shy Robbiani shy.robbi...@gmail.com What are the advantages of of using PostgreSQL for Opensim in comparison to mysql? Perfomance? Memory usage? Anything else? As far as I know, both have improved over the years and for me, as an average user and not a database guru, they are about the same. In other words, why should I switch if I have everything in place with MySQL? On Sat, Oct 12, 2013 at 4:00 AM, Fernando Francisco de Oliveira ferna...@oliveira.eti.br wrote: I hope so. I want to see it in production soon. cant wait to compile it from oficial repository :) I'm working on the database migration tool, and it is almost done. (mysql to postgresql) or any direction (even sqlite to postgres), mssql to postgres. as prototype its fixed to mysql to postgres, but adding the database plugin, like opensim itself, it can be done only configuring the INI file. like this: [Setup] Databases = myopensim,osmyothersim [DatabaseOrigin] StorageProvider = OpenSim.Data.MySQL.dll ConnectionString = Data Source=localhost;User ID=root;Password=***;Old Guids=true;Database= [DatabaseTarget] StorageProvider = OpenSim.Data.PGSQL.dll ConnectionString = User ID=postgres;Password=***;Host=localhost;Port=5432;Database= Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/11 James Hughes jam...@bluewallgroup.com On 10/10/2013 10:09 PM, Fernando Francisco de Oliveira wrote: Hello I just requested a push from my fork of opensim to the nebadon git opensim repository, that I created the PostgreSQL project to use this database in opensim. https://github.com/ffoliveira/**opensimulator/tree/PostgreSQLhttps://github.com/ffoliveira/opensimulator/tree/PostgreSQL I already have a Mantis Account. I hope the code and it's use may improve opensim performance and gain more users. Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_**landshttp://twitter.com/oliveira_lands Thanks Fernando. I have always been suspect of projects that had no PgSQL support :) I think it will be a nice addition to our little project. BlueWall __**_ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/**mailman/listinfo/opensim-devhttps://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev
Re: [Opensim-dev] PostgreSQL data module for OpenSim
Good. It would be nice to see the results when you get it. I'm going to conduct some more tests on my server too. The preliminary tests I've done at my home computer, with win8 and lots of stuff installed. Timothy Rogers did some tests on his servers and got better results that I did. Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/12 Shy Robbiani shy.robbi...@gmail.com Interesting. I'll give it a try on my test sims and watch memory consumption as memory limitations are often an issue for some virtual server installs. And yes, it's always good to have options. I'm glad to see it in the git master :) On Sat, Oct 12, 2013 at 3:39 PM, Fernando Francisco de Oliveira ferna...@oliveira.eti.br wrote: my intention with the project was to add new features and not replace them. With a database like postgresql, we can cover more users, and many of them in the corporate environment. Database migration is an option, and I'm working on a tool to cover who want to do it. I saw some advantages using postgresql, but it's necessary to do more benchmarks to see how its behavior under pressure. This was a little test : https://docs.google.com/document/d/1iPjAItQPNQCUagROLogf6GZH3NdPE_Wtn2KtAIhYwyE/edit?usp=sharingless Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/12 Shy Robbiani shy.robbi...@gmail.com What are the advantages of of using PostgreSQL for Opensim in comparison to mysql? Perfomance? Memory usage? Anything else? As far as I know, both have improved over the years and for me, as an average user and not a database guru, they are about the same. In other words, why should I switch if I have everything in place with MySQL? On Sat, Oct 12, 2013 at 4:00 AM, Fernando Francisco de Oliveira ferna...@oliveira.eti.br wrote: I hope so. I want to see it in production soon. cant wait to compile it from oficial repository :) I'm working on the database migration tool, and it is almost done. (mysql to postgresql) or any direction (even sqlite to postgres), mssql to postgres. as prototype its fixed to mysql to postgres, but adding the database plugin, like opensim itself, it can be done only configuring the INI file. like this: [Setup] Databases = myopensim,osmyothersim [DatabaseOrigin] StorageProvider = OpenSim.Data.MySQL.dll ConnectionString = Data Source=localhost;User ID=root;Password=***;Old Guids=true;Database= [DatabaseTarget] StorageProvider = OpenSim.Data.PGSQL.dll ConnectionString = User ID=postgres;Password=***;Host=localhost;Port=5432;Database= Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_lands 2013/10/11 James Hughes jam...@bluewallgroup.com On 10/10/2013 10:09 PM, Fernando Francisco de Oliveira wrote: Hello I just requested a push from my fork of opensim to the nebadon git opensim repository, that I created the PostgreSQL project to use this database in opensim. https://github.com/ffoliveira/**opensimulator/tree/PostgreSQLhttps://github.com/ffoliveira/opensimulator/tree/PostgreSQL I already have a Mantis Account. I hope the code and it's use may improve opensim performance and gain more users. Fernando Oliveira http://oliveira.eti.br http://twitter.com/oliveira_**landshttp://twitter.com/oliveira_lands Thanks Fernando. I have always been suspect of projects that had no PgSQL support :) I think it will be a nice addition to our little project. BlueWall __**_ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/**mailman/listinfo/opensim-devhttps://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev ___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev
Re: [Opensim-dev] Please help evaluate/test PostgreSql support for OpenSimulator
LIKE IT :) http://opensim-dev.2196679.n2.nabble.com/file/n7578809/Like-it-or-not-Facebook-changes-news-feed.jpg May also bring back alive MS-SQL support ... ... - _ Keep up the good work.!!! - OpenSimFan My Opensim/Second Life Blog http://verwijs.wordpress.com (Dutch, basic hardware/software help windows, Mac, Linux) http://verwijs-pc.nl My Twitter Page: http://twitter.com/OpenSimFan My Facebook page (be my friend, please ) http://www.facebook.com/andre.verwijs -- View this message in context: http://opensim-dev.2196679.n2.nabble.com/Please-help-evaluate-test-PostgreSql-support-for-OpenSimulator-tp7578790p7578809.html Sent from the opensim-dev mailing list archive at Nabble.com.___ Opensim-dev mailing list Opensim-dev@lists.berlios.de https://lists.berlios.de/mailman/listinfo/opensim-dev
