moss_backend : ERROR: function uuid() does not exist

Discussions About MOSS (Myst Online Server Software)

Moderators: a'moaca', rarified

Post Reply
User avatar
Griffi Marauder
Member
Posts: 4
Joined: Thu Dec 26, 2013 7:55 pm

moss_backend : ERROR: function uuid() does not exist

Post by Griffi Marauder »

Shorah,

i have installed MOSS succefull, but starting moss_backend give me the following error :

Code: Select all

1388089931.025377  INFO backend: Backend startup
1388089932.362669  WARN backend: SQL error in Call_initvault: ERROR:  function uuid() does not exist
LINE 1: ...ROM createage('Neighborhood', 'Bevin', 'DRC', '', uuid(), NU...
                                                                                            ^
HINT:  No function matches the given name and argument types. You might need to add explicit type casts.
QUERY:  SELECT v_agenode FROM createage('Neighborhood', 'Bevin', 'DRC', '', uuid(), NULL)
CONTEXT:  PL/pgSQL function initvault() line 152 at SQL statement
MOSS is running by the user moss.

I have the Source compiled and installed in the moss home-directory .
When adding the moss.sql-file to the Database, i got some errors but it seems to me all needed stuff is added
to the Database (my SQL-knowlege is near Zero). The moss.sql file is unchanged.

I am using Gentoo-Linux with PostgreSQL 9.3.2

Some help to soving this issue is needed.


regards and thank you

Griffi
User avatar
Griffi Marauder
Member
Posts: 4
Joined: Thu Dec 26, 2013 7:55 pm

Re: moss_backend : ERROR: function uuid() does not exist

Post by Griffi Marauder »

Yes, i did. It is installed in :

-rwxr-xr-x 1 root root 6820 Dec 25 13:50 /usr/lib/postgresql-9.3/lib/moss_uuidgen.so

this is the Place, where make install copy it.


regards and thank you

Griffi Marauder
User avatar
Mac_Fife
Member
Posts: 1239
Joined: Fri Dec 19, 2008 12:38 am
Location: Scotland
Contact:

Re: moss_backend : ERROR: function uuid() does not exist

Post by Mac_Fife »

I think (I'm not an expert here) that with PostgreSQL versions from 9.1 onwards you need to use "CREATE EXTENSION" to install additional modules -- something like this (and assuming you're logged in as the database "owner"):

Code: Select all

psql -U postgres yourmossdatabasename -c "create extension moss_uuidgen"
You probably need to do that after cd into the folder where the module has been saved.
Mac_Fife
OpenUru.org wiki wrangler
User avatar
Griffi Marauder
Member
Posts: 4
Joined: Thu Dec 26, 2013 7:55 pm

Re: moss_backend : ERROR: function uuid() does not exist

Post by Griffi Marauder »

Thank you Mac_Fife to point me to the right Direction !

I have to install it with 'create extension' , but have to create a moss_uuidgen.config file.
this one have to put in the extensions-folder of postgresql then the extenion can be created.

Next step : reading the Manual to learn how to write it :D

This will take some time, but when done i wil be back.

regards and thank you

Griffi Marauder
User avatar
Mac_Fife
Member
Posts: 1239
Joined: Fri Dec 19, 2008 12:38 am
Location: Scotland
Contact:

Re: moss_backend : ERROR: function uuid() does not exist

Post by Mac_Fife »

Griffi Marauder wrote:I have to install it with 'create extension' , but have to create a moss_uuidgen.config file.
I think you meant to say "moss_uuidgen.control file" -- From this manual page: http://www.postgresql.org/docs/9.1/stat ... sions.html, it seems that you also need a SQL script file, like "moss_uuidgen--1.0.sql".

Once you do have it all figured out, it'd be really good if you can provide detailed notes that we can add to the MOSS Setup wiki page - maybe the .control and .sql files you create can be added to the repository for other users.
Mac_Fife
OpenUru.org wiki wrangler
User avatar
Griffi Marauder
Member
Posts: 4
Joined: Thu Dec 26, 2013 7:55 pm

Re: moss_backend : ERROR: function uuid() does not exist

Post by Griffi Marauder »

Hello Mac_Fife

Yep, i mean the control file.

While digging and testing around, i find a simpler solution ;)

With Postgresql 9.3 on my Gentoo Box i do the following steps

As root

Code: Select all


realworld moss #   emerge --ask postgresql-server postgresql-base
realworld moss #   emerge --config =dev-db/postgresql-server-9.3.2
realworld moss #   /etc/init.d/postgresql-9.3 start

logout from root and login as user moss
(user moss is running the server and owner of the database)

Code: Select all

moss@realworld ~ $   psql -U postgres

postgres=# create role moss with login;       
postgres=# create database moss with owner=moss template=default;
postgres=# \q
with \l and \dg you can list the ROLE and DATABASE to see all is going well

Code: Select all


moss@realworld ~ $ psql -U postgres moss -f ./moss.sql

moss@realworld ~ $ moss_backend && moss

This are my steps and the Server is up and running :D
You can add this to the Wiki, if you wish.


Regards and Thank you

Griffi Marauder
Post Reply

Return to “MOSS”