Hi, I would like to run SQLite inside a Genode process. I could not find a run recipe or a dir in libports. Has someone tried in the past? If so, can you please point me in the right direction?
Best, Sid PhD UBC sid-agrawal.ca
Hi, I am writing a simple program to exercise sqlite3. I have written it using vfs_example_5 as a base, so I can access a file. Though the program compiles (which is great), I am running into issues at runtime. Looks like SQLite is calling fcntl with a command that the vfs_plugin doesn't recognize.
My gut tells me that I am missing some compile flags, i.e., I need to compile the sqlite3.c file in a way that is better suited to the libc version used by Genode, which, IIRC is BSD's libc. Or perhaps I need to use an older version of SQLite? Or I could be way off :)
It would be great if folks could point me in the right direction. My code and steps to repro are below.
Best, Sid
Source Code: https://github.com/sid-agrawal/genode/tree/sid-branch/repos/osmosis_examples...
Steps to reproduce:
git clone https://github.com/sid-agrawal/genode.git cd genode git checkout sid-branch ./tool/create_builddir x86_64 cd build/x86_64 # Update build.conf to # - include osmosis_examples, libports and ports repos # - comment out the -no-kvm option <GENODE_DIR>/tool/ports/prepare_port grub2 libc make KERNEL=hw run/sqlite_example
Output: -----------------------START-------------------------------- kernel initialized Warning: TSC calibration not yet implemented, using fixed value Genode 21.05-2061-gcf807a62cb 785 MiB RAM and 64533 caps assigned to init [init -> sqlite_example] Starting example [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init] child "sqlite_example" exited with exit value 0
Run script execution successful. -----------------------END--------------------------------
On Tue, Jun 6, 2023 at 9:26 AM Sid Agrawal siagraw@cs.ubc.ca wrote:
Hi, I would like to run SQLite inside a Genode process. I could not find a run recipe or a dir in libports. Has someone tried in the past? If so, can you please point me in the right direction?
Best, Sid PhD UBC sid-agrawal.ca
Hi Sid,
I had to patch the sqlite3 implementation that comes with Qt5 because of missing F_SETLK support. Maybe it is the same problem?
This is the patch:
https://github.com/cproc/qt5/commit/c8b512db33a612e5026aa73fd8bfd257f967cdd8...
Christian
On 11.06.23 05:26, Sid Agrawal wrote:
Hi, I am writing a simple program to exercise sqlite3. I have written it using vfs_example_5 as a base, so I can access a file. Though the program compiles (which is great), I am running into issues at runtime. Looks like SQLite is calling fcntl with a command that the vfs_plugin doesn't recognize.
My gut tells me that I am missing some compile flags, i.e., I need to compile the sqlite3.c file in a way that is better suited to the libc version used by Genode, which, IIRC is BSD's libc. Or perhaps I need to use an older version of SQLite? Or I could be way off :)
It would be great if folks could point me in the right direction. My code and steps to repro are below.
Best, Sid
Source Code: https://github.com/sid-agrawal/genode/tree/sid-branch/repos/osmosis_examples...
Steps to reproduce:
git clone https://github.com/sid-agrawal/genode.git cd genode git checkout sid-branch ./tool/create_builddir x86_64 cd build/x86_64 # Update build.conf to # - include osmosis_examples, libports and ports repos # - comment out the -no-kvm option <GENODE_DIR>/tool/ports/prepare_port grub2 libc make KERNEL=hw run/sqlite_example
Output: -----------------------START-------------------------------- kernel initialized Warning: TSC calibration not yet implemented, using fixed value Genode 21.05-2061-gcf807a62cb 785 MiB RAM and 64533 caps assigned to init [init -> sqlite_example] Starting example [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init] child "sqlite_example" exited with exit value 0
Run script execution successful. -----------------------END--------------------------------
On Tue, Jun 6, 2023 at 9:26 AM Sid Agrawal siagraw@cs.ubc.ca wrote:
Hi, I would like to run SQLite inside a Genode process. I could not find a run recipe or a dir in libports. Has someone tried in the past? If so, can you please point me in the right direction?
Best, Sid PhD UBC sid-agrawal.ca
Genode users mailing list users@lists.genode.org https://lists.genode.org/listinfo/users E�n�sڶ�z����z�b�� zzz�� �b���u:����&�����$j��ץi��d^q�y��i��X��^���r���f����ץi��l"��L�� �n+�>�d �eM7���h���k�z����z�b�� zzz��~�܆���&�����$j��ץi��d��]I�}��}9ۮ:�M���z+�u��X���}�^��m���� �� zzz��o)��X��^���r���)���`�w��ε����&��--wL��-��`�Hp7����zZ)y������w�X�����^��"wZ�=tӡ[�p�}u&���m��n���6�@� Ģ�v�����Ƭ���ꠞ����Z����Z��]X����^��,m�M�*���N�����w(v)� ��z{Sʗ�z�rN��Ԯn�+�����GzZK��O��K��@��b����'���r��x����S�+���-1�,j�6�xZ蘉�z�rN�^}�ޝǬ0�U�슉�zw^�'�{^�� ��z{Cz�+��b�t^��� �^E���k�d^���I��z�^���N�^��� �^���1�,j�����'z���'�c����M�m�&�a��t���b���;)a��nZ�M8؎i���=��y8,�ap�Ӧ/�T�CѠ��6�C�������ӑ��N{�Hc� ˨�?Ow��[�D�3&��Й�&�!Ζo��э�F�~' �F�x��*s�7��L�7 TX�!W&�pV�{2N�\����tIv��xۍd�c�b�9�ر��"���k�la況���,�8��� �u����ٗ!�3x�-.�A���;�w�߳t���`� ���gR���R��=��ƀyǢ��_�����hq�a��u��h_ׯ5�mvo)b�� zzz���+azɭ�Lb��x���zZ)y������w�X�����^��"wZ�*��MNL��}u&���m��n���6�D^q�y��i��W,��k^6�M��V�+-���ר�"����lL����lL��1�E !1�-��`�Hp7�1�n=�g���h���k"j ���.m���j���M5;��~����+-���ר���]I�}��}9ۭ��M���z+�u��f���5_4�� ��(�f���5_4�� ��(�m=��_4j�az{bq�^u��� �f���.m��^v��w���D�L���tܝ6���슉L���g"��۞�ć8n+ln��� �ߢ��z�%��l���u�+�&��Bn�m6�m6�]��MyǢ��[�f���5_4�� ��(���#>'Z�\w]�{~{�x������n����~����+-���ר���] �}��}�ۭwӽ4<4�c�Ơy+Z���W���M��f�$h>��Q���T�ӕE�}�6������8�(�˦4A��Ǧ�\�PH��#���+��� ��%y)��*.�ǀq�g��֪~�29�L̓r���6v@eP� w*L���g_<�����S���<K�W3��3��r|E����o-��f��uѽ;��6�G���"��L���M6�M�k~���t�M4ѽ4�Mk�毝�۞|�H6�^��w��u����] �}��}�ۭuӽ4<4� �z�"�}tE�ޭ��z���]�)���KE/��xm�� ��n����-u� ��X&j)\�b'E�e�:�vT��--�>����4@42�a� ��6���2x&j)`���r������� ���Ț���r˛qƃjגj�t&���m��n��N��q�j)N�("��Lz�����R�l=�����6��жv gñx����&j)`���r��z�����R�l=�����6��жv gñx����&j)`���r�����r�^F��x@��y:zzz��ɚ�X��X�����b�� zzz��\��8^��z�%��l���u�+�s�Y��W��*'�]�>��yקq�b������u�z�&j)b� b�۬z�%��l���u�+����I칻�&ކ�i����l���u�+��)�*'���z�&j)m����ު笶X�����^��,���rО˛���m���+r�zm����l���u�+��b���j)�ǫ�����ٚ�[h�ǫ�X�����^����GzZfj)m����ު笶X�����^��,���r�zZK��R���&ކ�i����l���u�+��b�ا~���왨����z�+z����b�� zzz����y˲��r��y��$���u�z�&j)b� b�۬z�%��l���u�+�*'���O*^��m��Z�w!j�����ק�:ڞ�ެIܡا���{���+�:.���n��q�%��l���u�+�t�jhh�ٚ�X��^���r��J����+{oWJ����+z)���ҥ��j�ҥ��z�+�-4_(� cD �T� 0 ы!$�P��T N ��]2�4@�U �,��0�MRK�H[Hܚ][��H�[\H��ܘ[H�^\��\�H�[]LˈH]�Hܚ][�]�\�[������^[\W�H\�H�\�K��H�[�X��\��H�[K��Y�B���ܘ[H��\[\� �X�\�ܙX] KH[H�[��[��[��\��Y\�]��[�[YK�����Z�H�S]H\��[[����]H��[X[�]B�����Y�[��\ۉ��X��ۚ^�K���^H�][�YH]H[HZ\��[����YH��\[H�Y��K�K�H�YY��\[HH�[]L˘��[H[�H�^H]\��]\��Z]Y�HX��\��[ۈ\�Y�H�[��K�X�RT��\��� ��X�ˈ܈\�\�H�YY��\�H[��\��\��[ۈو�S]O�܈H��[�H�^Hٙ��B��]��[�HܙX]Y�������[�[�YH[�H�Y�\�X�[ۋ�^B���H[��\���\��\�H�[�˂���\���Y�����\��H��N�����]X����K��YXYܘ]�[��[��K��YK��YX��[��ܙ\�����[��\��^[\\��ܘ��\��[]W�^[\B����\���\��X�N����]�ۙH���]X����K��YXYܘ]�[��[��K��]���[��B��]�X���]�YX��[��������ܙX]W؝Z[\� �͍���Z[� �͍��\]H�Z[��ۙ��H[��YH��[��\��^[\\�X�ܝ�[�ܝ��\��H��[Y[��]H[��ZݛH�[ۂ��S��W�T������ܝ���\\�W�ܝܝX��X�XZ�H�T��SZ��[���[]W�^[\B����]]��KKKKKKKKKKKKKKKKKKKKKKT�T�KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB��\��[[�]X[^�Y��\��[�Έ���[X��][ۈ��Y][\[Y[�Y\�[���^Y�[YB��[��H�K� KL� �KY�َ �M���� HZP��SH[� � L���\�\��YۙY�[�]��[�]O��[]W�^[\WH�\�[��^[\B��[�]O��[]W�^[\WH\����
N���[X[�L����\ܝYH���[�]O��[]W�^[\WH\����
N���[X[�L����\ܝYH���[�]O��[]W�^[\WH\����
N���[X[�L����\ܝYH���[�]O��[]W�^[\WH\����
N���[X[�L����\ܝYH���[�]H�[��[]W�^[\H�^]Y�]^]�[YH���[��ܚ\^X�][ۈ�X��\�ٝ[��KKKKKKKKKKKKKKKKKKKKKKQS�KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB������ۈYK�[� ����]N����+�SH�YYܘ]�[�XYܘ]��˝X�˘�O�ܛ�N�����K��H��[Z�H��[��S]H[��YHH�[��H���\�ˈH��[���[�H�[��X�\H܈H\�[�X�ܝˈ\���Y[ۙH�YY[�H\��Y����[�[�HX\�H�[�YH[�H�Y�\�X�[ۏ����\����Y��P���YXYܘ]�[��B�������������������������������������������������[��H\�\��XZ[[��\��\�\��\�˙�[��K�ܙ��\�˙�[��K�ܙ��\�[����\�\��g===
Thanks you Christian.
I was also reaching the same conclusion. I made changes to vfs_plugin.cc so that fcntl always returns success for F_SETLK. But your patch is cleaner.
Best, Sid
On Sat, Jun 10, 2023 at 9:20 PM Christian Prochaska christian.prochaska@genode-labs.com wrote:
[CAUTION: Non-UBC Email]
Hi Sid,
I had to patch the sqlite3 implementation that comes with Qt5 because of missing F_SETLK support. Maybe it is the same problem?
This is the patch:
https://github.com/cproc/qt5/commit/c8b512db33a612e5026aa73fd8bfd257f967cdd8...
Christian
On 11.06.23 05:26, Sid Agrawal wrote:
Hi, I am writing a simple program to exercise sqlite3. I have written it using vfs_example_5 as a base, so I can access a file. Though the program compiles (which is great), I am running into issues at runtime. Looks like SQLite is calling fcntl with a command that the vfs_plugin doesn't recognize.
My gut tells me that I am missing some compile flags, i.e., I need to compile the sqlite3.c file in a way that is better suited to the libc version used by Genode, which, IIRC is BSD's libc. Or perhaps I need to use an older version of SQLite? Or I could be way off :)
It would be great if folks could point me in the right direction. My code and steps to repro are below.
Best, Sid
Source Code: https://github.com/sid-agrawal/genode/tree/sid-branch/repos/osmosis_examples...
Steps to reproduce:
git clone https://github.com/sid-agrawal/genode.git cd genode git checkout sid-branch ./tool/create_builddir x86_64 cd build/x86_64 # Update build.conf to # - include osmosis_examples, libports and ports repos # - comment out the -no-kvm option <GENODE_DIR>/tool/ports/prepare_port grub2 libc make KERNEL=hw run/sqlite_example
Output: -----------------------START-------------------------------- kernel initialized Warning: TSC calibration not yet implemented, using fixed value Genode 21.05-2061-gcf807a62cb 785 MiB RAM and 64533 caps assigned to init [init -> sqlite_example] Starting example [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init -> sqlite_example] Error: fcntl(): command 12 not supported - vfs [init] child "sqlite_example" exited with exit value 0
Run script execution successful. -----------------------END--------------------------------
On Tue, Jun 6, 2023 at 9:26 AM Sid Agrawal siagraw@cs.ubc.ca wrote:
Hi, I would like to run SQLite inside a Genode process. I could not find a run recipe or a dir in libports. Has someone tried in the past? If so, can you please point me in the right direction?
Best, Sid PhD UBC sid-agrawal.ca
Genode users mailing list users@lists.genode.org https://lists.genode.org/listinfo/users E�n�sڶ �z� ���z�b�� zz z�� �b���u: ����&��� ��$j ��ץi� �d^q�y��i��X ��^���r���f�� ��ץi� �l"� �L�� �n+�>�d � eM7 ���h���k�z� ���z�b�� zz z��~�܆���&��� ��$j ��ץi� �d��]I�}��}9ۮ:�M�� �z+�u��X���}�^��m�� �� �� zz z��o)��X ��^���r���)���`�w��ε� ���&�� --wL�� -��`�Hp7����zZ)y��� ���w �X��� ��^��"wZ� =tӡ[�p �}u&���m��n���6�@� Ģ�v���� �Ƭ���ꠞ����Z�� ��Z��] X�� ��^��, m�M�*���N����� w(v)� ��z{Sʗ�z�rN��Ԯn�+�����GzZK��O��K��@��b����'���r��x����S�+���-1�,j � 6�xZ蘉�z�rN�^}�ޝǬ0� U�슉�zw^�' �{^�� ��z{Cz�+��b�t^��� �^E� ��k�d^���I��z�^���N�^��� �^���1�,j � ����'z���' �c��� � M�m�&�a��t���b� �� ;) a��nZ�M8؎i��� =��y8,�ap� Ӧ/� T�CѠ� �6�C� � �����ӑ��N {�Hc� ˨ � ? Ow��[�D�3&��Й�&�! Ζo��э�F�~' �F�x��*s �7��L�7 T X�! W&�pV� { 2N�\� ���tIv��xۍd�c �b �9�ر��"� ��k�la 況���, �8��� �u����ٗ!�3x�-.�A ���;�w� ߳ t � � �`� ���g R���R��=��ƀyǢ��_�����hq�a��u��h _ׯ5�mvo)b�� zz z���+azɭ�Lb��x���zZ)y��� ���w �X��� ��^��"wZ� *��MNL� �}u&���m��n���6�D^q�y��i��W,�� k^6�M��V�+-� ��ר� "� ���lL����lL�� 1�E !1� -��`�Hp7�1�n=�g���h���k"j ���.m� ��j� ��M5;��~����+-� ��ר� ��]I�}��}9ۭ��M�� �z+�u��f���5 _4�� ��(�f���5 _4�� ��(�m=��_4j�az{bq�^u��� �f���.m� �^v��w� ��D�L��� t ܝ6���슉L���g"� � ۞� ć 8n+l n��� �ߢ��z�%��l���u�+�&��Bn�m6�m6�]��M yǢ��[�f���5 _4�� ��(� ��# >'Z �\w]�{~{�x�� ����n����~����+-� ��ר� ��] �}��}�ۭwӽ4<4� c �Ơy+Z�� �W���M ��f�$h>�� Q���T�ӕE�}�6������8 �(�˦4A��Ǧ� \�PH� �#���+��� ��%y)��*.�ǀ q�g��֪~� 29� L̓ r� � �6v @ eP� w*L ���g _<����� S���<K�W3��3��r|E� ���o-��f��uѽ;��6�G���"� �L���M6�M�k~���t�M4ѽ4�M k�毝�۞|�H6�^��w��u����] �}��}�ۭuӽ4<4� � z�"�}tE�ޭ��z���]�)���KE/ ��xm�� ��n ����-u � ��X&j)\�b'E�e�: �vT� �-- �>����4@4 2�a� ��6���2x&j)`���r������� �� �Ț���r˛qƃjגj�t&���m��n��N��q�j)N�("��Lz� �� ��R�l=���� � 6 �� жv g ñx � ���&j)`���r��z� �� ��R�l=���� � 6 �� жv g ñx � ���&j)`���r�����r�^F��x @��y: zz z� �ɚ�X��X��� ��b�� zz z��\ ��8^��z�%��l���u�+�s �Y��W��*'�]�>��yקq�b���� ��u�z�&j)b� b�۬z�%��l���u�+����I칻 �&ކ�i����l���u�+��)�*'���z�&j)m�� ��ު笶X��� ��^��,���rО˛���m���+r �z m����l���u�+��b���j) �ǫ�����ٚ�[h�ǫ�X��� ��^�� ��GzZfj)m�� ��ު笶X��� ��^��,���r�zZK��R�� �&ކ�i����l���u�+��b�ا~���왨����z�+z����b�� zz z����y˲��r��y ��$� ��u�z�&j)b� b�۬z�%��l���u�+�*'���O*^��m��Z�w!j� � ���ק�:ڞ�ެIܡا���{� ��+�:.���n��q�%��l���u�+�t�jhh�ٚ�X ��^���r��J����+{oWJ����+z)���ҥ��j�ҥ��z�+� -4 _(� cD � T � 0 ы!$�P�� T N ��]2�4@�U �,�� 0�MR K �H [H ܚ] [�� H �[\ H ��ܘ[H � ^ \��\�H �[ ] Lˈ H ]�H ܚ] [� ] �\�[�� ����^ [\ W�H \� H �\�K �� H �[� X��\�� H �[ K� �Y� B� ��ܘ[H ��\ [ \� � X� \� ܙX] K H [H �[��[�� [� � \��Y\� ] ��[� [YK� ���� Z�H �S ] H \� �[ [�� � �] H ��[X[� ] B����� Y�[� �\ۉ� �X��ۚ^�K���^H �] [ � YH ] H [H Z\��[�� ��YH ��\ [ H � Y�� K�K� H �YY ˜��\ [ H H �[ ] L˘� �[ H [� H �^H ] \� �] \� �Z] Y � H X� �\��[ۈ \�Y �H �[�� K � X� RT�� \� �� �� X�ˈ ܈ \� \ � H �YY � � \�H [� � \� �\��[ۈ و �S ] O� ܈ H ��[ �H �^H ٙ� �B��] ��[ �H ܙX] Y� �� �� ��[ �[� YH [� H �Y� \�X� [ۋ� ^B��� H [� � \ � � �\ �� \�H �[ �˂���\� ��Y �����\��H �� N�� ���] X����K��Y XYܘ]�[ ��[�� K� �YK��Y X��[�� ܙ\ �����[��\��^ [\ \��ܘ��\ ��[ ] W�^ [\ B���� \ � � �\ �� X�N����] � ۙH ���] X����K��Y XYܘ]�[ ��[�� K��] �� �[�� B��] � X���] �Y X��[�� � �� �� �ܙX] W؝Z[ \� �͍ � � �Z[ � �͍ �� \ ] H �Z[ ��ۙ� ˆ� H [�� Y H ��[��\��^ [\ \� X� ܝ � [� ܝ � �\ �ˆ� H ��[Y[� �] H [��ZݛH � [ۂ� �S�� W� T��� �� � ܝ �� �\ \�W� ܝ ܝX�� X�›XZ�H �T��S Z � �[���[ ] W�^ [\ B����] ] ��KKKKKKKKKKKKKKKKKKKKKKT� T� KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB��\��[ [�] X[ ^�Y ��\��[�Έ �� �[ X��] [ۈ �� Y] [\ [Y[� Y \�[�� �^ Y �[ YB��[�� H �K� KL� �KY�َ �M���� H ZP� �SH [� � L�� �\ � \��YۙY � [�] ��[�] O� �[ ] W�^ [\ WH � \� [�� ^ [\ B��[�] O� �[ ] W�^ [\ WH \��� �
N� ��[X[� L� �� �\ ܝ Y H ��–�[�] O� �[ ] W�^ [\ WH \��� �
N� ��[X[� L� �� �\ ܝ Y H ��–�[�] O� �[ ] W�^ [\ WH \��� �
N� ��[X[� L� �� �\ ܝ Y H ��–�[�] O� �[ ] W�^ [\ WH \��� �
N� ��[X[� L� �� �\ ܝ Y H ��–�[�] H � [ ��[ ] W�^ [\ H� ^ ] Y �] ^ ] �[ YH ���[� �ܚ\ ^ X�] [ۈ �X��\�ٝ[ ��KKKKKKKKKKKKKKKKKKKKKKQS� KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKB������ۈ YK �[� � � �� ] N����+�SH �Y Yܘ]�[ �XYܘ]� �˝X�˘�O� ܛ� N����� K �� H ��[ Z�H � �[� �S ] H [��Y H H �[�� H ���\�ˈ H ��[ �� �[� H �[� �X�\ H ܈ H \� [� X� ܝ ˈ \� ��Y[ۙH �YY [� H \� � Y� �� �[� [�H X\�H �[� YH [� H �Y� \�X� [ۏ ��� �\� �� �Y �� P� � �Y XYܘ]�[ ��B������������������������������������������������‘�[�� H \�\�� XZ[ [�� \� �\�\�� \� ˙�[�� K�ܙš �� \� ˙�[�� K�ܙ�� \� [����\�\��g===
Genode users mailing list users@lists.genode.org https://lists.genode.org/listinfo/users