MySQL [(none)]> use forseti_security; Reading table information for completion of table and column names
The shell stay in this status during long time .....
Why ?
My Forseti database is 600Gb, this is the reason ? how many times i need to wait ?
Cordialement / Best Regards
CASTEX Antoine
Cloud Developer
Technology & Operations - Digital Factory
Group Information Systems & Technology (IS&T)
VEOLIA 30 rue Madeleine Vionnet / 93300 Aubervilliers / France
Bureau : 0 - Ouest - 137F
Direct: +33 1 85 57 70 91
Mobile: +33 6 10 93 63 49
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqREHs8dsJO5PZUtcQ%3DAXJ%2BsWsBHgxsyrdZRK%3DhnbH4orPg%40mail.gmail.com.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqREHs8dsJO5PZUtcQ%3DAXJ%2BsWsBHgxsyrdZRK%3DhnbH4orPg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAAOS2FMc%2Bttw0%3Dx_KA%2BVyOkKFEPg8wM81Xy4T7a5i7fwBHSpkw%40mail.gmail.com.
Cordialement / Best Regards
CASTEX Antoine
Cloud Developer
Technology & Operations - Digital Factory
Group Information Systems & Technology (IS&T)
VEOLIA 30 rue Madeleine Vionnet / 93300 Aubervilliers / France
Bureau : 0 - Ouest - 137F
Direct: +33 1 85 57 70 91
Mobile: +33 6 10 93 63 49
Hi Antoine,Did you start mysql with "-A"? If not, try that. mysql client does name completion and the setup for it grows almost exponentially as the number of tables (and columns) increases.Ramesh
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAAOS2FMc%2Bttw0%3Dx_KA%2BVyOkKFEPg8wM81Xy4T7a5i7fwBHSpkw%40mail.gmail.com.
Cordialement / Best Regards
CASTEX Antoine
Cloud Developer
Technology & Operations - Digital Factory
Group Information Systems & Technology (IS&T)
VEOLIA 30 rue Madeleine Vionnet / 93300 Aubervilliers / France
Bureau : 0 - Ouest - 137F
Direct: +33 1 85 57 70 91
Mobile: +33 6 10 93 63 49
Hi Antoine, I assume you are referring to your 1.x installation database? It might be worthwhile to look at snapshot retention days setting I added to 1.1.11:You would need to upgrade, and the first run is going to take quite a while to finish with a DB that full!
-Victor
On Thu, Apr 19, 2018, 10:00 AM Ramesh Menon <ram...@cloudquest.io> wrote:
Hi Antoine,Did you start mysql with "-A"? If not, try that. mysql client does name completion and the setup for it grows almost exponentially as the number of tables (and columns) increases.Ramesh
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqREHs8dsJO5PZUtcQ%3DAXJ%2BsWsBHgxsyrdZRK%3DhnbH4orPg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAAOS2FMc%2Bttw0%3Dx_KA%2BVyOkKFEPg8wM81Xy4T7a5i7fwBHSpkw%40mail.gmail.com.
mysql -u root -p --host localhost 127.0.0.1 -A-Victor
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqREHs8dsJO5PZUtcQ%3DAXJ%2BsWsBHgxsyrdZRK%3DhnbH4orPg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAAOS2FMc%2Bttw0%3Dx_KA%2BVyOkKFEPg8wM81Xy4T7a5i7fwBHSpkw%40mail.gmail.com.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRFzcaOKjbV7ObaD4M9ufe0oNHCLj_5g6oeo2HSo8x%2Bj1Q%40mail.gmail.com.
gcloud sql connect forseti-security-20170908132728 --user=root
Cordialement / Best Regards
CASTEX Antoine
Cloud Developer
Technology & Operations - Digital Factory
Group Information Systems & Technology (IS&T)
VEOLIA 30 rue Madeleine Vionnet / 93300 Aubervilliers / France
Bureau : 0 - Ouest - 137F
Direct: +33 1 85 57 70 91
Mobile: +33 6 10 93 63 49
-Victor
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqREHs8dsJO5PZUtcQ%3DAXJ%2BsWsBHgxsyrdZRK%3DhnbH4orPg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAAOS2FMc%2Bttw0%3Dx_KA%2BVyOkKFEPg8wM81Xy4T7a5i7fwBHSpkw%40mail.gmail.com.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRFzcaOKjbV7ObaD4M9ufe0oNHCLj_5g6oeo2HSo8x%2Bj1Q%40mail.gmail.com.
-Victor
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqREHs8dsJO5PZUtcQ%3DAXJ%2BsWsBHgxsyrdZRK%3DhnbH4orPg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAAOS2FMc%2Bttw0%3Dx_KA%2BVyOkKFEPg8wM81Xy4T7a5i7fwBHSpkw%40mail.gmail.com.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRFzcaOKjbV7ObaD4M9ufe0oNHCLj_5g6oeo2HSo8x%2Bj1Q%40mail.gmail.com.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRG3EYneRgn1qYVvWzsiJp24p6F9sYQ62G%3DAc0emTQEZVA%40mail.gmail.com.
Cordialement / Best Regards
CASTEX Antoine
Cloud Developer
Technology & Operations - Digital Factory
Group Information Systems & Technology (IS&T)
VEOLIA 30 rue Madeleine Vionnet / 93300 Aubervilliers / France
Bureau : 0 - Ouest - 137F
Direct: +33 1 85 57 70 91
Mobile: +33 6 10 93 63 49
Hi Antoine,It seems like gcloud sql connect doesn't support -A in this case, can you instead try the following?1. ssh to the Forseti VM (in Forseti v1, there is only one VM so you can use that one; in Forseti v2, you will need to use the server VM)2. run command "sudo apt-get install mysql-client" to Install mysql-client3. run command "mysql -u root --host 127.0.0.1 --database forseti_security -A" to connect to the cloudsql instanceThe above steps should work if the cloud sql proxy service is running on the VM.To verify that the cloud sql proxy service is running, you can run command "ps -aux | egrep cloud_sql_proxy" and you should see some outputs similar to the following:test@forseti-server-vm-xxxx:~$ ps -aux | egrep forsetiubuntu 12243 0.0 0.1 13036 7916 ? Ssl 17:05 0:02 /usr/local/bin/cloud_sql_proxy -instances=xxx-test-proj:us-central1:forseti-server-xxxx=tcp:3306Hope that helps!Thanks,Joe
-Victor
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqREHs8dsJO5PZUtcQ%3DAXJ%2BsWsBHgxsyrdZRK%3DhnbH4orPg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAAOS2FMc%2Bttw0%3Dx_KA%2BVyOkKFEPg8wM81Xy4T7a5i7fwBHSpkw%40mail.gmail.com.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRFzcaOKjbV7ObaD4M9ufe0oNHCLj_5g6oeo2HSo8x%2Bj1Q%40mail.gmail.com.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers+unsubscribe@forsetisecurity.org.
To post to this group, send email to beta-testers@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRG3EYneRgn1qYVvWzsiJp24p6F9sYQ62G%3DAc0emTQEZVA%40mail.gmail.com.
-Victor
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqREHs8dsJO5PZUtcQ%3DAXJ%2BsWsBHgxsyrdZRK%3DhnbH4orPg%40mail.gmail.com.
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAAOS2FMc%2Bttw0%3Dx_KA%2BVyOkKFEPg8wM81Xy4T7a5i7fwBHSpkw%40mail.gmail.com.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRFzcaOKjbV7ObaD4M9ufe0oNHCLj_5g6oeo2HSo8x%2Bj1Q%40mail.gmail.com.
--------------------------------------------------------------------------------------------This e-mail transmission (message and any attached files) may contain information that is proprietary, privileged and/or confidential to Veolia Environnement and/or its affiliates and is intended exclusively for the person(s) to whom it is addressed. If you are not the intended recipient, please notify the sender by return e-mail and delete all copies of this e-mail, including all attachments. Unless expressly authorized, any use, disclosure, publication, retransmission or dissemination of this e-mail and/or of its attachments is strictly prohibited.Ce message electronique et ses fichiers attaches sont strictement confidentiels et peuvent contenir des elements dont Veolia Environnement et/ou l'une de ses entites affiliees sont proprietaires. Ils sont donc destines a l'usage de leurs seuls destinataires. Si vous avez recu ce message par erreur, merci de le retourner a son emetteur et de le detruire ainsi que toutes les pieces attachees. L'utilisation, la divulgation, la publication, la distribution, ou la reproduction non expressement autorisees de ce message et de ses pieces attachees sont interdites.--------------------------------------------------------------------------------------------
--
You received this message because you are subscribed to the Google Groups "Forseti Security Beta Testers" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beta-testers...@forsetisecurity.org.
To post to this group, send email to beta-t...@forsetisecurity.org.
To view this discussion on the web visit https://groups.google.com/a/forsetisecurity.org/d/msgid/beta-testers/CAKAsqRG3EYneRgn1qYVvWzsiJp24p6F9sYQ62G%3DAc0emTQEZVA%40mail.gmail.com.