all users have the same mail

[ghost]

right now all users have this mail: [email protected]

when you try to change a profile you cannot save it because should be unique. This can potentially produce more problems:

The proposal is to mask user's mail as: <user>@guifi.net

Implement one of the two options:

1. change it in script (would be nice if this is public) - @miquelmartos (?)
2. change it in the building of the development environment

[miquelmartos]

crontab -l
22 2 1,15 * * cd /home/guifi/public_html; /bin/sh copia_db_a_devel.sh; /usr/bin/mysql -uMASKED -pMASKED guifi66_devel < guifi66_devel_clean.sql; mysqldump -uMASKED -pMASKED guifi66_devel > guifi66_devel.sql; rm guifi66_devel.sql.gz; gzip guifi66_devel.sql;

guifi@www:~/public_html$ cat copia_db_a_devel.sh
#!/bin/bash

DBUSER=MASKED
DBPASSWORD=MASKED
DBSNAME=MASKED
DBNAME=guifi66_devel
DBSERVER=localhost

fCreateTable=""
fInsertData=""
echo "Copying database ... (may take a while ...)"
DBCONN="-h ${DBSERVER} -u ${DBUSER} --password=${DBPASSWORD}"
echo "DROP DATABASE IF EXISTS ${DBNAME}" | mysql ${DBCONN}
echo "CREATE DATABASE ${DBNAME}" | mysql ${DBCONN}
for TABLE in echo "SHOW TABLES" | mysql $DBCONN $DBSNAME | tail -n +2; do
createTable=echo "SHOW CREATE TABLE ${TABLE}"|mysql -B -r $DBCONN $DBSNAME|tail -n +2|cut -f 2-
fCreateTable="${fCreateTable} ; ${createTable}"
insertData="INSERT INTO ${DBNAME}.${TABLE} SELECT * FROM ${DBSNAME}.${TABLE}"
fInsertData="${fInsertData} ; ${insertData}"
done;
echo "$fCreateTable ; $fInsertData" | mysql $DBCONN $DBNAME

guifi@www:~/public_html$ cat guifi66_devel_clean.sql

ALTER TABLE users DROP pass;
ALTER TABLE users DROP mail;
ALTER TABLE users DROP init;
ALTER TABLE users ADD pass VARCHAR( 32 ) NOT NULL DEFAULT '2c57ea903930c8530a4c71af00b6e749' AFTER name;
ALTER TABLE users ADD mail VARCHAR( 64 ) NOT NULL DEFAULT '[email protected]' AFTER pass;
ALTER TABLE users ADD init VARCHAR( 64 ) NOT NULL DEFAULT '[email protected]' AFTER picture;
UPDATE users SET uid = '0' WHERE name = '';
etc..
etc..
etc..