#!/usr/bin/env bash
POSTGIS_SQL_PATH='pg_config --sharedir'/contrib/postgis-2.0
createdb -E UTF8 template_postgis
createlang -d template_postgis plpgsql
psql -d postgres -c \
"UPDATE pg_database SET datistemplate='true' WHERE datname='template_postgis'"
psql -d template_postgis -f $POSTGIS_SQL_PATH/postgis.sql
psql -d template_postgis -f $POSTGIS_SQL_PATH/spatial_ref_sys.sql
psql -d template_postgis -f $POSTGIS_SQL_PATH/legacy.sql
psql -d template_postgis -f $POSTGIS_SQL_PATH/rtpostgis.sql
psql -d template_postgis -f $POSTGIS_SQL_PATH/topology.sql
psql -d template_postgis -c "GRANT ALL ON geometry_columns TO PUBLIC;"
psql -d template_postgis -c "GRANT ALL ON spatial_ref_sys TO PUBLIC;"
sudo yum install gdal*
pip install –r python_requirements.txt
On Fri, Nov 01, 2013 at 12:22:48AM -0700, Prabu Raja wrote:
> Thanks strk. I found and installed. But stuck at *"#<NoMethodError:
> undefined method `email=' for #<User @values={}>>"* error when running *"sh
> script/create_dev_user [mysubdomain]"* command. For mysubdomain I gave *
> "carto"*.
I usually run that script with no arguments. It'll prompt me for args.
Try it, Just in case it's a bug in the script.
> *carto_db_development*, *carto_db_test* database's created without any user
> records.
>
> When I run the same command again, getting *"#<Sequel::DatabaseError:
> PG::Error: ERROR: syntax error at or near "ALL"> LINE 1: REVOKE ALL ON ALL SEQUENCES IN SCHEMA public FROM PUBLIC"* , one
> more database "*cartodb_dev_user_1_db*" created and one role
> "development_cartodb_user_1".
Which PostgreSQL version are you running ?
--strk;
--
---
You received this message because you are subscribed to a topic in the Google Groups "cartodb" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cartodb/xlxtoGtdrbQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cartodb+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Jeremy, I did that three times, but same issue repeating. Any other possible ways to solve this?
Prabu, you may want to open Postgres and manually remove all databases associated with CartoDB. Then try running that create user script again. When it was created before with Postgres < 9.1 it looks as though it wasn't created properly.
Prabu,Just got this error tonight during a fresh install. Doing a rake db:migrate in the cartodb20 directory and then running the script again seemed to work for me. If you're running the script a second time, you'll likely see errors about some databases already existing, but this is normal.
On Friday, December 6, 2013 10:23:23 AM UTC-7, Prabu Raja wrote:Jeremy, I did that three times, but same issue repeating. Any other possible ways to solve this?
On Dec 6, 2013 10:43 PM, "Jeremy Schulz" <scu...@gmail.com> wrote:Prabu, you may want to open Postgres and manually remove all databases associated with CartoDB. Then try running that create user script again. When it was created before with Postgres < 9.1 it looks as though it wasn't created properly.To unsubscribe from this group and all its topics, send an email to cartodb+u...@googlegroups.com.
--
---
You received this message because you are subscribed to a topic in the Google Groups "cartodb" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cartodb/xlxtoGtdrbQ/unsubscribe.--
---
You received this message because you are subscribed to a topic in the Google Groups "cartodb" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cartodb/xlxtoGtdrbQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cartodb+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
Jeremy,It doesn't help, same result. Sadly, I stuck here.Thanks,
Prabu Raja
"There is a problem with your connection"
--
--
---
You received this message because you are subscribed to the Google Groups "cartodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cartodb+u...@googlegroups.com.
{"errors":["missing carto's database_name in redis (try CARTODB/script/restore_redis)"]}
--
---
You received this message because you are subscribed to the Google Groups "cartodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cartodb+u...@googlegroups.com.
--
---
You received this message because you are subscribed to the Google Groups "cartodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cartodb+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
---
You received this message because you are subscribed to a topic in the Google Groups "cartodb" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cartodb/xlxtoGtdrbQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cartodb+u...@googlegroups.com.
{"errors":["missing carto's database_name in redis (try CARTODB/script/restore_redis)"]}
--
---
You received this message because you are subscribed to the Google Groups "cartodb" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cartodb+u...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
--
---
You received this message because you are subscribed to a topic in the Google Groups "cartodb" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cartodb/xlxtoGtdrbQ/unsubscribe.
To unsubscribe from this group and all its topics, send an email to cartodb+u...@googlegroups.com.
We have something wrong here, in the previous script the database_name was being set (http://pastebin.com/f1q6vTYE) but now when you get the database_name for that user is null.Please, check that redis is not restarted/stopped between restore_redis and the following commands and do not execute windshaft tests after restore_redis (it clear redis database)
echo "hget rails:users:cartodb database_name" | redis-cli -n 5 (output below)
--
$ sudo pip install --upgrade pip
If not, perhaps what you should do is try to install it manually via the link above. Hope this helps!
Jeremy
Thanks!